CSV import format

On the "Products" - "Import/Export" - "Import" tab - "XML, YML, CSV, XLSX, ODS" page, you can import CSV files.

However, for the file to be imported successfully, it must meet our requirements. Below is a list of supported columns, and their names must be exactly as specified:

• model* - product code. (must be the first column)
• name* - product name. For different languages, use the pattern: name_(language_code) (name_uk, name_en).
• description* - product description. For different languages, use the pattern: description_(language_code) (description_uk, description_en).
• metaTitle - product meta title. For different languages, use the pattern: metaTitle_(language_code) (metaTitle_uk, metaTitle_en).
• metaDesc - product meta description. For different languages, use the pattern: metaDesc_(language_code) (metaDesc_uk, metaDesc_en).
• category* - product category name. For different languages, use the pattern: category_(language_code) (category_uk, category_en). If a product belongs to the "Laptops" subcategory of the "Electronics" category, specify it as: Electronics>Laptops.
• images* - product images. Specify image URLs. Multiple URLs can be added using ; (semicolon) without spaces.
• price* - product price.
• discount - product discount.
• quantity* - product quantity.
• date - product creation date (for example, 2023-07-07 13:36:07).
• manufacturer - manufacturer name. For different languages, use the pattern: manufacturer_(language_code) (manufacturer_uk, manufacturer_en).
• options - product attribute, such as color or size. For different languages, use the pattern: option_(unique_number)_(language_code)_attribute_name (option_1_uk_колір, option_1_en_color).
• status* - product status. Can be active or not_active. Inactive products remain in the catalog but are not visible on the website.
• category_image - category image. Specify the image URL for the category. When adding an image to a subcategory, URLs should be separated using > in the same way as category names.
  For example:

  If the image should be assigned only to the child category, add the > symbol before the URL, like this:

  >https://images.prom.ua/6468355273_realme-13-pro.jpg

  In this case, the image will be imported into the child category, while the parent category will have no image. If both the parent and child categories should have images, use the following format:

  https://images.prom.ua/6468355273_realme-13-pro.jpg>https://images.prom.ua/6468355273_realme-13-pro.jpg

  .
• vendor - supplier template.
• EOREOR* - mandatory column that must be placed at the end of the table.

CSV import file example.