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.

❓ FAQ¶

🔧 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.

🗂️ Export Formats & ERP Templates¶

In addition to the default CSV format, you can output your export profiles as Excel (XLSX), JSON or XML.

The export format is set per profile in the Configuration tab via the "File format" field and is enforced server-side across all export paths (manual, quick export, schedule, Flow Builder and CLI). If the In-App Purchase is not active, the export automatically falls back to CSV.

Unlock a Pro format¶

1. Open a profile under Orders > CSV Export > Profiles and switch to the Configuration tab.
2. Under File format, select a Pro format (XLSX, JSON or XML). If the purchase is not yet active, a hint with an "Unlock" button appears.
3. After purchase, the format is immediately available and applied on save.

Apply ERP templates¶

ERP templates pre-fill, with one click, the matching field selection as well as the delimiter, number, date and encoding settings for the target system:

To apply a template:

1. Make sure the "Pro Formats & ERP Templates" In-App Purchase is active.
2. In the profile, select the desired system under ERP template and click "Apply template".
3. The field selection and format settings are applied. Your chosen file format is preserved – so you can, for example, output a DATEV field selection as XLSX.

💡 Applying a template overwrites the profile's current field selection. Adjust the fields afterwards if needed and save the profile.

🔄 Incremental / Delta Export¶

With delta export, each run exports only the orders created or changed since the last successful export. This keeps an ERP or accounting system in sync without duplicates and saves time and data – especially with large order volumes.

• Enabled per profile via the "Delta / incremental export" switch in the Configuration tab.
• Matches orders by created or updated date (createdAt/updatedAt), so subsequently changed orders are re-exported.
• The delta watermark is advanced only after a successful export – if a run fails, no orders are lost.
• Works across all export paths: schedule, Flow Builder and CLI (config profile).

Set up delta export¶

1. Open a profile and switch to the Configuration tab.
2. Enable the "Delta / incremental export" switch. If the purchase is not yet active, a hint with an "Unlock" button appears.
3. Save the profile. From the next run on, only new or changed orders are exported.

Reset the delta watermark¶

If you want to export all orders again (e.g. for a full initial sync), reset the watermark:

1. Open the profile in the Configuration tab.
2. Click "Reset" in the delta hint and save the profile.
3. The next run exports all matching orders again and then sets a new watermark.

💡 Delta export uses the export start time as the watermark. In edge cases it therefore re-exports a few orders rather than skipping them – ideal for idempotent imports (upserts) into an ERP.

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¶

📦 Order Line Items¶

👤 Customer Data¶

🚚 Shipping Address¶

🧾 Billing Address¶

🛒 Product Data¶

🧬 Line Item Details (Payload)¶

Snapshot data stored on the order line item at the time of purchase.

📄 Documents¶

Fields from generated documents (invoice, delivery note and – if the Pickware plugin is installed – Pickware pick list / POS receipt). Values are only filled once the corresponding document has been created for the order.

Invoice¶

Delivery note¶

Pickware ERP pick list¶

Pickware POS receipt¶

⚡ 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 or fixed weekdays + time
  • FTP / email destination
  • Profile selection (incl. the format, ERP template and delta export of the chosen profile)

*/5 * * * * /usr/bin/php /path/to/shop/bin/console scheduled-task:run-single cnk_order_csv_export.task

📊 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:

bin/console cnk:csv-order-log:consume

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)