E-commerce

Comprehensive guide to managing inventory in the Shopify admin

Comprehensive guide to managing inventory in the Shopify admin

March 25, 2025

Receiving goods, cycle counting, seasonal peak, or a simple data entry correction: the Stock page in Shopify admin is the dashboard where customer trust is at stake. This “pro” guide draws on the official documentation: Inventory management, Understanding inventory statuses, the Stock page and quantity tracking, bulk editing, the inventory CSV file, transfers, selling when out of stock, and the developer documentation on inventory management apps. For a broader view (ABC analysis, Flow, reports), compare it with our article inventory management in Shopify admin and add a product.

The goal is not to repeat unverifiable market percentages: it is to read the columns correctly, align warehouse and channels, and document every movement to avoid overselling and impossible promises.

Summary

Stock page: views, columns, habits

Shopify displays quantities on the Stock page (Shopify admin) next to each product or variant. You can create saved views: hide a less useful column (for example, physical stock if you mainly manage available stock), add filters by vendor or location, and keep a distinct “weekly inventory” view from a “collection launch” view. The help on quantity tracking reminds you that these settings help focus attention on what matters for your team.

A simple habit: start the day by sorting variants with low available stock or incoming SKUs not yet received, depending on your role. The same screen is used for the warehouse (receiving and movements) and e-commerce (consistency with campaigns): document who updates what to avoid two people correcting the same line without talking to each other.

Official statuses: physical, available, engaged, unavailable, incoming

The definitions below follow the logic of the French Help Center. Physical stock is the total number of units present at the location; it combines the committed, unavailable, and available states. Available is what you can sell: it is not committed to a confirmed order, is not reserved as unavailable for a draft order in the documented sense, and does not include incoming stock.

“A stock state defines the status of a product, indicating in particular whether a product is in physical stock and available for purchase, committed to an order, unavailable, or part of an incoming shipment.”

Shopify Help Center, introduction to stock states (adapted quote)

State

Operational idea

Question to ask

Physical

Total present at the location

Does my physical inventory correspond to this column?

Available

Immediately sellable online (excluding channel rules)

Does my promotion advertise this actual volume?

Committed

Tied to orders not yet processed

Is my preparation time compatible with this committed stock?

Unavailable

Temporary reservations, apps, quality, safety stock

Does each unit have a traceable internal reason?

Incoming

Transfers, purchase orders, integrations

Is receipt planned and assigned?

Important final point: units linked to a draft order are not purchasable by the public, but they only move into the committed state once the draft order is converted into an order, as explained in the help on stock states. Train sales teams so they understand the impact of an open draft on available stock.

Enable tracking and avoid blind spots

Without stock tracking enabled, Shopify cannot reliably apply the state logic described above for your configuration. Check product pages after an import or duplication: a copied variant may retain an unsuitable setting. For launches, a check of “tracking enabled + quantities by location” avoids unpleasant surprises on launch day.

Adjustments, reasons and history

Manual adjustments remain the most direct lever after an inventory count or breakage. Each movement should ideally include an identifiable reason (receipt, inventory count, correction, breakage) so that the adjustment history can be used during an internal audit or a supplier dispute. If multiple sites use the same SKU, the reason naming convention avoids vague labels like « correction » without context.

When you change physical stock in the admin, the available quantity changes in parallel according to the documented rules: a change thought of as « local » can have effects on the availability promise in the online store if the channels share the same location.

Bulk editing and CSV: when to use them

Mass editing speeds up corrections after a partial inventory: you select variants, open the grid, edit the visible fields, and save. It is suited to teams that prefer the interface to a spreadsheet.

The inventory CSV is for larger volumes or ERP integrations. Good practice: export the current state, keep a timestamped copy, test on a small batch of SKUs, then launch the full import. Check the columns related to locations: a header error or location mapping error can shift quantities without the marketing team seeing it immediately on the storefront.

Method

Typical case

Risk to manage

