Overselling is the expensive kind of data problem. A customer buys something, pays for it, gets a confirmation email — and then you find out your supplier ran out nine days ago and your store never knew.

The fix is the same mechanism as a price feed, pointed at a different column: read the supplier's stock file, match it to your variants, and set the quantity. This guide covers the parts that are specific to stock, which behave differently from prices in ways that matter.

The one rule that matters most

A blank cell leaves the quantity alone. It does not set it to zero.

This is deliberately the opposite of how a blank behaves in most sheets, and it exists for exactly this case. A supplier file that covers half your catalogue, or a column that failed to parse, must never empty a warehouse. Zero is a meaningful stock level and has to be written explicitly — which means a supplier genuinely reporting zero still zeroes you, but a gap in their file does not.

If you want a product set to zero, the feed has to say zero.

Matching, and why it is strict

Stock feeds use the same exact join as price feeds: SKU or barcode, hash lookup, nothing fuzzy. Barcodes are especially useful here because a GTIN validates its own check digit, so the barcode column identifies itself regardless of what the supplier titled it.

An identifier that matches two of your variants is treated as matching neither and reported as ambiguous. With prices that would be an embarrassing error; with stock it would be a phantom quantity on a product you cannot ship.

Where their codes carry a prefix yours do not, strip it with an identifier transform rather than editing their file.

Several locations, one supplier number

A supplier tells you they have 7 units. You have three locations. Shopify needs a number per location.

You can send the whole quantity to one nominated location, which is what most dropship and single-warehouse setups want. Where a quantity is divided across locations it is split as evenly as it goes — 7 across 3 becomes 3, 2, 2, never 2, 2, 2 with a unit quietly lost in the rounding.

Worth thinking about before you run it: if your supplier's number is their warehouse stock and not yours, pushing it into a retail location's count will make your shop floor figures fiction. Most stores want a dedicated location representing supplier availability.

Step by step

  1. On the Inventory page, choose Import stock from a supplier.
  2. Give the feed URL and credential if it needs one. Saved credentials are encrypted at rest.
  3. Confirm the proposed mapping — which column identifies the product, which holds the quantity.
  4. Choose the location the quantities apply to.
  5. Review the preview: matched, unmatched, ambiguous, and the quantity each variant would land on.
  6. Approve. It runs through the normal pipeline, so it lands in Activity with undo.
  7. Save the feed so the next file is one click.

Things that bite

Who this is for

Dropshippers, resellers and anyone whose availability is really their supplier's availability. If you have ever refunded an order because something was out of stock upstream, this is the gap it closes.

Stop overselling what your supplier ran out of

Point SheetSync at a supplier stock file and keep your inventory in step with it.

Try SheetSync today
← Import a supplier price list