In Progress

Excel Macro For E-Commerce Product Upload

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.

Skills: Excel

See more: excel macro commerce, we excel, site e commerce, me excel, what is macro in excel, work on excel, updating product information, the product, run sheet, product copy, price excel, match product, macro, macro to upload, macro excel, macro e, excel type work, excel automate, e-commerce\, e commerce, do excel, copy product from 1 site to another, copy excel, bracket, written code examples

About the Employer:
( 13 reviews ) Rustington, United Kingdom

Project ID: #481776

Awarded to:

agihcam

Please refer to PMB.

$30 USD in 0 days
(39 Reviews)
5.2

19 freelancers are bidding on average $46 for this job

lucky2gaf

Hi, please view my PM for details, thanks.

$50 USD in 2 days
(48 Reviews)
5.4
vivekgarg96

Hi Please refer to PMB for details

$30 USD in 1 day
(20 Reviews)
5.2
pyazlm

You better check PMB.

$30 USD in 2 days
(30 Reviews)
4.4
gvyshnya

I will be happy to apply my 12+ year experience with programming for Excel to solve your problem. Please see more details in PM.

$30 USD in 1 day
(6 Reviews)
4.0
nmppatel

I am a VBA expert. I have very good experience with Excel VBA. I have completed many projects in Excel skill. I will provide quick & professional service.

$30 USD in 1 day
(9 Reviews)
3.7
edatawiz

Hi - I would be glad if you can show me a sample. Please check your PM for more information.

$50 USD in 1 day
(6 Reviews)
3.2
vishalgoyal4

Your search ends here. Best provider. Select us and experience the difference.

$30 USD in 0 days
(1 Review)
2.9
Abikris

Hi, View PMB for details Kris

$30 USD in 1 day
(5 Reviews)
2.5
refractocd

Please refer to PM

$30 USD in 1 day
(3 Reviews)
2.5
SSYES

Hi, Please can you refer my PM.Thanks.

$201 USD in 5 days
(1 Review)
2.0
riff79

Please check PM for my offer. Thanks

$30 USD in 1 day
(2 Reviews)
1.9
aswint

Can do this job. Please check PM

$40 USD in 2 days
(0 Reviews)
0.0
hitz123

i have done an advanced course in excel and i get assure you that your demands will be fulfilled by my services

$30 USD in 10 days
(0 Reviews)
0.0
ZeusPaez

I could do this sucessfully I have experience in a similar project please see my example

$50 USD in 2 days
(0 Reviews)
0.0
panuwatat

Hi, please see PM for detail. Thank you.

$30 USD in 2 days
(0 Reviews)
0.0
karthickkr82

Mission Data Entry Services provides exclusive and highly accurate data entry and data processing services from India with absolute confidentiality and high level of accuracy. We offer data processing outsourcing an More

$39 USD in 2 days
(0 Reviews)
0.0
mukhtarhussain

I am already working as a PREMIUM writer on some other freelance website, therefore, I am very much fimiliar about how to manage my task so that they are completed within time range, provided the complete satisfaction More

$60 USD in 5 days
(0 Reviews)
0.0
derrickkwa

I've done VBA macros for a research project with a local university. The macro can be done in 2 days. Payment can be made after delivery of macro. Check pm for more information.

$50 USD in 2 days
(0 Reviews)
0.0