Đang Thực Hiện

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

Kỹ năng: Excel, Kiến trúc phần mềm, Visual Basic cho Ứng dụng

Xem thêm: 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, excel vba paypal, excel fedex data, charge credit card vba, excel fedex, fedex tracking excel vba, vba fedex tracking, vba work, vba get data website, time residential, pull data website excel, price engineer, pending payment paypal, paypal transaction pending, paypal pending transaction, paypal payment says pending, paypal email confirmation number, paypal email confirmation

Về Bên Thuê:
( 0 nhận xét ) United States

Mã Dự Án: #1679028

Đã trao cho:

garycheiro

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

$200 USD trong 7 ngày
(0 Đánh Giá)
0.0

10 freelancer đang chào giá trung bình $111 cho công việc này

koolsidz

Excel Whiz here ;) Please see PMB

$200 USD trong 5 ngày
(92 Đánh Giá)
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: etnasoft.com/showcase We would Thêm

$30 USD trong 1 ngày
(1 Đánh Giá)
5.0
imudita

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

$50 USD trong 3 ngày
(26 Đánh Giá)
4.6
MichalBayer

Please read my privat emessage. Thank you!

$30 USD trong 3 ngày
(5 Đánh Giá)
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 trong 4 ngày
(13 Đánh Giá)
4.4
fkgeem10

sir, i can help you do this work

$30 USD trong 2 ngày
(0 Đánh Giá)
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 trong 3 ngày
(0 Đánh Giá)
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. Thêm

$200 USD trong 5 ngày
(0 Đánh Giá)
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 Thêm

$130 USD trong 3 ngày
(0 Đánh Giá)
0.0