Grocery Price Scraper Creation

Build a reliable, locally runnable "Coles & Woolworths Price Data Extraction Tool" that collects weekly Coles and Woolworths product pricing data across Australia.

- Build a tool that can be executed automatically every week.
- Scrape product data from Coles and Woolworths websites for all available store locations across Australia.
- Extract the following fields: product name, package size/weight/volume, current price, unit price (e.g. $/kg), retailer, store location, product URL, promotional price (if applicable), and extraction date.
- Capture location-specific pricing, including regional price differences and store-specific promotions, wherever available.
- Collect all available products, including different sizes and variants, while avoiding duplicate records.
- Export the extracted data in a structured format such as CSV or JSON.
- Include logging, error handling, retries, and a summary of successful and failed extractions and uploads.
- Make retailer settings, store locations, execution schedule, and AWS configuration configurable without changing the core code.