Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

The stock counts in QuickBooks and my online store are different

Short answer

Stock counts drift when two systems both change the same quantity, an event is missed, or products are matched wrongly. Decide which system is the master for quantity, stop edits in the other, and count a few products by hand before trusting any sync.

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

Does this sound like your situation?

  • The shop shows items in stock that QuickBooks says are zero, or the reverse.
  • The gap grows a little each week.
  • Returns, bundles or items sold in packs never come out right.
  • A product was renamed or merged and now has two stock lines.
  • I oversold an item that the shop thought it had.

Why does this happen?

  1. Both systems change the same number

    If staff adjust stock in QuickBooks while the shop also subtracts each sale, two sets of changes land on one quantity. Whichever syncs last overwrites the other.

  2. Missed or reordered events

    Shopify's developer guidance says its event messages can be missed and are not kept in a fixed order, and recommends periodic jobs that fetch data again. A stock sync with no catch-up quietly loses sales and returns.

  3. Products matched on a changing name

    If the link between a shop product and a QuickBooks item rests on the name or a code that was edited, the sync creates a second item or updates the wrong one.

  4. Bundles, variants and units

    A pack of six sold as one, a product with sizes, or stock bought by the box and sold singly each need a rule. Without it the quantities subtract in the wrong units.

  5. Returns, cancellations and locations

    A return that adds stock in one place, a cancelled order that never gives stock back, or several warehouses mapped to one total, all leave a permanent difference.

What can I do about it today?

  1. Pick five products and count themCount the physical stock, then compare with both systems. This shows which side is closer to the truth.
  2. Choose one master for quantityWrite down which system is the master and ask staff not to edit stock in the other.
  3. Look for pairs of the same productSearch QuickBooks for items that look the same. Two lines for one product is a matching problem, not a counting one.
  4. Do not overwrite everything from a spreadsheetA bulk import over live stock can erase sales made since you exported. Ask first.
  5. Note when the drift beganA product import, a rename, a new warehouse or a change of connector.

When should I bring someone in?

  • You are overselling or turning away stock you actually have.
  • Many products drift, or bundles and variants are involved.
  • Stock value on your accounts depends on these numbers.

How do I handle it?

  1. Compare a sampleI read the vendor's current documentation first, and every change is tried on test data before it touches your real books. I take a set of products and trace each quantity from the shop and from QuickBooks back to the movements that built it.
  2. Fix the matchingEach product is linked by a fixed identifier, not a name, and duplicates are listed for your bookkeeper to merge.
  3. Make one system the masterQuantity changes flow one way, with rules for bundles, variants, returns and locations written down.
  4. Add a regular comparisonA scheduled check lists products where the two numbers differ and re-sends only those.

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 two-way stock sync work?

It can, but it needs strict rules about who changes what, and it is where drift starts. One-way from a single master is simpler and safer.

Should I stop selling while it is fixed?

That is your call. For fast-moving products, set the shop count to a safe low number first so you do not oversell.

Why do returns break it?

A return can be restocked, written off or sent elsewhere, and the sync must be told which. Otherwise stock goes up in one system only.

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.

Next step

Want this off your desk?

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