← All posts

Forecasting

What one big order does to your sales rate

A wholesale buyer, an influencer post or a queue of waiting customers can put a month of sales through in one day. A plain sales rate counts that day like any other, and every order sized in the next two months inherits it.

Marcus VolstedCo-founder, Restocio Published 21 October 202612 min read

Every source on this page was opened and read, and each one is dated in the Sources section at the foot.

One large one-off order lifts your sales rate by its size divided by what you would have sold in the window anyway. A 400-unit wholesale order inside a 60-day window, on a product that does 10 a day at retail, moves the rate from 10 to 16.7 a day, two thirds high, and it stays there at full strength until the day the order falls out of the window. Nothing fades. Every quantity sized in those 60 days is two thirds too big, and on day 61 the rate is right again as if nothing had happened.

This is the overstated rate, the opposite error to the stockout loop. An empty shelf hides demand and makes a best seller look slow, which how to stop running out of stock covers and this page does not repeat. A big one-off order records demand that will not come again, so the rate reads fast and you buy for a customer who has already left. It is also a different animal from a discount week, which is a price event with its own section on the forecasting page, and from returns counted as sales, which push the rate up by a share of every day rather than in one lump. The lump is what makes this one easy to find and easy to fix, once you know what it does.

Why a plain average cannot tell one order from sixty ordinary days

A sales rate is units sold in a window divided by the days in it, or in a better calculation, by the days the product was actually on the shelf. Either way it is a plain average, and a plain average has no memory of how the units arrived. Six hundred units from 60 customers and 600 units from one customer are the same 600 to it.

So take the product at 10 a day, in stock every day of a 60-day window. Six hundred units, 10 a day. Now a wholesale buyer takes 400 in one order on any day inside those 60. The window holds 1,000 units, the divisor is still 60, and the rate reads 16.7. The overstatement is 400 divided by the 600 you would have sold anyway, two thirds, and the day the order landed makes no difference to it, because every day in the window weighs the same. An order on day 3 and an order on day 58 push the rate up by the same amount. What the date decides is how long the push lasts. The order leaves the window exactly one window length after it arrived, and it leaves in one step: on day 61 the rate goes from 16.7 back to 10.0 overnight.

The window length decides the size of the push, and only the window length. The same 400 units spread over more ordinary days are a smaller share of them.

Read it as a trade. A long window dilutes the lump and carries it for longer. A short window takes the full hit and is rid of it in a month. Neither is a correction, and there is a real cost at the long end: a window that barely notices a 400-unit order also barely notices that sales have doubled.

What the inflated rate does downstream

Follow the two rates through the numbers a purchase actually runs on. Put 900 units on the shelf and a 70-day sea journey behind this product.

The deadline is the one that bites. On the real pace you have three weeks to book the boat. On the shown pace you are 16 days late, the sea option looks gone, and whatever sizes your orders starts pricing rail or air for a shortfall that does not exist. The quantity error is quieter and dearer: 667 units more than the product needs, which at 10 a day is about two extra months of stock, bought because one customer who will not be back was counted as if they came every day. It runs the same way as the returns error, cash parked rather than sales lost, with the difference that this one arrives all at once and leaves all at once.

When the big order also emptied the shelf

There is a worse version, and it is common, because a 400-unit order on a product holding 500 leaves 100 behind. If the shelf then runs empty before the next delivery, a rate that counts only in-stock days does the right thing with the empty days and the wrong thing with the lump. Say the shelf was empty for ten of the 60 days, so the 50 days it was in stock carried 500 units of retail sales at the real pace. The divisor drops to 50, the numerator holds those 500 plus the 400, and the rate reads 900 over 50, which is 18 a day, 80 percent high instead of 67. The two errors do not cancel here. The in-stock divisor is right, the 400 is still wrong, and a smaller divisor makes a fixed lump worth more per day.

Does the order belong in the rate at all?

Only you can answer that, and the answer is not always no. The test is whether the demand will repeat at this price, because the rate's whole job is to predict next month's shelf.

The first row matters most and is the one a rate handles worst. A real wholesale account is real demand, and it is lumpy demand on a calendar, which a daily average smears across every day between orders. Planned as its own line, with a date and a quantity, it stops distorting the retail pace and stops being forgotten.

Where to find the order in Shopify

Start from the symptom. A product whose days of stock halved in a week without a price change, a campaign or a stockout has usually had one order go through it. Note the window your rate is measured over, then go to Shopify's Orders page. Shopify's page on viewing and filtering orders, read on 10 October 2026, says you can "narrow results by fulfillment status, payment status, sales channel, date range, or tagged orders" and search "using order numbers, customer names, email addresses, or product details". Set the date range to the window, search the product, and a 400-unit line is hard to miss. If your wholesale orders carry a tag or come through their own channel, filter on that instead and you have the whole list in one click. Sorting the list by units is not described on that page, so the quick route is by customer, channel or tag rather than by size.

Two things worth knowing about which orders are in the rate at all. A wholesale order you keyed in yourself is in it: Shopify's page on draft orders, read the same day, names "negotiated wholesale rates" as a use for a draft order and says that "when a draft order is paid, it becomes a regular order on your Orders page", which is the list a sales rate reads. And the report that finds a buyer rather than an order is Sales by customer name, which Shopify's sales reports page, read the same day, describes as "the breakdown of orders by customer over a period of time". Set its range to the window and the buyer who took 400 units in one go stands out.

Taking the order out by hand

