To add goods products by importing goods products using an XLS file, the user needs to click on the Username (name / email) in the user panel (menu). By clicking on it, a drop-down menu will open.

Fig. 1 - User menu

In the menu that opens, you must select the "Settings". On the page that opens, in the left side menu, select the item “Download data from XLS” and the user will be redirected to the page (/accounts/supplier/import/xls) for further work with the function of importing goods.

Image Added

Fig. 2 - Go to the import page

If you have not previously imported

products, the  page has the form shown in Figure 3.

If import has already been done before, then the page has the form shown in Figure 4.

To add a new data loading source, click on the "Add file" button.

   Fig. 3 - Page without a list of sources

Image Modified

Fig. 4

After clicking on the "Add file" button, the user will be redirected to the page to download the file prepared in advance

In the "Download file" field, you must select a file of the appropriate format, which will be downloaded by clicking on the "Download file" button. In the field instead of "Select file" the file name will be displayed. Then click on the "Next" button.

Next, the user will be redirected to the import settings page (/accounts/supplier/import/xls/ID). On which you want to set the desired import settings

This page has fields for selection. 

• Select a sheet from the uploaded document

• Choose the type of import (category, properties, products)

• check box Skip first row (exclude import of document table header with column names)

• Values ​​for matching product data (select with list of values)

• Identifier - designed to determine what will be displayed on the site (you must select at least one identifier)

• table with

• products - a list of

• products loaded from a file

Image Modified

Fig. 6 - Import Settings

Additional settings include the following:

• Manual download 
• Automatic download (for the ability to automatically update data on products from a file by reference), 
• Download by email, 
• Download frequency (contains a select with a list of available intervals in days, the default is - Do not download, if desired, the user can select an option from the ones proposed)

Fig. 7 - Manual download

Fig. 8 - Automatic download

Image Modified

Fig. 9 - Email Download

To complete the download process in manual download, click the Download file button; in all other cases, click the Save button.