We are a drop ship company buying from multiple suppliers. Each of these suppliers send us a feed with products, price and quantity in csv format. This means we don't have a set database of products or key item specifics for those products.
We are now in need of a full product database in order to populate an inventory file to upload our products onto Channel Adviser to sell our products via eCommerce channels.
We pay a subscription to a data provider that holds all data relevant to the products we want to sell. We have this data as multiple .txt files at the moment.
What needs to be done:
- Creation of database and population using the data we have from our data supplier (currently in 6 or 7 .txt files)
- Querying that database to find the products on the supplier feeds and identifying all relevant data to those products
- Population of the blank inventory template csv by mapping query results to locations in that csv file.