How do export orders by status?

Introduction

Under the order export tab, you can specify orders with a certain status to export. Enter a comma separated list, like shipped,pending to pull multiple statuses. Pulling orders by status will cause our system to query orders by the date they are modified.

Invoices and Payments

If you want to insert invoices and payments later, then you want to filter by order status. This will enable us to query orders by the date that they are modified. The same order will reach QB multiple times, but our system will catch the duplicate and skip the order. Then, our software inserts the payment. The software will update existing orders in QB, if you have the delete and reinsert QB transactions button turned on, which is located in the advanced tab.

Order Statuses

These carts support order status filtering:

Amazon

Connex only exports shipped orders. There are no order statues to export. Orders are queried by their modified date. When they reached shipped status and when the sync runs, we will send the orders to your QuickBooks.

Bigcommerce

Here are the available order statuses

  • Incomplete
  • Pending
  • Shipped
  • Partially Shipped
  • Refunded
  • Cancelled
  • Declined
  • Awaiting Payment
  • Awaiting Pickup
  • Awaiting Shipment
  • Completed
  • Awaiting Fulfillment
  • Manual Verification Required

Channel Advisor

The statuses are case sensitive!

  • NoChange
  • Unshipped
  • PendingShipment
  • PartiallyShipped
  • Shipped

eBay

Here are the available order statuses:

  • Completed

Magento

Here are the available order statuses:

  • complete
  • pending
  • processing

SKU Vault

Here are the available order statuses:

  • ReadyToShip
  • Completed

ShipStation

Here are the available order statuses:

  • awaiting_shipment
  • awaiting_payment
  • shipped

Shopify

Here are the available order statuses:

  • pending
  • authorized
  • partially_paid
  • paid
  • shipped

WooCommerce

Here are the available order statuses:

  • completed
  • pending
  • processing

You can add a comma separated list on the configure page > order status field:

 

Have more questions? Submit a request
Powered by Zendesk