Export Refunds from WooCommerce V3.5+
This task will export refunds from your WooCommerce store to an XML file.
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 Setting > Date Created
Required
The date to export products from when the task is set to export new records. Updates automatically each time a product is exported.
Export Setting > Date Modified
Required
The date to export products from when the task is set to export modified records. Updates automatically each time a product is exported.
Export Setting > Export Modified, New or All Records
Required
Choose which products should be exported from WooCommerce. The available options are:
- Modified - Exports updated products since the date shown in the Date Modified setting.
- New - Exports new products since the date shown in the Date Created setting.
- All - Exports all products.
Page Size
Required
The number of products 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.
Refund Order Status
Optional
The status to filter the order download on to return refunded orders. Defaults to 'refunded'.
Output File
Required
The name of the XML file to export the products to. Defaults to 'woo_commerce_export_refunds.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>145</id>
<date_created>2019-11-04T17:21:50</date_created>
<date_created_gmt>2019-11-04T17:21:50</date_created_gmt>
<date_modified>2019-11-04T17:25:59</date_modified>
<date_modified_gmt>2019-11-04T17:25:59</date_modified_gmt>
<parent_id>0</parent_id>
<number>145</number>
<order_key>wc_order_T0miCatc8jj6e</order_key>
<created_via>admin</created_via>
<version>3.7.0</version>
<status>refunded</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 />
<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 />
<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 />
<meta_data />
<line_items>
<line_item>
<id>11</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>12</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_lines>
<shipping_lines />
<fee_lines />
<coupon_lines />
<refunds>
<refund>
<id>146</id>
<date_created>2019-11-04T17:25:46</date_created>
<date_created_gmt>2019-11-04T17:25:46</date_created_gmt>
<date_modified xsi:nil="true" />
<date_modified_gmt xsi:nil="true" />
<amount>24.00</amount>
<reason>Product was damaged</reason>
<meta_data />
<line_items>
<LineItem>
<id>13</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>
<meta>
<id>88</id>
<key>_refunded_item_id</key>
<value>11</value>
</meta>
</meta_data>
<sku>TEST001</sku>
<price>20</price>
</LineItem>
</line_items>
<total xsi:nil="true" />
</refund>
</refunds>
<set_paid xsi:nil="true" />
</order>
</orders>