I gang

Simple Desktop Application

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

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

Færdigheder: Databehandling, Visual Basic

Se mere: visual basic 2007 online, suppliers online, suppliers online stores, simple file database, processing orders online, payment processing escrow, or desktop, online visual basic help, online store suppliers, online store supplier, online processing mode, online payments escrow, online help visual basic, online file escrow, online escrow payments, online data entry testing, online code escrow, day application, file escrow online, escrow sale, escrow payment fees, escrow demand payment, data entry process available, data entry access 2007, supplier online store

Om arbejdsgiveren:
( 3 bedømmelser ) Cary, United States

Projekt-ID: #264159