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?
Décerné à :
10 freelance font une offre moyenne de $111 pour ce travail
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.
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