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
icon