Help Documentation

Note:When Uploading the file URL the file name should not have spaces in it it can have – and _.

The export name should not contain “/”

Minimize the use of special characters in the file name.

Installation

1. 1. Click on the App Store
   2. Search and click on Custom Template Downloader
   3. Click on Install Custom Template Downloader
      1. Fixed Rows[The total header row count in the sheet, including those that are hidden and intended to remain fixed]
      2. Header Row Pos[The desired position of the header row that you want the system to recognize as the header.]
      3. Sheet Num[When dealing with multiple files, you have the option to indicate which file to consider by specifying the sheet number. If you wish to consider the first file, simply assign it the number ‘0’.Note:Please ensure that all sheets are visible to avoid any confusion when assigning the sheet numbers.]
      4.  Delimiter[CSV(,) TSV(Tab Space),XLSX nothing should be entered]
   4. Choose the file by clicking on Upload file                                                                                                                                                                                      Note: Sheet should have only the header rows, multiple header rows if required but there should not be any product data in the sheet  Add on: Formula to get properties as an comma separated values=TEXTJOIN(“,”,TRUE,A1[Index for first property]:AL1[Index for last property])
   5. Click on Install.
   6. Click on View Export Template.
   7. Skip the one property that is present
   8. Click on Action to the top right corner of the screen
   9. Click on Bulk add properties
   10. Copy the properties from the Excel sheet and paste them here in bulk add properties. 
   11. Click on Update.

Now, to view the products in the given Excel sheet format

1. Click on Certified Products 
2. Select Products
3. Click on Export All Products
4. You can see the file in the export list 
5. Click on Download CSV.