Tasks and Scope of Work

1. 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 a "selection" garland when filtering products in the category - no longer needed

   4. Automate the mapping of 1st and 2nd level categories of all suppliers. Because after parsing there will be many categories from each supplier. It is impossible to map this in manual format

   5. In the admin panel for each supplier, there should be the ability 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. Highlighting duplicates in color in the dashboard.
   If duplicates - take the cheaper one by price wholesale (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

   1. 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
      • 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 (RRP, wholesale price, availability, quantity)
      • Link to the xml catalog of products processed from excel

   2. 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

   3. Parser Google Sheets Navionica and the Navionica site (garmin.ua) there is xml

      Design and elements

      • Field for the link
      • Time of last parsing completion
      • Enable / Disable monitoring
      • Block for setting 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

   4. 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

   5. Parser 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

   6. Parser 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

   7. Parser site sportorg.com.ua (there are xml exports) + MADHUNT (there are xml exports) our export from the promo. The product is entered as a separate supplier in the dashboard

   8. *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

   9. 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 export products
        • Ability to manage properties (price, availability, stock) of the product on export platforms
        • Ability to disable / enable 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
      
      

   10. 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 removal 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 must be
       • Automation
       • Separate additions
       
       

   11. 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

   12. Section - Proxy

       
       

   13. 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

   14. 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
       
       

   15. Modules for exporting products:

       1. 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
            
            
            

Appendices 3