Managed WordPress Ecommerce Help

Create a custom CSV export format

Create a custom CSV export format for your orders, customers, or coupons.

Required: Customer / Order / Coupon Export is a premium WooCommerce extension included with WordPress Ecommerce Hosting or as a standalone purchase.
  1. Sign in to WordPress.
  2. Go to WooCommerce > Exports > Custom Formats.
  3. Select the export type that you would like to create - Orders, Customers, or Coupons.
  4. Click Add new CSV format.
  5. Select an existing format to use as a starting point for your custom format and click Load, or click X to start from scratch.
  6. Update the Format Options:
  7. If you are creating an orders export format, you can also update the following extra options:
    • A row represents: Choose whether a row should represent a single order or a single line item (e.g. an order with multiple line items will span multiple rows).
    • Item columns should use: Choose whether item columns (e.g. line items) should be pipe-delimited or JSON format.
      • JSON example: typically used in the predefined CSV Import format for orders - [{"product_id":99,"product_name":"Woo Album","quantity":1,"total":19.99}]
      • Pipe-delimited example: typically used in the predefined Default CSV format for orders – product_id:99|sku:woo-album|name:Woo Album|quantity:1|total:19.99
  8. Update the Column Mapping to determine which fields will appear on your export.
    • When adding columns, the data source determines what data will appear in the export. You can select an option from the list, add a custom meta key, or add a static value.
  9. Click Save.

More info

Share this article