Subtract the order from the units and divide by the same days. One thousand units less 400 is 600, over 60 days is 10 a day, and that is the rate to use for days of stock, the deadline and the quantity until the order leaves the window on its own. If the buyer is coming back, add their next order on top as a separate line with its own date, rather than letting the average carry it. If you would rather not touch the number, the table above says what a longer window buys you and what it costs, and a window that merely outlasts the lump is a weaker tool than a subtraction that removes it.

What Restocio does with a one-off order today

The honest part, since the rate in question is ours. Restocio's sales rate is units sold in the window divided by the days in it, less the days the shelf was recorded empty, over a window you set, 60 days by default. It is a plain average: nothing weights recent days more, nothing smooths, and nothing looks at the size of an order. The order list it reads is every order Shopify returns for the window, whatever channel it came through, a paid draft order included, and there is no filter on tags, channel or customer in that fetch. We checked for an outlier filter while writing this page. The word appears once in the engine, in a comment about the size of a cached page, and nowhere near the rate. So a 400-unit wholesale order reads exactly as the arithmetic above says, two thirds high on a 60-day window, for 60 days.

What you can do about it in the app is honest but blunt. The window is yours to set, under Settings, then Inventory, as "Sales period the pace is measured over", anywhere from 1 to 365 days and capped at the order history your shop lets us read, with a label that calls 45 days and under jumpy and 75 and over slow to notice change. It is one window for the whole catalogue, though, so lengthening it to dilute one product's lump slows every product's reaction. The quantity on each row of the Replenishment page is a box you can type over before you create the order, and that is the right tool for the two months the lump is in the window: subtract the order from the rate yourself and type the quantity you get. The box is not remembered after you leave the page, so you will do it again next time. Two things in SKU Manager look as if they might help and should not be used for this. Discontinued stops the product being recommended ever again, and Ignore this product hides it from every list and every recommendation. Both are for products, not for orders. A way to exclude one order, on one product, does not exist in the app today. There is a blunter lever one level up: Demand, then Event days, lets you mark a date as a one-off event at 0 percent, and that day's units come out of the pace for every product at once, store-wide, the same mechanism built for a Black Friday week. It removes a day, not an order, so it only fits if the lump genuinely landed on a date you are happy to zero out across the whole catalogue, not a one-SKU fix. A per-product pace you can type by hand still does not exist. If your store sells to trade buyers as a matter of course, tell us, because that is the store this page understates. Where the rate sits in the rest of the decision, deadline and quantity included, is the Shopify replenishment guide.

Common questions

Should I exclude a wholesale order from my inventory forecast?

If it will not repeat, yes. Subtract it from the units in the window and divide by the same days, and use that rate for days of stock, the deadline and the quantity. If the buyer is a regular account, still take it out of the daily rate, and plan their orders as a separate line with a date and a quantity, because a daily average smears a monthly order across every day in between.

How much does one big order change my sales velocity?

By its size divided by what you would have sold in the window without it. A 400-unit order on a product selling 10 a day is 400 over 600 in a 60-day window, so the rate reads 67 percent high, and 133 percent high on a 30-day window. The day it landed inside the window makes no difference to the size. It decides when the order drops out.

How long does a one-off order affect the reorder suggestion?

Exactly one window length, at full strength, then not at all. The order enters the average the day it is placed and leaves it one window later, in one step, so a 60-day window carries it for 60 days. Nothing fades in between, which is why a quantity sized on day 59 is as wrong as one sized on day 2.

Is this the same thing as sales velocity?

Not the one most search results mean. Shopify's blog post on sales velocity, dated 6 March 2025 and read on 10 October 2026, gives the formula as the number of opportunities times win rate times deal size, divided by the sales-cycle length, which is a sales-pipeline figure. The number a reorder runs on is units per day over the days a product was on the shelf, and that is what this page means by the rate.

Does Restocio filter out unusually large orders?

No, not automatically and not per order. The rate is a plain average over the window you set, and every order Shopify returns for that window counts, whatever its channel. There is no outlier filter and no per-product pace you can type. Demand, then Event days, lets you mark a specific date as a 0 percent event, which takes that day's units out of every product's pace at once, store-wide, so it is a bigger lever than removing one order from one product. On a single product, what you can do is set the window, and type the quantity you want on the Replenishment row before you create the order.

How do I find a large order in Shopify?

On the Orders page, set the date range to the window your rate is measured over, search for the product, and look for the line with the quantity. If wholesale orders carry a tag or come through their own sales channel, filter on that. Shopify's Sales by customer name report finds the buyer rather than the order. Set its range to the same window and the account that took 400 units in one go stands out.

Sources

Every source below was opened and read on the date shown against it. Rules, rates and schedules change, so check the current page before you act on a number that matters. If anything here is out of date or wrong, tell us and we will correct it.

• Shopify Help Center, Viewing and filtering orders (read 10 October 2026)
• Shopify Help Center, Draft orders and invoices (read 10 October 2026)
• Shopify Help Center, Sales reports (Sales by customer name) (read 10 October 2026)
• Closo, Demand & Lead Time Variance (inventory forecasting framework), updated 10 September 2026 (read 10 October 2026)
• Shopify blog, Sales Velocity: Meaning, Formula, and How to Improve, 6 March 2025 (read 10 October 2026)

Marcus Volsted

Co-founder, Restocio

Marcus co-founded Restocio and works on it daily with a Swedish importer who plans their purchasing in it every working day. Restocio is built in Sweden by two founders, one Swedish and one Danish, and Marcus is the Danish one. Why we are building it.

Related reading

• How to stop running out of stock
• Do returns count as sales in your sales rate?
• Inventory forecasting, without the mystique
• How many days of stock should you hold
• Shopify replenishment, end to end