Working with cards using Excel templates
Category templates for working with products
Step 1. Download the template for the desired category
Unlike files intended for downloading a catalog, card templates include all the characteristics that belong to a specific category. Therefore, each category has its own template.
-
In the cabinet, click Products → Catalog.
-
In the upper right corner, click Upload products.
-
In the block By category click Download.
-
In the list, select the category that the products belong to, the cards of which you want to create or add, and download the template for it.
There is a search bar in this window — you can use it to find and download templates for categories that do not appear in the list.
Is it possible to download a template for a category in which I do not have products?
Yes. In it, you can see what characteristics are provided for this category.
Fill out the template
The instructions are in the template itself.
Keep in mind the rules:
- Do not change the file structure: the name and the order of the sheets and columns.
- Do not leave empty lines in the file between the filled ones.
- Do not use the tab character and line break. Do not insert formulas and links to other cells and files into cells.
- If there is a drop-down list in the cell, use the values from it, otherwise the product will not be included in the filters.
- If there are more than 15,000 products in the template, split it into two files.
Warning
If you have the option to automatically add content, then download the current version of the product file every time before updating, and make edits to it. If you do this through an empty template or uploaded a long time ago, then some of the updated data may not change.
Upload the completed template to the Market
When the file is ready, upload the file to the Market.
- In the cabinet, click Products → Catalog.
- In the upper right corner, click Upload products.
- In the block By category click Download.
- Use the button Select a file or just drag and drop the file into the download area.
The file will be sent for verification — first technical, and then for content verification.
The results of the verification will appear on the same page. If the file has not passed technical verification, you will see the status The file is incorrect or There are products with errors. Click More detailed next to this status, to see a description of the errors found.
If the technical check is passed, you can follow the process of updating the cards in the catalog.