---
title: Export Product Properties
description: How to import and export custom product properties (like Size or Color) in Shopware 6, including the property column format and mapping to propertiesSources.
---

By default, Shopware 6 does not export custom properties that you've added to your products, such as 'Size' or 'Color.' This means that when you export products, any custom attributes you've created won't be included in the export file.

To address this, you can export custom product properties as a separate entity. However, this approach comes with a limitation: the exported file won't include references to the products these properties are associated with. As a result, re-importing the products with their corresponding custom properties becomes impossible, since the connection between the products and their custom attributes is lost in the process.

![](https://firebearstudio.com/blog/wp-content/uploads/2021/07/Снимок-экрана-2021-07-14-в-14.29.56.png)

With the Improved Import, Export & Mass Actions app, you can export custom properties along with your products in a convenient format. This format includes both the database ID of the custom property and the name as displayed in the store's backend, making it easy to reference and manage.

The exported file might look like the screenshot below:

![](https://firebearstudio.com/blog/wp-content/uploads/2021/07/Снимок-экрана-2021-07-14-в-18.13.58.png)

The columns highlighted in green represent custom product properties and follow this format:

```
color#0bde8db993684f8b92a713913aa3d9c3
```

Where:

- **color** is the name of the property as it appears in the Shopware 6 backend.
- **#0bde8db993684f8b92a713913aa3d9c3** is the ID of the property as stored in the database.

## Importing Products with Custom Properties

When importing products along with these properties, you can import them using three different formats for the column names:

1. `property_name#property_id` — This is the default format you receive in the export file.
2. `property_name` — You can also import the property by naming the column as it is labeled in the Shopware 6 admin panel.
3. `#property_id` — Alternatively, you can use just the property ID, starting with the "#" symbol.

During the mapping step of the import procedure, you'll need to assign all custom properties from your file as follows:

1. Locate the custom property, such as "**color**."
2. In the dropdown menu under store properties, select "**propertiesSources**".

![](https://firebearstudio.com/blog/wp-content/uploads/2021/10/08_firebear_import_shopware_app.png)

Assign "propertiesSources" to all the custom properties you are importing. This ensures that Shopware correctly interprets and applies them, regardless of the order or format you use.

We also recommend using both the property name and ID as your import format.

In the Shopware 6 backend, you can create multiple custom properties with the same name. Therefore, if you have several properties with identical names, you'll need a way to distinguish them. This is where the property ID comes in, such as "#0bde8db993684f8b92a713913aa3d9c3". The property ID is always unique and ensures that each property is correctly identified and applied without confusion.