Færdiggjort

Webscraping and Excel

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).

Færdigheder: Dataindførsel, Datasøgning, Databehandling, Excel, Web Skrabning

Se mere: automated data scraping from websites into excel, scraping data from web into excel using vba, excel scraper, vba code examples for excel web scraping, how to pull data from a website into excel macro, how to extract data from website to excel automatically, excel scrape html add-in, extract data from website to excel vba, excel 2007 vba fuzzy match, excel 2007 cell remove password, excel spreadsheet automated data search create tables, league match create php, remove watermak create pdfsharp, excel macro find records match criteria, create tabs homepage

Om arbejdsgiveren:
( 47 bedømmelser ) GJØVIK, Norway

Projekt-ID: #15461148

Tildelt til:

srikartiram

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

$125 USD in 10 dage
(187 bedømmelser)
6.5

11 freelancers are bidding on average $172 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 dage
(67 bedømmelser)
7.0
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 Mere

$200 USD in 8 dage
(54 bedømmelser)
7.0
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 dage
(194 bedømmelser)
6.5
$250 USD in 3 dage
(117 bedømmelser)
6.2
oadsmedia

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

$200 USD in 2 dage
(61 bedømmelser)
5.8
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 dage
(32 bedømmelser)
5.9
$155 USD in 3 dage
(22 bedømmelser)
5.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 Mere

$100 USD in 5 dage
(13 bedømmelser)
3.6
$155 USD in 3 dage
(3 bedømmelser)
2.9
mofajjelbd

i hope you are well so please message me and then i will try give 100% done...................................................................

$35 USD in 3 dage
(4 bedømmelser)
2.6