Skip to main content

Syncing Shopify orders as Sales Orders in QuickBooks Online

Sync Shopify orders to QuickBooks Online as sales orders, with or without an invoice: plans, setup, what syncs, payments and cancellations.

MyWorks can sync your Shopify orders to QuickBooks Online as sales orders. A sales order records what a customer has ordered without posting anything to your accounts, which suits wholesale orders, pre-orders and anything you invoice later.

Availability

  • Sales Order is available on the Grow, Scale and Soar plans.

  • Sales Order + Invoice is available on the Scale and Soar plans.

  • The Sales Order row in Based on Order Tag is available on the Scale and Soar plans.

The Grow plan features on the Plans page, including Sync orders as QuickBooks Sales Orders

Before you start

In QuickBooks Online:

  • Your company needs QuickBooks Online Plus or Advanced, or Intuit Enterprise Suite. Simple Start and Essentials need the Inventory add-on.

  • Go to Settings > Account and settings > Sales and turn on Sales orders.

Your QuickBooks connection also needs permission for sales orders. If you connected MyWorks before this option was available, Settings > Order will ask you to reconnect. Go to MyWorks Sync > Connection, click Disconnect, then connect the same QuickBooks company again. Your settings and product mappings are kept. If you use Map > Custom Fields, check those mappings afterwards, because QuickBooks can give your custom fields new IDs and they may need to be chosen again.

Notice in Settings > Order: Reconnect QuickBooks to sync sales orders

Turning it on

  1. Go to MyWorks Sync > Settings > Order.

  2. Set Sync Shopify Orders as to Sales Order or Sales Order + Invoice.

  3. Choose a QuickBooks Product for Shipping line item and a QuickBooks Product for Discount line item.

  4. For Sales Order + Invoice, decide whether to turn on Only sync the invoice once the order is fulfilled in Shopify.

  5. Save your settings.

Settings > Order with Sync Shopify Orders as set to Sales Order + Invoice

This applies to orders synced from now on. Orders already in QuickBooks stay as they are.

What appears on the sales order

  • The customer, order date, order number, memo, terms, billing and shipping addresses, ship via, tracking number and ship date.

  • Your products, with the class and location from your mappings. A bundle syncs as its component products.

  • Shipping and discounts as product lines, because a QuickBooks sales order has no shipping or discount field. Tips, duties and fees follow your Order settings.

An order line with a price and no matching QuickBooks product stops that order from syncing, so a sales order is never short. MyWorks Sync > Log tells you which line needs attention.

Sales orders do not carry custom fields, a private note or a due date, because QuickBooks does not accept them from apps yet.

Sales Order + Invoice

The sales order syncs first, and MyWorks then creates one invoice from it, with each line tied back to the sales order.

The Scale plan features on the Plans page, including Sales Orders with or without an Invoice
  • With Only sync the invoice once the order is fulfilled in Shopify off, the invoice is created together with the sales order.

  • With it on, the invoice is created once the whole order is fulfilled. A partly fulfilled order waits.

  • The order counts once toward your monthly order limit.

QuickBooks does not close a sales order automatically when it has been invoiced. Close it in QuickBooks when you are finished with it.

Payments, refunds and cancelled orders

  • Payments are recorded on the customer. With Sales Order + Invoice, a payment that synced first is applied when the invoice is created, up to the amount the invoice owes. With Sales Order alone, it stays on the customer until you apply it in QuickBooks.

  • Refunds sync as refund receipts, as they do for your other orders.

  • Cancelled orders: QuickBooks does not let apps void a sales order. MyWorks sets it to a single line with a quantity of 0, and its message starts with "CANCELLED in Shopify". With Sales Order + Invoice, the invoice is voided as usual.

  • Order edits update the sales order until an invoice exists for it. After that the sales order is left as it is, so it stays matched to the invoice.

Using order tags

On Scale and Soar, you can send only some orders to sales orders. Set Sync Shopify Orders as to Based on Order Tag and add your tags to the Sales Order row. See Syncing Shopify orders as different transaction types based on order tag.

Set Order Tags table with a Sales Order row

If an order does not sync

Settings > Order shows a notice if QuickBooks is not ready, and MyWorks Sync > Log explains any order that failed:

  • Sales orders are not turned on for this QuickBooks company: turn them on in QuickBooks, and check that the subscription is active and on a supported plan.

  • The connection does not include permission for sales orders: disconnect and connect QuickBooks again.

  • QuickBooks has not switched on sales orders for apps in this company: contact us.

  • A discount needs a product: choose a QuickBooks Product for Discount line item.

  • QuickBooks did not confirm whether the sales order was created: check Sales orders in QuickBooks before pushing the order again, so it is not created twice.

Notice in Settings > Order: Turn on sales orders in QuickBooks

Good to know

  • A sales order always uses the Shopify order number, with your prefix if you have one, even when Use next QuickBooks order # is on.

  • QuickBooks calculates the tax on a sales order itself, so it can differ slightly from Shopify. If your company does not use sales tax, no tax is added.

  • If a discount is built into the line price, no separate discount line is needed. See Syncing Shopify orders containing discounts.

  • A sales order has no currency setting that apps can use. If you sell in more than one currency, test one foreign-currency order and check it before relying on this.

Did this answer your question?