---
title: Customer Import Field Reference
description: Complete reference table of all fields available for customer import in Shopware 6, including system field names, descriptions, and example values.
---

Use this page as a lookup table when you need the exact field name, system field name, description, or example value for a customer import.

For customer workflows and entity-specific behavior, start in the [Customers section](/entities/customers/).

| **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 |