Import Customer Custom Fields
Use customer custom fields when you need to import extra customer data that is not part of the standard Shopware customer fields.
The app supports custom fields assigned to the Shopware customer entity. When you create or open a customer import profile, the mapping step loads available customer custom fields and shows them as selectable fields.
Column Name Format
Section titled “Column Name Format”Add one column for each customer custom field you want to import.
Use this column format:
cf_<technical_name>Replace <technical_name> with the technical name of the custom field from Shopware.
For example, if the customer custom field technical name is customer_loyalty_level, use this column name:
cf_customer_loyalty_levelFind the Technical Name
Section titled “Find the Technical Name”- Open your Shopware Administration.
- Go to Settings > System > Custom fields.
- Open the custom field set assigned to Customers.
- Copy the technical name of the custom field.
- Add
cf_before that name in your import file.
CSV Example
Section titled “CSV Example”email,firstName,lastName,cf_customer_loyalty_level,cf_external_customer_idcustomer@example.com,Veronica,Costello,gold,C-1000In this example:
| Column | Imported To |
|---|---|
cf_customer_loyalty_level | Customer custom field customer_loyalty_level |
cf_external_customer_id | Customer custom field external_customer_id |
Map Customer Custom Fields
Section titled “Map Customer Custom Fields”- Create or open a customer import profile.
- Upload your file or select your source.
- Continue to the mapping step.
- Map each source column to the matching custom field.
You can map customer custom fields in two ways:
| Mapping Option | When To Use It |
|---|---|
Map cf_<technical_name> columns to customFields | Use this when your file already uses the cf_ column naming format. |
Select a specific cf_<technical_name> field in the mapping dropdown | Use this when your source column has a different name, for example Loyalty level, but should update a specific customer custom field. |
Value Format
Section titled “Value Format”Use values that match the custom field type in Shopware.
| Custom Field Type | Import Value Example | Notes |
|---|---|---|
| Text or text editor | VIP customer | Imported as text. |
| Number | 25 | Imported as a number. |
| Float | 19.95 | Use a decimal value. |
| Checkbox or switch | 1, 0, true, false | The app converts the value to a boolean. |
| Select | gold | Use an option value that exists in the custom field options. |
| Price | {"currencyId":"b7d2554b0ce847cd82f3ac9bd1c0dfca","gross":10,"net":8.4,"linked":true} | Price custom fields must be valid JSON. |
Updating Existing Customers
Section titled “Updating Existing Customers”When the import updates an existing customer, mapped cf_ columns update the matching customer custom fields.
Use the customer lookup fields in your profile, such as email or customer number, so the app can find the existing customer record.
Translations
Section titled “Translations”Customer custom-field import uses the standard cf_<technical_name> column format. Product-style translated custom-field columns such as translations.de_DE.cf_<technical_name> are not used for customer imports.