Ecommerce & Marketplace · THE NO-PANIC PLAN
Review a Shopify inventory export before replenishment planning
A stock number without its location and state can lead to an accidental reorder or an inventory overwrite. This workflow helps Shopify merchants export a reviewable snapshot, distinguish sellable stock from committed, unavailable, and incoming units, check the data against inventory history, and prepare a human-reviewed replenishment decision. Nirmion tools analyze supplied data; they do not connect to Shopify or place orders.
MISSION Review a dated, location-aware Shopify inventory CSV and resolve quantity-state or history discrepancies before using it to plan supplier replenishment.
Review a Shopify inventory exportTHE REAL-WORLD BIT
What happens outside this browser tab?
Set the inventory snapshot scope; export the right Shopify CSV format; preserve and validate the file; inspect state and location differences; use the local replenishment analyzer only on supported fields and confirmed assumptions; compare with Shopify reports, adjustment history, and supplier terms; then route a reviewed purchase order and track receipt separately.
YOUR CHECKLIST, WITH FEWER DRAMATIC SIGHES
One step at a time.
Follow the order below. If a step names a Nirmion tool, its link is right there with it.
- 01
Set the location, product, and review time boundary
Decide whether this review covers one location or all locations, which product variants or SKUs are in scope, the export date and time, and the replenishment question you need to answer. Name the person responsible for catalog identity, stock counts, supplier lead times, and purchase-order approval. Confirm whether your business uses Shopify locations, inventory apps, fulfillment services, or a separate warehouse system, since each can affect where a quantity is held and which system owns it. Avoid combining quantities from different locations unless the fulfillment route can actually use that stock. Keep a dated export for the review and note any manual sales, pending transfers, open orders, or purchase orders that may have changed after it was downloaded. A Shopify inventory export is a snapshot, not a live promise that the same quantity remains available at the time a later order is placed.
- 02
Export the inventory states that match your review
In Shopify admin, open Products > Inventory and use Export for the selected location or locations and variants. For a replenishment review that must distinguish stock states, choose the All states CSV where available: Shopify describes this as the recommended complete view with separate rows per location and columns for all inventory states, with protection against accidental overwrites. The Available-only export is simpler but omits the other states and does not provide that overwrite protection. Record which format you selected, the date, and the selected location/variant scope. Keep the source export unchanged and create a separately named working copy. Do not import an analyzed file back into Shopify unless an authorized person has checked the correct template, quantity type, and import consequences; a review workflow should never turn a report into a bulk stock adjustment by accident.
- 03
Check the product key, location rows, and quantity states
Confirm each row maps to the expected product or variant and location; look for blank or repeated handles, unexpected location names, missing quantity cells, and a file date outside the review window. Shopify defines On hand as the total at a location and Available as stock that can be sold; Committed is reserved for orders, Unavailable is set aside, and Incoming has not yet been received into available stock. Do not simply add Incoming to Available or treat On hand as sellable quantity. Check that the columns and totals make sense for the export mode, and compare a few rows in Shopify admin before trusting a bulk file. If a product has variants or a location does not fulfill it, confirm the displayed state and location behavior in Shopify’s current inventory views rather than assuming every row is interchangeable.
- 04
Use the local analyzer as a screening aid, not an order instruction
Before using Inventory Replenishment CSV Analyzer, review the tool’s current input fields and handling description, and use only a working copy containing data you are allowed to process. Confirm that the columns you supply mean what the tool expects and that its visible rules and assumptions fit the selected Shopify export. The current tool is a client-only commerce analyzer for supplied merchant data, but it does not connect to your store, fetch live inventory, verify physical counts, or know supplier commitments. Treat its downloadable artifact as a list of candidates or calculations to review, not as a purchase order or automatic reorder point. If the tool does not accept the exported state format as-is, stop and prepare an explicitly documented working table; do not relabel or collapse Shopify inventory states merely to make the file fit.
- 05
Reconcile suspicious quantities with Shopify history and current activity
For a discrepancy or unexpectedly low quantity, open the affected product or variant in Shopify and review its adjustment history and any inventory adjustment report. Shopify records inventory changes with details such as date, activity, creator, and quantity states; third-party apps can also change inventory. Compare the export with recent sales, open orders, pending transfers, incoming purchase orders, physical counts, and any external warehouse record that the responsible owner considers authoritative. Remember that inventory reports can be snapshots or period-based metrics, not the same thing as a current per-location available balance. Record who checked the mismatch, what source explained it, and whether the problem is a data issue, stock-count issue, delayed update, or genuine replenishment need. Escalate unexplained discrepancies before ordering or changing quantities.
- 06
Prepare a replenishment decision using verified demand and supplier terms
For each proposed item, combine the confirmed available quantity with the business’s own recent sales or demand measure, expected supplier lead time, minimum order or pack size, and open purchase orders or transfers. Keep the time window and method visible; Shopify inventory alone does not provide all those assumptions. Compare the candidate quantities with your budget, storage capacity, supplier terms, and authorized approval limit. Inventory Replenishment Action Checklist can help structure a review of supplied merchant information; it does not verify demand, set your organization’s reorder policy, or approve a purchase. Have the accountable buyer review exceptions, large orders, low-confidence forecasts, and items where location or incoming quantities are uncertain. Record the reason for the decision and who approved it before creating a purchase order in Shopify or the approved procurement system.
- 07
Track the purchase order and reconcile what actually arrives
When a supplier confirms an order, record the purchase order reference, products and quantities, supplier terms, expected arrival, and destination location in the authorized system. Shopify purchase orders can record supplier agreements and link to inventory transfers for tracking shipments and receiving stock. When goods arrive, reconcile delivered, missing, damaged, or rejected quantities with the packing record and purchase order; mark only the quantity actually received through the Shopify receiving workflow or the system of record. Review the resulting adjustment history and compare the next inventory snapshot with the prior export so unexplained changes remain visible. Retain the dated source, reviewed output, decision owner, and receiving evidence under your business’s record policy, and remove temporary working copies when no longer needed.
THE HELPER CREW
Tools for the fiddly bits.
These are the currently published Nirmion tools matched to this guide. Open a tool page for its accepted inputs and limits.
RECEIPTS, PLEASE
Sources & review notes
Each source is linked to the steps it supports. Open it to check its scope and current guidance.
Source checked 2026-10-10
- Shopify Help Center — Exporting and importing inventory with a CSV file
- Shopify Help Center — Understanding inventory states
- Shopify Help Center — Inventory reports
- Shopify Help Center — Viewing inventory adjustment history
- Shopify Help Center — Purchase orders
- Shopify Help Center — Receiving and processing inventory from purchase orders
- Shopify Help Center — Inventory and locations
- Shopify Help Center — Adjusting inventory quantities