How to export orders including product fields data

Exporting WooCommerce orders including custom fields created by Advanced Product Fields for WooCommerce is possible using several exporting plugins. Our plugin stores additional data as standard WooCommerce order data, so most export plugins (with Woo compatibility) should be able to export that data.

Unfortunately, it is impossible for us to test all export plugins. Instead, we chose 2 popular plugins and described their export process below.

Exporting with Advanced Order Export For WooCommerce

To export orders with the free or premium version of Advanced Order Export, follow these steps:

1. Download and install the plugin at https://wordpress.org/plugins/woo-order-export-lite/
2. In your WordPress dashboard, go to WooCommerce → Export Orders.
3. Once you are in the export orders panel, look for the Set Up Field to Export section at the bottom of the page.
   
4.  On the right sidebar, look for the Product order items, and click Add field.
5. In the Order item fields list, look for the field label you want to include in the export. For example, we created 2 Advanced Product Fields:
   
   Which you’ll find in this list too:
   
6. Click the Confirm button as seen in the screenshot above. Please note you can only add 1 field at a time, so repeat this process for all fields you’d like to add.
7. Once you have added the field(s) you want to include, drag the created metadata to the left to include them in the export.
8. You are now ready to export your data!

Exporting with WP All Export

To export orders with WP All Export, you’ll need their import/export package with WooCommerce export addon. Once installed, follow these steps:

1. In the WordPress dashboard, go to All Export → New Export.
2. Export a specific post type, and select WooCommerce Orders.
   
   
3. Click the Customize Export File button.
4. In the new screen, click the Add Field button an a popup will open.
5. In the list, search for the field label you wanted to include in the export or look in the Other section where our fields are added.
6. For example, we created 2 Advanced Product Fields:
   You can find them in this dropdown list:
   
7. You are now ready to export your data!

Filtering orders with WP All Export

If you wanted to filter orders based on custom field values, you can set a filter rule by clicking the Add Filtering Options button.

Once you have setup your rule, the plugin will automatically select the order that has the specific field and option.