Sneaker Stock Upload Automation

Замовник: AI | Опубліковано: 08.01.2026

I manually upload stock numbers for dozens of sneaker SKUs from a Google Sheet into several retail sites every day, and it is eating far too much time. Each site only allows browser log-in with a regular username / password—no public API—so a solution that signs in, finds the product by SKU, and pushes the latest size-level quantities in one shot. What I expect your script or bot to do • Read the live Google Sheet and capture SKU + size breakdown. • Open the target site, perform the standard username/password login, and navigate to the product page for that SKU. • Update every available size with the exact pair count listed in the sheet. • Scrape the page again right after saving, compare the on-site figures against the sheet, and compile a brief summary report of any mismatches. • Save all discrepancies (or a clean “all matched” note) into a dated file I can download at the end of the run. A fast run time matters more to me than an over-engineered UI, as long as I can launch it with one command and swap credentials or add another site in the future without rewriting code. Selenium, Playwright, or a similar browser-automation library is fine—use what you know best, but please keep the project structured so I can maintain it. I would prefer to make it done by requests as right now it is 13 websites and to go one by one with browser would eat too much time Acceptance criteria 1. One-click start, no manual steps after supplying credentials. 2. Stock numbers on every site match the Google Sheet when the script finishes. Regular checks are needed too. 3. A clear, human-readable summary file is generated for each run. If you have questions about site quirks or need sample log-ins, let me know and I will provide them.