XLSX and ODS import formats
On the page "Products" - "Import/Export" - "Import" tab - "XML, YML, CSV, XLSX, ODS" you can import files in XLSX and ODS formats.
However, to import the file, it must meet our requirements. Below you can see a list of possible columns for import in English, and they should be named as follows:
- model* - product code.
- name* - product name.
- description* - product description.
- price* - product price.
- metaTitle - product meta title.
- metaDesc - product meta description.
- images* - product images. You need to specify links to product images, and there can be several links.
- discount - product discount.
- quantity* - product quantity.
- status* - product status, can be active or inactive. Inactive products are displayed in the catalog, but not visible on the site.
- date - product addition date.
- category_1* - product category name.
- category_2 - subcategory name, as well as columns for categories below.
- category_3
- category_4
- category_5
- manufacturer - product manufacturer name.
- any characteristic name - for example, a "Color" column. There can be several columns for characteristics.
- EOREOR* - mandatory column that must be at the end of the table.
The names of mandatory columns are marked with an asterisk (*). Accordingly, the file must contain the columns model, name, description, category_1, images, price, quantity, status, EOREOR.
Last updated on: 31/07/2024