Käynnissä

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.

Taidot: Excel

Näytä lisää: excel macro commerce, we excel, me excel, updating product information, the product, run sheet, product copy, price excel, match product, macro, macro upload, macro excel, macro e, excel type work, excel automate, e commerce, do excel, copy product site another, copy excel, bracket, written code examples, excel macro row, automate excel code, excel delete row, product price

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

Projektin tunnus: #481776

Myönnetty käyttäjälle:

agihcam

Please refer to PMB.

30 $ USD 0 päivässä
(39 arvostelua)
5.2

19 freelanceria on tarjonnut keskimäärin 46 $ tähän työhön

lucky2gaf

Hi, please view my PM for details, thanks.

50 $ USD 2 päivässä
(48 arvostelua)
5.4
vivekgarg96

Hi Please refer to PMB for details

30 $ USD 1 päivässä
(20 arvostelua)
5.2
pyazlm

You better check PMB.

30 $ USD 2 päivässä
(30 arvostelua)
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 1 päivässä
(6 arvostelua)
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 1 päivässä
(9 arvostelua)
3.7
edatawiz

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

50 $ USD 1 päivässä
(6 arvostelua)
3.2
vishalgoyal4

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

30 $ USD 0 päivässä
(1 arvostelu)
2.9
Abikris

Hi, View PMB for details Kris

30 $ USD 1 päivässä
(5 arvostelua)
2.5
refractocd

Please refer to PM

30 $ USD 1 päivässä
(3 arvostelua)
2.5
SSYES

Hi, Please can you refer my PM.Thanks.

201 $ USD 5 päivässä
(1 arvostelu)
2.0
riff79

Please check PM for my offer. Thanks

30 $ USD 1 päivässä
(2 arvostelua)
1.9
aswint

Can do this job. Please check PM

40 $ USD 2 päivässä
(0 arvostelua)
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 10 päivässä
(0 arvostelua)
0.0
ZeusPaez

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

50 $ USD 2 päivässä
(0 arvostelua)
0.0
panuwatat

Hi, please see PM for detail. Thank you.

30 $ USD 2 päivässä
(0 arvostelua)
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 Lisää

39 $ USD 2 päivässä
(0 arvostelua)
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 Lisää

60 $ USD 5 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
0.0