How to Find Customers Due to Reorder
Find customers due to reorder using completed purchases or a confirmed schedule, then check open orders and contact history before drafting reminders.
Free app. Runs on your Mac with the Claude or Codex plan you already have.
What a report on customers due to reorder is
A repeat purchase report helps you find customers due to reorder an item they have bought before. Start with a confirmed schedule where one exists. Otherwise, compare completed purchases of the same product in the same selling unit to look for a repeat pattern. A regular pattern gives you a reorder window, or a date around which it may be useful to ask whether the customer wants another order.
The working list needs more than order history. The customer may already have an order pending, may have asked you to stop sending reminders, or may have discussed this same cycle with their account manager. Check those facts before handing off a proposed date and quantity. A useful review gives the account owner the basis for each suggested conversation, keeps uncertain cases visible and tells the owner what to check next.
What it does for the business
- Make reminders specificA buyer can respond more easily to a reminder that names the last item and order quantity. The account owner has a concrete starting point and can ask whether timing or requirements have changed.
- Protect active orders from duplicate conversationsCheck the proposed opportunity against pending work before giving it to sales. The account owner can follow up on delivery or order status when the customer is already waiting for the same item.
- Give account owners a manageable listA queue with a candidate date, evidence and disposition makes it easier to review conversations in order. Owners can route uncertain units or returns to the people who maintain those records.
- Improve the next reviewRecord what customers or account owners confirm, including a changed schedule or a declined reminder. Those decisions help the next review recognize resolved cycles and explain cases that genuinely need another look.
How to build a report on customers due to reorder, step by step
Build a comparable completed order history
A repeat pattern starts with distinct completed purchases of the same item in the same unit.
What to do
- Set the cutoff, time zone and history window. List which stores, accounts and products the records cover. Check that returns, current open orders and contact clearance cover those same combinations.
- Match orders by stable account, order, line and variant IDs. Reconcile conflicting versions at the source. Combine aliases, substituted items or pack sizes only when you can document equivalence and any required unit conversion.
- Count one completed commercial purchase per relevant order. If a line ships in parts, use the completion date for the relevant purchase. Exclude canceled orders, samples and replacement shipments from the repeat pattern.
- Subtract documented returned units from fulfilled units in the same selling unit. Check the physical return record independently of the refund record and flag missing return quantities for review.
Why
Store exports often include one row per item, fulfillment or update. Treating every row as an order can make a customer seem to buy more often than they do. Returns can also change the useful reference quantity. Preserving order IDs, dates and units lets someone verify that the records belong together before using them for a conversation.
Set a candidate date and quantity
Use an explicit schedule when you have one and a consistent purchase pattern when you have enough history.
What to do
- Check for a confirmed active schedule and read its next date, item and quantity. For a date that has already passed, check current execution before interpreting it as a new request.
- With no schedule, put comparable completed purchases in date order. Look at the number of days between consecutive purchases and use the median, the middle value or the midpoint of the two middle values, to reduce the influence of an unusually long or short gap.
- Add the supported interval to the last comparable completion date. Use the last comparable retained quantity as a reference. For example, a regular pattern of case purchases supports a discussion in cases.
- Mark sparse, irregular or conflicting records for review. Record which fact would resolve the uncertainty, such as an authoritative completion date or the number of units returned.
Why
A calendar date is useful when you can explain where it came from. A confirmed schedule points to a specific occurrence. For customers without one, a purchase cadence, or the observed spacing between completed purchases, gives the owner a starting point. Wide swings in timing or quantity can indicate changes in customer needs or buying conditions that deserve a closer look.
Check existing orders and the contact history
A due date deserves a fresh conversation only when the current order and contact records support one.
What to do
- Look for an open or scheduled order for the same customer, variant and unit. If one exists, record its reference and route any follow-up to the person who owns that order.
- Read current suppression or other contact clearance and carry it forward across cycles. If source coverage is incomplete, record what needs to be checked before any draft is used.
- Identify the cycle by account, variant, unit and its confirmed occurrence or calculated date. Read prior contact, dismissal and order decisions. Keep their dates and sources so a repeated export leaves the existing decision in place.
- Explain changes in date, quantity or open-order state with before-and-after evidence. Ask the owner to recheck changes with a material effect and preserve earlier decisions for reference.
Why
An order already underway can satisfy the need that a historical pattern suggests. A prior conversation can also cover the same reorder window even if no purchase followed. Keeping these checks separate from the calculation preserves the purchase basis and lets staff change the next action when a customer responds or an order opens.
Draft and verify eligible conversations
A useful reorder message gives the customer a factual reference and an easy way to confirm what they need.
What to do
- Address the same item and unit the customer previously ordered. Give the factual purchase reference or confirmed schedule, then ask whether another order would be useful.
- Keep suggested dates and quantities conditional unless they come from explicit terms. Check that the wording reflects what you can verify about the previous purchase and any agreement.
- Read each draft against the current open-order and contact records. Hold it if an order is active, outreach is blocked or the customer has already been contacted about that cycle.
- Have a reviewer trace the date and quantity to the schedule or completed purchases and confirm that each combination has a disposition. Correct any mismatch between the calculation, queue and draft.
Why
The customer may have stock left or may need a different pack this time. A short note can mention a previous purchase and ask if a repeat would help. Checking draft eligibility against both the queue and the contact record reduces the chance that the same customer gets asked twice.
Deliver the review with a clear owner
Each row should tell the owner whether to discuss, wait or resolve a specific issue.
What to do
- Name the owner for each next action and include the source references that support it. Mark cases with no confirmed owner so someone can assign them.
- Show whether each row is ready for discussion, waiting for the date, covered by current work, suppressed or in need of review. Give each review case a precise evidence request.
- Show which cycles are new, changed or resolved since the last review. Keep unchanged cases in the supporting records so an owner can trace earlier decisions.
- Record the population and cutoff so a reader can tell what the file covers. Where records are missing, keep the gap visible instead of reporting a zero opportunity count.
Why
A review can be useful even when it produces few conversations. The owner can see that existing orders cover some customers and that other cases need a source check. Stating the coverage makes the next review comparable and lets the team focus on changed cases while preserving the full record.
Common mistakes
- Counting split shipments as repeat purchasesGroup shipment records by the original order and use a documented completion date once the relevant purchase is complete.
- Mixing cases and individual unitsKeep pack sizes separate unless source records establish the exact conversion and item equivalence.
- Using payment dates as completion datesFind the authoritative completion or delivery event for the relevant items before calculating the interval.
- Sending reorder reminders over an active orderLook for existing same-item orders and contact history before putting the customer into a new conversation.
- Assuming a typical interval measures stock on handUse history to inform timing and let the customer confirm their remaining stock and current needs.
What a good result looks like
- Every proposed date has a current schedule or a traceable set of comparable completed purchases.
- Every quantity names the item, variant and selling unit and accounts for documented returns.
- The review shows current open orders, contact clearance and previous decisions on the same cycle.
- Drafts are limited to eligible conversations and use the actual purchase or schedule as context.
- The owner can see which population was reviewed and what evidence would resolve each held case.
And then what? Using the result
- Have account owners review eligible drafts against their latest customer conversations.
- Route active orders to the team that can confirm their status and fulfillment plans.
- Ask the record owner to resolve the specific gaps in returns, pack sizes or account identity.
- Record actual contacts, dismissals and orders with sources so the next review can use them.
- Refresh the list after new completed purchases, schedule changes or confirmed decisions.
When to run it
- Before planning account follow-upsUse supported dates and quantities to decide which conversations merit an owner's attention this week.
- After a run of split shipmentsCheck completion and returns for the affected orders before resuming routine reminders.
- When a repeat schedule changesConfirm the exact next occurrence and check for an existing order before proposing a discussion.
- When taking over another person's accountsRead the prior cycle history so customers who already responded keep their earlier disposition.
Questions people ask
How do you find customers due to reorder?
Look for a confirmed next occurrence or a supported repeat pattern in comparable completed purchases. Check open orders, contact clearance and prior follow-up before treating a candidate as ready for discussion.
How many purchases do you need to estimate a reorder window?
You need several comparable purchases on distinct dates to see whether intervals repeat. The 10folds calculation requires at least three with matching retained quantities and leaves irregular histories for review.
How do returns affect a repeat purchase report?
Documented returns reduce the units the customer kept from the relevant purchase. Use the physical return record and keep unknown quantities visible so they do not silently affect the pattern.
What if a customer already has another order in progress?
Route the case to the existing order owner and keep the order reference beside the disposition. Recheck it when the order's status changes and current records support a fresh decision.
Should you use order history or a confirmed schedule?
Use a confirmed active schedule when it specifies the next occurrence and quantity. Use comparable purchase history to suggest a conversation window where no such schedule is available.
What should a reorder reminder say?
Name the previous purchase or agreed schedule and ask whether another order would be useful. Let the customer confirm the quantity and timing where those details are open.
More jobs in E-commerce
Find customers due to reorder, on your own Mac.Free app. Runs on your Mac with the Claude or Codex plan you already have. Your files stay on your computer.
Download for Mac