En cours

VBA code for Excel / Paypal / Fedex / Credit card data

Hi guys,

I'm an engineer & I've got a little business. My problem is that it takes a while to pull orders from paypal into my spreadsheet. I also manually put phone orders into the spreadsheet. Then twice a week take the spreadsheet (paypal orders & phone orders) and fill in FedEx ground shipping forms & print the shipping labels. And also fill in my on-line credit card charge form (for phone orders). These are 3 separate macros, let me clarify:

1. This macro will go out to my paypal account (pause to let me put in the password the first access). Look back in my spreadsheet and only pull customer purchases since the last extraction. I could put in a number in the spreadsheet & have the macro pull that many latest purchases. I need to pull: customer name, address, city, state, zip, country, email, quantity per item (I only have 5 items for sales), pricing, calculate box dimension (only 3 choices) & weight. There are some details, like flagging any purchases that Paypal says aren't ready to ship. The data will get inserted into the spreadsheet starting at the current selected box.

2. I will highlight a number of rows in the spreadsheet. The macro will take the data from those rows and go out to the [url removed, login to view] website. I will put in my password then it creates the shipments (fedex ground) and print the shipping labels. If Fedex flags any of the addresses as invalid, then either kick them back & flag them (change name to red text?) or let me go in & try to correct any errors (ie it could be a commercial address instead of a residential...). I do want to extract the tracking number and estimated price.

3. The third macro will go to my credit card processor website. I will highlight a row (or more). It takes that customer's data and goes out to the website (again pause so I can put in the password) and selects "sale" and fills in all the data (credit card #, exp date, CSV code, amount, description, address...). Extra the confirmation number and transaction number. If something gets rejected, flag that.

I might get 5-10 orders per day... so it's not LOTS of time but I think this can be streamlined. Is there someone who can write this code for me in VBA? Being that this will access my financial accounts, I can't just let you log into my accounts. But I'm sure there are ways to work together on this. I do know some about coding, and will want to walk through the code after delivery.

We can discuss the program details & payment. Anyone interested in a project like this?

Thanks

Tony

Compétences : Excel, Architecture Logicielle, Visual Basic pour les apps

Voir plus : vba log paypal, excel vba fedex, macro excel paypal, fedex vba, vba coding fedex tracking, vba fill fedex tracking, paypal fedex card, excel fedex tracking, macro pull data fedex website, excel vba paypal, code customer accounts vba excel, excel fedex data, charge credit card vba, excel fedex, fedex tracking excel vba, vba fedex tracking, who need an engineer, vba work, vba get data from website, vba extract data from website, vba code to extract data from website, time residential, pull data from website to excel vba, pull data from website into excel, price of an engineer

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #1679028

Décerné à :

garycheiro

I can provide what you need and even make suggestions for any improvement. Customer satisfaction is my guarantee.

200 $ USD en 7 jours
(0 Commentaires)
0.0

10 freelance ont fait une offre moyenne de 111 $ pour ce travail

koolsidz

Excel Whiz here ;) Please see PMB

200 $ USD en 5 jours
(92 Commentaires)
5.6
ETNASoftware

Hello Tony, Our developers have extensive experience in development of financial software and in integration of different solutions with PayPal. Examples of the work completed: [url removed, login to view] We would Plus

30 $ USD en 1 jour
(1 Commentaire)
5.0
imudita

I have done similar project before. Please see PM for detail.

50 $ USD en 3 jours
(26 Commentaires)
4.6
MichalBayer

Please read my privat emessage. Thank you!

30 $ USD en 3 jours
(5 Commentaires)
4.4
himanshuhc

Hi, I would love to provide you with a WORKING SAMPLE for review before bid acceptance. I would like to request for some more details. Kindly refer PM.

150 $ USD en 4 jours
(13 Commentaires)
4.4
fkgeem10

sir, i can help you do this work

30 $ USD en 2 jours
(0 Commentaires)
0.0
powerpresenter

Dear Tony, I've written thousands of lines of macro code. And I being an MBA grad, can understand your requirements very easily and deliver you more than you expected

90 $ USD en 3 jours
(0 Commentaires)
0.0
christyler74

Fedex and Paypal both have APIs, and I propose using those APIs to develop your macros. I have not used these APIs before, but I strongly suspect this will be preferable to some sort of web scraping macro with Excel. Plus

200 $ USD en 5 jours
(0 Commentaires)
0.0
jansen1428

I have a good experience in macro and i have done couple of projects similar to this. Awaiting for the opportunity to showcase my experience here. Will complete the project satisfying your needs within the given time i Plus

130 $ USD en 3 jours
(0 Commentaires)
0.0