You have traffic, new customers every day, and a store that looks healthy on the surface. Then you check how many first-time buyers ever place a second order and the number disappoints. The store-wide figure hides the real story: some products in your catalogue quietly create repeat customers, and others create one-time buyers. The product a customer starts with is the strongest single predictor of whether they come back.
Key takeaways
-
The first product a customer buys predicts the second order better than anything else you can see in an export.
-
You can find which first products lead to a second order with a spreadsheet: tag each customer's first product, then measure the share who reorder within 90 days and how long it takes.
-
A gateway product is the opener that most reliably turns a first-time buyer into a repeat customer. It is often not your bestseller.
-
The actions follow directly: lead acquisition with the products that retain, fix or demote the openers that do not, and pair each opener with the product that most often follows it.
How do I see which first product leads to a second order?
Compare each customer's first product with whether they placed a second order inside a fixed window, such as 90 days. That gives you a repeat rate per opener.
You need an order export with customer id, order id, order date, product id or name, and quantity. Sort by customer and date, tag the main product on each customer's first order, then check whether a second order arrived within the window and how many days it took. The purchase frequency guide covers the same export in more depth.
How do I find the products that turn one-time buyers into repeat customers?
Rank your first-purchase products by two numbers: the share of their first-time buyers who reorder within the window, and the median days to that second order. Products that score well on both are doing the retention work.
For consumables such as coffee, skincare, pet food and supplements, the window usually sits somewhere between 25 and 75 days depending on how fast the product is used up. Products that slot into a daily or weekly routine repeat more reliably than products bought for an occasion, which is why a small routine item often outperforms a large gift set on this measure.
What is a gateway product, and how do I find mine?
A gateway product is the first product that most often turns a new customer into a repeat customer within a predictable number of days. Three roles are worth naming:
-
Opener: the product people most often buy first, usually the one your ads feature. It gets attention. It may not earn the second order.
-
Gateway: the opener that best converts a first purchase into a second, typically inside 30 to 90 days.
-
Retainer: the product people keep reordering month after month: the 30-day vitamin, the weekly coffee bag, the monthly bag of dog food.
Your gateway may be a smaller, cheaper item that builds trust rather than your highest-value SKU. Look at the product-level repeat rates and second-order timing from your export. The top of that table is your gateway candidate list. Market basket analysis across orders surfaces the same roles automatically, along with which product tends to follow which.
Which tools do this from order history, and what can a spreadsheet do alone?
A spreadsheet can tag first products, compute repeat rates by product, and find the median days to second order. That is enough to find your gateway candidates, and for a small catalogue it may be all you need.
Tools that read the full order history add two things. They show which product follows which across orders, including substitute pairs that cannibalise each other rather than complement. And they split the roles by customer segment, because the gateway for a Champion is often not the gateway for a first-time bargain buyer. Affinsy does this from an uploaded export and turns any product role into an exportable customer list for a campaign.
Compute product-level repeat rates from your order export
Columns: customer id, order id, order date, product id or name, quantity, and order total if you have it.
-
Sort by customer id, then order date. Mark each customer's first order and its main product. If there are several line items, take the highest-value one.
-
For each customer, find the next order date after the first. Compute the days between them and flag whether the second order landed within 90 days.
-
Group by first product. For each, compute the share of first-time buyers who reordered within 90 days, the median days to second order among those who did, and the number of first-time buyers, which is your sample size.
Illustration, with round numbers:
| First product | First-time buyers | Reordered within 90 days | Share | Median days to second order |
|---|---|---|---|---|
| Product A | 1,000 | 400 | 40% | 32 |
| Product B | 800 | 120 | 15% | 61 |
| Product C | 1,200 | 600 | 50% | 45 |
Product C is the strongest gateway candidate: highest share, reasonable timing. Product A has a good share and a fast median. Product B is a weak opener for repeat: low share, long delay. If your acquisition budget is behind Product B, you are paying to bring in customers who are unlikely to return.
Treat products with fewer than 100 first-time buyers with caution. Small samples produce unreliable rates.
From analysis to action
Lead acquisition with the retainer or gateway. Make it the hero of paid ads, the welcome offer and the first-order bundle. Measure the change in second-order rate for the cohort that saw it.
Pair openers with the product that follows them. If first orders of the puppy kibble are most often followed by one specific treat, put the two together in the post-purchase flow and in a bundle. The bundles from order data entry covers how to avoid pairing substitutes.
Fix or demote weak openers. Adjust the pack size or price, improve the onboarding email, test a different message, or stop leading acquisition with it. A bestseller that produces one-time buyers is a strong opener and a weak gateway, and the fix is to change what it leads to, not to stop selling it.
Time the reminder to the product. If the median second order for the 30-day vitamin lands on day 32, the education email goes in week one, social proof in week two, and the reorder nudge around day 24 to 28. The replenishment email guide has the full method.
For agencies: the deliverable
Product-level repeat behaviour is a one-page deliverable, not a dashboard. Name the top opener, the gateway and the retainer, show the product table above, state the typical second-order window, and propose two or three campaign changes per role. Refresh the table monthly and tie any movement to the experiment that caused it. Affinsy shortens this across several client stores by computing the roles and the follow-on products from each store's export.
Next steps
-
Pull an order export this week and run the product-level repeat table in a spreadsheet.
-
Pick one gateway to promote harder and one weak opener to demote from acquisition this month.
-
Set a quarterly review. Product roles shift when the catalogue, pack sizes or acquisition offers change.
If you would rather have the roles, the follow-on products and the reorder timing worked out for you, the 48-hour analysis returns them for your store, and the free bundle finder runs a first pass on a CSV in the browser.
FAQ
How often should I refresh the gateway and retainer analysis?
Quarterly for most stores, monthly for fast-moving categories, and any time you launch a major product, change pack sizes or shift acquisition offers.
What if my bestseller has a poor second-order rate?
It is a strong opener and a weak gateway. Test changes to onboarding and messaging, bundle it with a proven retainer so first-time buyers are led into a repeat habit, and stop leading acquisition with it on its own.
Does this work for subscriptions?
Yes. The gateway is usually the product or intro offer that most often precedes a subscription. Knowing which items customers reorder before they subscribe tells you where to place the offer. The subscription timing section of the hub article covers when to make it.
What about non-replenishable or high-ticket products?
Extend the window past 90 days and focus on next-product patterns, accessories and refills rather than strict reorder timing. Some first products still predict a second order, and others still do not.