I need a custom automation tool that connects Excel, Amazon, and my WordPress/WooCommerce website for automatic product management. The goal is to read data from an Excel file, check for duplicates on my website, update existing products, and scrape new products from Amazon and other sites when missing. Detailed Requirements: Excel-Based Input: I will upload an Excel file containing all product details (like ISBN, SKU, or title). The tool will use this Excel as the main input for checking and updating products. Duplicate Check on Website: The tool will first compare Excel data with existing products on my WooCommerce website (via REST API). If a product already exists, it will only update the price and inventory (quantity). No duplicate products should be created. Scraping for Missing Products: If a product from Excel is not found on my website, the scraper should automatically: Fetch full product data (title, author, publisher, price, stock status, image, and description) from Amazon.in and other sources (like Bookswagon or ExoticIndiaArt). Clean or modify metadata (format titles, enhance descriptions, etc.) as per rules I’ll provide. Upload the new product to my WooCommerce website automatically. Website Integration: Seamless integration with WordPress/WooCommerce via REST API. Ability to push both updates and new products directly. Option to log every change (added/updated/skipped) in an output Excel or CSV. Technical Preferences: Language: Python (BeautifulSoup / Scrapy / Requests preferred). Excel/CSV data handling with Pandas. WooCommerce REST API for upload and update. Clean, modular code with comments and documentation. Optionally: a simple GUI (to upload Excel and start the process). Deliverables: Fully working scraper and automation script/tool. Documentation (setup + usage guide). Testing on my live WooCommerce website. Skills Required: Python (BeautifulSoup / Scrapy / Requests) WooCommerce REST API / WordPress integration Excel/CSV handling Web scraping & automation Data cleaning & metadata formatting Example Workflow: Upload Excel → Tool checks WooCommerce → Finds duplicates. Updates price/inventory for existing items. For missing SKUs → Scrapes Amazon & others → Cleans metadata → Uploads new products to website. Generates a summary log file (added/updated/skipped).