Ecommerce Inventory Management 101

Everything you need to know about tracking and managing stock for your online store. Start here.

What is ecommerce inventory management?

Inventory management is the process of tracking what products you have, where they are, how many you have, and making sure you always have enough to fulfill customer orders without having too much sitting in a warehouse costing you money.

For a physical store, this used to mean someone walking the aisles with a clipboard. For an ecommerce store, it means knowing in real time how many units of each product are available to sell across every sales channel you use.

If you sell on one platform with 20 products, inventory management might feel unnecessary. But as soon as you start selling on two platforms, or you start doing real volume, or you add product variations like sizes and colors, a bad inventory system will cost you money, customers, and reviews.

Good inventory management means:

Why inventory management makes or breaks your store

Poor inventory management is one of the top reasons ecommerce businesses fail or stagnate. Here's what goes wrong when sellers ignore it:

Overselling damages your reputation

When you sell something you don't have, you have to cancel the order. That cancellation shows up in your seller metrics on every marketplace. On Amazon, too many cancellations get your account flagged. On Etsy, a high cancellation rate tanks your Star Seller status and search ranking. On eBay, it directly lowers your seller level. One oversell creates a ripple effect that can hurt your business for months.

Stockouts mean lost revenue

Running out of a product that customers want to buy means you're leaving money on the table. Worse, the customer finds the item on a competitor's listing and might never come back. If you're running paid ads to a product that's out of stock, you're spending money sending people to a dead end.

Cash tied up in overstock

The flip side of stockouts is overstock. Buying too much of a product that doesn't sell means your cash is frozen. If that product is large or heavy, you're also paying storage fees. Proper inventory management helps you order the right quantities at the right time.

Real numbers

According to IHL Group, retailers lose $1.75 trillion annually due to overstocks, stockouts, and returns caused by poor inventory data. For small sellers, the percentage impact is even higher because there's no buffer to absorb the losses.

Core concepts every seller needs to know

SKU (Stock Keeping Unit)

A SKU is a unique identifier you assign to each distinct product or product variant. "Blue t-shirt, size medium" and "blue t-shirt, size large" are two different SKUs. SKUs are how inventory systems know what's what. If you sell on multiple platforms, using consistent SKUs across all of them makes syncing and tracking dramatically easier. See our guide on how to match SKUs across different platforms for a naming strategy.

Reorder point

The reorder point is the inventory level at which you need to place a new order with your supplier. It's calculated based on how fast you sell the product and how long it takes to restock. If you sell 10 units per week and your supplier takes 2 weeks to ship, your reorder point is 20 units. When stock drops to 20, you order more.

Safety stock

Safety stock is extra inventory you keep as a buffer against unexpected demand spikes or supplier delays. If your reorder point is 20 units, you might keep an additional 10 units of safety stock so you're never caught empty during a busy period or a supplier delay.

COGS (Cost of Goods Sold)

COGS is what you paid for the products you sold. Proper inventory management ties directly to COGS tracking. If you don't know what each unit cost you, you can't accurately calculate profit margins. This becomes especially important at tax time and when making decisions about which products to keep selling.

Inventory turnover

Inventory turnover is how many times you sell through your entire inventory in a given period. A high turnover rate means products are selling quickly. A low turnover rate means products are sitting too long. Most ecommerce businesses aim for 4 to 8 turns per year depending on the product category.

Signs of good inventory management

  • Near-zero order cancellations
  • Products rarely go out of stock unexpectedly
  • You know your margins on every product
  • Reorders happen before you run out
  • No dead stock sitting unsold for months

Signs of bad inventory management

  • Regularly canceling orders you can't fulfill
  • Discovering you're out of stock after a sale
  • Boxes of product you forgot you had
  • Guessing reorder quantities by gut feel
  • Different stock counts on different platforms

Inventory tracking methods: from spreadsheets to software

There's no one-size-fits-all method. Your best option depends on how many products you have, how many channels you sell on, and how fast your inventory moves.

Method 1: Manual tracking with pen and paper

