TASK:
Develop an automatic Python script (parser) to collect a catalog from the website
(I have a login/password), so that:
it exports all products of the brand (the entire site is dedicated to it),
with real stock balances,
and saves it in an Excel file that I can use in my online store.
🧾 What needs to be collected for each product:
Field What it is
Part No. product article
Title product name
Requested Qty fixed value 9999
Qty Available how many are actually in stock
Production Qty how many are in production/on the way
Backorder how many are ordered in minus
Available On date when it will be available in stock
Unit Price price per piece
List Price recommended price (if any)
Total Price Unit Price × Requested Qty
Total Price Available Unit Price × Qty Available
Lbs, Kgs weight in pounds and kilograms
Vol (ft³) volume in cubic feet
Image URL link to the photo
Description short description
Location must always be in stock
Detail URL link to the product page
📦 Data source:
Website catalog (entire assortment).
If convenient – you can go through the public categories of the site or create a list of SKUs (but the goal is to get the entire catalog of the brand).
🧠 Important:
The script must enter the card of each product, set Qty = 9999, click Update Qty, and only then read the real balances (Qty Available/Production Qty, etc.).
The parser must be discreet:
Single-threaded mode (without parallel requests),
Pauses between actions (random),
No load on the site.
All data should be stored in an Excel file (.xlsx), preferably with automatic naming by date.
⚙️ How to run:
The script should work optionally on the server.
There should be a way to schedule it to run several times a week (via a scheduler or by command).
💬 I expect from the freelancer:
Configured Python script, instructions for running, without terminal with a user-friendly interface
Installation commands (pip install …),
Willingness to test together with me.