Restock recommendations: what to order this week

Every Monday you ask yourself the same question and answer it with the same mix of arithmetic and nerves: what do I order this week? It is not a small decision. Whether your hero product is still selling in two weeks or sitting at zero exactly when buyers are looking for it depends on this one call. And the answer almost always comes out of a spreadsheet you built by hand, with numbers pulled from three different screens that were already stale by the time you pasted them.

The real problem is not that you do not know how to order. It is that to decide well you need to bring together, in one place, how much you truly have available, how fast each SKU is selling across all your channels combined, how long your supplier takes to replenish, and how long your 3PL takes to make a unit sellable. That information lives scattered across Amazon Seller Central, MercadoLibre, and your logistics operator, each with its own cutoff time. When you consolidate it by hand, you end up deciding from yesterday’s snapshot: ordering too much of what has already cooled off and too little of what is heating up.

A restock recommendation should not be a hunch dressed up as a table. It should be a clear calculation: for each SKU, how many units to order this week to cover projected demand during the replenishment lead time, plus a safety buffer, minus what you already have on the way. When that calculation runs on its own and in real time, Monday stops being a gamble and becomes a review.

why the restock decision gets harder across channels

When you sell on a single channel, restocking is almost intuitive: you see how fast it moves, you see how much you have, and you order. It breaks down when the same product is fed from the same physical stock but sells at different speeds on Amazon and MercadoLibre, and on top of that depends on a 3PL that updates in batches. Suddenly the question “how much do I order?” no longer has an obvious answer, because each channel tells you only part of the story.

Amazon Seller Central gives you its FBA sales velocity and its own restock notice, built for Amazon alone. MercadoLibre shows you the movement of each listing, completely ignoring what leaves through the other channel. Your 3PL knows the physical inventory, but it does not know how much is committed or at what rate it is consumed on each marketplace. None of them holds the number that actually matters for ordering: aggregate sell-through against total real availability.

That is why you end up in a spreadsheet. You export three reports, paste them, add the velocity by hand, subtract what you think is in transit, and out comes the number you send your supplier. It works on quiet days. But an organic spike on one channel or a campaign that accelerates sell-through on the other turns that math into a dead figure before Wednesday. The complexity is not in placing the order; it is in trusting numbers that age while you look at them.

the math behind a good recommendation

A solid restock recommendation is not magic, it is a formula with good inputs. The skeleton is always the same: projected demand during the lead time, plus safety stock, minus what you already have available and on the way. The result is the suggested quantity to order. The hard part is not the formula, it is feeding it with fresh, complete data from all your channels at once.

Projected demand starts from your combined sales velocity, not from a single channel’s. If a SKU sells eight units a day on Amazon and five on MercadoLibre, your projection works with thirteen, not eight. Lead time is the real total time from when you place the order to when the unit becomes sellable: supplier production or dispatch, transit, and 3PL processing. Safety stock is the buffer that absorbs variability, the days that sell more than usual, and it depends on how erratic that product’s demand is.

This logic is a close cousin of forecasting: if you want to understand in depth how the demand that feeds these recommendations is projected, it is worth reading inventory forecast in depth. The difference is one of purpose: the forecast tells you how much you will sell; the restock recommendation translates that forecast into a concrete purchase order for this week.

Dictionary: days of inventory estimate how long your stock will last at the current sales pace across all channels combined, and they are the first trigger for deciding whether a SKU belongs on the restock list.

what to order this week: prioritize by urgency and by impact

Not every SKU deserves the same attention on Monday. The “what to order this week” list is sorted by crossing two axes: urgency and weight in your business. Urgency is set by how many days of coverage you have left against your lead time. Weight is set by how much that product sells and how much margin it leaves. A SKU with few days of coverage and high margin sits in the red corner: order it first, no hesitation.