For a seller with fewer than 10 products selling a few times per week, a simple notebook works. After each sale, subtract from your count. After each restock, add. This breaks down immediately when you have more products, more channels, or faster sales velocity.

Method 2: Spreadsheet (Excel or Google Sheets)

A spreadsheet is the most common starting point. Create columns for SKU, product name, current quantity, cost per unit, and reorder point. After each sale, update the quantity. Google Sheets lets multiple people update it simultaneously and is accessible from your phone.

The limitation: you're still updating it manually, which means there's always a lag. A sale happens, and until you update the sheet, your real inventory and your recorded inventory are out of sync.

Method 3: Platform-native inventory tools

Shopify, WooCommerce, and most marketplaces have built-in inventory tracking. They'll count down automatically when orders come in and alert you when stock is low. This works well for single-channel sellers but falls apart when you're selling the same product on multiple platforms. each platform only knows about its own sales.

Method 4: Dedicated inventory management software

Tools like Commerce Kitty are built specifically for multi-channel inventory. When an order comes in from any connected platform, stock levels update everywhere simultaneously. You get one view of your inventory regardless of how many platforms you sell on.

Method Best for Multi-channel? Cost
Pen & paper1–10 products, slow sales NoFree
Spreadsheet10–100 products, one channel ManualFree
Platform toolsSingle-channel sellers NoIncluded
Dedicated softwareMulti-channel, growing volume YesFree plan available

Inventory management for multi-channel sellers

Selling on one platform is straightforward. Selling on two or more is where inventory management gets complicated and where most sellers run into problems.

Here's the scenario that breaks manual systems: You have 5 units of a product listed on both Amazon and eBay. Three sell on Amazon in quick succession. You update Amazon's inventory. But eBay still shows 5 available. A buyer on eBay orders 4 units. You now have 2 units but 4 pending eBay orders. Someone is getting a cancellation.

The only reliable solution for multi-channel selling is a central inventory system that all platforms read from and write to. When a sale happens on any channel, the shared count updates and all other channels reflect the new number within seconds.

Read our detailed guide on how to track inventory across multiple platforms for a step-by-step setup guide. If you're considering adding more sales channels, see the benefits of selling on multiple platforms for why the extra complexity is worth it.

Which platforms need synced inventory?

Any platform where you list the same physical product counts. This includes:

Digital products, print-on-demand items, and dropshipped goods where the supplier manages stock have different considerations. but physical inventory you hold yourself needs syncing across every channel where it's listed.

6 beginner mistakes and how to avoid them

1

No SKUs at all

Listing products without SKUs means you're tracking everything by product name. Names are ambiguous (is "Blue Mug" the same as "Blue Coffee Mug"?). SKUs are exact. Add them from the start, even if you think you don't need them yet.

2

Treating variations as one product

If you sell a shirt in four sizes, each size is a separate inventory item. Tracking the shirt as a single product with a total quantity of 20 tells you nothing about whether you're out of size small. Track at the variation level from day one.

3

Ignoring returns in inventory counts

When a customer returns a product, you need a process to inspect it and either add it back to available inventory or write it off. Many sellers forget returns entirely and end up with phantom inventory. items that show as available but don't actually exist in sellable condition.

4

No reorder alerts

Relying on memory to know when to reorder is how you end up discovering you're out of stock after a sale. Every product should have a documented reorder point. Set alerts in your inventory system to notify you when stock drops below that level.

5

Waiting too long to upgrade your system

Sellers outgrow their inventory system and keep using it anyway because switching feels disruptive. By the time the pain is unbearable, they've already lost revenue to overselling and stockouts. Upgrade before you need to, not after.

6

Not doing periodic physical counts

Even the best software can drift from reality over time due to damaged goods, lost items, or data entry errors. Do a physical count of your inventory at least quarterly and reconcile it against your records. Discrepancies reveal problems before they become costly.

Ready to go deeper? See our guides on tracking inventory across multiple platforms and the complete guide to selling on multiple platforms.

Put your inventory management on autopilot

Commerce Kitty syncs your stock across every channel automatically. Free to start, no credit card required.

Start Free
Free plan included No credit card required Set up in 5 minutes