Export Orders from B2B Wave
This task will export your orders from B2B Wave based on the settings configured below. You can create and edit orders if you login to your B2B Wave admin panel and go to Orders.
Customer Settings
Export Customers
Optionally export the related customer record for each order.
File Settings
Output File
Required The file to save records to.
Filter Settings
Export All
Required Optionally export all records from B2B Wave.
Order Status(es)
Required Optionally select one or more order statuses to filter the export from B2B Wave.
Submitted From
Optional Export orders from B2B Wave submitted after this date.
Product Settings
Export Products
Optional Optionally export the related product record for each order item.
Zynk Settings
See Common Task Settings.
Example
<?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>
<order_info>
<id>185</id>
<status_order_id xsi:nil="true" />
<customer_id>65</customer_id>
<submitted_at>2020-03-11T18:58:43+00:00</submitted_at>
<comments_customer />
<address />
<address2 />
<city />
<province />
<country>GB</country>
<postal_code />
<customer_order_reference />
<shipping_option_id>1</shipping_option_id>
<shipping_costs>4.0</shipping_costs>
<total_products_before_discount>60.0</total_products_before_discount>
<discount_percentage>0.0</discount_percentage>
<total_products_before_vat>60.0</total_products_before_vat>
<total_before_vat>60.0</total_before_vat>
<total_vat>0.0</total_vat>
<total_products_after_vat>60.0</total_products_after_vat>
<gross_total>64.0</gross_total>
<request_delivery_at>2020-03-14T00:00:00+00:00</request_delivery_at>
<is_paid>false</is_paid>
<customer_email>[email protected]</customer_email>
<customer_company>Company name Inc.</customer_company>
<customer_name>Account manager</customer_name>
<customer_phone />
<customer_reference_code>fecc5f55-c482-46e8-9fec-45a1e2fbfc35</customer_reference_code>
<customer_pricelist_id>2</customer_pricelist_id>
<shipping_option_name>Royal Mail</shipping_option_name>
<payment_option_name>Bank US</payment_option_name>
<addressbook_type>main</addressbook_type>
<currency>USD</currency>
<order_products>
<order_product>
<order_product_info>
<id>546</id>
<order_id>185</order_id>
<product_id>56</product_id>
<quantity>10.0</quantity>
<price>6.0</price>
<final_price>6.0</final_price>
<discount_percentage>0.0</discount_percentage>
<vat_percentage>0.0</vat_percentage>
<total_before_vat>60.0</total_before_vat>
<total_vat>0.0</total_vat>
<total_after_vat>60.0</total_after_vat>
<status_order_name />
<product_name>Coconut</product_name>
<product_code>-</product_code>
<product_variant_code />
<product>
<id>56</id>
<name>Coconut</name>
<description />
<part_number>-</part_number>
<is_active>true</is_active>
<status_id>1</status_id>
<category_id>14</category_id>
<promote_category>false</promote_category>
<promote_front>false</promote_front>
<created_at>2018-02-12T14:44:19+00:00</created_at>
<updated_at>2020-03-15T04:28:21+00:00</updated_at>
<minimum_quantity>0.0</minimum_quantity>
<vat_class_id>1</vat_class_id>
<meta_description />
<package_quantity>3</package_quantity>
<has_variants>false</has_variants>
<code_upc />
<import_uuid>b28a42c2-6fe1-42af-8cd8-6c2a30570200</import_uuid>
<manufacturer_id>2</manufacturer_id>
<price_msrp>0.0</price_msrp>
<box_size_m3>0.0</box_size_m3>
<quantity>145.0</quantity>
<quantity_monitor>true</quantity_monitor>
<reference_code />
<weight>0.0</weight>
<custom_boolean_1>false</custom_boolean_1>
<length>0.0</length>
<width>0.0</width>
<height>0.0</height>
<barcode />
<cost>0.0</cost>
<is_private>false</is_private>
<can_backorder>false</can_backorder>
<is_bundle>false</is_bundle>
<code>-</code>
<brand_id>2</brand_id>
<image_url>https://res.cloudinary.com/dbrtm8pf6/image/upload/v1584246502/uploads/a4be3475_apisandboxuk/products/56/images/zr3dafdorlvzafe1t6yi.png</image_url>
<category_path>Fruit</category_path>
</product>
</order_product_info>
</order_product>
</order_products>
<customer>
<id>65</id>
<email>[email protected]</email>
<created_at>2019-04-03T18:19:25+01:00</created_at>
<updated_at>2020-03-04T21:37:32+00:00</updated_at>
<approved>true</approved>
<company_name>Company name Inc.</company_name>
<name>Account manager</name>
<company_activities />
<pricelist_id>2</pricelist_id>
<is_active>true</is_active>
<phone />
<comments_admin>Invited</comments_admin>
<vat_group_id>2</vat_group_id>
<discount_percentage>0.0</discount_percentage>
<reference_code>fecc5f55-c482-46e8-9fec-45a1e2fbfc35</reference_code>
<email_new_orders />
<locale>en-US</locale>
<password_sent>true</password_sent>
<apply_shipping_costs>true</apply_shipping_costs>
<unsubscribe_hash>6dcd905b-0d8c-4077-9c59-2ed731c30a25</unsubscribe_hash>
<receive_email_marketing>true</receive_email_marketing>
<receive_email_notifications>true</receive_email_notifications>
<bcc />
<created_by_admin>true</created_by_admin>
<enable_api>false</enable_api>
<api_token>28c2205c-24e4-4d0a-98e1-4cd6c57ef90f</api_token>
<enable_orders_import>false</enable_orders_import>
<allow_countries>
<string />
</allow_countries>
<credit_amount>0.0</credit_amount>
<current_order_id>175</current_order_id>
<can_confirm_order>true</can_confirm_order>
<enable_product_feed>false</enable_product_feed>
<disable_ordering>false</disable_ordering>
<trusted_uas />
<user_agent_validation_enabled>false</user_agent_validation_enabled>
<can_view_full_history>false</can_view_full_history>
<invoice_email />
<magic_link_token>f504e0983240d062674cc5fda456ace8</magic_link_token>
<magic_link_expires_at>2019-07-13T06:32:56+01:00</magic_link_expires_at>
<overdraft_balance>0.0</overdraft_balance>
<require_terms>false</require_terms>
<payment_terms_frequency>monthly</payment_terms_frequency>
<latest_order_submitted_at>2020-03-11T18:58:43.000+00:00</latest_order_submitted_at>
<balance_status>not_applicable</balance_status>
<address />
<city />
<province />
<country>GB</country>
<postal_code />
<website />
<tax_id />
<invoice_same>true</invoice_same>
<invoice_phone />
<invoice_address />
<invoice_city />
<invoice_province />
<invoice_country>GB</invoice_country>
<invoice_tax_id />
<invoice_postal_code />
<company_number />
<address2 />
<invoice_address2 />
<email_new_orders_attach_xls>false</email_new_orders_attach_xls>
<invoice_company_name />
<invoice_name />
<email_new_orders_attach_pdf>false</email_new_orders_attach_pdf>
<sales_rep_name />
<address_book>
<address>
<id>46</id>
<address />
<city />
<province />
<country>UK</country>
<postal_code />
<address_type>main</address_type>
<customer_id>65</customer_id>
<created_at>2019-06-28T02:37:15+01:00</created_at>
<updated_at>2019-06-28T02:37:15+01:00</updated_at>
<last_used_at xsi:type="xsd:dateTime">2020-03-11T18:58:43+00:00</last_used_at>
<title>UK</title>
</address>
</address_book>
</customer>
</order_info>
</order>
</orders>