Technical task
Project
Configuration of filling and synchronization of two Prom.ua stores with suppliers of auto parts.
Task
It is necessary to implement the loading and updating of products from auto parts suppliers for two online stores on Prom.ua.
⸻
1. Connecting suppliers
It is necessary to connect suppliers through:
- Supplier API;
- XML, CSV, XLS price lists;
- or another available method of obtaining products from the supplier's website.
It is important to ensure complete synchronization of products between the supplier and the Prom.ua stores.
⸻
2. Filtering and selection of products
It is necessary to implement the ability to select products during import based on the following parameters:
- Car brand;
- Category of parts;
- Subcategory of parts;
- Other available characteristics.
Example:
For each store, there should be the ability to separately determine which categories of products and which car brands need to be loaded.
Additional requirements for product selection
It is necessary to implement the ability to select products during import not only by car brands and categories of parts but also by product availability status.
There should be the ability to configure the following scenarios:
- Import only products that are in stock with the supplier;
- Do not import products with the status "out of stock";
- Disable or remove products from Prom.ua after they are out of stock with the supplier.
During pricing configuration, there should be the ability to combine filters:
- By car brand;
- By category of parts;
- By subcategory;
- By product availability.
Example:
Import only parts for Volkswagen and Audi, category "Braking system", that are in stock with the supplier.
It is also necessary to implement a mechanism to prevent duplication of products from different suppliers. If the same product is present with multiple suppliers, only one product record should be imported into the catalog.
Criteria for selecting a product when duplicates are detected:
- Priority is given to the product that is in stock with the supplier;
- If the product is in stock with several suppliers, priority is given to the product with the lowest price;
- If the cheapest product is out of stock, the system should choose the cheapest product among those that are in stock;
- Duplicate products from other suppliers should not create separate entries in the catalog.
Example:
Import only parts for Volkswagen and Audi, category "Braking system", that are in stock with the supplier.
If the same part is available from several suppliers, only one entry is imported into the catalog — from the supplier with the lowest price among those who have the product in stock.
⸻
3. Import of product cards
During import, the following should be automatically loaded:
- Product name;
- Article;
- Photos;
- Product description;
- Price;
- Product characteristics;
- Manufacturer;
- Other available parameters.
⸻
4. Updates
It is necessary to set up automatic:
- Price updates when changed by the supplier
⸻
5. Removal of unavailable products
Products that are no longer in stock with the supplier should:
or
- Be removed from Prom.ua (by agreement).
⸻
6. Filling the stores
It is necessary to:
- Create a category structure;
- Create subcategories;
- Correctly distribute products across categories;
- Check the correctness of product import.
⸻
7. Work results
After the work is completed, there should be:
- Suppliers connected;
- Product import configured;
- Price updates configured;
- New product addition configured;
- Disabling or removal of unavailable products configured;
- Prom.ua stores fully filled and ready for operation.
