I am an eBay seller and I am in need of the following....
1. A faster way of printing invoices to include in my parcels.
2. A fast way to print shipping labels with the buyers address and phone number.
With eBay there is a .CSV file that can be exported which includes all of the buyers details such as item, price, address, name etc. I wish to have a program developed that you load this .CSV file and it produces invoices with my name, business name, item cost, item quantity, total price, and a small message in a nice format.
I'm after either a program or a macro that works with excel.
There is a way that this can be done in Excel, it's called Mail Merge. So I don't mind which method the programmer decides to use, whether it be mail merge or a program. It's up to them, what ever is easiest and quickest.
Essentially, I could export the .CSV file onto the desktop and then open up two spreadsheets, both which have already been programmed to 1. Make invoices and 2. Make shipping labels.
The shipping labels must contain name, address, postcode and country. I must be able to inspect the labels before they are printed for errors such as incorrect fields etc.
The program must account for multiple purchases from the same user at the same time. For example one user may purchase one of 'product A' and three of' product B'. The program should be able to merge all purchases into one invoice and know to only print out one label.
After all of the labels and invoices are printed the program must store the purchases in a database so they can be looked up later, and also stored for tax/warranty purposes.
If you need more information please contact me
Added is a copy of the .CSV file from eBay, it doesn't have any buyers information in it however you get the point
11 freelance font une offre moyenne de $194 pour ce travail
Hello, Excel VBA expert here. I've done a number of similar projects and have worked in 4 eBay CSV / eParcel CSV projects. Please check PM for more details. Thanks!
I've done similar projects for EDI integration, csv integration. Print directly from app: pack slip, ship label (or export shipping info as csv for UPS automation).