Export products

You can export your products as an XLSX file. This functionality can for example be used to compile the respective product data for point-of-sale (POS) systems or other external systems. You can also export your products, update product data in the export file, and then import this file again to update several products at once.

Skip to:

• How to export products
• The structure of the XLSX file

How to export products

1. In the sidebar of your cockpit, select Products.
2. In the upper right corner, select Export all products to start the product export.

   Note

   Note that the export will always include all products of your cockpit, no matter their product status or currently applied filters.
3. You are forwarded to a new tab dedicated to product export.

   Note

   Do not close the new tab until the download of the XLSX file is finished. Depending on how many products you would like to export, the preparation and the download of the XLSX file might take a short while. But no worries, you can continue working in your cockpit in the other tab.

   The product export consists of three phases:

   • The XLSX file is being prepared and a text is informing you that the download will start in a few moments.
   • After the file has been prepared, the download automatically starts (if allowed by your browser, otherwise you first need to allow the download in a pop-up window). In some browsers, you can keep track of the download at the bottom of the browser window in a status bar (e.g. in Chrome). In other browsers, the download will only be processed in the background (e.g. in Safari and Firefox).
   • The download is finished and you can open the XLSX file. It depends on your browser how to open the file. Some browsers will display a pop-up asking you if you would like to open the file (e.g. Firefox), others will add the XLSX file to a Download icon in the upper right corner (e.g. Safari), and yet others show the file in the bottom bar of the browser (e.g. Chrome).

You have exported your products and can further process the XLSX file. We recommend saving the XLSX file in a dedicated folder to make it easier for you to find the product export later on. If you would like to export your products again, you can do so at any time. The name of the XLSX file includes the date of the export to make it easier for you to manage the different product export files.

The structure of the XLSX file

Let's have a look at the general structure of the XLSX file. The file includes one row per product. In the case of variation products, the file includes one row for the variation product and one row for each related variation.

The following columns are included in the XLSX file:

