Closed

excel programme to highlight stock changes and prices

This project was awarded to himanshuhc for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
24
Project Description

Hi
We currently receive daily csv files from our distributors giving us the usual product info ie product codes, pricing, descripion and stock levels. We upload this to a number of platforms including our own ecommerce site. What we are looking for if possible (and i dont know if this is possible in excel or if we would need to buy some sort of stocking system programme - advice would be appreciated) is a programme written in excel that can do the following;

1. Look at two csv files (one a master with our own SKU's) and and assign the correct SKU from the manufacturers codes.

2. Highlight any products that dont match SKU's i.e. new products

3. Highlight any products that have had a price change

Once this is done we can then compare and upload new stock levels and prices were needed to the relevant sites.

Thanks, Carol

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