Extract prices from web page using excel list with product numbers

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

Hi

I have an excel sheet with a list of 150 SKU product numbers, i would like to retrieve the prices for each product number from this web site on a weekly base. the site url is [login to view URL]

an example of the query would be [login to view URL]

the product number in this case is 5200124320014

when the page loads you will see the lowest price situated under the image on the left hand side in a euro symbol ( 15,20 )

I want that price to be saved next to the product number in the excel sheet.

thanks

below is partially correct code can you tell me how much you would charge me to fix it

Private Sub Worksheet_Change(ByVal Target As Range)

If [login to view URL] = Range("keyphrase").Row And _

[login to view URL] = Range("keyphrase").Column Then

Dim IE As New InternetExplorer

[login to view URL] = True

[login to view URL] "[login to view URL]"; & Range("keyphrase").Value

Do

DoEvents

Loop Until [login to view URL] = READYSTATE_COMPLETE

Dim Doc As HTMLDocument

Set Doc = [login to view URL]

Dim sPrice As String

sPrice = Trim([login to view URL]("price").innerText)

MsgBox sPrice

End If

Data Entry Excel PHP Software Architecture Web Scraping

Project ID: #16049884

About the project

28 proposals Remote project Active 6 years ago

Awarded to:

saqibmunir55

sure i can create a code for u or fix this code in 55 euros Relevant Skills and Experience sure i can create a code for u or fix this code in 55 euros Proposed Milestones €55 EUR - sure i can create a code for u or f More

€53 EUR in 1 day
(705 Reviews)
7.5

28 freelancers are bidding on average €106 for this job

Dhruvika111

Greetings Based on your requirement we have created few samples , please reply to my bid so that i can show you the quality work Looking forward to your reply Thanks Brad Relevant Skills and Experience Data collec More

€61 EUR in 1 day
(455 Reviews)
8.1
mantislin

Hi sir, I am scraping expert, I have did more than 350+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/script More

€109 EUR in 3 days
(460 Reviews)
7.9
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. Relevant Skills and Experience Data Entry, Excel, PHP, Software Architecture, Web Scraping Propos More

€100 EUR in 3 days
(429 Reviews)
8.0
gangabass

I can create simple desktop app that will read list of SKUs from you file and for each SKU it will get price and update Excel file just like you want. You can place it to Windows Scheduler. Relevant Skills and Experi More

€60 EUR in 1 day
(624 Reviews)
7.7
langlangFan

I have much experience in web scrapping My previous target was eCommerce web site. I fetch price, product image, name, category etc. I have solution to overcome ip block, catpcha and session. Relevant Skills and Exper More

€155 EUR in 3 days
(51 Reviews)
7.3
mmadi

Hello gyamanis I have gone through your project Extract prices from web page using excel list with product numbers here we are for providing you the best service with my expertise in Data Entry, Excel, PHP, Softwa More

€175 EUR in 4 days
(46 Reviews)
7.1
aanvikm

Hello Sir, I am an excel expert. I can help you with this project. Please open chat to discuss more about this project. Thanks Aanvik Relevant Skills and Experience Excel Proposed Milestones €155 EUR - Milestone

€155 EUR in 3 days
(52 Reviews)
6.8
fatimatuzzohura

Hi, I am a highly trained on Data Entry ,Data Analysis, Research, Web search, Web scraping, Python, Expert with great knowledge of Word, Excel and PDF. Relevant Skills and Experience Data Entry, Excel, Python, Softwa More

€150 EUR in 3 days
(187 Reviews)
6.6
pinakincode

Hello sir, We have check detail as per that you need get price from website using sku number. we will do it now. Relevant Skills and Experience PHP Proposed Milestones €70 EUR - we will discuss later

€50 EUR in 0 days
(145 Reviews)
6.4
pakee

Ready to EXTRACT Prices from WEB PAGE very FAST..Send me your 150 SKU and lets START Relevant Skills and Experience Highly Expert and Experienced in price extracting ... I can fix your code as well Proposed Milestone More

€50 EUR in 2 days
(234 Reviews)
6.7
iwebphpdeveloper

We assure you for the accurate number. we have a team of 50+ Relevant Skills and Experience we provide quality and quantity on time Proposed Milestones €100 EUR - Milestone

€100 EUR in 3 days
(33 Reviews)
5.6
sisodiakaran

Greetings of the day! Thank you for posting the job. Have gone through your requirements and would like to work on this. Relevant Skills and Experience I would like to update you that I have been working on the simil More

€100 EUR in 0 days
(19 Reviews)
5.2
ChanakyaNaag

Hey there! I have read your description and checked the website. I can build a software for you using python through which you can get data into excel with one click. Please ping me for more details Relevant Skills a More

€50 EUR in 1 day
(43 Reviews)
5.1
Nada100200

Over 8 +years experience writing almost exclusively web scraping code. I've done it all. I can scrape all LinkedIn profile My languages in order of experience and use is Python, JavaScript, PHP. Python libraries ( sele More

€100 EUR in 3 days
(15 Reviews)
5.5
Rajesh088

Dear client , hope you doing well . i 've gone through your requirement . i'm designer , developer and Blog Writer having experience of more than 5 year . want to take interest in your project . Relevant Skills and E More

€30 EUR in 1 day
(18 Reviews)
3.9
uzair81

hello .... i am expert with 5 year of work experience. I am interested in your project, please message me to discuss further. Relevant Skills and Experience PHP Proposed Milestones €155 EUR - final

€155 EUR in 3 days
(2 Reviews)
3.3
AssistSW

I can do this with phantomjs for the scraping and python for the parsing. please let me know Relevant Skills and Experience phantomjs - javascript beautifulsoap - python3 Proposed Milestones €95 EUR - done

€95 EUR in 2 days
(2 Reviews)
2.2
amirbengherbi

I'm experts with data extraction and web scraping, I will give you a high-quality Python script that make the job

€55 EUR in 2 days
(1 Review)
1.9
maheshvanneldas

I hold myself fit for this job. Relevant Skills and Experience I have worked for web scrapping for 2 websites one of those is Pharmacy products for one of my client. Proposed Milestones €155 EUR - sample scrapping ve More

€155 EUR in 3 days
(0 Reviews)
0.0
israasa

A proposal has not yet been provided

€40 EUR in 1 day
(0 Reviews)
0.0