In Progress

Email Orders to Various Suppliers From CSV File

I am an online drop ship seller doing decent volume. I receive orders via CSV file, usually one per day with as many as hundreds of individual orders. This file has all needed info, including box size, weight, so on. I currently create UPS labels using CSV batch process, save each of these as PDF then email each order to the appropriate supplier one at a time. I would like to create a process that does the following:

1- Uses info in CSV order file, this file is flexible, I can change, manipulate as needed. Contains order number, item ordered, customer ship to info, box size, QTY so on. Can add more info if needed very easily.

2- Use UPS API to generate UPS label on specified UPS account (same every time) and generate PDF label. Would be great if it could place the label on the bottom half of an 8.5 x 11 paper so that it could be printed on label paper UPS supplies. I can provide a example of this. Would have to specify value for UPS ref 1 and ref 2. Would be even better if the top half could be my branded generic packing slip, top half would be the same for every order without needing to have specific customer info.

3-Send an email to the appropriate supplier. This email address can be specified in the CSV order file or other way. This email would have a simple subject with the order number, message body showing customer ship to address, part# they ordered and QTY. Attach PDF UPS label and send.

4-Would be great but not necessary to generate end of day excel report showing items shipped with tracking number.

Would love to have web based access to the process so can access from remote locations. Would be ok though if file process resided on local computer. Can provide samples of the referenced file upon request.

Skills: PHP, Software Architecture

See more: ups drop box, top online email, suppliers online, packing box online, online suppliers, online for suppliers, suppliers, orders, csv api, computer architecture -- 2, api supplier, php process csv, paper architecture, change order email, php create csv file, ups tracking using, php generate label, excel use api, web access 2013 send email, send email using excel, batch batch excel file, add pdf email, email great, architecture paper, slip report

About the Employer:
( 24 reviews ) dalton, United States

Project ID: #4352803

Awarded to:

webmajstr

Hello! I am experienced PHP programmer and I've done a lot of automation projects. I can make the online script that you will provide CSV of specific format to and it will do everything as you wrote in the description. More

$800 USD in 7 days
(42 Reviews)
5.0

10 freelancers are bidding on average $1270 for this job

NetzPro

Dear Sir, We would love to get this opportunity of working with you. We can assure you that we will provide you with a very nice automated system. Regards NetzPro

$1500 USD in 30 days
(354 Reviews)
8.5
toinnisfree

pls chk pmb

$1335 USD in 10 days
(525 Reviews)
7.8
cr8tivewebexpert

Hi, We have reviewed your requirement for CSV file based orders processing. We have experienced of such automation and processing. We are interested and ready to get this done. Thank you,

$1500 USD in 10 days
(160 Reviews)
7.5
coolguyinus2004

Already done a csv project and already done a canadapost label work via PHP code so i can do this for UPS label [url removed, login to view] i know how to handle csv file and changes on it. I am very much fit for this job for you. Do you More

$1500 USD in 5 days
(270 Reviews)
7.3
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$1400 USD in 5 days
(346 Reviews)
6.9
meet2amitvw

Hello I am myself doing programming so i you will work directly with one person and that's me. No mediators. No managers. No subcontractors. I went through your requirement and ready to work with you. I will crea More

$1111 USD in 7 days
(44 Reviews)
5.5
tamrakar81

Hi, I have gone through your requirement and I am glad that We can accomplish this task, Please give us opportunity to work with you. Please check PM . Thanks, TTS Team

$1250 USD in 22 days
(28 Reviews)
4.7
tannew

Hi man,I'm ready to work on this project. thanks

$800 USD in 10 days
(14 Reviews)
4.3
mdakrobin

Would you send me that example that you said about? After seeing that we will discuss.

$1500 USD in 30 days
(0 Reviews)
0.0
cm4dev4android

Hi, we rae the perfect match for this project. Looking at your PMB will help!

$750 USD in 18 days
(0 Reviews)
0.0