Skip to main content
Keep Your Business Open During COVID-19Learn More
Call us
Phone numbers and hours
Request a Call

Avoid the wait. Make a request and we will call you back

Request a Call
Help Center

Explore our online help resources

BlogHelp

Managed WordPress 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. Log 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

Community Related

bobdenver's Avatar
Transfer Office 365 emails to Excel sheet?

2 Replies

Last posted over 1 year ago.

parkerandco's Avatar
Exporting product list for Facebook

4 Replies

Last posted 3 months ago.

JohnLaurino's Avatar
Exporting Data From On-Line Bookings

1 Replies

Last posted over 1 year ago.

matthewthowells's Avatar
Suggestion: URL Shortener - Bulk import / export

1 Replies

Last posted over 2 years ago.

abbylo's Avatar
how to change export products template

1 Replies

Last posted over 3 years ago.

Don't see what you are looking for? Search the Community