Name	Description
sku	The Stock Keeping Unit (SKU) of the product. The SKU is an article or item number that uniquely identifies the product.
name	The product name as it is shown on your website.
visible	Products can be saved as a draft or published. If the column shows 0, the product is saved as a draft. If it shows 1, the product is published.
tags	Tags are key words that are one of the available criteria for the creation of automatic categories. You can choose any word you like as a tag. Tags are not shown to the visitors of your website. The column shows tags added to the respective product.
salesPrice.amount	This column depends on whether or not the product has a sale price. If the product has a sale price and the reduced price is shown next to the regular price, this column contains the reduced price. If the product does not have a sale price, the regular price of the product is shown in this column.
listPrice.amount	This column depends on whether or not the product has a sale price. If the product has a sale price and the reduced price is shown next to the regular price, this column contains the regular price. If the product does not have a sale price, this column is empty.
manufacturerPrice.amount	The recommended retail price (RRP), also known as the manufacturer's suggested retail price (MSRP), is the price that the product's manufacturer recommends for the sale of the product.
description	The product's description as it is also shown on the product's detail page on your website.
manufacturer	The product's manufacturer, wholesaler, or other vendors.
productIdentifiers	The product codes of the product. Product codes are, for example, the European Article Number (EAN), the Universal Product Code (UPC) and the International Standard Book Number (ISBN). The code is not displayed on the website but can be used by visitors to search.
essentialFeatures	The product's essential product characteristics, meaning the features by which it is characterized. In some countries, it is legally required to inform customers about the essential characteristics of a product before they do the final purchase in the checkout. This allows them to compare one product with another, and make a well-informed purchase decision without seeing the product in real life.
taxClass	The product's tax class. This can either be REGULAR, REDUCED, or EXEMPT.
shippingWeight.value	The shipping/delivery weight of the product (including packaging) in grams (by default) or kilograms. Enter only the number without a unit. Example: 1500
shippingWeight.displayUnit	The weight unit for the shipping/delivery weight you have entered for specifiedShippingWeight.value. You can enter GRAMS or KILOGRAMS
shipping weight	The shipping/delivery weight of the product (including packaging) in grams.
maxOrderQuantity	The maximum quantity of the product that can be ordered at once. Note that this property is currently not reflected in your cockpit. Nevertheless, visitors won't be able to order more than the determined quantity.
shippingPeriod.min	The minimum number of days, weeks, or months for shipping/delivery the product. The related unit is shown in column shippingPeriod.displayUnit.
shippingPeriod.max	The maximum number of days, weeks, or months for shipping/delivery the product. The related unit is shown in column shippingPeriod.displayUnit.
shippingPeriod.displayUnit	The unit for the product's shipping/delivery period. This can either be DAYS, WEEKS, or MONTHS.
shippingDimension.length	The length of the product (including packaging) in millimeters. Note that this property is currently not reflected in your cockpit or on your website.
shippingDimension.width	The width of the product (including packaging) in millimeters. Note that this property is currently not reflected in your cockpit or on your website.
shippingDimension.height	The height of the product (including packaging) in millimeters. Note that this property is currently not reflected in your cockpit or on your website.
refPrice.refQuantity	The reference price enables visitors to compare prices regardless of package sizes. Example: 1l=10,53 Euro It is automatically calculated based on the product quantity (column refPrice.quantity) and the reference (this column combined with column refPrice.unit).
refPrice.quantity	The reference price enables visitors to compare prices regardless of package sizes. Example: 1l=10,53 Euro It is automatically calculated based on the product quantity (this column) and the reference (column refPrice.refQuantity combined with column refPrice.unit). The unit of the product quantity is the same as the reference unit (column refPrice.unit).
refPrice.unit	The reference price enables visitors to compare prices regardless of package sizes. Example: 1l=10,53 Euro It is automatically calculated based on the product quantity (column refPrice.quantity) and the reference (this column combined with column refPrice.refQuantity). The following units are supported: GRAM, KILOGRAM, MILLILITER, LITER, METER, SQUAREMETER, and CUBICMETER. The unit is also used for the product's quantity (column refPrice.quantity).
images	The list of images for the product.
stockLevel	Keeping track of your inventory keeps you up-to-date about when you need to order or produce new goods and helps to prevent that visitors order products that are no longer in stock. If you track the stock level, this column shows the quantity of the product that is currently available.
stockThreshold	Keeping track of your inventory keeps you up-to-date about when you need to order or produce new goods and helps to prevent that visitors order products that are no longer in stock. The stock threshold is the number up to which the product should be displayed as "low stock" on your website. If the stock level reaches or falls below this number, it is also an indicator for you that this product needs to be re-ordered or re-produced soon. In the case of variation products, the stock threshold is the same for all variations of the variation product.
variationLevel	Variation products are products of the same type that differ only in certain attributes (e.g. size, color, material). These attributes, in turn, are assigned values (e.g. M, green, cotton). Each combination of attributes and values is a variation. A variation product can have up to 3 attributes and a maximum of 150 variations. The column shows MASTER for the first row of a variation product. This row includes general information about the variation product. The column shows VARIATION for all variation rows related to that variation product. These rows include variation-specific information. The column is empty for all products without variations.
variationAttributes.1.displayName	Variation products are products of the same type that differ only in certain attributes (e.g. size, color, material). These attributes, in turn, are assigned values (e.g. M, green, cotton). Each combination of attributes and values is a variation. A variation product can have up to 3 attributes and a maximum of 150 variations. This column shows the name of the first variation attribute.
variationAttributes.1.values	Variation products are products of the same type that differ only in certain attributes (e.g. size, color, material). These attributes, in turn, are assigned values (e.g. M, green, cotton). Each combination of attributes and values is a variation. A variation product can have up to 3 attributes and a maximum of 150 variations. This column shows the list of all the available values for the first variation attribute (column variationAttributes.1.displayName).
variationAttributes.2.displayName	If applicable, this column shows the name of the second variation attribute.
variationAttributes.2.values	If applicable, this column shows the list of all the available values for the second variation attribute (column variationAttributes.2.displayName).
variationAttributes.3.displayName	If applicable, this column shows the name of the third variation attribute.
variationAttributes.3.values	If applicable, this column shows the list of all the available values for the third variation attribute (column variationAttributes.3.displayName).
customVariationPrice	Variations can either have variation-specific prices or share the same prices. If they have variation-specific prices, this column shows 1 and the respective prices for each variation are shown in columns salesPrice.amount, listPrice.amount and manufacturerPrice.amount. If they share the same price, this column shows 0 and the respective price is shown in the variation product row (the one that says MASTER in column variationLevel) of columns salesPrice.amount, listPrice.amount and manufacturerPrice.amount.
customVariationImages	Variations can either have variation-specific images or all share the same images. If they have variation-specific images, this column shows 1 and the respective images for each variation are shown in column images. In column variationImagesDifferentiator, you can see for which variation attribute (column variationAttributes.1.displayName, variationAttributes.2.displayName, or variationAttributes.3.displayName) the images are displayed. If they share the same images, this column shows 0 and the respective images are shown in the variation product row (the one that says MASTER in column variationLevel) of column images.
variationAttributes.1.variationValue	In column variationAttributes.1.displayName, you can see which values are in general available for the first variation attribute. In this column, only the value for the first variation attribute is shown, which applies to the respective variation.
variationAttributes.2.variationValue	In column variationAttributes.2.displayName, you can see which values are in general available for the second variation attribute. In this column, only the value for the second variation attribute is shown, which applies to the respective variation.
variationAttributes.3.variationValue	In column variationAttributes.3.displayName, you can see which values are in general available for the third variation attribute. In this column, only the value for the third variation attribute is shown, which applies to the respective variation.
variationImagesDifferentiator	In column customVariationImages, you can see whether or not variations have variation-specific images. If they have variation-specific images, this column shows for which variation attribute (column variationAttributes.1.displayName, variationAttributes.2.displayName, or variationAttributes.3.displayName) the images are displayed.