When a Variant Sells Out, Which Shopify Sales Are Substitutions?

The black weekender sells out on Tuesday. By Friday, the olive one is your hottest SKU. Before you double the olive reorder, ask the people who bought it what they came for. The same sales curve can describe a breakout color, a good substitute, or a suitcase needed before a flight.

Keep a dated record of when the original variant became unavailable to online shoppers. In Shopify, inventory at a location that doesn't fulfill online orders can leave a product showing as unavailable online, even if the business has units somewhere. Check what a shopper could actually order in the market you are studying. Shopify's out-of-stock inventory guide

Give buyers a way to describe the switch

Run a single-choice poll on the Shopify thank-you page for the relevant family of products. Ask “Which best describes the weekender you bought today?”

• It was my first choice.
• I picked another color because my first choice was unavailable.
• I picked another size because my first choice was unavailable.
• I picked another style because my first choice was unavailable.
• I changed my mind for a different reason.
• I didn't have a first choice.

For any of the three stockout answers, ask the optional follow-up “Which color, size, or style were you looking for?” A comment such as “black, small enough to fit under the seat” is more actionable than a tally of “unavailable.” If the alternatives in your assortment differ by scent or pack count, use those dimensions instead. Keep the category narrow enough that a shopper with several items in the basket knows which decision you mean.

Recover the story inside the bestseller report

Imagine 90 shoppers buy one olive bag apiece during the black stockout, and 45 of them answer. Eighteen say they changed color because their first choice was unavailable. Fourteen of those 18 specifically name black. You have 14 reported black-to-olive switches, plus four color switches whose original preference may be another color or unknown.

Those 14 replies can change a reorder conversation immediately. Keep the complete 90 units in your sales records, and put the 14 observed switches beside them in the buying brief. Multiplying 14 by two assumes that the silent half switched at the same rate as respondents. Buying an extra 90 black bags assumes something even bigger: that olive had no demand of its own.

Watch what happens when the first choice comes back

Track daily units for both colors before the outage, while black is unavailable, and after it returns. Note changes in price, featured placement, traffic, or campaign creative. If olive stays strong after black returns at the same price, the shortage may have introduced customers to a genuine second favorite. If olive sales drop immediately, a conservative olive reorder and better coverage of black deserve closer attention.

A thank-you-page poll reaches buyers who found a workable substitute. Someone who closed the tab after seeing “sold out” cannot answer it. A restock signup count can give you a separate view of unfulfilled interest, although a signup and a purchase are different commitments. If you choose to offer a preorder, use the preorder expectations survey to verify that buyers understood the wait. If a missing item sends shoppers into a kit, ask what made the bundle worth buying.

Publish the poll with OrderSurvey on the Shopify App Store. Test one first-choice answer and one substitution answer before collecting responses. Record the date the original SKU came back into stock next to the date the poll ended. Six months from now, that little pair of dates may explain a color trend that otherwise looks like a merchandising mystery.

Frequently asked questions