Create a custom CSV export format

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

1. Go to WooCommerce > Exports > Custom Formats.
2. Select the export type that you would like to create - Orders, Customers, or Coupons.
3. Click Add new CSV format.
4. Select an existing format to use as a starting point for your custom format and click Load, or click X to start from scratch.
5. Update the Format Options:
   • Name: Enter an internal name for your export format.
   • CSV delimiter: Select a delimiter to separate columns in your file.
   • Include all meta: Choose whether to include all meta in the export. Click here to learn more about adding meta to exports.
6. 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
7. Update the Column Mappingto 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.
8. Click Save.

Article ID: 1581
Created On: Mon, May 10, 2021 at 4:01 PM
Last Updated On: Mon, May 10, 2021 at 4:01 PM

Online URL: https://www.heartinternet.uk/support/article/create-a-custom-csv-export-format.html