The common mistake is to treat the list as one uniform row. There are products that will fall short this week and, if you do not order today, will stock out before replenishment arrives; those do not allow waiting. There are others that still have a buffer and can wait until the next buying cycle, avoiding tying up extra capital. And there are decelerating products where ordering the usual amount would bury money in inventory that no longer turns the way it used to.

That is why a good recommendation is not just “order X units”: it is “order X units of these SKUs now because they cross their threshold before the lead time, and none of these others yet because they have coverage to spare”. That hierarchy protects your cash flow as much as it protects your sales. Ordering well is not ordering a lot; it is ordering the right thing, in the right quantity, at the right moment.

from the spreadsheet snapshot to a living calculation

The Monday spreadsheet has a flaw that no formatting fixes: it is born old. The moment you paste the three exports, the day’s sales are already running and do not appear in your table. If you decide on Monday afternoon with Monday morning data, you have already lost half a day of movement on each channel. For slow SKUs it does not matter; for your stars, that lag is exactly where the stockout is brewing.

The alternative is not to export more often, it is to stop exporting. When real availability, sales velocity, and orders in transit live in a single source that updates as sales happen, the restock recommendation recalculates itself. You open Monday and the list already reflects what happened over the weekend, including that strong Saturday on MercadoLibre that your spreadsheet would not have captured until Tuesday.

This shows up most in the trickiest figure: what you already ordered. A recommendation that does not subtract inventory in transit makes you order double. One that does subtract it, and knows when it arrives, tells you exactly how much you need to cover the gap between today and the next inbound. To see how these pieces connect at the level of a single product, the walkthrough in anatomy of a multichannel SKU: a case study shows how one item drags inventory, velocity, and costs across channels.

Dictionary: real availability is the inventory you can actually sell right now, after subtracting what is reserved or committed on other channels, and it is the honest starting point of any restock recommendation.

the case of a seller who orders per channel and ends up unbalanced

Think of a store like SPORTIFY, which sells its hero item on Amazon and MercadoLibre, both fed from the same 3PL. If it decides restock by looking at each channel separately, it falls into a silent trap: it orders for Amazon based on Amazon’s velocity and for MercadoLibre based on MercadoLibre’s, without seeing that both draw from the same physical pool. The total ordered can fall short of combined demand, or be unbalanced relative to what each channel truly needs.

The typical result is paradoxical: there is surplus inventory mentally assigned to one channel while the other stocks out, even though the physical unit is the same. Or it over-orders “just in case” on both, tying up capital that could have gone to a SKU that actually needed it. The cause is always the same: deciding from three partial truths instead of a single consolidated one.

When the recommendation starts from aggregate velocity and total real availability, the question stops being “how much do I order for each channel” and becomes “how much do I need in total this week so that no channel stocks out before replenishment”. Allocation between channels becomes a second step, not the basis of the decision. That way SPORTIFY orders a single, well-sized quantity and splits it afterward, instead of adding up two orders that never spoke to each other.

turning the recommendation into a healthy weekly routine

The goal is not for the system to decide for you, but to hand you on Monday a short, reliable list you can review in minutes instead of building in hours. The healthy routine starts by trusting that availability, velocity, and what is in transit are already consolidated and fresh; that takes the mechanical part off your plate and leaves you the judgment part.

On that base, your work narrows to three moves: review the SKUs that cross their threshold before the lead time and approve their order, adjust the safety stock of the most volatile products if a season warrants it, and consciously defer what still has coverage so you do not tie up capital. Each product’s healthy margin matters here too: it is worth pushing the restock of what leaves good profit ahead of what barely holds.

Dictionary: real net margin is what you actually keep per unit after fees, commissions, logistics, and returns, and it is the compass for deciding which SKU gets restock money first.

Seen this way, “what to order this week” stops being the anxious Monday question and becomes an informed decision you make in five minutes. Not because you order less often, but because you stop ordering blind. The difference between a restock that protects your sales and one that buries your cash flow almost never lies in the supplier or the price: it lies in whether the calculation behind the order was alive and complete, or dead and split across three screens.