In Progress

excel programme to highlight stock changes and prices

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

Skills: Excel

See more: excel highlight stock changes, highlight price changes excel, we excel, new products looking for distributors, new product manufacturers, master excel 2010, excel sites, csv codes, buy codes, new excel, master excel, manufacturers looking for new products, manufacturers buy, stocking, stock, sort excel, sku, programme , pricing excel, price excel, in stock, Highlight, excel us, excel ecommerce, do excel

About the Employer:
( 1 review ) Blackburn, United Kingdom

Project ID: #650864

Awarded to:

himanshuhc

Hi, I can do this within 2 hrs Plz see PMB.

$30 USD in 0 days
(13 Reviews)
4.3

24 freelancers are bidding on average $72 for this job

mrbrave

SEE PMB Please

$100 USD in 2 days
(129 Reviews)
5.9
shoaibeyg

Hi, kindly see PM to get an attractive bid. Thanks

$95 USD in 3 days
(6 Reviews)
3.7
mantripti

Hi I am mechanical engineer, backed up by 40 PC I can do your job Let us start Please see PMB Regards

$100 USD in 7 days
(9 Reviews)
3.3
workaholicIndian

Carol, Please check your personal mailbox. I do have experience working on excel and what you said can be perfectly done in it. Regards, Vipin

$95 USD in 2 days
(1 Review)
3.0
chengsterlei

I've worked for a company in San Francisco who owns an online vitamin company. We receive daily cvs files from vendors and this is similar stuff that I have done for the company before. I would be able to create a simp More

$50 USD in 3 days
(0 Reviews)
0.0
warunawnc

Hi Carol, According to your description of the project, i will be able to deliver the project in 3-4 days It's much better if you can provide me some sample excel file to have a proper idea of your requirement

$54 USD in 3 days
(0 Reviews)
0.0
hummertoy

we are ready for this job. pls provide us the details

$60 USD in 30 days
(0 Reviews)
0.0
salver

Please give and see my work

$90 USD in 18 days
(0 Reviews)
0.0
yashwanthkumar92

Yes.... Your requirement can be satisfied using excel ... But pls note that while dealing with large data and updating them a data base package of microsoft or star base may be a apt choice. Pls provide me more info i More

$35 USD in 10 days
(0 Reviews)
0.0
Nissan5300

I cam help you with a program. Please check your PM. Hope to get a chance to work with you.

$55 USD in 2 days
(0 Reviews)
0.0
sumanbhuiyan

Please check PM

$43 USD in 13 days
(0 Reviews)
0.0
techmbapat

Hi, Please check PMB. Regards

$250 USD in 5 days
(1 Review)
0.0
thinkinger

Please check your PM to see more details. I believe I can finish it in a perfect way.

$70 USD in 2 days
(0 Reviews)
0.0
ravi2004

Just check out my profile i can do this 4 u

$30 USD in 1 day
(0 Reviews)
0.0
charlesU105

Hi, I'm intersted in your project, I have knowlege in using Excel, kindly give me an opportunity to do the task........thanks

$30 USD in 5 days
(0 Reviews)
0.0
mhrr

Dear sir, I have good knowledge on Excel, If you give me this opportunity i will try to my best for you. I assure you that I never compromise our quality. I will hear from you soon. ________________________________ More

$50 USD in 10 days
(1 Review)
0.0
karinoy

Hi Carol, I'm interested in this project. I have experiences using Excel and CSV. Looking forward for your reply. Thanks.

$100 USD in 2 days
(0 Reviews)
0.0
muby4you

Respected Sir, I offer my services for the job. If a chance is given to me you will found me the Best for that job. Regards, Mubashir

$35 USD in 5 days
(0 Reviews)
0.0
maticot

Hi Carol, With a very long Office/Excel/VBA experience, you will have it done right and fast. Thank you.

$99 USD in 1 day
(0 Reviews)
0.5
ilyaskazi

Hi Carol, please consider checking your Inbox for more information. Thank you!

$30 USD in 2 days
(1 Review)
0.0