Экспорт товаров EXCEL, YML, СSV (PIM)

There are 3 ways to export product lists from the system to the online store. You can use static links in XLS, YML, and CSV formats to create a list of goods. 

Preparing the list of products for export

To export goods, click on the left menu.

On the page that appears, you can upload the product according to the already prepared list of products. If the list of goods for uploading has not been created before, you will be prompted to create a new list.

Creating Product List

If you have not created export lists before, then after clicking the button, a page with the creation of a list will open:

Enter the name, and click Save.

If the list has already been created, then after clicking the button, a page with the created lists will open:

To add a new list, click Create list. Type the name of the list, and click Save.

Adding products to the list

After creating a list of products, you must add products to it. There are several options for this:

Adding products from the product catalog

In the catalog, you can:

1. Select the Catalog section;
2. Select one or more checkboxes;
3. Click Products export. 

Then you will be asked to choose the list  - you can select an existing list (left field of the form) or create a new list (right field of the form) and click on the Save button. All selected products will be added to the list for export.

After the necessary products are added to the export list, they will be marked with a “banner” in the catalog with the name of the list (when the list of goods is displayed as a list ): 

Adding to the list from the product card

Open the product catalog by clicking  on the left menu, then select the desired product. In the product card, click the Add to list button.

Then you will be asked to choose the list  - you can select an existing list (left field of the form) or create a new list (right field of the form) and click on the Save button. All selected products will be added to the list for export.

Export to Excel

To export goods, click  on the left menu. At the top, select the Excel tab.

Before exporting, make the following settings:

• Select a currency.
• If necessary, specify the properties of the products for export. The displayed properties are set in the administration panel (the Portal settings section > Properties when exporting area).
• If required, select the necessary checkboxes: Download prices in the format From and To, Download prices of the RRP, Download the modifications.
• Set the frequency of export.

After completing the settings, click the Apply button.

In the What to upload section specify the following:

• Products, categories, and tags manually selected (if you select this option, a list of products for export will appear at the bottom of the page, here you can delete unnecessary products, as well as a list of categories and tags for export).
• All goods (all products from the list will be exported).
• All available goods (all products from the list that are in stock will be exported).

Click the Apply button.

After selecting the goods for unloading and setting the export options, click the Form button.

After that, the process of file formation will begin, the Form button will become inactive, the Cancel button appears, which allows you to cancel the process if an error occurs.

When the export is finished, a link with the Excel file will appear in the Result area.

When you set the frequency of unloading, this link will be updated at the specified time.

Export to YML

To export goods, click on the left menu. At the top, select the YML tab.

Select the time of exporting and click the Apply button.

From the What to unload drop-down list, select the goods to be unloaded:

• Products, categories, and tags manually selected (if you select this option, a list of goods for export will appear at the bottom of the page, here you can delete unnecessary products, as well as a list of categories and tags for export).
• All goods (all products from the list will be exported).
• All available goods (all products from the list that are in stock will be exported).

Click the Apply button.

After selecting the goods for unloading and setting the export options, click the Form button.

After the end of the export, a link will appear in the Result area. Click the link to download the YML file.

When you set the time of export, this link will be updated at the specified time.

Export to CSV

This option is similar to Export to Excel, except for the need to specify a separator in the "Separator" field.