Project Detail

Description

I am looking to automate a few data entry tasks.

I need a desktop application, preferably in VB (.NET) to perform the following tasks.

Task 1:

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)

Task 2:

Create a.csv 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.

Task 3:

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).