Develop a script that:
Loads data from 2 XLSX links
Extracts information about products (article number, price, availability).
Updates the corresponding products on Prom.ua via API for 5 stores.
1. Data sources
Format: Excel file via direct link
Number of sources: 2 links.
Update frequency: once a day.
2. Fields to process:
Article number — used to search for the product on Prom.ua
Price — product price, to be updated.
Availability / Quantity — to be updated.
Additionally:
Ability to set markup or price adjustment (for example, +10% for store 1).
3. Business logic
The same product list can be updated on all 5 stores.
Each store has its own API key and may have individual rules:
Markup/discount.
Update only if the price has changed.
4. API Integration with ozon.ru
Actions used:
Retrieve product list (by article number or ID).
Update information: price, stock
5. Update frequency
Automatic run once a day (by schedule).
Optional manual run.
Logging updates (what was updated, what was skipped, errors).
6. Infrastructure
Language: Python 3.x.
Configuration storage: .env or config.json (keys, links, store settings).
Execution:
Locally (manual start).
Or on free GitHub Actions (by schedule).
7. Output / logging
log.txt file
Article number
Was → Now (price/stock)
Store
Status (updated, skipped, error)
8. Create and configure a Telegram bot for success/failure notifications
9. Deploy and configure on GitHub Actions
Offer your terms
