1. Home
  2. WooCommerce Sync for QuickBooks Online
  3. Payments
  4. How to update WooCommerce order statuses when a payment is received in QuickBooks

How to update WooCommerce order statuses when a payment is received in QuickBooks

If your WooCommerce orders are being synced to QuickBooks as invoices, and there’s no payment actually being made in WooCommerce when the orders are placed (using gateways like wire transfer, bank transfer, cash on delivery, etc) – the order will be synced to QuickBooks as an open invoice.

In cases like this, it’s very common to proceed either in one of three ways.

  1. Proceed as normal. Have the open invoice be synced to QuickBooks, and invoice the customer out of QuickBooks, then receive the payment as normal in QuickBooks.
  2. When the payment is received from the customer, change the order status in WooCommerce to a status like “Completed”, and set the payment gateway to artificially sync a payment to QuickBooks when this occurs. You can read more about this here.
  3. When the payment is received from the customer, receive the payment in QuickBooks to close the invoice. This commonly occurs when matching an invoice to a payment in a bank feed in QuickBooks. Then, set our integration to sync payments from QuickBooks > WooCommerce:
    1. In MyWorks Sync > Settings > Automatic Sync, turn on Payment switch in the QuickBooks > WooCommerce direction.
    2. In MyWorks Sync > Pull, there are two settings that will now show:
      1. Order Status once payment is pulled: This setting controls what the WooCommerce order status will be changed to by our sync, once a payment for that order is added in QuickBooks.
      2. Prevent Payment Pull for these order statuses: This setting controls which order status should not be changed by our sync, if the order is set to this status when we pull a payment into QuickBooks. The common options to set here would be Completed (if you don’t want completed orders to have their status changed), or Cancelled (if you don’t want cancelled orders to have their status changed) – if a payment is applied to those orders in QuickBooks.
    3. Then, when the payment is applied in QuickBooks, we will automatically update the status for the related WooCommerce order, following the settings above.
Updated on December 31, 2018

Was this article helpful?