Inventory Management Best Practices for Shopify

Inventory is simultaneously your largest asset and your most dangerous liability. Too much stock ties up cash, increases storage costs, and risks obsolescence. Too little stock means lost sales, backorder frustration, and competitors capturing customers who cannot wait. Getting inventory management right is arguably the most operationally complex challenge in ecommerce — and Shopify's built-in tools, while solid, require deliberate configuration and supplementary systems to work effectively at scale.

This guide covers the complete inventory management stack for Shopify merchants: from native feature configuration through third-party tools, demand forecasting, supplier management, and warehouse operations.

Key Takeaways

• Shopify's native inventory tracks quantities per location but lacks demand forecasting and reorder automation
• ABC analysis segments your SKUs by revenue contribution — 80% of revenue typically comes from 20% of SKUs
• Safety stock calculation prevents stockouts during demand spikes or supplier delays
• Reorder points (ROP) trigger replenishment orders automatically when stock falls below threshold
• Multi-location inventory requires deliberate allocation rules to prevent simultaneous overselling
• Shopify's inventory API enables real-time sync with warehouse management systems (WMS)
• Cycle counting is more accurate and less disruptive than annual physical inventory counts
• Dead stock identification and liquidation prevents storage cost accumulation

---

Shopify's Native Inventory System

Understanding what Shopify handles natively — and where its limitations lie — prevents misaligned expectations.

What Shopify inventory does well:

• Real-time quantity tracking per variant per location
• Prevents overselling (configurable: block checkout or allow with backorder)
• Purchase order receiving (with POS Pro)
• Basic low-stock alerts via email
• Inventory history per product variant
• CSV import/export for bulk updates
• Inventory adjustments with reason codes

Shopify inventory limitations:

• No demand forecasting or sales velocity analysis
• No automatic reorder point calculation
• No multi-supplier management
• No lot/batch tracking (critical for perishables, regulated goods)
• No serialized inventory tracking
• No multi-warehouse bin/shelf location tracking
• Limited reporting on inventory aging

For stores with under 500 SKUs and simple fulfillment, native Shopify inventory is often sufficient. Beyond that threshold, supplementary inventory management software becomes economically justified.

---

ABC Analysis: Prioritizing Your Inventory Attention

Not all inventory deserves equal attention. ABC analysis segments your SKU portfolio by revenue contribution, focusing management effort on the items that drive the most business impact.

ABC segmentation methodology:

Export your Shopify sales data by product and sort by total revenue for the past 12 months. Then classify:

• A items: Top 10-20% of SKUs by revenue, representing 70-80% of total revenue. These deserve daily monitoring, the tightest safety stock, premium shelf location, and the closest supplier relationships.

• B items: Next 30-40% of SKUs, representing 15-25% of revenue. Weekly monitoring, standard safety stock, regular supplier review.

• C items: Bottom 40-50% of SKUs, representing 5-10% of revenue. Monthly monitoring, minimal safety stock, consider discontinuation if sales velocity is declining.

Applying ABC in Shopify:

1. Export Sales by Product report from Shopify Analytics (last 12 months)
2. Import to Excel/Google Sheets
3. Sort by Net Sales descending
4. Calculate cumulative revenue percentage
5. Classify: A = 0-80%, B = 80-95%, C = 95-100%
6. Apply findings: set different reorder points, safety stock levels, and review frequencies by category

Seasonal adjustment:

A item classification must account for seasonality. A product that is a C item in aggregate might be an A item during the 8 weeks of holiday season. Maintain separate ABC classifications for peak and off-peak periods.

---

Safety Stock Calculation

Safety stock is the buffer inventory that protects against two simultaneous risks: demand spikes (selling faster than expected) and supply disruptions (supplier ships late or short). Without safety stock, any demand spike or supplier delay causes a stockout.

Basic safety stock formula:

Safety Stock = Z × σ(demand) × √(lead time)

Where:
Z = service level factor (1.65 for 95% service level, 2.05 for 98%)
σ(demand) = standard deviation of daily demand
lead time = supplier lead time in days

Practical example:

Product: Canvas Tote Bag (A-item)

• Average daily demand: 12 units
• Standard deviation of daily demand: 4 units
• Supplier lead time: 14 days
• Target service level: 95% (Z = 1.65)

Safety Stock = 1.65 × 4 × √14
Safety Stock = 1.65 × 4 × 3.74
Safety Stock = 24.7 → round up to 25 units

This store should maintain at least 25 units of buffer stock for this product.

Setting safety stock in Shopify:

Shopify does not natively enforce safety stock levels, but you can simulate the effect:

