Most Shopify retention work starts too late. A store sees returning customer rate flatten, repeat purchase revenue soften, or post-purchase flows underperform, then jumps straight to more discounts, more loyalty points, or another email sequence.
The better first question is simpler: which products are creating customers who come back?
A product can look healthy in normal Shopify reporting because it drives a lot of first orders. But if those customers rarely place a second order, the product may be a revenue leak hiding inside your best-seller list. The opposite can also happen: a modest SKU may not lead total sales, but customers who start with it may come back faster, buy more categories, or reorder predictably.
Operator rule: do not judge retention only at the store level. Segment repeat purchase behavior by the product a customer bought first.
This matters because retention tactics depend on the product. A replenishable product needs reorder timing. A giftable product may need occasion reminders. A technical product may need education before cross-sell. A low-satisfaction product may need product-page expectation fixes before you spend more to acquire buyers.
What to export from Shopify
Start with your Shopify orders export, not a dashboard screenshot. You need order-level and line-item-level detail so you can connect each customer’s first order to what happened afterward.
Use a period long enough for customers to have had a realistic chance to buy again. For many stores, that means the last 6 to 18 months. For consumables, you may be able to use a shorter window. For durable goods, use a longer one.
| Field | Why it matters |
|---|---|
| Order name or order ID | Groups line items into the same purchase. |
| Created at | Identifies first order date and time between purchases. |
| Email or customer ID | Connects multiple orders to the same buyer. |
| Lineitem name | Shows which product was included in the first purchase. |
| Lineitem sku | Cleaner grouping when product names change. |
| Lineitem quantity | Separates single-unit trial behavior from bulk buying. |
| Total or subtotal | Helps compare order value and follow-up value. |
| Discount amount or discount code | Shows whether repeat behavior is driven by heavy incentives. |
| Refunded amount | Flags products that sell but create satisfaction or expectation risk. |
Shopify order exports can show additional line items on separate rows, with some order fields blank on those extra rows. Before calculating anything, fill down the order-level fields so every line item row has the order ID, date, customer, and financial fields it needs.
Do not skip cleanup. Product-level retention analysis breaks quickly if multi-item orders are not handled correctly.
Build the first-purchase view
The core of this audit is a customer-first table. Each row should represent one customer, their first order, and what happened after that first order.
Create these columns in a spreadsheet or analysis tool:
- Customer email or customer ID
- First order ID
- First order date
- First-purchase product or SKU
- First order subtotal
- First order discount
- First order refunded amount
- Number of later orders
- Date of second order
- Days from first order to second order
- Second order subtotal
- Second order product or category
If a first order contains multiple products, choose one of three approaches and keep it consistent:
- Use the highest-priced SKU in the first order as the starter product.
- Use the product with the highest quantity as the starter product.
- Create a bundle or multi-product starter group when combinations are common.
For diagnostic work, the highest-priced SKU is often the easiest starting point because it usually represents the main purchase decision. If bundles are central to your store, grouping common first-order combinations may be more accurate.
Want SignalOps to find this automatically?
Upload your Shopify CSV and get a product-level read on repeat purchase decay, refund risk, revenue drops, and silent leaks.
Analyze your Shopify CSVCalculate repeat purchase by product
Once every customer has a first-purchase product assigned, group the table by that product or SKU. Then calculate the metrics that show whether the product creates future revenue.
| Metric | Formula | What it tells you |
|---|---|---|
| First-time customers | Count of customers whose first order included the SKU | How much acquisition volume the product attracts. |
| Repeat customers | Count of those customers with at least one later order | How many buyers came back after starting with that SKU. |
| Product repeat purchase rate | Repeat customers divided by first-time customers | The SKU’s ability to create returning customers. |
| Median days to second order | Median days between first and second order | The real reorder or follow-up timing. |
| Second-order revenue | Sum of later order revenue from that cohort | How much future revenue the starter product creates. |
| Refund rate for first orders | Refunded first orders divided by first orders | Whether a product creates satisfaction or expectation risk. |
| Discounted first-order share | Discounted first orders divided by first orders | Whether repeat behavior depends on incentive-heavy acquisition. |
Do not overreact to tiny samples. If a SKU has only a handful of first-time customers, mark it as directional. Focus first on products with enough first-order volume to affect revenue.
The key comparison is not just high repeat rate. The best retention products combine meaningful first-order volume, healthy repeat rate, reasonable time to second order, low refund risk, and useful second-order revenue.
Read the patterns
After grouping by first-purchase product, look for these operator patterns.
High sales, low repeat purchase
This is the hidden leak. The product brings in new customers but does not create many second orders. Check refund comments, reviews, product-page promises, shipping expectations, sizing, quality complaints, and whether the product naturally has a next purchase path.
Low sales, high repeat purchase
This is a potential acquisition or merchandising opportunity. If customers who start with this SKU come back reliably, test featuring it more prominently, bundling it with entry products, or using it in paid acquisition where margins allow.
High repeat purchase, slow second order
This usually means your follow-up timing may be wrong. A generic 14-day or 30-day post-purchase flow may miss the real reorder window. Use the median days to second order as the starting point, then test reminders before that point.
High repeat purchase, high refund rate
This can happen when a product is popular but creates inconsistent experiences. Do not treat it as a pure retention winner. Investigate variants, batches, fulfillment locations, sizing, or product education.
Discount-driven repeat behavior
If a starter SKU only repeats when the first order was heavily discounted, the product may be training low-margin customers. Compare discounted and non-discounted cohorts before scaling acquisition.
Turn findings into actions
The point of product repeat purchase analysis is not another spreadsheet. It is better operating decisions.
| Finding | Action | Owner |
|---|---|---|
| Starter SKU has high repeat rate | Feature it in acquisition, collection pages, quizzes, and first-order bundles. | Growth and merchandising |
| Starter SKU has low repeat rate | Audit product promise, reviews, refund reasons, post-purchase education, and next-best offer. | Merchandising and CX |
| Second order happens around a clear window | Move reorder reminders to match observed timing by product. | Email and lifecycle |
| Customers repeat into a specific second SKU | Create product-specific cross-sell blocks and post-purchase recommendations. | Email and site |
| First-order refunds are concentrated in one SKU | Investigate product quality, variant issues, expectation mismatch, and fulfillment defects. | Ops and CX |
| High-volume SKU creates weak second-order revenue | Review paid spend, landing pages, offer structure, and whether the SKU should remain a hero product. | Growth and finance |
Run this audit monthly if you have meaningful order volume. For smaller stores, run it quarterly. The goal is to catch retention decay before it shows up as a storewide revenue problem.
When repeat purchase drops, the cause is rarely just one metric. It can be product mix, acquisition quality, discounting, refund risk, replenishment timing, or a missing second-purchase path. A Shopify orders CSV gives you the raw material to separate those causes.
Best next step: rank your top first-purchase SKUs by repeat purchase rate, median days to second order, second-order revenue, and refund rate. The products that look strong across all four are retention assets. The products that sell once and disappear are where to investigate first.