Mass editing in the admin

Campaign, targeted inventory, small list

Forgetting hidden columns in the view

CSV import

Bulk restocking, external tool integration

Poorly encoded file or incorrect location mapping

Line-by-line adjustment

One-off correction, single-unit case

Less scalable but traceable case by case

Transfers, incoming stock and receiving

The transfers between locations feed the state incoming until receipt. As long as the movement has not been received, the stock is not available for sale at the destination: a common mistake is to announce store availability while the inter-site package is still « on the way ». Closing the receipt is a process step, not a logistical detail.

Purchase orders and supplier receipts

If you use purchase orders, the supplier purchase orders section links receipt and quantity updates. Align the receipt accounting date with the date on which stock becomes available for sale: a mismatch often explains the differences between finance and the warehouse.

Out of stock, overselling, and multi-location

A product is out of stock when tracking is active and the level is zero or negative, and by default customers cannot order until you have restocked. You can allow overselling for documented cases (preorder, imminent restock), via the option to continue selling when out of stock, while being aware of the limitations: for example, with multiple locations, an item may remain shown as out of stock online if only a warehouse that does not fulfill web orders holds stock. The help article Selling out-of-stock products details these interactions and notes that Shopify POS behaves differently from the web.

Temporary orders, apps and channels

Reservations and third-party apps can increase the non-available share without affecting physical stock: this is desirable (quality control) or problematic (an app setting that needs fixing). Sales channels consume the same inventory: if a marketplace is still showing an offer while available stock is zero, the problem often comes from synchronization delay or location rules, not just Shopify.

Developer documentation emphasizes that the inventory management apps must respect Shopify's inventory model to avoid discrepancies. Before activating a critical app, test a pilot SKU and verify the states after a test order and a product return.

B2B: underlying catalogs and stock levels

B2B catalogs and negotiated pricing do not replace inventory discipline: quantities remain those of your locations. Clarify lead times, minimum order quantities, and restocking so the sales team does not promise volumes the warehouse cannot fulfill at the same pace. For customer journeys, also see variants and collections when product ranges differ between retail and wholesaler.

Healthy indicators without generic numbers

Rather than displaying "market average" percentages, build your own signals: number of SKUs available below a threshold, number of unreceived transfers beyond N days, discrepancy between physical inventory and admin records on a monthly sample, orders canceled due to unavailability. These simple series, drawn from Shopify reports and your spreadsheets, support purchasing and staffing decisions.

Additional sections

Inventory reports and reconciliation

Beyond the Stock page, inventory reports help track changes in quantities and prepare monthly or quarterly reconciliations. Use them to compare recorded value with your accounting, identify dormant SKUs, and prioritize sell-off campaigns. Regular exports to your spreadsheet, cross-referenced with sales by variant, highlight structural gaps: not just a one-off data entry error, but a category that drains stock poorly or a size option that is poorly dimensioned.

During a reconciliation, work by workstream: one department, one brand, or one supplier at a time. Note the root causes (labeling, duplicate picking, unintegrated returns) rather than correcting the number without keeping a record. This discipline prevents the same discrepancy from reappearing after every cycle count.

Order routing and locations

Online orders are assigned to one or more locations based on available stock and your order routing rules. If a warehouse is overloaded or misconfigured, you may see "unexplained" stockouts in the store while another site still holds units: the problem is often organizational, not mathematical. After each location addition or shipping strategy change, rerun an order test and check which location receives the line item to fulfill.

The location configuration that does or does not fulfill online orders interacts directly with stockouts and overselling: keep an internal "channel → eligible locations" map shared between marketing and logistics.

Physical inventory, returns, and quality

A full physical inventory stops operations: more mature teams reserve it for financial closings or audits, and prefer cycle counts on high-value or fast-moving families. For each count, prepare the list of relevant locations, the double-check rules, and the time slot during which online sales are temporarily frozen if necessary. After counting, enter adjustments with an explicit reason to enrich the history.

