Export Orders from BigCommerce V3
This task will download orders taken on your BigCommerce store to an XML file.
Settings
Connection
Required
The BigCommerce connection to use.See the Connecting to BigCommerce v3 article if you require more information on how to create/manage connections.
Export Coupons
Required
Set to true to include detailed coupon information in the output file. Defaults to True.
Export Customers > Enabled
Required
Set to true to export detailed customer information. Defaults to False.
Export Customers > Export Addresses
Required
Set to true to export customer address information. Defaults to False. This setting will only take effect when the 'Export Customers > Enabled' setting is True.
Export Customers > Export Attributes
Required
Set to true to export customer attributes. Defaults to False. This setting will only take effect when the 'Export Customers > Enabled' setting is True.
Export Customers > Export Form Fields
Required
Set to true to export customer form fields. Defaults to False. This setting will only take effect when the 'Export Customers > Enabled' setting is True.
Export Customers > Export Store Credit
Required
Set to true to export customer store credit information. Defaults to False. This setting will only take effect when the 'Export Customers > Enabled' setting is True.
Export Settings > Date Created
Required
When the 'Export Type' is set to New, only records created after this date will be downloaded. The date will update automatically each time the task runs based on the data returned.
Export Settings > Date Modified
Required
When the 'Export Type' is set to Modified, only records updated after this date will be downloaded. The date will update automatically each time the task runs based on the data returned.
Export Settings > Export Type
Required
Used to choose which records should be included in the download. The available options are: -
- New - Only records created since the task last ran will be downloaded
- Modified - Only records created or updated since the task last ran will be downloaded
- All - All records will be downloaded, regardless of whether or not they have been updated since the task last ran
Export Shipping Addresses
Required
Set to true to include detailed shipping address in the output file. Defaults to True.
Order Status
Optional
The status of the orders to be downloaded. If not set orders at any status will be downloaded. Use the dropdown menu to select the required status.
Output File
Required
The name of the XML file to export the data to (e.g. orders.xml).
Page Size
Required
The number of records returned per page of the request. Defaults to 50.
Zynk Settings
See Common Task Settings.
Examples
A sample output file is shown below showing an order for 'Zynk Software Limited'. For detailed documentation on the fields please see the BigCommerce Dev Center.
<?xml version="1.0" encoding="utf-8"?>
<orders>
<order>
<id>104</id>
<zynk_external_id />
<date_created>2013-08-09T14:04:01+01:00</date_created>
<date_modified>2013-08-09T14:06:20+01:00</date_modified>
<customer_id>1</customer_id>
<customer>
<id>1</id>
<date_created>2013-01-09T17:04:30Z</date_created>
<date_modified>2013-01-17T09:37:10Z</date_modified>
<email>[email protected]</email>
<first_name>Joe</first_name>
<last_name>Blogs</last_name>
<company>Zynk</company>
<phone>0191 303 7279</phone>
<registration_ip_address>217.23.234.104</registration_ip_address>
<notes />
<tax_exempt_category />
<customer_group_id>0</customer_group_id>
<address_count>2</address_count>
<attribute_count>0</attribute_count>
<authentication>
<force_password_reset>false</force_password_reset>
</authentication>
<addresses>
<address>
<id>2</id>
<first_name>Tony</first_name>
<last_name>Tiger</last_name>
<company>Edinburgh Zoo</company>
<address1>Lion Enclosure</address1>
<address2>Edinburgh Zoo</address2>
<city>Edinburgh</city>
<state_or_province>East Lothian</state_or_province>
<postal_code>NE1 4XF</postal_code>
<country_code>GB</country_code>
<phone>0845 123 2920</phone>
<address_type>commercial</address_type>
<customer_id>1</customer_id>
<country>United Kingdom</country>
<form_fields />
</address>
<address>
<id>9</id>
<first_name>Tony</first_name>
<last_name>Tiger</last_name>
<company>Edinburgh Zoo</company>
<address1>Lion Enclosure</address1>
<address2>Edinburgh Zoo</address2>
<city>Edinburgh</city>
<state_or_province>East Lothian</state_or_province>
<postal_code>NE1 4XF</postal_code>
<country_code>GB</country_code>
<phone>0845 123 2920</phone>
<address_type>residential</address_type>
<customer_id>1</customer_id>
<country>United Kingdom</country>
<form_fields />
</address>
</addresses>
<attributes />
<form_fields />
<accepts_product_review_abandoned_cart_emails>false</accepts_product_review_abandoned_cart_emails>
<origin_channel_id>1</origin_channel_id>
<trigger_account_created_notification xsi:nil="true" />
</customer>
<date_shipped xsi:nil="true" />
<status_id>10</status_id>
<status>Completed</status>
<custom_status>Completed</custom_status>
<subtotal_ex_tax>499.0000</subtotal_ex_tax>
<subtotal_inc_tax>598.8000</subtotal_inc_tax>
<subtotal_tax>99.8000</subtotal_tax>
<base_shipping_cost>0.0000</base_shipping_cost>
<shipping_cost_ex_tax>0.0000</shipping_cost_ex_tax>
<shipping_cost_inc_tax>0.0000</shipping_cost_inc_tax>
<shipping_cost_tax>0.0000</shipping_cost_tax>
<shipping_cost_tax_class_id>2</shipping_cost_tax_class_id>
<base_handling_cost>0.0000</base_handling_cost>
<handling_cost_ex_tax>0.0000</handling_cost_ex_tax>
<handling_cost_inc_tax>0.0000</handling_cost_inc_tax>
<handling_cost_tax>0.0000</handling_cost_tax>
<handling_cost_tax_class_id>2</handling_cost_tax_class_id>
<base_wrapping_cost>0.0000</base_wrapping_cost>
<wrapping_cost_ex_tax>0.0000</wrapping_cost_ex_tax>
<wrapping_cost_inc_tax>0.0000</wrapping_cost_inc_tax>
<wrapping_cost_tax>0.0000</wrapping_cost_tax>
<wrapping_cost_tax_class_id>3</wrapping_cost_tax_class_id>
<total_ex_tax>499.0000</total_ex_tax>
<total_inc_tax>598.8000</total_inc_tax>
<total_tax>99.8000</total_tax>
<items_total>1</items_total>
<items_shipped>0</items_shipped>
<payment_method>Cash on Delivery</payment_method>
<payment_provider_id xsi:nil="true" />
<payment_status />
<refunded_amount>0.0000</refunded_amount>
<order_is_digital>false</order_is_digital>
<store_credit_amount>0.0000</store_credit_amount>
<gift_certificate_amount>0.0000</gift_certificate_amount>
<ip_address>78.86.222.163</ip_address>
<currency_id>1</currency_id>
<currency_code>GBP</currency_code>
<currency_exchange_rate>1.0000000000</currency_exchange_rate>
<default_currency_id>1</default_currency_id>
<default_currency_code>GBP</default_currency_code>
<staff_notes />
<customer_message />
<discount_amount>0.0000</discount_amount>
<coupon_discount>0.0000</coupon_discount>
<shipping_address_count>1</shipping_address_count>
<is_deleted>false</is_deleted>
<is_email_opt_in>false</is_email_opt_in>
<ebay_order_id>0</ebay_order_id>
<billing_address>
<id xsi:nil="true" />
<first_name>Joe</first_name>
<last_name>Blogs</last_name>
<company>Zynk Software Limited</company>
<street_1>6-8 Charlotte Square</street_1>
<street_2>i6</street_2>
<city>Newcastle upon-Tyne</city>
<state>Tyne and Wear</state>
<zip>NE1 4XF</zip>
<country>United Kingdom</country>
<country_iso2>GB</country_iso2>
<phone>0845 123 2920</phone>
<email>[email protected]</email>
<form_fields />
</billing_address>
<order_source>manual</order_source>
<products>
<resource>/orders/104/products</resource>
<url>https://api.bigcommerce.com/stores/v5k4i/v2/orders/104/products</url>
<records>
<order_product>
<id>6</id>
<order_id>104</order_id>
<product_id>186</product_id>
<order_address_id>5</order_address_id>
<name>iPhone 4 16GB White</name>
<sku>IPHONE4</sku>
<type>physical</type>
<base_price>499.0000</base_price>
<price_exc_tax xsi:nil="true" />
<price_inc_tax>598.8000</price_inc_tax>
<price_tax>99.8000</price_tax>
<base_total>499.0000</base_total>
<total_exc_tax xsi:nil="true" />
<total_inc_tax>598.8000</total_inc_tax>
<total_tax>99.8000</total_tax>
<quantity>1</quantity>
<base_cost_price>0.0000</base_cost_price>
<cost_price_inc_tax>0.0000</cost_price_inc_tax>
<cost_price_ex_tax>0.0000</cost_price_ex_tax>
<weight>0.0000</weight>
<width>0.0000</width>
<depth>0.0000</depth>
<height>0.0000</height>
<cost_price_tax>0.0000</cost_price_tax>
<is_refunded>false</is_refunded>
<refunded_amount xsi:nil="true" />
<return_id>0</return_id>
<wrapping_name />
<base_wrapping_cost>0.0000</base_wrapping_cost>
<wrapping_cost_ex_tax>0.0000</wrapping_cost_ex_tax>
<wrapping_cost_inc_tax>0.0000</wrapping_cost_inc_tax>
<wrapping_message />
<quantity_shipped>0</quantity_shipped>
<event_date xsi:nil="true" />
<fixed_shipping_cost>0.0000</fixed_shipping_cost>
<ebay_item_id />
<ebay_transaction_id />
<option_set_id xsi:nil="true" />
<parent_order_product_id xsi:nil="true" />
<is_bundled_product>false</is_bundled_product>
<bin_picking_number />
<applied_discounts />
<product_options />
<external_id xsi:nil="true" />
</order_product>
</records>
</products>
<shipping_addresses>
<resource>/orders/104/shippingaddresses</resource>
<url>https://api.bigcommerce.com/stores/v5k4i/v2/orders/104/shippingaddresses</url>
<records>
<address>
<id>5</id>
<first_name>Joe</first_name>
<last_name>Blogs</last_name>
<company>Zynk Software Limited</company>
<street_1>6-8 Charlotte Square</street_1>
<street_2>i6</street_2>
<city>Newcastle upon-Tyne</city>
<state>Tyne and Wear</state>
<zip>NE1 4XF</zip>
<country>United Kingdom</country>
<country_iso2>GB</country_iso2>
<phone>0845 123 2920</phone>
<email />
<form_fields />
</address>
</records>
</shipping_addresses>
<coupons>
<resource>/orders/104/coupons</resource>
<url>https://api.bigcommerce.com/stores/v5k4i/v2/orders/104/coupons</url>
</coupons>
<channel_id>1</channel_id>
<tax_provider_id />
</order>
</orders>