Parsing from Rozetka

Web application on FastAPI that automatically collects product data from rozetka.com.ua. There is an authorization system, a database, and three parsing modes. All results are saved in Excel categorized by categories.

What it does:

1. Parses products by search query or category — you insert the link, specify the number of pages, and the bot collects all items in Excel.
2. Collects products from a specific seller with data on groupings and minimum prices.
3. Allows saving and parsing favorite products manually or automatically.

What data it receives:
name, price (old and new), rating, number of reviews, brand, category, popularity, seller, payment methods, warranty, specifications, delivery, number of videos and credits. For sellers, metrics on reviews, prices, and groupings are added.

Technical part:
Selenium — for processing dynamic pages (expanding cards, scrolling, etc.), Cloudscraper — for bypassing Cloudflare, up to 10 threads simultaneously, batches of 60 products, random delays to simulate real actions.

Authorization system:
three levels of access — pending, accepted, and admin. JWT tokens are used (24 hours), passwords are hashed via bcrypt. There is an admin panel, by default a user admin1/admin33 is created.

Export to Excel:
products are automatically distributed by categories into separate sheets, columns are highlighted in color — green (main), orange (delivery), gray (popular features), yellow (rare). If there are no popular features in the category, the sheet is marked with three exclamation marks.

Technology stack:
Python, FastAPI, Selenium, Cloudscraper, BeautifulSoup, OpenPyXL, SQLite, JWT, bcrypt, asyncio, ThreadPoolExecutor.