Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

My Shopify sales are missing in QuickBooks

Short answer

Shopify orders go missing in QuickBooks when an event never arrived, the connection lost its permission, or QuickBooks rejected one record and the sync stopped there. Shopify says its event messages can be missed. Write down the last order that did arrive and do not re-enter the rest by hand.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • Orders placed in Shopify last week are not in QuickBooks.
  • Some orders arrived and others, often refunds, edited or partly paid ones, did not.
  • The connector shows a green tick but the totals in QuickBooks are lower than in Shopify.
  • My bookkeeper is typing sales in by hand to close the month.
  • It worked for a long time and stopped around a change to products, taxes or the QuickBooks login.

Why does this happen?

  1. The event from Shopify never arrived

    Shopify tells connected apps about new orders by sending them a message. Shopify's developer guidance says an app can miss events through handler failures or downtime. It recommends a periodic job that fetches data from Shopify again, so a sync with no such catch-up job loses orders silently.

  2. Events arrive in the wrong order

    Shopify does not keep events in a fixed order for the same order. An order update can reach the sync before the order itself, and a sync that does not sequence them can fail or overwrite newer data with older.

  3. One rejected record blocks the queue

    A new product with no matching item in QuickBooks, a tax code that does not exist, a customer with a missing field or a closed accounting period can make QuickBooks refuse one order. A badly built sync keeps retrying that order and never reaches the ones behind it.

  4. The connection to QuickBooks lost its permission

    The sync acts as the person who connected it. If that person is removed, changes role or disconnects the app, every send fails until someone reconnects.

  5. The sync only handles the simple case

    Many connectors cover a plain paid order. Refunds, exchanges, gift cards, discounts, partial payments, draft orders and orders edited after payment are the usual gaps, and they show up as missing or mismatched totals rather than as an error.

What can I do about it today?

  1. Find the first missing orderIn Shopify note the number and date of the last order that does appear in QuickBooks and the first one that does not. Also note whether the missing ones share something, such as a refund, a discount code or a product.
  2. Keep a list instead of typing the sales inManual entries made now can collide with the automatic ones later and cause duplicates. A simple sheet of missing order numbers is safer.
  3. Look at the connector screen and take a screenshotOpen the app that does the sync and the connected apps page in QuickBooks. Record what each says. Do not disconnect and reconnect unless your developer asks.
  4. Ask your bookkeeper what changedNew tax codes, renamed accounts, items added or merged, a user who left, or a month that was closed.
  5. Do not uninstall the connectorRemoving it can discard its record of what was already sent, and that record is what prevents duplicates when it is repaired.

When should I bring someone in?

  • A month-end or a tax filing is close and the totals do not match.
  • The connector is a custom script or an app nobody on your side built.
  • Missing orders include refunds or payments, where the books are wrong rather than only incomplete.

How do I handle it?

  1. Count both sides for the broken periodI read the vendor's current documentation first, and every change is tried on test data before it touches your real books. I list the orders in Shopify and the sales in QuickBooks for the same dates, so it is exact what is missing, what is doubled and what differs in amount.
  2. Find the first failureI read the sync logs and the connection state to find the first order that failed and why, rather than the last error shown.
  3. Repair the cause and the dataI fix the rejection, mapping or permission problem, then send only the missing orders in a controlled run that checks each one before creating it.
  4. Add a catch-up and an alertA scheduled job compares both systems and re-sends what is missing, and a failed send raises a message to you.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Can I just export the Shopify orders and import them into QuickBooks?

It can work for a one-off catch-up, but check first that the import will not duplicate orders the sync already sent. Compare the order numbers on both sides before importing.

Why do some orders sync and others do not?

Usually the missing ones differ in some way: a refund, a discount, a product with no match in QuickBooks, or a tax code QuickBooks refuses. The pattern in the missing orders points to the cause.

Will reconnecting fix it?

It restores the permission if that was the cause, but it does not send the orders that were skipped. Those need a controlled catch-up.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

For your developer: the technical fixes

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.