1688 Excel Scraper Tool

I need a small, no-cost scraper that my data-entry colleagues can run without touching code. Their task will be to upload a single Excel file that lists one or more 1688.com product URLs. When they press “Run”, the tool must create a fresh workbook where every product colour gets its own row.

For each colour please capture the full listing details: title, current price, every available size with its stock count, weight, the live product link itself and every gallery-image URL. All values must line up with the column order in the sample file I will provide.

Robust error handling is critical. If a page turns up blank, blocked or otherwise unreadable, the script should retry automatically; if the second attempt still fails, mark that row as failed and record the exact reason so we can review it later.

Technical notes
• Python is preferred, using Selenium, Playwright or another free library.
• Package the script as a simple double-clickable .exe or light GUI so non-technical staff can operate it.
• Make sure the scraper copes with dynamically loaded content, lazy images and basic anti-bot checks on 1688.

Deliverables
• Clean, well-commented Python source code plus a ready-to-run executable.
• User guide (one-page PDF or README) that shows the steps for uploading the URL file and receiving the output.
• A demonstration run on fifty sample products to confirm formatting and error logging.
• Brief notes on updating selectors if 1688 changes its layout.

Once the tool meets these requirements I will test it with a larger batch of links and sign off.