A practical, unhurried companion for Shopify merchants who want to make confident inventory decisions — without the stress, the spreadsheets, or the Sunday-night panic.
You don't need to be an inventory expert to run a great store. You need a calm system, a clear framework, and the confidence to act on what actually matters — not everything at once.
Inventory management has a reputation for being complicated. And honestly, it can be. But the complexity usually isn't in the concepts themselves — it's in the chaos that builds up when there's no system. When you're reacting instead of planning. When everything feels equally urgent, so nothing gets done well.
This guide is designed to change that feeling. We're going to walk through the fundamentals of inventory management in plain language, with real examples and practical worksheets you can fill in as you go. By the time you finish, you'll have a personal inventory playbook built around your store — not a generic template.
A few things this book is not: it's not a scare tactic, it's not full of jargon, and it won't tell you everything you're doing wrong. It will, however, offer better ways to do things — and give you the space to implement them at your own pace.
Each chapter ends with a worksheet. You can fill these in digitally right here in the browser (your answers save automatically), or print the whole guide and work through it with a pen. Both approaches are fully supported.
Work through each chapter in order on your first pass. After that, treat it as a reference — return to any chapter or worksheet whenever you need a reset. The Weekly Review sheet at the end is designed to become part of your regular routine, not a one-time exercise.
Let's begin.
Before we talk about solutions, it helps to name the actual problem. Most inventory stress doesn't come from having too many products or too complex a catalog — it comes from three specific patterns. Once you can see them, they're much easier to break.
Spend enough time talking with Shopify merchants — from stores doing $50K a year to stores doing $5M — and you'll hear the same frustrations. The names change. The product categories change. But the underlying problems almost always come back to three things.
Reactive inventory management means you respond to problems after they've already happened. You run out of stock and then scramble to reorder. You notice a product sitting for months and then try to discount it out. You check stock counts when a customer asks about something, not on a regular schedule.
This pattern isn't laziness — it's the natural result of not having a proactive system in place. When there's no scheduled review, no early-warning alerts, and no forecasting, reaction is the only option available to you.
The cost: Stockouts you could have prevented. Lost sales. Customers who went elsewhere and didn't come back. And the particular stress of urgency — making important decisions under pressure, with incomplete information.
Here's something counterintuitive: one of the biggest inventory management mistakes isn't neglecting problems — it's spending equal energy on all of them. When you log into your store and see 15 things that might need attention, and you don't have a way to know which three actually matter right now, one of two things happens.
Either you try to handle everything at once (exhausting, and still incomplete), or you handle whatever feels most visible (arbitrary, and often wrong). Neither approach serves your store well.
The cost: Time and mental energy spent on low-urgency issues while high-urgency ones wait. Decision fatigue. The sense that you're always working but never quite on top of things.
Inventory is money in physical form. Every unit sitting on your shelf represents dollars that could be elsewhere — in marketing, in payroll, in new product development. When you think of inventory purely as a logistics problem rather than a cash flow decision, you make ordering choices that look fine on the surface but quietly drain your working capital.
Overstocking a slow-moving SKU feels safe. Understocking a fast-moving one feels like a minor miss. But over months, these patterns compound into cash flow problems that are genuinely hard to reverse.
The cost: Capital locked in low-turnover inventory. Missed growth opportunities. The frustrating experience of being "profitable" on paper while constantly feeling short on cash.
"The goal isn't to manage every SKU perfectly. It's to manage the right SKUs at the right time — and have a system that tells you which ones those are."
Here's the reframe that underlies everything in this guide: inventory management is not about having perfect information. It's about having a good enough system that surfaces the right priorities at the right time, so you can make confident decisions without needing to know everything.
A well-run inventory system shouldn't demand your attention every hour. It should be like a good smoke alarm — quiet when everything is fine, and clearly audible when something actually needs your attention. The rest of this guide is about building that kind of system.
When you log in to InventoryIQ, the first thing you see isn't a list of 200 SKUs. It's three specific issues your store needs you to address right now — ranked by urgency, with context on why each one matters. This design comes directly from the three root causes above. Not everything needs your attention today. The system tells you what does. Try it free for 30 days →
Use this worksheet to honestly assess where your current inventory pain points come from. There are no wrong answers — this is a baseline, not a grade.
| Situation | Never | Sometimes | Often | Always |
|---|---|---|---|---|
| I discover I'm out of stock only when a customer mentions it | ||||
| I place reorders based on gut feel rather than data | ||||
| I feel overwhelmed when I look at my inventory dashboard | ||||
| I have products sitting unsold for more than 90 days | ||||
| I feel like I'm always short on working capital |
The single biggest shift in how successful merchants manage inventory is this: they've stopped trying to manage everything equally. They've built a system that tells them what needs attention today, what can wait until next week, and what's fine for now.
Every inventory issue your store faces falls into one of three tiers. Learning to classify issues quickly — and respond proportionally — is the foundation of calm inventory management.
The Priority Framework works best when it's baked into your regular routine rather than applied ad hoc. Here's how to use it practically.
Each morning (2 minutes): Check for any Priority 1 situations. If something has crossed into "imminent stockout" territory overnight, that's your first task. If nothing has, move on to your actual work.
Each week (20 minutes): The Weekly Review (detailed in its own section) surfaces Priority 2 items — things that need attention before they become urgent. This is where most of your inventory decision-making happens.
Each month (30–45 minutes): A slower review of Priority 3 items. Slow movers, overstock, supplier relationships. This is strategic rather than operational.
One pattern worth naming explicitly: the tendency to treat Priority 2 and 3 items as Priority 1 when you're stressed. When inventory management feels overwhelming, everything can start to feel equally urgent. The antidote is the framework itself — trusting the classification system to tell you what actually needs your attention, even when anxiety is suggesting otherwise.
A product with 60 days of stock left and a 14-day lead time is a Priority 3 item. It doesn't need your attention today. A product with 12 days of stock left and a 14-day lead time is Priority 1. It needs your attention right now.
The math, not the feeling, determines the tier.
One of the most practical things AI can do in inventory management is this exact classification work — continuously calculating which products need attention, in what order, based on current stock levels, sales velocity, and lead times. When InventoryIQ shows you your top 3 priorities each time you log in, this is the Priority Framework at work. The AI does the triage; you make the decisions.
It's worth personalizing the Priority Framework for your specific situation. A product that's Priority 1 for a store doing 200 units/day might be Priority 2 for a store doing 20 units/month. The tiers are relative to your velocity, your lead times, and your customers' tolerance for waiting.
The worksheet for this chapter will help you define what each priority tier looks like specifically for your store.
Define what each priority tier means for your specific store. This becomes your personal classification system — the lens through which you evaluate every inventory situation.
| Priority Level | Days of Stock Remaining | Supplier Lead Time | Your Action |
|---|---|---|---|
| Priority 1 · Act Today | |||
| Priority 2 · Act This Week | |||
| Priority 3 · Monitor |
List up to 3 products that are currently (or recently were) at Priority 1 urgency.
| Product / SKU | Current Stock | Daily Sales Rate | Lead Time | Status |
|---|---|---|---|---|
The reorder point is the single most important number in inventory management. Get it right for every SKU and you'll never be caught off guard by a stockout. Get it wrong and you'll spend your working life in reactive mode. Here's how to get it right.
A reorder point (ROP) is the inventory level at which you need to place a new order so that new stock arrives before you run out. It's not the level at which you want to order — it's the level at which you must order to avoid a gap in availability.
Reorder points are the backbone of proactive inventory management. When your system knows a product's reorder point, it can alert you the moment stock drops to that level — giving you time to act before a problem develops.
Let's say you sell a candle that moves 5 units per day on average. Your supplier takes 14 days to deliver. You'd like a 7-day buffer for peace of mind.
ROP = (5 × 14) + (5 × 7) = 70 + 35 = 105 units
When your candle stock drops to 105 units, that's your signal to place an order. If you order that day, your new stock will arrive just as your current stock runs out — with a 7-day buffer to spare.
Safety stock is the cushion between "we should be fine" and "we definitely won't run out." It accounts for two types of variability that make inventory planning imperfect in the real world.
Demand variability: Some days you'll sell more than your average. A viral social post, a feature in a gift guide, a sudden trend — demand isn't perfectly predictable. Safety stock protects you when sales spike unexpectedly.
Supply variability: Suppliers don't always deliver on schedule. A container ship runs late. A factory has a quality issue. A supplier runs out of materials. Safety stock protects you when your lead time extends unexpectedly.
Mistake 1: Setting them once and never updating. Your sales velocity changes with seasons, trends, and promotions. A reorder point that was correct in January may be dangerously low in October. Reorder points should be reviewed at least quarterly, and ideally updated automatically when your velocity changes significantly.
Mistake 2: Using the same buffer for every product. Not all products carry the same risk. A product with an unreliable supplier needs more safety stock than one with a supplier who consistently ships in 5 days. A bestseller that drives 40% of your revenue deserves more buffer than a slow mover. Customize your safety stock by product and supplier, not by feel.
Manually calculating and updating reorder points for 50, 100, or 500 SKUs isn't practical. This is where AI-powered inventory management genuinely earns its place. InventoryIQ continuously recalculates reorder points for every SKU using your actual sales velocity — not last month's average, but your real current rate — combined with your supplier's lead times. When the math changes, the reorder point updates automatically. You get the right number, always current, without doing the math yourself.
Use this worksheet to calculate reorder points for your top 5 products. Once you've done these manually, you'll understand exactly what your inventory system should be doing automatically for every SKU.
| Product / SKU | Avg Daily Sales | Lead Time (days) | Safety Stock (days) | Safety Stock (units) | Your ROP |
|---|---|---|---|---|---|
Safety Stock (units) and ROP calculate automatically when you fill in the other fields.
Every unit you order is a dollar deployed. The question isn't just "do I have enough stock?" — it's "am I deploying my inventory capital in the places that generate the best return?" This shift in thinking changes everything about how you manage a store.
Overstock is easy to justify in the moment. Bulk discounts feel like savings. "Just in case" feels like prudence. But overstock has real, measurable costs that most merchants don't track.
Capital cost: Every dollar sitting in excess inventory is a dollar not available for marketing, product development, payroll, or any other use. If you have $20,000 in slow-moving inventory that could have been $20,000 in ads, the opportunity cost is real — even if it doesn't show up as a line item anywhere.
Storage cost: Whether you pay for a warehouse or use your own space, excess inventory takes up room that has a cost. For Amazon FBA sellers, this is particularly visible: monthly storage fees compound quickly on slow-moving products.
Obsolescence risk: Products can become outdated, discontinued, or out of season. Every month of excess inventory is another month of exposure to becoming unsellable.
Understock is easier to feel — a sale you missed, a customer who went elsewhere. But its full cost is often underestimated.
Lost revenue: The direct cost of a sale you couldn't fulfill. For products with high margin, even a few days of stockout can be significant.
Customer lifetime value: A customer who finds your product out of stock often doesn't come back. The cost isn't just the single missed sale — it's the relationship that didn't form.
Search ranking: For Amazon sellers especially, stockouts damage algorithmic ranking. Rebuilding that rank requires advertising spend. So the cost of a stockout extends beyond the duration of the stockout itself.
"The best inventory decision isn't the one that has the most stock. It's the one that has the right stock — enough to serve demand without tying up capital unnecessarily."
Inventory turnover measures how many times your inventory "cycles" in a given period. A product that sells through its full stock 12 times a year has a turnover rate of 12. A product that only sells through once has a turnover rate of 1.
Higher turnover generally means better capital efficiency — you're converting inventory to revenue faster. But the "right" turnover rate varies by category, margin, and business model. The goal isn't to maximize turnover at all costs — it's to understand it and optimize accordingly.
Every store has them: products that sounded like a good idea, or used to sell well, but now move at a trickle. Slow movers are often ignored because they feel like small problems — but collectively, they can represent tens of thousands of dollars in locked-up capital.
A monthly slow-mover review should be part of every merchant's routine. Products sitting for 90+ days without meaningful movement deserve a deliberate decision: promote, discount, bundle, or discontinue. "Let it sit and hope" is not a strategy.
InventoryIQ includes cashflow and ROI projections for each SKU, so you can see which products are generating the best return on your inventory investment — and which are quietly draining capital. Before you place your next bulk order, it helps to know whether that product earns its shelf space. Explore the free trial →
A straightforward audit of where your inventory capital is currently deployed — and where it's working hardest for your store.
List your top 5 slowest-moving products. Be honest — these are the ones you've been avoiding thinking about.
| Product / SKU | Units in Stock | Est. Cost Value ($) | Last Sale | Action Plan |
|---|---|---|---|---|
List your 3 highest-turnover products — the ones converting inventory to revenue fastest.
| Product / SKU | Units Sold (period) | Avg Units Held | Est. Turnover Rate | Notes |
|---|---|---|---|---|
Your inventory system is only as reliable as the information feeding it. And no piece of information matters more than your supplier lead times — how long it actually takes from placing an order to having product ready to sell.
Most merchants think of lead time as "how long my supplier takes to ship." But the real lead time — the number that should drive your reorder calculations — is the total time from placing an order to having inventory ready to sell to customers.
For a Shopify merchant shipping from their own location, the real lead time might be: supplier processing time + shipping transit time + your receiving and processing time.
For an Amazon FBA seller, add: shipping from your location to FBA + FBA receiving time (which can be 2–7 days, sometimes more during peak periods).
If your supplier says "14 days," your real lead time might be 21–28 days once all steps are accounted for. Using the shorter number in your reorder calculations means you're consistently ordering too late.
It's tempting to optimize supplier relationships primarily around price. But for inventory management, lead time consistency is often more valuable than saving a few percent per unit.
A supplier who quotes 14 days and consistently delivers in 12–15 days is far more valuable to your inventory planning than one who quotes 14 days but delivers anywhere from 10 to 25 days. The variability in the second scenario means you need dramatically more safety stock to cover the uncertainty — which costs more than the price difference.
Keep a simple log of every order: when you placed it, when it was promised, and when it actually arrived. After 5–10 orders, you'll have a clear picture of each supplier's actual reliability. This data should inform your safety stock levels — unreliable suppliers need larger buffers. Reliable ones can operate on leaner safety stock, freeing up capital.
The best inventory outcomes come from genuine partnerships with suppliers, not purely transactional relationships. A supplier who knows your business, understands your seasonal patterns, and has a relationship with you is more likely to prioritize your orders, give you advance notice of delays, and offer flexibility when you need it.
A few practices that build strong supplier relationships: communicate clearly and promptly, pay on time, give advance notice when you anticipate large orders (especially around seasonal peaks), and don't treat every delay as a crisis that requires an angry email.
Good supplier documentation makes your inventory system dramatically more reliable. At a minimum, document: contact name and email, typical lead time in days, realistic lead time range (best to worst case), minimum order quantities, payment terms, and any known reliability patterns (strong in certain seasons, slow during Chinese New Year, etc.).
This documentation becomes the foundation of your reorder calculations — and makes onboarding any new team member or inventory system much faster.
Document your key suppliers in one place. This becomes your inventory system's foundation — every reorder point calculation depends on accurate lead time data.
Complete one row per active supplier. Be realistic about lead times — use your actual experience, not their quoted estimate.
| Supplier Name | Contact Email | Quoted Lead (days) | Actual Lead (days) | MOQ | Reliability (1–5) | Notes |
|---|---|---|---|---|---|---|
You don't need to predict the future perfectly. You need to be more right than wrong, more often, with the information you actually have. Good demand forecasting is about pattern recognition, not prophecy.
Demand forecasting has a reputation for being complicated — the kind of thing that requires data scientists and expensive software. And at large scale, that complexity is real. But for most Shopify merchants, the foundations of useful forecasting are simpler than you might expect.
At its core, forecasting asks: based on what we know about this product's past performance, what should we expect going forward — accounting for seasonal patterns, any planned promotions, and current trends?
That's a question any merchant can meaningfully engage with, even without a data science degree.
Your most reliable predictor of future demand is past demand. How many units did this product sell per day, on average, over the last 30, 60, and 90 days? These three windows give you both a current snapshot and a longer trend to compare against.
If your 30-day average is significantly higher than your 90-day average, demand is accelerating. If it's lower, demand may be softening. Both signals are useful for forecasting.
Most products have some seasonality — even if it's subtle. Look at the same period in previous years. Did demand spike? Soften? When? Understanding your seasonal calendar lets you pre-position inventory before demand arrives, rather than scrambling to restock in the middle of a peak.
Promotions, product launches, influencer features, gift guides, email campaigns — any planned event that will drive unusual demand should be factored into your forecast. These are the moments when your default sales velocity is not the right input for your ordering calculations.
Is your product category growing or softening? Is there a trend on TikTok or Pinterest that might accelerate demand? Is a competitor going out of stock? External context isn't the most reliable input, but it's worth considering alongside your own data.
Take your average daily sales over the past 30 days. Multiply by 1.2 for a modest seasonal uplift, 1.5 for a moderate uplift (strong season or promotion), or 2.0 for a significant event. Use that adjusted number as your demand input for the relevant period. It won't be perfect — but it will be better than ignoring seasonality entirely, which is what most merchants do.
Manual forecasting is better than no forecasting. But AI-powered forecasting is better than manual forecasting in almost every scenario, because it can analyze patterns in your data that are too subtle for human recognition — trends within trends, micro-seasonal variations, correlations between products — and update forecasts continuously as new sales data comes in.
For a merchant with 50+ SKUs, manually maintaining up-to-date forecasts for each product isn't realistic. For an AI system, it's straightforward. This is one of the clearest places where the right tool pays for itself many times over.
Map out the demand patterns for your store across the year. This becomes your planning calendar — the document you reference before placing every major order.
| Month | Expected Demand Level | Key Events / Reason | Pre-Stock By |
|---|---|---|---|
| January | |||
| February | |||
| March | |||
| April | |||
| May | |||
| June | |||
| July | |||
| August | |||
| September | |||
| October | |||
| November | |||
| December |
Whether you have two Shopify locations, a warehouse and a retail store, or a Shopify store plus an Amazon FBA operation — managing inventory across multiple locations adds real complexity. The good news is that the principles are the same; it's the visibility that makes the difference.
In a single-location business, inventory management has one question to answer: do I have enough product to fulfill demand? In a multi-location business, that question multiplies: do I have enough product at the right location to fulfill demand from the right customers?
Stock sitting in the wrong place is almost as problematic as no stock at all. A product overstocked at your warehouse while your retail location runs out is a visible failure of inventory positioning — and it's surprisingly common.
The ability to transfer stock between locations — from warehouse to retail, from high-inventory location to low-inventory location — is an underused lever in multi-location inventory management. A well-timed transfer can prevent a stockout at one location without requiring a new order, which is faster and cheaper when the product already exists in your system.
For transfers to work well, you need real-time visibility into stock levels at every location. This is the fundamental capability that makes multi-location inventory management tractable.
Many Shopify merchants also sell on Amazon — and managing inventory across both platforms is one of the most common sources of inventory stress. Each platform has its own inventory system, its own demand patterns, and its own timing requirements. Without a unified view, it's easy to over-commit to one channel and under-serve the other.
The goal for two-channel sellers is simple to state and harder to execute: a single view of all inventory across all channels, with demand forecasting and reorder recommendations that account for both. When that's in place, you're not managing two businesses separately — you're managing one inventory across two sales channels.
InventoryIQ provides a unified view of inventory across all your Shopify locations and your Amazon Seller Central account. Location-specific reorder recommendations ensure you're ordering for the right place — not just the right total quantity. The Priority Framework applies per location, so a Priority 1 stockout at your retail store shows up as such, even if your warehouse has plenty in stock.
Map your locations, channels, and inventory flows. Even if you currently have just one location, this worksheet helps you plan for future growth.
| Location / Channel | Type | Products Held | Primary Purpose | Biggest Challenge |
|---|---|---|---|---|
All the frameworks in this guide are most useful when they're part of a regular practice. The Weekly Inventory Review is that practice — a structured 20 minutes each Monday morning that keeps your store running smoothly all week, without requiring constant attention the rest of the time.
The principle behind the Weekly Review is simple: if you spend 20 focused minutes each Monday looking at the right things, you'll rarely be surprised by inventory problems the rest of the week. The problems you would have discovered on Thursday — too late to solve easily — get surfaced on Monday, when you still have time to act calmly.
The review is structured in four zones, each with a specific focus. Work through them in order. Don't let any zone expand to fill more time than it needs — the goal is disciplined, efficient coverage, not exhaustive analysis.
Zone 4 deliberately limits you to one slow mover. This might feel artificially restrictive — shouldn't you review all of them? But the research on habit formation is clear: small, consistent actions outperform large occasional ones. By reviewing one slow mover every Monday, you'll have reviewed 52 products over a year — far more than most merchants address in irregular slow-mover purges.
The discipline of one also prevents the review from becoming a multi-hour session that you avoid because it feels too heavy. Twenty minutes, every Monday. That's the practice.
Block the time in your calendar as a recurring event. Put it before you answer emails or check social media — treat it as the first real task of your week. Keep your Weekly Review Sheet (below) open during the review so you're capturing decisions, not just making them. And resist the temptation to "fix" everything during the review — identify it, note it, and then act separately. The review is diagnostic, not operational.
| # | Product / Issue | Priority Level | Action Required | By When | Done? |
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 |
| Product / SKU | Current Stock | Reorder Point | Order Qty | Supplier | PO Sent? |
|---|---|---|---|---|---|
| PO / Order # | Supplier | Ordered Date | Expected Arrival | Status / Notes |
|---|---|---|---|---|
Shopify announced that Stocky will be discontinued on August 31, 2026. If Stocky has been part of your inventory workflow, this section will help you understand what that means — and what to do about it — without any unnecessary stress.
Stocky provided several capabilities that Shopify's base admin doesn't include: demand forecasting, reorder point recommendations, purchase order management, and supplier tracking. If you used any of these features, you'll want to ensure your replacement tool covers them before the August deadline.
Take a moment to honestly assess which Stocky features were part of your regular workflow. Not everyone used all of them — and knowing what you actually relied on makes choosing a replacement straightforward.
Any replacement for Stocky should cover the core workflow: knowing when to reorder, generating purchase orders, and tracking stock across your locations. Beyond that, there are a few things worth looking for that Stocky didn't offer.
No POS Pro requirement. Stocky required a Shopify POS Pro subscription ($89/month) to access its features. A good replacement works independently of your POS setup — you shouldn't pay for retail infrastructure you don't use just to unlock inventory planning.
AI-powered recommendations. Static reorder points that you set manually and never update are better than nothing — but they're not much better. A tool that continuously recalculates recommendations based on your actual current sales velocity is meaningfully more valuable.
Amazon support. If you sell on Amazon as well as Shopify, a replacement that covers both channels is dramatically more useful than one that only sees half your business.
InventoryIQ covers every Stocky feature — reorder recommendations, purchase orders, supplier tracking, multi-location inventory — and adds AI-powered demand forecasting, cashflow and ROI projections, and Amazon Seller Central support. It doesn't require POS Pro, and it's available on the Shopify App Store with a 30-day free trial, no credit card needed. If you're looking for a calm, well-designed replacement before the August deadline, it's worth a look. Start your free trial at ecominventoryiq.com →
You don't need to rush. But you do need to act before the summer gets busy and the deadline creeps up. Here's a calm sequence for making the transition smoothly.
The full migration checklist — with detailed instructions for each step — is available as a separate document at ecominventoryiq.com.
You won't read this guide once and have a perfect inventory system by Friday. That's not how it works — and that's not what we're aiming for. What you can have by the end of this week is a clearer understanding of where your current system has gaps, a set of worksheets that have given you real data about your store, and a Weekly Review practice that starts putting you in proactive rather than reactive mode.
That's already a significant shift. The rest follows from there.
Return to this guide whenever you need a reset. The worksheets can be redone quarterly to reflect how your store has grown. The Weekly Review sheet is designed to be used every single week. The frameworks — Priority, Reorder Points, Cash Flow — are tools you'll reach for throughout your life as a merchant.
The goal was never to add more to your plate. It was to help you spend less time on inventory — and more time on the things that made you want to run a store in the first place.
"A calm merchant is a better decision-maker. And a better decision-maker runs a better store."
InventoryIQ · The smarter inventory tool for Shopify and Amazon sellers.
30-day free trial · No credit card · No POS Pro required
ecominventoryiq.com