I am looking to automate a few data entry tasks.
I need a desktop application, preferably in VB (.NET) to perform the following tasks.
Compare two .csv files (one is the stock file and the other file is the online store listings file ) and create a single file with:
Items that are not in stock, and currently listed on the store (so I can take them off the store)
Items that are in stock, and not listed in the store (so I can list them for sale)
Create [url removed, login to view] file with orders to be sent to my supplier.
Required fields are:
Order Id (exists in my sales history)
First name , last name, address line1, address line2, city, state, country code(all these data exist in my sales history)
shipping mode (constant "ground" / "2nd Day air")
Order details with quantity & sku number (available in the sales history)
The output of this task is a csv file.
Process a csv file with shipping information (order number, carrier, shipped date, tracking number) and tie the order number to the sales history file to create a (email) mailing list to notify customers their order tracking information.
Despite the description being very long for the tasks, I have been able to perform these tasks with Access 2007 queries.
I can pass on the queries I have written, if that helps.
The missing piece is an application to perform these tasks (on demand or scheduled )
Even if you are not a database person (but comfortable with applications), I don't mind as long as you can deliver.
Payment will be released only after testing the application, I can escrow the fees if required.
No partial payments prior to completion of the project and satisfactory testing.
Any specific questions about the project / data / tasks, please ask.
Please do not assume anything.
After successful completion of this project, I may need help with similar projects (different suppliers / different stores etc).