Webscraping and Excel

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

This project is only for Karthik S.

Webscraping and excel expert that can produce high quality results!

1. Scrape 4 different websites for Sku, Price, Sale Price, and Product-url´s.

From 5.000 - 20.000 products from each site.

2. Compare the SKU´s from all scraped sites against a Supplier DataFeed.

3. Remove the SKU´s (products) with no match in the Supplier DataFeed.

4. Create an excel file with 4 tabs/windows with SKU´s and Product-urls, from each scraped website where unmatched SKU´s is removed. Keep these files like this and move on to the next step.

5. For every similar scraped SKU from the 4 websites, keep the second highest "Price"

and the second lowest "Sale Price".

6. Reduce the Price with 1 and reduce the Sale Price with 1 for every SKU.

7. Update the Supplier DataFeed with the new Prices.

8. Update the Supplier DataFeed with the new Sale Prices, but NOT if it is lower than the RRP (the price that already exist in the file).

Data Entry Data Mining Data Processing Excel Web Scraping

Project ID: #15461148

About the project

10 proposals Remote project Active 6 years ago

Awarded to:

srikartiram

Thank you for your invite. please award the project I ll accept the project morning

$125 USD in 10 days
(204 Reviews)
6.6

10 freelancers are bidding on average $186 for this job

mhmhz

If your developer not ready. I can provide a MUlti-threads desktop that fetches data from the 4 sites and do the comparison per your request. Final program can be delivered in less than 1 day.

$277 USD in 0 days
(102 Reviews)
7.6
phpXpertbd

Dear Sir, I'm very much delighted to let you know that i did data scraping with PHP-cURL, PhantomJS, Node.js, Selenium from many sites. I just scraped the data from web site and then wrote the data in mysql database More

$200 USD in 8 days
(68 Reviews)
7.2
Harun1986

Hello, I will scrap all product information from 4 different websites for Sku, Price, Sale Price, and product URLs etc. Please ask me the sample for your selected website. Thank you

$250 USD in 10 days
(229 Reviews)
6.8
oadsmedia

!!! Dear Honor !!! We Can Help You Make That Happen !!!  Let's discuss............. ..............................

$200 USD in 2 days
(90 Reviews)
6.6
dynamitewebsol

Hello, I read your requirements very-well and i will provide you best Webscraping and Excel according to your requirements. Thank you

$150 USD in 2 days
(40 Reviews)
6.1
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

$100 USD in 5 days
(19 Reviews)
4.0