Task:
There is a website OS 2.3

There are suppliers, price lists, and supplier websites.

Objective:
1. Add and update (if a new product appears from the supplier) products from suppliers exclusively based on the price lists provided by the supplier.
2. Enable updating products based on the supplier's price lists. (prices, stock)

3. Set up exports to marketplaces (Rozetka, Prom, others). And export the products.

Price lists in Excel, there is also part in xml, yml
Important:

1. configure up to 5 main characteristics when parsing products from each supplier, as there will be a garland
2. make a manual format for matching categories. As there will be intersections of products by categories (the client will do this)

One of the options for an extended technical specification. Or your options

Technical requirements (if needed)

1. Proxy https://proxy2.webshare.io/
2. Hosting for script placement
3. Windows server for parsing websites that block such parsing

Terminology

• Task structure
  • Design and elements - this is the visible part, usually a page.
  • Functions - in contact with the user: deletion \ creation \ import.
  • Automation - everything that is under the hood and works independently of the user.
  • Separate additions - third-party dependencies for task implementation.

Tasks and scope of work

1. Loading the Ibis arm excel catalog

   Design and elements

   • Field for uploading the excel catalog
   • Time of the last upload
   • Column settings fields: 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 (retail price, wholesale price, availability, quantity)
   • Link to the xml catalog of products processed from excel

2. Loading the Ibis fish excel catalog xml, xls

   Design and elements

   • Field for uploading the excel catalog
   • Time of the last upload
   • Column settings fields: 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 (retail price, wholesale price, availability, quantity)
   • Link to the xml catalog of products processed from excel

3. Loading the Stvol excel catalog

   Design and elements

   • Field for uploading the excel catalog
   • Time of the last upload
   • Column settings fields: 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 (retail price, wholesale price, availability, quantity)
   • Link to the xml catalog of products processed from excel

4. Parser Stvol xls, xml

   Design and elements

   • Field for link
   • Time of the 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

5. Parser Google Sheets Navionica xls

   Design and elements

   • Field for link
   • Time of the last parsing completion
   • Enable \ Disable monitoring
   • Block for setting sheet parameters: Sheet name, product name column, product stock column, product availability column, article column, retail price 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

6. Parser website Navionica xls

   Design and elements

   • Field for link
   • Time of the 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

7. Parser xml catalog Atlant market xml

   Design and elements

   • Field for link
   • Time of the 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

8. Parser xml catalog kievopt xml

   Design and elements

   • Field for link
   • Time of the 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

9. Parser website Control (no price lists)

   Design and elements

   • Field for link
   • Time of the 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

10. Parser website Optics pro (no price list)

    Design and elements

    • Field for link
    • Time of the 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

11. Parser website Skinandskin(xls)

    Design and elements

    • Field for link
    • Time of the 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

12. 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 disable \ enable product updates (prices, availability) for any of the export platforms
      • Products should be displayed in the context 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

13. 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 photo watermark removal
    • 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 triggered by a button and open a modal window for selecting the translation language, from which we translate and to which we translate. Confirmation in the modal window starts the translation, which will last until completion. The more products, the longer it takes.
    • Automation

    Separate additions

14. 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, relationship to parent

15. Section - Proxy

    Design and elements

    • Page in the form of a table with the following columns:
      • Identifier
      • Proxy
      • Status (active\ inactive)
      • Creation date
      • Update date
    • Mass deletion button
    • Proxy check button
    • Functions
    • Mass deletion of records
    • Update the proxy list by importing from a txt file or link for import https://proxy2.webshare.io
    • Ability to activate the status check of proxy activity

16. 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:
      • Name
    • Mass deletion of records

17. 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
      • Relationship to category or categories
    • Mass deletion of records
    • Automation

    Separate additions

18. Modules for exporting products:

    1. Rozetka.ua

       Design and elements

       Functions

       • Category dependency settings
       • Enable / Disable updates
       • Set update frequency in minutes
       • Link to the catalog being exported
       • Automation
       • Update products (availability, price)
       • Create new products and link them with system products
       • Separate additions

    2. Prom.ua

       Design and elements

       Functions

       • Category dependency settings
       • Enable / Disable updates
       • Set update frequency in minutes
       • Link to the catalog