Database Integration of Inventories

Completed Posted Feb 16, 2011 Paid on delivery
Completed

I need to integrate my retail store's inventory with two of my suppliers for updating our website and web order management system.

## Deliverables

Project: Integrate our suppliers' inventories with our own for purposes of displaying inventories on our website and updating our order management system.

All files will be csv or text.

Uploaded Files:

Winning Edge Inventory:

This is our own inventory. The .csv file will contain our item number, our supplier's item number, our supplier's upc number and our inventory quantity. Not every item in this inventory is from the two suppliers we are trying to integrate with. Sample file [url removed, login to view]

English Riding Supply Inventory:

One of our suppliers. This .txt file will contain their UPC number and their inventory quantity among other information that is not necessary for this purpose. UPC's are unique. The file is [url removed, login to view] and the column headers are UPC and Availnow. Sample file [url removed, login to view]

Weatherbeeta Inventory:

One of our suppliers. This .txt file will contain their item number (which is unique) and their inventory quantity amount other information that is not necessary for this purpose. Weatherbeeta's item numbers are unique. The file is [url removed, login to view] and the column headers are Product # and Avail. Weatherbeeta does not give us actual numbers for stock. They provide us with either none, good or great. For our purposes none will be zero, good will be 1 and great will be 10. Sample file [url removed, login to view]

Cactus Complete Commerce:

This is a .csv file from our order management software. It has our current inventory and the inventory of our vendors by our item number. The only thing that differentiates is the warehouse column. Our inventory has Winning Edge listed as the warehouse, English Riding Supply is their name as is Weatherbeeta. Sample file [url removed, login to view]

Output Files:

1. One file needs to be a .csv that has our item number and the combined total of our inventory and our suppliers inventory. Our item number will be in a column called code, the combined inventory will be in a column called quantity. As an example, if for item number 100 we have 10 and our suppler has 10, the output in the quantity column should be 20. The output file name should be inv.csv. This file will be uploaded to our website so that customers may see available quantities for any item. Sample file [url removed, login to view]

2. The other file will also be a .csv formatted the same as the Cactus Complete Commerce file. the only difference is that this file will have the current inventory numbers for Winning Edge, English Riding Supply and Weatherbeeta. The output name does not matter. Sample file [url removed, login to view]

I don't particularly care how this is programmed, whether its through a MS Access script or a SQL database or something else. It does need to be easily expanded for more vendors and simple to use.

Microsoft Access MySQL

Project ID: #3109605

About the project

2 proposals Remote project Active Feb 18, 2011

Awarded to:

aegon

See private message.

$22.75 USD / hour
(0 Reviews)
3.7

2 freelancers are bidding on average $23/hour for this job

tigertechvw

See private message.

$22.75 USD / hour
(0 Reviews)
0.0