Export Orders from WooCommerce V3.5+
This task will export orders taken on your WooCommerce store to an XML file.
We recommend configuring the task to export all orders of a particular status. Once the orders have been processed successfully, the Import Orders to WooCommerce V3.5+ task can be used to change the order status in WooCommerce to prevent the same ones exporting again.
Settings
Connection
Required
The WooCommerce connection to use. See the WooCommerce V3.5+ Connection article if you require more information on how to create/manage connections.
Export Customers
Required
Set to true to export the customer information related to each order.
Export Order Notes
Required
Set to true to export the internal notes related to each order. This setting does not need to be enabled to retrieve the note provided by the customer at the time the order was placed.
Export Products
Required
Set to true to export the product information related to each line item on the order.
Export Setting > Date Created
Required
The date to export orders from when the task is set to export new records. Updates automatically each time a order is exported.
Export Setting > Date Modified
Required
The date to export orders from when the task is set to export modified records. Updates automatically each time a order is exported.
Export Setting > Export Modified, New or All Records
Required
Choose which orders should be exported from WooCommerce. The available options are:
- Modified - Exports new and modified orders since the date shown in the Date Modified setting.
- New - Exports new orders since the date shown in the Date Created setting.
- All - Exports all orders.
Order Status
Optional
The status to filter the order download on. Leave blank to download orders with any status.
Page Size
Required
The number of orders to export per page. Increasing this value will speed up the export, but will consume more memory. Defaults to 10.
Record IDs
Optional
Enter a comma separated list of IDs of specific records to export. This will override the Export Settings.
Output File
Required
The name of the XML file to export the orders to. Defaults to 'woo_commerce_export_orders.xml'.
Zynk Settings
See Common Task Settings.
Examples
Sample output file:
<?xml version="1.0" encoding="utf-8"?>
<orders xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<order>
<id>9</id>
<external_id>2414</external_id>
<date_created>2017-05-24T15:50:53</date_created>
<date_created_gmt>2017-05-24T14:50:53</date_created_gmt>
<date_modified>2019-09-18T17:30:05</date_modified>
<date_modified_gmt>2019-09-18T16:30:05</date_modified_gmt>
<parent_id>0</parent_id>
<number>20</number>
<order_key>wc_order_59259dcdd2d84</order_key>
<created_via>checkout</created_via>
<version>3.7.0</version>
<status>cancelled</status>
<currency>GBP</currency>
<discount_total>0.00</discount_total>
<discount_tax>0.00</discount_tax>
<shipping_total>0.00</shipping_total>
<shipping_tax>0.00</shipping_tax>
<cart_tax>4.00</cart_tax>
<total>24.00</total>
<total_tax>4.00</total_tax>
<prices_include_tax>false</prices_include_tax>
<customer_id>2</customer_id>
<customer_ip_address>::1</customer_ip_address>
<customer_user_agent>mozilla/5.0 (windows nt 10.0; wow64; rv:53.0) gecko/20100101 firefox/53.0</customer_user_agent>
<customer_note />
<billing>
<first_name>Adam</first_name>
<last_name>Wardle</last_name>
<company>Zynk Software Ltd</company>
<address_1>Nelson House</address_1>
<address_2 />
<city>Jesmond</city>
<state>Tyne & Wear</state>
<postcode>NE2 3AE</postcode>
<country>GB</country>
<email>[email protected]</email>
<phone>08451232920</phone>
</billing>
<shipping>
<first_name>Adam</first_name>
<last_name>Wardle</last_name>
<company>Zynk Software Ltd</company>
<address_1>Nelson House</address_1>
<address_2 />
<city>Jesmond</city>
<state>Tyne & Wear</state>
<postcode>NE2 3AE</postcode>
<country>GB</country>
</shipping>
<payment_method>cheque</payment_method>
<payment_method_title>Check payments</payment_method_title>
<transaction_id />
<date_paid xsi:nil="true" />
<date_paid_gmt xsi:nil="true" />
<date_completed xsi:nil="true" />
<date_completed_gmt xsi:nil="true" />
<cart_hash>238ce812c453f12e11a4a8ad632fe394</cart_hash>
<meta_data>
<meta>
<id>386</id>
<key>_shipping_method</key>
<value>
<item>flat_rate:1</item>
</value>
</meta>
</meta_data>
<line_items>
<line_item>
<id>5</id>
<name>Test product</name>
<product_id>8</product_id>
<variation_id>0</variation_id>
<quantity>1</quantity>
<tax_class />
<subtotal>20.00</subtotal>
<subtotal_tax>4.00</subtotal_tax>
<total>20.00</total>
<total_tax>4.00</total_tax>
<taxes>
<tax_line>
<id>1</id>
<compound xsi:nil="true" />
<tax_total xsi:nil="true" />
<shipping_tax_total xsi:nil="true" />
</tax_line>
</taxes>
<meta_data />
<sku>TEST001</sku>
<price>20</price>
</line_item>
</line_items>
<tax_lines>
<tax_line>
<id>7</id>
<rate_code>GB-VAT-1</rate_code>
<rate_id>1</rate_id>
<label>VAT</label>
<compound>false</compound>
<tax_total>4.00</tax_total>
<shipping_tax_total>0.00</shipping_tax_total>
<meta_data />
</tax_line>
<tax_line>
<id>10</id>
<rate_code />
<rate_id>0</rate_id>
<label>VAT</label>
<compound>false</compound>
<tax_total>0.00</tax_total>
<shipping_tax_total>0.00</shipping_tax_total>
<meta_data />
</tax_line>
</tax_lines>
<shipping_lines>
<shipping_line>
<id>6</id>
<method_title>Flat rate</method_title>
<method_id>flat_rate</method_id>
<total>0.00</total>
<total_tax>0.00</total_tax>
<taxes>
<tax_line>
<id>total</id>
<compound xsi:nil="true" />
<tax_total xsi:nil="true" />
<shipping_tax_total xsi:nil="true" />
</tax_line>
<tax_line>
<id>1</id>
<compound xsi:nil="true" />
<tax_total xsi:nil="true" />
<shipping_tax_total xsi:nil="true" />
</tax_line>
</taxes>
<meta_data>
<meta>
<id>42</id>
<key>Items</key>
<value>Test product &times; 1</value>
</meta>
</meta_data>
</shipping_line>
</shipping_lines>
<fee_lines />
<coupon_lines />
<refunds />
<set_paid xsi:nil="true" />
<order_notes>
<order_note>
<id>8860</id>
<date_created>2023-02-02T14:54:08</date_created>
<date_created_gmt>2023-02-02T14:54:08</date_created_gmt>
<note>Example.</note>
<customer_note>false</customer_note>
</order_note>
<order_note>
<id>8859</id>
<date_created>2023-01-31T11:40:41</date_created>
<date_created_gmt>2023-01-31T11:40:41</date_created_gmt>
<note>Awaiting cheque payment Order status changed from Pending payment to Processing.</note>
<customer_note>false</customer_note>
</order_note>
</order_notes>
</order>
</orders>