1. Calculate safety stock for each A and B item
2. Use Shopify's "Continue selling when out of stock" setting: disable for products where safety stock is your actual floor
3. Use a third-party app (Inventory Planner, Stocky) to set reorder alerts that trigger when stock drops to safety stock level

---

Reorder Points: Automating Replenishment Triggers

A reorder point (ROP) is the inventory level at which you initiate a purchase order. Setting it correctly ensures you never run out before new stock arrives.

Reorder point formula:

ROP = (Average Daily Demand × Lead Time) + Safety Stock

For Canvas Tote Bag:
ROP = (12 × 14) + 25
ROP = 168 + 25 = 193 units

When stock falls to 193 units, place a purchase order immediately. By the time the order arrives (14 days later), safety stock consumption brings you to approximately 25 units — exactly your safety stock target.

Reorder quantity (Economic Order Quantity):

EOQ = √(2 × Annual Demand × Order Cost / Holding Cost per Unit per Year)

Example:
Annual demand = 4,380 units (12/day × 365)
Order cost = $75 (admin, shipping, receiving labor)
Holding cost = $3/unit/year (storage, insurance, obsolescence risk)

EOQ = √(2 × 4,380 × 75 / 3) = √219,000 = 468 units

Order 468 units per replenishment cycle for minimum total cost. Adjust upward for quantity discounts from suppliers.

Inventory Planner app for Shopify:

Inventory Planner (from Brightpearl, now Sage) automates ROP and EOQ calculations by pulling sales history from Shopify. It accounts for seasonality, supplier lead times, and generates suggested purchase orders. Cost: $99-$499/month depending on SKU count. ROI typically positive within 30-60 days for stores with $500,000+ annual revenue.

---

Multi-Location Inventory Management

Merchants operating multiple Shopify locations (retail stores, warehouses, 3PLs) need deliberate inventory allocation rules to prevent overselling and stockouts.

Location priority for online order fulfillment:

In Shopify Admin > Settings > Shipping and delivery > Location priority, define which location fulfills online orders first. Common configurations:

1. Single warehouse model: One warehouse fulfills all online orders, retail locations have their own inventory pools
2. Proximity-based: Orders route to the location nearest the customer (requires third-party app like Shipwire or Flexe)
3. Stock-based: Orders route to the location with the most available inventory for the ordered SKU

Preventing overselling in multi-location setup:

Shopify tracks inventory per location and deducts from the fulfilling location when an order is created. However, if two customers simultaneously place orders for the last unit at the same location, overselling can occur. Mitigate by:

1. Setting safety stock buffers (keep 2-3 units as buffer rather than selling to true zero)
2. Enabling "Hide when out of stock" for products with low quantity
3. Using an inventory reservation app (Linnworks, Brightpearl) that reserves inventory at cart-add rather than order-confirm

Inventory transfers between locations:

When a retail location runs low while the warehouse has surplus:

1. Admin > Inventory > Transfers > Create transfer
2. Select origin (warehouse) and destination (retail)
3. Add products and quantities
4. Mark as "In transit" — warehouse inventory decrements, retail shows "Incoming"
5. Retail staff "receives" transfer when goods arrive — retail inventory increments

Track transit inventory separately to avoid committing the same units to multiple shipments.

---

Warehouse Operations for Shopify Merchants

As order volume grows, warehouse organization directly impacts fulfillment speed, accuracy, and labor cost.

Bin location system:

Assign every SKU a bin location code in your warehouse. Format: Aisle-Shelf-Bin (e.g., A2-3-4 = Aisle A, Shelf 2, Position 4 from left). Store this in Shopify product metafields:

1. Admin > Settings > Custom data > Products > Add metafield
2. Name: "Bin Location", Namespace: "warehouse", Key: "bin_location", Type: Single line text
3. Populate for each product
4. Pull metafield data in pick list exports

Pick list optimization:

Paper pick lists are inefficient and error-prone. Options:

• Zone picking: Group picks by warehouse zone, reduce walking distance
• Batch picking: Pick multiple orders simultaneously, sort and pack afterward
• Wave picking: Schedule multiple batch picks at coordinated times for efficiency

Apps that generate optimized pick lists from Shopify orders: Packed, Shopify Flow (with custom workflow), ShipStation (for multi-carrier shipping).

Packing accuracy:

Human error in packing is the primary driver of returns and negative reviews. Implement:

• Barcode scan verification before sealing box (scan product barcode, verify against order)
• Weight check after packing (scale integrated with shipping software flags boxes outside expected weight range)
• Photo documentation for high-value orders

