Closed

Supermarket Product Data Scraping into Excel via Macros -- 2

Background:

I am looking to scrape website data from two supermarket websites in Australia. (Woolworths and Coles). The only products that I am after are the products that are on sale. The expected output will be a macro embedded or excel spreadsheet that can be used on a weekly basis to scrape data.

Data I am after (but not limited to):

- Product Name

- Brand Name (if applicable)

- Sale Price

- Single buy v multi buy (i.e. if the product is only on sale when you purchase 2 or more products. e.g. 2 for $5)

- Discount and/or Original Price

- Sale price measure (i.e. $/gram , $/unit etc)

- Product Code/ID (or SKU)

- URL

Output:

I am after the above information fields placed into a excel for each sales product that would be triggered by an excel macro. The usage is to run this on a weekly basis to extract new specials.

Coles Source:

[login to view URL]

Woolworths Sources:

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL]

Things to note:

- The source pages above had multiple pages (i.e. page 1, 2, 3, etc.) The macro is expected to go through each page to pull data from

- Ensuring there are no IP bans when running this macro or repeated use of this macro

Curious to know what thoughts you have and to understand the doability. Please don't accept this project if you don't think you can deliver. If you have any questions, please don't hesitate to reach out to me.

Skills: Excel, Web Scraping, Data Entry, Visual Basic, Data Processing

See more: product data excel, excel macros selecting data pasting, scraping data jpeg excel, urgent excel product data entry, excel macros data web, excel macros data internet, excel macros check data cell, paste data locations excel macros, download product data scraping, retrieve data internet excel macros, product data scraping, data list excel macros, data scraping excel spreadsheet, data conversion excel macros, how to match data in excel from 2 worksheets, product data scraping service by fishpig, how to match data in excel from 2 worksheets using vlookup

About the Employer:
( 1 review ) Sydney, Australia

Project ID: #30193488

42 freelancers are bidding on average $163 for this job

(400 Reviews)
8.1
phpXpertbd

Hi there! I have checked the project details; I am expert in Web searching task. Contact me so I can make few samples before you award the job. Looking forward to work with you thanks. With Regards DEBDULAL ROY

$200 AUD in 7 days
(78 Reviews)
7.3
paulmd369

ok so the task is to scrap super market data into Excel in project description as you specified URL I need to do with that link I am interested let me know thank you so much

$200 AUD in 5 days
(146 Reviews)
6.6
(110 Reviews)
6.8
(25 Reviews)
5.5
ARTICLEYOUWANT

I will scrape website data from two supermarket websites in Australia. (Woolworths and Coles). I will be doing it manually for 100% accuracy so if you are looking for something similar, please hit me up. I will scrape More

$100 AUD in 1 day
(26 Reviews)
5.5
rkurilenko007

Hi. How are you. I am a professional python scraper, I understand what you want. I have powerful experience and skills in this aspects. If you interested in me, please let me know.

$300 AUD in 2 days
(11 Reviews)
5.2
Banze

I can I help you in Supermarket Product Data Scraping into Excel. I have read and understood all your initial requirements, and I feel,I am producing quality data entry for my clients including; Web Research, Data Mini More

$250 AUD in 7 days
(43 Reviews)
5.3
pilotarif

Hello there, I have gone through your project  "Supermarket Product Data Scraping into Excel via Macros -- 2 ", and I can firmly assure that I have understood the requirements and can perfectly do the project work with More

$140 AUD in 7 days
(41 Reviews)
5.1
kimhuo99

Hello How are you? I am a python expert and Web scraping expert I can help you Thanks

$140 AUD in 7 days
(15 Reviews)
4.9
fadeevdoma

✔️ https://www.freelancer.com/u/fadeevdoma Hello, As you can see in my profile, I am the expert in Selenium web scraping, I specialized in product scraping from e-Shops. Through your job description, I am sure that thi More

$140 AUD in 7 days
(2 Reviews)
3.8
RequenaP

Hello, how are you? I'm Pedro, a pleasure to meet you, I just read your project of "Supermarket Product Data Scraping into Excel via Macros - 2", from what I understand you need an application that will scrape data fro More

$360 AUD in 20 days
(6 Reviews)
3.9
Prgohil89

♦ Web Research Expert ♦ Surely Delivery in 2 Days ♦ Team of 18+ ♦ Immediate Start ♦ Offering you Professional IT Experience in data mining, web searching, Web scrapping and lead generation with over 5+ years experienc More

$250 AUD in 7 days
(8 Reviews)
3.8
prembasu24

Hello there! I am really honored to place a bid on your Supermarket Product Data Scraping project posting. I read through the job details extremely carefully and I am absolutely sure that I can complete the project pe More

$140 AUD in 7 days
(9 Reviews)
3.6
(8 Reviews)
3.2
BabakKanan

Hi, I read the project description and what are you looking for is doable but not with Excel's macro. I have done many similar projects collecting product information of various online stores which you can check them o More

$100 AUD in 3 days
(4 Reviews)
2.9
maksimihnatiuk14

Dear Client! As a full stack developer I have extensive knowledge of webscrapping. My extensive experience with web scraping using IP proxy rotation, Selenium, tor Browser, multi thread and Bypassing captcha well wit More

$200 AUD in 7 days
(1 Review)
2.3
(3 Reviews)
2.3
Mendez61187

I am computer science engineer. I am an expert of Excel and I know how yo scrape data from website through Excel and Selenium and chrome. We can try another type of web scraping if you are not interested in Selenium.

$222 AUD in 3 days
(2 Reviews)
2.0
ACCASpogmai

"Sir, This data extraction is so easy for me i will provide a formatted work with detailed information.. i have completed similar accounting and data extraction assignments with 5 star ratings from client, you can ch More

$30 AUD in 1 day
(4 Reviews)
1.7