Skip to content

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

🖥️ Command Line Export (CLI)

Start running exports directly

#[AsCommand(
    name: 'cnk:csv-customer-log:consume',
    description: 'Export all customer activities in progress',
)]
bin/console cnk:csv-customer-log:consume