Excel Macro For E-Commerce Product Upload

  • Status Closed
  • 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.

Get free quotes for a project like this
Awarded to:
Skills Required

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