Ecommerce Inventory Spreadsheet Template (Free Download)

Spreadsheets aren't the enemy of inventory management.

Bad spreadsheets are. The kind thrown together in 10 minutes with no structure, no formulas, and no conventions — then shared across a team who each edit it differently. Those spreadsheets create more problems than they solve. But a well-structured inventory spreadsheet is a legitimate tool for managing up to 1,000 SKUs across multiple channels. According to a Wasp Barcode Technologies survey, 43% of small businesses still track inventory manually or don't track it at all. A structured spreadsheet is a massive upgrade from either.

This guide walks through how to build an ecommerce inventory spreadsheet template that actually works — with the right columns, formulas, and structure for multi-channel sellers on Shopify, Shopee, Lazada, and TikTok Shop. No paid tools required.

What Should an Ecommerce Inventory Spreadsheet Track?

An effective ecommerce inventory spreadsheet tracks five data categories: product identification, cost data, stock levels, reorder triggers, and channel allocation. Businesses that track all five categories experience 65% fewer stockouts than those tracking only stock levels, according to inventory management benchmarks from TradeGecko (now QuickBooks Commerce).

Most inventory spreadsheets fail because they only track one thing — how many units you have. That's necessary but insufficient. You also need to know what it costs, when to reorder, where stock is allocated, and how fast it's moving.

The Five Data Categories

A spreadsheet that covers all five categories replaces the need for inventory software until you're managing over 1,000 active SKUs or selling more than 500 orders per day. Below those thresholds, the discipline of maintaining the spreadsheet teaches you more about your inventory than any software dashboard.

How Do You Structure the Main Inventory Sheet?

The main inventory sheet is one row per SKU (not per product) with columns organized from identification to action triggers reading left to right. Teams using a structured spreadsheet with formula-based reorder alerts reduce stockout frequency by 50% compared to teams checking inventory manually, according to inventory management data from Cin7.

Column Structure

Here's every column your main inventory sheet needs:

Key Formulas

Available Quantity (Column K):

=I2-J2

Daily Sales Rate (Column N): If you track sales in a separate sheet, reference the last 30 days:

=SUMPRODUCT((SalesSheet!A:A=A2)*(SalesSheet!B:B>=TODAY()-30)*(SalesSheet!C:C))/30

Days of Supply (Column O):

=IF(N2>0, K2/N2, 999)

The IF prevents division by zero for SKUs with no recent sales.

Reorder Point (Column Q):

=(N2*M2)+P2

This means: order when available stock drops below (daily sales x lead time) + safety stock.

Status (Column S):

=IF(K2<=0, "STOCKOUT", IF(K2<=Q2, "REORDER", IF(O2>90, "OVERSTOCK", "OK")))

Color-code this column: Red for STOCKOUT, Orange for REORDER, Green for OK, Blue for OVERSTOCK.

How Do You Track Multi-Channel Stock Allocation?

Multi-channel stock allocation prevents the overselling problem that plagues sellers on 3+ marketplaces. Without channel allocation, a product showing 50 units on Shopify, 50 on Shopee, and 50 on Lazada looks like 150 units of demand coverage — but you only have 50 actual units. Teams using allocation-based inventory management reduce overselling by 80%.

The Channel Allocation Sheet

Create a second tab that breaks down available stock by channel:

Rules for allocation:

• Total channel allocations + buffer must equal total available
• Buffer (5-10% of total) is never listed on any channel — it covers sync delays
• Allocate proportionally to each channel's sales velocity
• Reallocate weekly based on actual sales performance

Allocation formula:

Channel Allocation = (Total Available - Buffer) x (Channel Sales % of Total Sales)

If Shopee SG generates 35% of your sales, it gets 35% of available stock (minus buffer).

When to Reallocate

Review allocations weekly. Signs you need to reallocate:

• One channel's allocation is nearly depleted while another has excess
• A channel's sales velocity has changed significantly (campaign, seasonal shift)
• You've received new stock that needs to be distributed
• A marketplace campaign is approaching and needs extra allocation

For a deeper dive into multi-channel inventory management, see the marketplace inventory management guide.

How strong are your ecommerce operations? Score your ops in 2 minutes — Take the free scorecard. No signup required.

How Do You Calculate Reorder Points Correctly?

Reorder points are the most important formula in your inventory spreadsheet — they determine when you order more stock and directly control whether you stockout or overstock. A study by the Institute of Business Forecasting found that businesses using formula-based reorder points reduce stockouts by 35% and excess inventory by 25% compared to gut-feel reordering.

The Reorder Point Formula

Reorder Point = (Average Daily Sales x Lead Time) + Safety Stock

This means: when your available inventory drops to this number, place a purchase order. By the time the new stock arrives (lead time), you'll have just enough safety stock to cover any variability.

Example Calculation

When available stock hits 168, you order. The 112 units consumed during lead time plus the 56-unit safety buffer ensures you don't stockout even if sales spike 50% or the supplier is a few days late.

Adjusting Safety Stock

The 7-day safety buffer is a starting point. Adjust based on:

Reorder Quantity

How much to order when you hit the reorder point:

Economic Order Quantity (simplified):

Reorder Qty = Average Daily Sales x Days of Supply Target

If you want 30 days of supply and sell 8/day: order 240 units. If you want 60 days: order 480 units. Balance ordering cost (fewer, larger orders) against storage cost (more stock = more warehousing).

How Do You Track Product Costs Accurately?

Cost tracking determines whether your pricing is profitable — and most sellers undercount costs by 15-20%. A product with a $10 supplier cost actually costs $12-15 when you include shipping, duties, packaging, and storage. Landing cost accuracy directly determines whether your pricing model works or you're slowly losing money.

