CSV Export for Customers & Addresses¶
The plugin enables flexible export of Shopware 6 customer data as a CSV file – either completely or filtered by customer group, registration date, status, newsletter status, and more.
Using individual profiles, fields can be freely defined and exports precisely tailored to ERP, CRM, or marketing systems.
Highlights
- 👤 Export customers as CSV – complete or filtered
- 🔁 Fully automatic export via schedule (Scheduled Task / Cronjob)
- ✉️ Send by email or upload via FTP
- 🧩 Freely configurable export fields including custom fields
- 🛠️ CSV format fully configurable (delimiter, date, encoding, etc.)
❓ FAQ¶
Can I automate the customer export?
Yes, the plugin supports automatic exports via Scheduled Tasks (Cronjobs).
The CSV file can be automatically created and sent by email or FTP.
Can I create custom export profiles?
Yes, you can create individual profiles and define which customer and address fields are exported and in what order.
Are custom fields supported?
Yes, custom fields for customers and customer addresses are fully supported.
Can I export only active or newly registered customers?
Yes, you can filter by registration date, active status, customer group, or newsletter status.
🔧 Installation¶
- Prerequisite: CNK Foundation Plugin
- Installation via Shopware Store or ZIP
- Activation in the Plugin Manager
- Menu item visible under Customers > CSV Export
🧩 Manage Profiles¶
Export profiles define which customer data is included in the CSV file and in what order it appears.
Profiles are located in the admin area under:
Customers > CSV Export > Profiles
Within a profile you can define:
- Which fields are exported
- In what order they appear
- Whether custom fields are included
The order of fields corresponds to the column order in the CSV file.
Variables¶
💡 Field names must be used exactly as shown below.
👤 General Customer Data¶
| Field Name | Description |
|---|---|
customer_number | Customer number |
salutation | Salutation |
title | Title |
first_name | First name |
last_name | Last name |
email | Email address |
company | Company |
birthday | Date of birth |
active | Active (0/1) |
guest | Guest account |
customer_group | Customer group |
sales_channel | Sales channel |
default_payment_method | Default payment method |
default_shipping_method | Default shipping method |
created_at | Registration date |
last_login | Last login |
first_login | First login |
📊 Statistics & Activity¶
| Field Name | Description |
|---|---|
order_count | Number of orders |
total_spent | Total revenue |
last_order_date | Date of last order |
🏠 Default Billing Address¶
| Field Name | Description |
|---|---|
default_billing_address_company | Company |
default_billing_address_department | Department |
default_billing_address_salutation | Salutation |
default_billing_address_title | Title |
default_billing_address_first_name | First name |
default_billing_address_last_name | Last name |
default_billing_address_street | Street |
default_billing_address_zipcode | ZIP code |
default_billing_address_city | City |
default_billing_address_country_name | Country |
default_billing_address_country_iso | Country (ISO) |
default_billing_address_phone_number | Phone number |
🚚 Default Shipping Address¶
| Field Name | Description |
|---|---|
default_shipping_address_company | Company |
default_shipping_address_department | Department |
default_shipping_address_salutation | Salutation |
default_shipping_address_title | Title |
default_shipping_address_first_name | First name |
default_shipping_address_last_name | Last name |
default_shipping_address_street | Street |
default_shipping_address_zipcode | ZIP code |
default_shipping_address_city | City |
default_shipping_address_country_name | Country |
default_shipping_address_country_iso | Country (ISO) |
default_shipping_address_phone_number | Phone number |
⚡ Quick Export via Customer Overview¶
- Direct export of selected customers
- Direct export of filtered customers
- Select a profile from the dropdown
- Immediate CSV download
📊 Activity & Logging¶
- Export history with status (Success / Error)
- Display of recipient, FTP path, timestamp
- CSV file download directly from the log
Found under:
Customers > CSV Export > Activity