Export your catalogue to a CSV file. You can edit it in a spreadsheet and import it again, or keep it as a backup.

Before you start

  • You have the product viewer role.
  • The export contains all your products that are not deleted, in their latest edited version, including unpublished changes. It is sorted by SKU. You cannot select products or filter.
  • Not in the file: prices, stock, delivery and attribute values.

Steps

  1. In the sidebar, open Offering & Logistics and then Products. On the My Products page, click Export CSV. The Export products dialog opens.
  2. Choose the Column layout:
    • Database columns (no mapping): the standard columns sku, brand, category_id, year_of_purchase, condition, external_ref, is_online_flag, selected_attribute_set_key, parent_id, primary_image_url, images, name, short_description, long_description and tags. The texts are in the default language of the product.
    • A saved mapping: the file gets the same column names and column order as the file that mapping was made from. A multi-language mapping gives one row per language.
  3. Click Download. You get the file products-YYYY-MM-DD.csv, comma-separated and in UTF-8.

Edit and import again

  1. Open the file in a spreadsheet and change what you need.
  2. Save it as CSV UTF-8, comma-separated.
  3. Import it again. See Importing products with a CSV file.

Keep the SKU column. Without a SKU column (or an external reference column), the import creates new products instead of updating the existing ones, and you end up with duplicates.

Good to know

  • Opening the file in Excel: use Data, then From Text/CSV, and choose UTF-8 and comma. That way accents and columns come out right.
  • If you see The export failed. Please try again., try again a little later.

Related