E-commerce returns sometimes add units back to available stock, sometimes to non-available stock (quality control). Decide who approves restocking, how you temporarily mark damaged units, and how you prevent a quarantined item from being promoted in a campaign. A vague process line between "return received" and "available for sale" creates promises that cannot be kept for the end customer.

Finally, link displayed availability to marketing messages: announcing fast delivery on a landing page while stock is still incoming or mostly committed undermines trust. When the supply chain is delayed, update the lead times on the product page before amplifying the campaign.

ABC analysis and SKU prioritization

As the catalog grows, you cannot monitor every variant at the same level of detail. Shopify offers an introduction to ABC inventory analysis to classify items based on their contribution to sales or margin and focus controls on "A" items. This is not a planning requirement: it is a prioritization tool. In practice, combine ABC analysis with your saved views on the Stock page: a "critical SKUs" dashboard and a "long tail" dashboard are often enough to balance team time and inventory frequency.

To go further on automating alerts when available stock crosses a threshold, explore Shopify Flow (triggered by a variant quantity change) and the documented flow templates in the help center: useful when the number of references exceeds what daily manual monitoring can cover without error.

Best practices and common mistakes

Error

Effect

Fix

Not closing a transfer

Stock stuck as incoming

Named receiving process

Importing a CSV without a backup

Hard to roll back

Export + test on a subset

Ignoring multi-location rules

Stockout displayed even though stock exists elsewhere

Check which location supplies the online channel

Overselling enabled without a framework

Delivery promises not kept

Clear preorder policy on the customer service side

Short checklist for regular monitoring

  • Check lines with low available stock or incoming stock not received.

  • Cross-reference with marketing campaigns planned for this week.

  • Review open draft orders that reserve stock.

  • Check a sample of recent adjustments in the history.

Enhance with a chatbot

A conversational assistant like Qstomy does not replace quantity updates, but it can answer questions about lead times, suggest alternatives when a variant is unavailable, and reduce "are you in stock?" tickets when product pages are up to date. Learn more: e-commerce chatbot, AI recommendations, Shopify integration.

Summary

Managing stock "like a pro" in Shopify means mastering the Stock page, the official states (physical, available, committed, unavailable, incoming), and the related levers: documented adjustments, bulk editing, CSV, received transfers, purchase orders if you use them, and stockout or overselling rules adapted to your strategy. Avoid unsourced external statistics: prefer indicators built on your store and clear coordination between warehouse, sales, and channels.

FAQ

How does this article differ from the "inventory management" guide?

This one focuses on the Stock page, reading states day to day, and workflows (reconciliation, routing, returns); the efficient inventory guide offers a more structured overview of the same topic (reports, automation, advanced cases). The two articles complement each other.

Why doesn’t my draft order show committed stock?

As long as the draft order has not become an order, the units are not counted as committed in the sense described in the help on inventory states; however, they can be unavailable if reserved.

My CSV import is not updating the correct warehouse: what should I do?

Check the location columns and the mapping; run another test on a few SKUs and compare the Stock page before and after.

Is POS behavior the same as the web when out of stock?

No: the help on selling when out of stock specifies that the rules can differ for Shopify POS; train store staff.

How do I estimate the cost of a stockout?

Use your margins, your cancellation rate, and customer feedback on unavailability rather than published averages without methodology.

Go further

March 25, 2025

Convert over 2,000 customers on average per month with Qstomy.

The world’s 1st Shopify AI dedicated to customer conversion

Empowering 200+ e-commerce merchants

Subscribe to the newsletter and get a personalized e-book!

No-code solution, no technical knowledge required. AI trained on your e-shop and non-intrusive.

*Unsubscribe at any time. We do not send spam.

Subscribe to the newsletter and get a personalized e-book!

No-code solution, no technical knowledge required. AI trained on your e-shop and non-intrusive.

*Unsubscribe at any time. We do not send spam.