---
title: Custom Properties
description: How to import and export custom product properties (like Size or Color) in Shopware 6, including column naming conventions and translation support.
---

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.

![](https://firebearstudio.com/blog/wp-content/uploads/2024/02/Shopware-Custom-Properties-Import.png)

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](https://saimana.com/list-of-country-locale-code/) 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`.

![](https://firebearstudio.com/blog/wp-content/uploads/2024/02/Shopware-Custom-Properties-Import-translations.png)