CSV Export for Orders – Flexible & Automated¶
The plugin enables flexible export of Shopware 6 orders as a CSV file – either completely or filtered by time period, status, payment method, and more. Using individual profiles, fields can be freely defined and exports tailored to specific requirements.
Highlights
- ✅ Export orders as CSV – flexible, filterable, automatable
- 🔁 Fully automatic export via schedule (Scheduled Task / Cronjob)
- ✉️ Send by email or upload via FTP
- 🧩 Freely configurable export fields with sorting and filters
- 🛠️ CSV format fully configurable (delimiter, date, encoding, etc.)
❓ FAQ¶
Can I automate the export?
Yes, the plugin supports automatic export via Shopware 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 export profiles and determine which fields are exported and in what order.
Are custom fields supported?
Yes, the plugin supports custom fields for orders, customers, products, and order line items.
How many orders can I export at once?
The maximum number of orders is configurable in the plugin settings.
Very large datasets can also be exported via CLI.
🔧 Installation¶
- Prerequisites (CNK Foundation)
- Installation via Store or ZIP
- Activation & visibility in the backend
🧩 Manage Profiles¶
Export profiles define which data is included in the CSV file and in what order it appears.
Profiles are located in the Shopware admin area under Orders > CSV Export > Profiles.
Within a profile, you can specifically define which fields should be included in the exported CSV file.
Using the "Add field" button, order, customer, product, and address fields can be individually selected and arranged.
The order of fields in the profile corresponds to the column order in the CSV file.
Variables¶
💡 Field names must be used exactly as shown in the left column.
The following overview shows all available variables that can be used in an export profile.
These determine which data appears in the CSV file – for example, general order data, customer information, address fields, or product details.
Field names in the left column are configured in the profile; the right column describes the content.
🧾 General Order Data¶
| Field Name | Description |
|---|---|
order_number | Order number |
order_date | Order date |
order_date_time | Order date and time |
sales_channel | Sales channel |
payment_method | Payment method |
shipping_method | Shipping method |
amount_total | Total amount |
amount_net | Net amount |
position_price | Gross price of the item |
currency_name | Currency |
currency_short_name | Currency (short) |
shipping_total | Shipping costs |
customer_comment | Customer comment |
transactions_state_machine_state | Payment status |
deliveries_state_machine_state | Delivery status |
📦 Order Line Items¶
| Field Name | Description |
|---|---|
line_items_label | Name |
line_items_description | Description |
line_items_quantity | Quantity |
line_items_unit_price | Unit price |
line_items_total_price | Total price |
👤 Customer Data¶
| Field Name | Description |
|---|---|
company | Company |
salutation | Salutation |
first_name | First name |
last_name | Last name |
email | Email address |
birthday | Date of birth |
order_count | Number of orders |
🚚 Shipping Address¶
| Field Name | Description |
|---|---|
shipping_address_company | Company |
shipping_address_department | Department |
shipping_address_salutation | Salutation |
shipping_address_title | Title |
shipping_address_first_name | First name |
shipping_address_last_name | Last name |
shipping_address_street | Street |
shipping_address_zipcode | ZIP code |
shipping_address_city | City |
shipping_address_phone_number | Phone number |
shipping_address_country_name | Country |
shipping_address_country_iso | Country (ISO) |
🧾 Billing Address¶
| Field Name | Description |
|---|---|
billing_address_company | Company |
billing_address_department | Department |
billing_address_salutation | Salutation |
billing_address_title | Title |
billing_address_first_name | First name |
billing_address_last_name | Last name |
billing_address_street | Street |
billing_address_zipcode | ZIP code |
billing_address_city | City |
billing_address_country_name | Country |
billing_address_country_iso | Country (ISO) |
🛒 Product Data¶
| Field Name | Description |
|---|---|
line_items_product_number | Product number |
line_items_product_name | Product name |
line_items_product_description | Description |
line_items_product_manufacturer_number | Manufacturer number |
line_items_product_ean | EAN |
line_items_product_stock | Stock |
line_items_product_available_stock | Available stock |
line_items_product_max_purchase | Max. quantity |
line_items_product_min_purchase | Min. quantity |
line_items_product_purchase_prices | Purchase price |
line_items_product_shipping_free | Free shipping |
line_items_product_weight | Weight |
line_items_product_width | Width |
line_items_product_height | Height |
line_items_product_length | Length |
line_items_product_category_ids | Category IDs |
line_items_product_category_names | Category names |
line_items_product_release_date | Release date |
line_items_product_manufacturer_name | Manufacturer name |
⚡ Quick Export via Order Overview¶
- Direct export of selected orders
- Direct export of filtered orders
- Select a profile from the dropdown
🔁 Jobs (Automation)¶
- Description: Scheduled Task / Cronjob
- Configurable options:
- Time interval
- FTP / email destination
- Profile selection
📊 Activity & Logging¶
- Export history & status (Success/Error)
- CSV log: recipient, FTP path, timestamp
-
Logs are found under Orders > CSV Export > Activity
-
The result looks like this
🖥️ Command Line Export (CLI)¶
Quick export of running activities¶
Exporting large datasets – even more than 10,000 orders – is possible.
An integrated progress bar shows the export progress.
To avoid waiting for the queue, you can trigger the export manually – e.g. for an immediate CSV download after creating an export:
#[AsCommand(
name: 'cnk:csv-order-log:consume',
description: 'Export all the activities in progress',
)]
The export can then be started directly from the console:
This command starts all running exports directly via the console.
Export with Shopware profile¶
bin/console cnk:csv-orders:export --fromDate 2023-05-15 --toDate 2025-02-01 --exportType sw_profile --mode order --profileName "Default orders" --limit 500
Export with custom profile¶
bin/console cnk:csv-orders:export --fromDate 2023-05-15 --toDate 2025-02-01 --exportType config --mode line_items --profileName "WAWI" --limit 500
- fromDate: Orders from, format Y-m-d
- toDate: Orders to, format Y-m-d
- exportType: Choose between sw_profile and config
- mode: Choose between order and line_items
- profileName: Default profile or user-created profile
- limit: Limit of orders to export (default: 100)