Data import to database and query output to csv inventory file

  • Status Closed
  • Budget £20 - £250 GBP
  • Total Bids 44

Project Description

Hello Freelancers!

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.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online