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.
44 freelancers are bidding on average £143 for this job
Hi, This can be achieved in SQL Server by designing database and SSIS to import data from CSV files. I have 7 years experience in SQL Server and C#.