Closed

Excel Macro For E-Commerce Product Upload

This project was awarded to agihcam for $30 USD.

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

I need an Excel macro written to automate the product price updating on an e-commerce site.
We currently have 2 spreadsheets.
SPREADSHEET 1 - The first has the product code and the type of product.
SPREADSHEET 2 - The second has the product code and the cost price of the product.

What needs to be done:
step 1.
Sheet 1 needs to be matched against sheet 2 by product code and if the codes match the price from sheet 2 needs to be copied from sheet 1 and the row deleted from sheet 2.

step 2.
Sheet 1 now needs to copy any product codes that do not have a price next to them to another sheet and delete them from sheet 1.

step 3.
Multiply the price in sheet 1 depending on the product type and cost price.
e.g. IF type 1 AND < £30 MULTIPLY by 25%
These multipliers will be in a sheet within the main spreadsheet and the macro needs to run through every product and just apply the muliplier relevant to that product type and price bracket.

If any of this is unclear please PM me for more information.
We will supply spreadsheet examples to work on obviously.

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