Carefully review the possibility of parsing suppliers
Important:
1. Separate display of products entered manually in the system for subsequent updates through created automation. Based on the excel price list
2. Removal of watermarks on photos (if possible)
3. Solve the problem and configure up to 5 main characteristics, filters, attributes of the product card in automatic mode when parsing products from each supplier, to avoid the "selection" garland during product filtering in the category - no longer needed
4. Automate the mapping of categories of level 1 and 2 for all suppliers. Because after parsing there will be many categories from each supplier. It is not possible to map this in manual format
5. In the admin panel for each supplier, there should be an option to add only certain categories to our site (provided that direct parsing, without price lists). It is mandatory in the backend to display the supplier's name in the product card. In the Ean field (supplier name)
6. Removal of duplicates by name, code, article. Highlight duplicates in color in the dashboard.
If duplicates - take the cheaper wholesale price (since there will be duplicates)
7. The dashboard should have the ability: to set a markup, enable/disable/delete a product. (example in screenshots)
The project is considered successful if: the product is added to our OpenCart site, corresponds to the categories, filtering, attributes, options work adequately, the product is displayed on the live marketplaces, the product is updated according to the price lists or the parser
Loading the excel catalog Ibis arm, Ibis fish, excel catalog Stvol - there is xml
Design and elements
- Field for uploading the excel catalog
- Time of last upload
- Fields for configuring columns: title, wholesale price, retail price, stock, article, availability
- Button to save settings
- Link to the last converted xml
- Functions
- Conversion of excel to xml for further processing and detection of changes in products (RRP, wholesale price, availability, quantity)
- Link to the xml catalog of products processed from excel
Parser Stvol if necessary
Design and elements
- Field for the link
- Time of last parsing completion
- Enable / Disable monitoring
- Ability to specify a list of categories to exclude from parsing
- Ability to set the frequency of parsing in minutes
- Functions
- Link to the xml catalog of products from the last parsing
- Automation
- Automatic start of parsing from the moment of completion
Parser of Google Sheets Navionica and the Navionica site (garmin.ua) has xml
Design and elements
- Field for the link
- Time of last parsing completion
- Enable / Disable monitoring
- Block for configuring sheet parameters: Sheet name, product name column, product stock column, product availability column, article column, RRP column, wholesale price column
- Ability to set the frequency of parsing in minutes
- Functions
- Link to the xml catalog of products from the last parsing
- Automation
- Automatic start of parsing from the moment of completion
Parser xml catalog Atlant market
Design and elements
- Field for the link
- Time of last parsing completion
- Enable / Disable monitoring
- Ability to set the frequency of parsing in minutes
- Functions
- Link to the xml catalog of products from the last parsing
- Automation
- Automatic start of parsing from the moment of completion
Parser of the site Control, zeta-zoid, Optics pro, cezar.ua(only radios),
Design and elements
- Field for the link
- Time of last parsing completion
- Enable / Disable monitoring
- Ability to specify a list of categories to exclude from parsing
- Ability to set the frequency of parsing in minutes
- Functions
- Link to the xml catalog of products from the last parsing
- Automation
- Automatic start of parsing from the moment of completion
Parser of the site 4 seasons, DB.ua, price excel
Design and elements
- Field for the link
- Time of last parsing completion
- Enable / Disable monitoring
- Ability to specify a list of categories to exclude from parsing
- Ability to set the frequency of parsing in minutes
- Functions
- Link to the xml catalog of products from the last parsing
- Automation
- Automatic start of parsing from the moment of completion
Parser of the site sportorg.com.ua(there are xml exports) + MADHUNT( there are xml exports) our export from Prom. The product is entered as a separate supplier in the dashboard
*Design and elements
- Field for the link
- Time of last parsing completion
- Enable / Disable monitoring
- Ability to specify a list of categories to exclude from parsing
- Ability to set the frequency of parsing in minutes
- Functions
- Link to the xml catalog of products from the last parsing
- Automation
- Automatic start of parsing from the moment of completion
Dashboard - Products
Design and elements
- Page in the form of a table with the following columns:
- ID
- Product name
- Price
- Availability
- Internal article
- Creation date
- Update date
- Supplier name
- Supplier article
- Supplier availability
- The dashboard should show related products with exported products
- Ability to manage properties (price, availability, stock) of the product on export platforms
- Ability to enable / disable product updates (price, availability) for any of the export platforms
- Products should be displayed in the breakdown of each of the export platforms by categories
- Ability to go to the product to view the connection of the product with the products of export catalogs
- Functions
- Automation
Section - Products
Design and elements
- Page in the form of a table with the following columns:
- Product status
- Product name
- Category
- Model also sku
- Ean (supplier name)
- Price
- Quantity
- Availability
- Update switch Enabled / Disabled
- Manufacturer
- Modal window for uploading excel with new products
- Modal window for checking attributes
- Modal window for checking category filter options with the ability to add a new one
- Auto-translate button
- Mass deletion button
- Button for managing the cleaning of photos from watermarks
- Functions
- Mass deletion of records
- Ability to import new products and edit each of the imported products, making the following edits with saving:
- Title
- Description
- Category
- Model
- Ean
- Price, Wholesale, Availability
- Manufacturer
- Attributes
- Photo (url)
- The automatic translation function should be available
- Automation
- Separate additions
Section - Categories
Design and elements
- Page in the form of a table with the following columns:
- Name
- Identifier
- Creation date
- Update date
- Mass deletion button
- Functions
- Mass deletion of records
- Ability to go to the category and edit:
- Name
- Connection, relation to parent
Section - Proxy
Section - Attributes
Design and elements
- Page in the form of a table with the following columns:
- Name
- Identifier
- Creation date
- Update date
- Mass deletion button
- Functions
- Ability to go to the attribute and edit:
- Mass deletion of records
Section - Filter Options
Design and elements
- Page in the form of a table with the following columns:
- Name
- Identifier
- Category
- Creation date
- Update date
- Mass deletion button
- Functions
- Ability to go to the option and edit:
- Name
- Relation to category or categories
- Mass deletion of records
- Automation
- Separate additions
Modules for exporting products:
Rozetka.ua and Prom.ua. The task is closed subject to the approval of the product by the platform
Design and elements
Functions
- Settings for category dependencies
- Enable / Disable updates
- Set the frequency of updates in minutes
- Link to the catalog being exported
- Automation
- Updating products (availability, price)
- Creating new products and linking them with system products
- Separate additions
Creating missing attributes
Creating missing filter options
Enable / Disable updates
Set the frequency of updates in minutes
Link to the catalog being exported
Automation
Updating products (availability, price)
Creating new products and linking them with system products
Separate additions
