Custom Properties

By default, Shopware 6 exports products without including any custom properties you’ve added, such as “Size” or “Color”. This means custom properties won’t be part of the exported product data. While you can export custom product properties as a separate entity, this export won’t include references to the products they’re assigned to, making it difficult to re-import products with their associated custom properties.

The Improved Import, Export & Mass Actions app solves this issue by allowing you to export custom properties along with your products in a format that includes both the database ID of the custom property and the name displayed in the store’s backend for easy reference.

In the exported file, custom properties are formatted like this: color#0bde8db993684f8b92a713913aa3d9c3, where:

• color is the name of the property as displayed in the Shopware 6 backend.
• #0bde8db993684f8b92a713913aa3d9c3 is the property’s unique ID in the database.

Column Name Formats for Import

When importing products with custom properties, you can use three different formats for column names:

• property_name#property_id — the default format as it appears in the export file.
• property_name — using only the name of the property as it appears in the Shopware 6 admin panel.
• #property_id — using only the property’s ID, preceded by the # symbol.

During the import process, you need to map all custom properties in your file by selecting the corresponding propertiesSources option in the dropdown for each property. This step ensures that Shopware correctly recognizes and processes the custom properties, regardless of the order or format used.

Using both the property name and ID is important because Shopware 6 allows you to create multiple custom properties with the same name. The property ID, which is always unique, helps distinguish between similarly named properties.

Importing Translations for Custom Properties

If you want to add translations to your custom properties, use this column title format:

[language code].[property_name#property_id]

Where:

• language code is the locale of the language you provide translation for, e.g., en_GB, en_US, de_DE, de_CH, etc.
• property_name is the name of the property as displayed in the Shopware 6 backend.
• property_id is the property’s unique ID in the database.

For instance, you can translate the Material custom property with the ID #a67cdd9627cb488bb4cd91f3e8d66e32 to German by adding the following column to your CSV file: de-DE.Material#a67cdd9627cb488bb4cd91f3e8d66e32.