Blog › Shopify Stores

The Last Item Sold Twice: Fixing Shopify Stock Across Your Shop and DMs

By Joseph Maina · · 3 min read

Shopping bags and gift boxes arranged on a table

One customer pays through the website while another pays for the same last item in your shop. The dashboard did not know about the conversation at the counter. Inventory problems often start at that handover between sales channels. Before buying a stock app, trace who records a sale and when the quantity changes.

Count the sellable options, not just the product names

An illustrative clothing shop may have ten shirts overall but no blue medium shirts left. A total at product level cannot answer the customer’s actual choice. Start with a physical count of the options you sell and agree which item identifiers staff use across the shop, website and stock sheet.

Separate sellable stock from damaged items, display pieces and stock reserved for another purpose. Record where the items are held and which location can fulfil online orders. A number is only useful if the person packing an order can find the corresponding product.

Make every sales route update an agreed record

List how orders arrive: Shopify, Instagram messages, WhatsApp and walk-in purchases. For each route, name the person who records the sale and the point at which it is recorded. If a tool synchronises channels, verify that exact workflow rather than assuming every payment channel updates every stock record.

Decide how reservations work. If a customer asks you to hold an item before paying, state who records the hold and when it expires. Otherwise an unpaid promise in a chat can look identical to available stock on the website. Keep the process simple enough for a busy employee to follow.

EventDecision to document
Walk-in purchaseWho records the item and option immediately?
Unpaid reservationWhere is the hold recorded and when does it expire?
Cancelled orderWho confirms whether the item becomes sellable again?
Returned itemWho inspects its condition before returning it to available stock?

Review what happens at zero before a promotion

Shopify allows tracked products to continue selling when out of stock if that option is enabled. This may fit an intentional preorder, but it needs a clear customer promise. Review the actual product or variant settings and location configuration before assuming zero quantity stops every kind of sale.

A preorder needs confirmed availability expectations and an exception process. Do not silently sell unavailable items as immediate stock. Test the storefront with a representative sold-out option and confirm how staff handle purchases in other channels, whose behaviour can differ.

Sources and further reading

Investigate stock differences while the trail is fresh

Choose a manageable set of fast-moving items for regular checks. When a quantity differs, look for an unrecorded counter sale, an expired hold, a return awaiting inspection or a mistaken option. Correct the cause as well as the number; otherwise the next count will reveal the same gap.

Track cancellations caused by stock errors as an operating measure. A store can receive more orders while creating more refunds and support work. Use that evidence to decide whether you need a clearer process, training or a properly scoped integration.

Bring your sales routes to a Shopify support review

Share the channels you sell through, approximate catalogue size and where discrepancies occur. I can scope a Shopify catalogue and storefront review around that workflow. Start with the process before choosing an app.

Sources and further reading

Related articles