Returns intake process:

1. Receive returned item, retrieve original order from Shopify
2. Inspect condition against return policy
3. Resaleable: restock to inventory (adjust Shopify quantity, update bin location)
4. Not resaleable: document condition, dispose or donate, record as shrinkage
5. Process refund or store credit in Shopify

---

Demand Forecasting

Accurate demand forecasting reduces both stockout frequency and excess inventory accumulation. Shopify's native analytics provide historical sales data — the input for forecasting.

Simple moving average forecast:

For stable demand products: average the last 4-8 weeks of sales as the forecast for the next period.

Weighted moving average:

Weight recent weeks more heavily: Week 8 × 0.4, Week 7 × 0.3, Week 6 × 0.2, Week 5 × 0.1. This gives more weight to recent demand trends while smoothing volatility.

Seasonal adjustment:

For seasonal products, multiply your base forecast by the seasonal index for the forecast period:

Seasonal Index = Average sales in period / Overall average sales
Forecast = Base Forecast × Seasonal Index

Example: Your swimwear averages 10 units/week overall, but June averages 35 units/week. June seasonal index = 35 / 10 = 3.5 If base forecast for June is 10 units/week: Adjusted forecast = 10 × 3.5 = 35 units/week.

Forecasting tools integrated with Shopify:

---

Dead Stock Identification and Liquidation

Every merchant accumulates dead stock — products that sold poorly and now consume storage space and working capital. Systematic identification and liquidation is essential for inventory health.

Identifying dead stock in Shopify:

Export the Inventory report and cross-reference with the Sales by Product report. Flag any product that:

• Has been in stock for more than 90 days with no sales, or
• Has inventory quantity representing more than 180 days of supply at current sales velocity

Liquidation strategies by situation:

Preventing dead stock accumulation:

1. Always test new products with conservative initial orders (minimum viable inventory)
2. Use Shopify's "pre-order" capability to gauge demand before committing to stock
3. Negotiate consignment terms with suppliers for unproven products
4. Set a 60-day review trigger for any product not reaching minimum sales velocity targets

---

Frequently Asked Questions

What inventory management app should I use with Shopify?

The best app depends on your scale. Under 500 SKUs and $500K annual revenue: Shopify's native inventory plus Stocky (free from Shopify) covers most needs. $500K-$2M revenue with growing SKU count: Inventory Planner or Cogsy provide forecasting and purchase order automation that pays for itself quickly. Above $2M or multi-channel with external warehouses: Linnworks, Brightpearl, or a dedicated WMS (3PL Central, Fishbowl) integrated with Shopify via API.

How do I sync inventory between Shopify and Amazon FBA?

Use a multi-channel inventory management platform: Linnworks, Sellbrite, or ChannelAdvisor. These pull orders from both Shopify and Amazon, decrement a shared inventory pool, and prevent overselling across channels. Alternative: if Amazon is your secondary channel, use Amazon's MCF (Multi-Channel Fulfillment) for Shopify orders while keeping separate inventory pools — simpler but requires manual monitoring of stock split.

How often should I do inventory counts?

Annual physical inventory is required for accounting purposes but operationally insufficient. Implement cycle counting: count A items weekly, B items monthly, and C items quarterly. This distributes the counting burden throughout the year, catches discrepancies faster, and is far less disruptive than shutting down for a full annual count. Use Shopify POS Pro's built-in inventory count feature for retail locations.

What is consignment inventory and how does it work with Shopify?

Consignment means you hold a supplier's inventory and pay only when it sells — they retain ownership until the sale. This eliminates inventory risk but typically means lower margins. Track consignment inventory in Shopify using custom inventory adjustments and supplier-specific location codes. Note: Shopify does not have native consignment inventory management — use a third-party app or manage manually with metafields to distinguish owned vs consigned stock.

How do I handle inventory for products with expiration dates?

Shopify does not natively track expiration dates or lot numbers. For perishables, supplements, cosmetics, or any regulated goods requiring lot tracking: use an inventory management system like Cin7 or Fishbowl that supports lot-controlled inventory and integrates with Shopify. These systems track expiration dates per lot and can implement FEFO (First Expired, First Out) pick sequencing to minimize expiration-related losses.

---

Next Steps

Effective inventory management for Shopify requires combining native Shopify configuration with appropriate third-party tools, deliberate supplier relationships, and documented operational processes.

ECOSIRE's Shopify services include inventory management system selection, implementation, supplier integration, and warehouse process design — helping merchants build inventory operations that scale without stockouts or capital waste.

Speak with our Shopify operations team about optimizing your inventory management.