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.
Export New, Modifed or All Records
Optional
If Modified, then records updated since the Modified Since on the task will be exported. If New, then records submitted since the Submitted Since on the task will be exported.
Created Since
Optional
Only export records that have been created since this date when exporting New.
Modified Since
Optional
Only export records that have been updated since this date when exporting Modified.
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>