Customer Import Field Reference
This section includes a detailed reference table outlining the fields required to import customer data into Shopware 6. The table lists each field name as it appears in the Shopware interface, along with the corresponding system field name, a description of its function, and an example value to help you correctly format your data.
| Field Name | System Field Name | Description | Value Example |
|---|---|---|---|
| Line Item Type | linetype | Defines whether the row is for a customer or a customer address. | customer, addresses |
| Customer Number | customerNumber | Unique customer code. Can contain any characters and spaces. | SWDEMO10000 |
| Email Address | email | Customer’s email. Make sure to properly paste the email address with the domain | test@mail.com |
| First Name | firstName | Customer’s first name. Any characters are allowed. | Veronica |
| Last Name | lastName | Customer’s last name. Any characters are allowed. | Costello |
| Customer Group | group | Customer’s customer group. | Standard customer group |
| Default Payment Method | defaultPaymentMethod | Customer’s default payment method. | Cash on delivery |
| Active Status | active | Defines if the customer is enabled: 1 - customer is enabled; 0 or EMPTY - customer is disabled. | 1 |
| Language | language | Customer’s language. | English |
| Affiliate Code | affiliateCode | Used to track and identify customers who were referred to your store through an affiliate program. | 3465 |
| Campaign Code | campaignCode | Refers to a code associated with a marketing or promotional campaign. | 8973 |
| Sales Channel | salesChannel | Name of the Sales Channel the customer belongs to. Can contain any characters and spaces | Storefront |
| Date of Birth | birthday | Customer’s day of birth. | 1996-09-09T00:00:00.000+00:00 |
| Default Billing Address | defaultBillingAddressId | Unique ID of the default Billing Address inside the Shopware 6 database. Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f. Required attribute for UPDATE. | 069d109b9b484f9d992ec5f478f9c2a1 |
| Default Shipping Address | defaultShippingAddressId | Unique ID of the default Shipping Address inside the Shopware 6 database. Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f. Required attribute for UPDATE. | 069d109b9b484f9d992ec5f478f9c2a1 |
| Address ID | addresses.id | Unique ID of the Address inside the Shopware 6 database. Should be composed of exactly 32 symbols with numerals 0-9 and letters a-f. Required attribute for UPDATE. | 069d109b9b484f9d992ec5f478f9c2a1 |
| Address First Name | addresses.firstName | Customer’s first name specified in the address. | Veronica |
| Address Last Name | addresses.lastName | Customer’s last name specified in the address. | Costello |
| Zip/Postal Code | addresses.zipcode | Postal code associated with a customer’s address. | 12345 |
| Country | addresses.country | Country associated with a customer’s address. | Germany |
| City | addresses.city | City associated with a customer’s address. | Berlin |
| Company | addresses.company | Company associated with a customer’s address. | Firebear |
| Street | addresses.street | Street associated with a customer’s address. | street1 |
| Department | addresses.department | Department associated with a customer’s address. | Marketing |
| Title | addresses.title | Manager | |
| Phone Number | addresses.phoneNumber | Phone number associated with a customer’s address. | 495819739180 |
| Address Created At | addresses.createdAt | Date and time when the address was initially added to the customer’s profile. | 2023-05-05T09:21:45.707+00:00 |
| Address Updated At | addresses.updatedAt | Date and time when the address was updated in the customer’s profile. | 2023-08-03T12:21:10.953+00:00 |