Landed Cost Calculation

Add a "Landed Cost" column to your main inventory sheet. Use this number — not the supplier unit price — for all pricing calculations.

Cost Tracking Sheet

Create a third tab for cost history:

Track cost history per SKU per purchase order. Costs change — supplier price increases, shipping rate changes, currency fluctuations. If you use the latest landed cost for pricing but have older, more expensive inventory on the shelf, your margin is lower than your spreadsheet suggests.

For pricing strategies that use these cost numbers, see the marketplace pricing strategy guide.

How Do You Handle Variants in a Spreadsheet?

Variant management is where most inventory spreadsheets become unusable. A product with 5 sizes and 4 colors creates 20 SKUs — and managing 500 products with variants means tracking 5,000-10,000 rows. The key is consistent SKU naming and filtering, not separate sheets per product.

SKU Naming Convention

Your SKU should encode enough information to identify the variant without looking it up:

Format: CATEGORY-BRAND-MODEL-SIZE-COLOR

One Row Per Variant

Every variant gets its own row with its own stock count, cost, and reorder point. Do not combine variants into one row with comma-separated sizes. That makes formulas impossible and counts unreliable.

Filtering and Views

With thousands of rows, you need saved filters:

• Reorder view: Filter Status column for "REORDER" and "STOCKOUT"
• Category view: Filter by category to review one product type at a time
• Supplier view: Filter by supplier to create purchase orders
• Channel allocation view: Switch to the allocation tab filtered by low-stock channels
• Dead stock view: Filter for items with Days of Supply > 90 and Daily Sales Rate = 0

How Do You Keep a Spreadsheet Accurate?

Spreadsheet accuracy degrades over time unless you actively maintain it. The average inventory spreadsheet drifts 2-5% per week from physical reality — meaning after a month without cycle counts, your data is 10-20% wrong. Teams that do weekly cycle counts maintain 97%+ accuracy; teams that don't drop below 85% within 90 days.

The Weekly Maintenance Routine

Monday: Cycle count. Pick 50-100 SKUs at random (or focus on fast-movers and high-value items). Physically count them. Compare to your spreadsheet. Fix discrepancies.

Wednesday: Reorder review. Filter for REORDER status. Place purchase orders for everything flagged. Update the In-Transit column.

Friday: Sales data update. Update your daily sales rate calculations with the latest week of data. This keeps reorder points accurate as demand shifts.

Accuracy Rules

1. One person updates inventory counts. Not five people updating the same sheet. Designate an inventory owner.
2. Every count change gets a timestamp. Use the "Last Updated" column. If a row hasn't been updated in 30 days, it's suspect.
3. Lock formula columns. Protect the cells containing formulas so nobody accidentally overwrites a reorder point calculation with a static number.
4. Back up daily. Google Sheets does this automatically. If you use Excel, save a dated copy every morning.
5. Version history. If numbers look wrong, check Google Sheets version history to see who changed what and when.

When to Graduate from Spreadsheets

Your spreadsheet has served you well. Time to move to software when:

• You manage more than 1,000 active SKUs
• You process more than 500 orders per day
• Multiple team members need to update inventory simultaneously
• You need real-time inventory sync across 4+ channels
• Manual updates take more than 5 hours per week
• Accuracy stays below 95% despite regular cycle counts

At that point, tools like TradeGecko (QuickBooks Commerce), Cin7, or a platform like TaskForce that includes inventory management with channel sync become worth the investment.

Frequently Asked Questions

Can I manage multi-channel inventory with just a spreadsheet?

Yes, up to about 500-1,000 active SKUs and 3-4 channels. The limitation isn't the spreadsheet — it's the manual updating. A spreadsheet can't auto-sync with marketplace APIs, so every inventory change requires manual entry. Below 500 SKUs, that's manageable. Above 1,000 SKUs with 4+ channels, manual updates become a full-time job and errors compound too fast.

How often should I do a full physical inventory count?

Full counts once per quarter for businesses with fewer than 1,000 SKUs. More frequently (monthly) if your accuracy is below 95%. Between full counts, do weekly cycle counts of 50-100 SKUs. Cycle counting is more effective than infrequent full counts because it maintains accuracy continuously instead of fixing it periodically.

What's the best way to track inventory across multiple warehouses?

Add a "Location" column to your main sheet, or create separate tabs per warehouse. Each location gets its own On-Hand quantity. Total Available across all locations is a formula summing each warehouse's available stock. Channel allocation should pull from the warehouse closest to that channel's customers to minimize shipping time and cost.

Should I use Google Sheets or Excel?

Google Sheets for multi-person teams because of real-time collaboration, automatic version history, and cloud backup. Excel for single-user operations or when you need advanced features (pivot tables, Power Query). For teams, the risk of overwriting each other's work in Excel shared files makes Google Sheets the safer choice.

How do I handle pre-orders or backorders in a spreadsheet?

Add a "Pre-Order Qty" column that tracks committed quantities for products not yet in stock. Your Available calculation becomes: On-Hand - Committed - Pre-Order = Available for new sales. When pre-ordered stock arrives, move the quantity from Pre-Order to On-Hand and adjust committed orders to ready-to-ship status.

Keep Reading

• Marketplace Inventory Management — The complete guide to managing inventory across multiple sales channels
• Multi-Channel Inventory Management Guide — Advanced strategies for inventory allocation and sync
• Ecommerce Operations Metrics — Track inventory accuracy alongside the other metrics that matter