Free tool

Shopify overselling check

Several listings can sell one real item: one blank tee behind many designs, one candle in a set, one bottle in a 3-pack. Shopify keeps a separate count for each listing. Type your numbers, and see how many units customers can buy that you do not have.

✓ No sign-up✓ Your numbers stay in your browser✓ No Shopify login

Check one item on your shelf

Type the real count of the item. Then add each listing that sells it, with the quantity that Shopify shows for that listing.

Count only the units that are free to sell. Do not count units for orders that you did not ship yet, because Shopify already took them off.

Uses per sale is the number of items one sale takes. A 3-pack uses 3. A single tee uses 1.

Check the whole store from a CSV file

In Shopify admin, go to Products, then Inventory, then Export. Drop the file here. The check finds each SKU that is on more than one listing. A product CSV export with Variant Inventory Qty also works.

Drop a .csv file here, or click to choose one

Why Shopify oversells shared stock

Read the guide: Why Shopify oversells, and how to stop it

Questions

Why does Shopify oversell when variants share stock?

Shopify keeps a separate quantity for each variant. When a customer buys one variant, Shopify takes 1 from that variant only. Each other listing that uses the same item still shows its old quantity.

How do I stop overselling on Shopify without an app?

Split the real count between the listings, so that the quantities add up to the shelf. This is safe. But a listing can sell out while the shelf still has stock, and you must move units by hand. The check shows a split for your numbers.

Does "Continue selling when out of stock" cause overselling?

Yes. With that setting on, Shopify sells a listing at 0 and below. The check counts only the quantity that Shopify shows, so it assumes that the setting is off.

Does a bundle made with the Shopify Bundles app oversell?

Not because of shared stock. For a bundle made with the Shopify Bundles app, Shopify sets the quantity of the bundle from its parts. Do not add that bundle to the check. A set or a pack that you made as a separate product has its own count, so add it with its uses per sale.

Is my file uploaded anywhere?

No. The check runs in your browser. Your file and your numbers do not leave your computer.

Other free tools

One shelf, one count

OneShelf gives the listings that sell one item one base stock. A sale on any listing takes from the base stock, and each listing shows what the shelf allows. It is free for up to 3 base stocks.

Install on Shopify See how it works