Extract prices from web page using excel list with product numbers
€30-250 EUR
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
Project ID: #16049884
About the project
Awarded to:
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
28 freelancers are bidding on average €106 for this job
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
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
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
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
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
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
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
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
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
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
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
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
I'm experts with data extraction and web scraping, I will give you a high-quality Python script that make the job
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