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
- In the sidebar, open Offering & Logistics and then Products. On the My Products page, click Export CSV. The Export products dialog opens.
- 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_descriptionandtags. 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.
- Database columns (no mapping): the standard columns
- Click Download. You get the file
products-YYYY-MM-DD.csv, comma-separated and in UTF-8.
Edit and import again
- Open the file in a spreadsheet and change what you need.
- Save it as CSV UTF-8, comma-separated.
- 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.