kijun blog Stocky data cleanup and setup prep

Shopify Inventory Audit After Stocky: What to Check Before You Reorder

A Shopify inventory audit after Stocky is a merchant’s own review of the inventory records you rely on: the products, variants, SKUs, locations, tracking settings, and quantities behind every buy list and purchase order. It means a review checklist you run yourself, not a professional accounting, tax, or financial audit. As you move your inventory work off Stocky and into Shopify, the records you carry over decide every later buying call, so the point of this review is to catch stale, unclear, or mismatched data before you reorder rather than after. Work through your catalog structure, confirm what is actually tracked, compare quantities against recent reports, and read your CSV files before you import or rebuild on them. Stocky will not be available after August 31, 2026, and its records do not arrive in Shopify already checked, so treat this as a review you run rather than a result you inherit. Here is what to check before you reorder.

What a Shopify inventory audit should mean after Stocky

An inventory audit here is a review you run on your own records, not an outside service and not a financial audit. It is the habit of opening what you have in Shopify, checking each part against what you expect, and deciding what you trust before you act on it. The reason it matters after a migration is that the two systems do not line up on their own. Shopify has said that some Stocky-specific features might work differently or might not yet be available in Shopify, so plan to check field by field rather than assume everything carried over intact. Treat the audit as a checklist you work through, one record type at a time, so that when you do reorder you are reading from figures you have looked at rather than ones you hope are right. If you have not yet set up the Shopify side, the Shopify inventory setup after Stocky guide covers building that foundation, the readiness work before the cutover is preparing Shopify inventory before the Stocky sunset, and the order of the whole move is the Stocky migration checklist; this review is what you run over that setup afterward.

Start with products, variants, SKUs, and locations

Start where every quantity is anchored, because a count only means something if the variant and location behind it are right. Product details live in the Shopify product CSV, which can import products into a store and export them from it: titles, handles, vendors, SKUs, variant options, prices, and costs. Export yours and check that every product and variant you sell is present with the SKU you expect, and that nothing you retired is still listed. Locations are the other key: the inventory CSV uses the Handle, Location, and Option1 Value columns, plus Option2 and Option3 Value for products with more than one option, to identify the product variant and the location a quantity belongs to, so confirm each place you hold stock exists with the exact name you will reference. A mismatched SKU or a renamed location is exactly the kind of quiet error this first pass is meant to surface. For the field-by-field mapping behind these columns, the Stocky CSV migration guide walks the structure.

Check which items are tracked and which are not

A quantity you are not tracking is not a quantity you can review, so separate the two before you trust any number. Export the inventory to see what Shopify actually holds: Shopify inventory CSV files can export current inventory quantities and update quantities for products in each location, which gives you a per-location view of what is being tracked. Prefer the All states export, which includes separate rows for each location with columns for all inventory states and provides protection against accidental overwrites on import, because it shows the full picture rather than a single number. Anything that does not appear with a managed quantity is an item you are not tracking, and that is a decision to make on purpose rather than discover mid-reorder. Note those items now so a buy list later does not treat an untracked product as if its count were reliable.

Compare inventory quantities with recent reports

Numbers agree with themselves too easily, so check them against a second source. Shopify’s inventory reports summarize past sales and current stock to help you decide which products to prioritize when restocking, and they are not automatic reorder recommendations and do not calculate reorder quantities, which makes them a useful cross-check: a product whose report shows barely any sales but whose count looks high is worth a second look before you refill it. Where a count is wrong and you plan to correct it with a CSV, keep both the On hand (current) and On hand (new) columns so Shopify runs a safety validation that prevents accidental overwrites when the current value in your file does not match what is in Shopify. The point of comparing is to catch the figures that do not hold up before they drive a purchase, not to re-key every count. Once you are live, the ongoing version of this check is the inventory replenishment workflow after Stocky.

Review CSV files before importing or rebuilding

The files you review are the ones you pulled out of Stocky, so read them as drafts rather than trusted imports. Records you want to keep must be exported manually using Stocky’s built-in reports while the app is still running, which means the files on your disk are exactly what you have to check: confirm each column’s meaning, split product attributes from quantity data, and spot-check that SKUs and locations still match before anything writes against a live count. Supplier details sit outside this inventory review, because suppliers can’t be exported from Stocky and Shopify suppliers are created in the admin when you create a purchase order rather than uploaded, so a supplier list is reference material you re-enter by hand, not a file you check here. The full file-by-file pass, including how to split the fields and catch mismatches, is the Stocky CSV cleanup guide, and what to pull out of Stocky in the first place is exporting Stocky data before the sunset.

Separate dead-stock risk from low-stock urgency

An audit is also the moment to be honest about what is worth reordering at all, because a clean count on a product nobody buys is still money you should not spend again. As you review, flag the slow movers and the overstock separately from the items that are genuinely running low, so a buy list built afterward does not refill shelves that are already too full. This is its own review with its own signals, and it reads the same quantities you are checking here: reviewing dead stock after Stocky tells the slow movers apart from real low-stock urgency, which is the work of separating dead stock from low stock. Doing that separation during the review keeps a fresh setup from carrying old overstock straight into a new order.

Connect the audit to buy lists and purchase orders

A review is only worth the effort if it changes what you buy next, so carry its results into the buying workflow. A buy list only points at the right products when the SKUs and on-hand figures behind it are accurate, which is why a buy list after Stocky is more reliable on records you have checked. When a buy decision becomes an order, it lands in a native record: a Shopify purchase order records the products, their costs, and the quantities ordered from a supplier. Old purchase-order history does not follow you into that record, since historical Stocky data, including old purchase orders and stocktakes, won’t automatically move into Shopify, so keep those exports as notes rather than trying to re-key them. The difference between a flexible working list and the native order of record is the CSV versus PDF purchase orders comparison, what native purchase orders cover is set out in purchase orders after Stocky, and deciding what to reorder and when is reorder planning after Stocky.

Shopify inventory audit checklist after Stocky

Run this short review so the audit stays a deliberate pass rather than a vague good intention. Export your product CSV and confirm the products, variants, and SKUs you sell are present with the names you expect. Export the inventory CSV and confirm each location exists exactly, and note which items are tracked and which are not. Compare your on-hand counts against recent inventory reports and flag anything that does not agree. Read each CSV before you import it, keeping the On hand columns so the safety validation runs, and treat supplier details as re-entry notes rather than an import. Separate the slow movers and overstock from genuine low stock before any buy list is built. One deadline frames the timing: Stocky will not be available after August 31, 2026, so run your review while you can still compare against Stocky, and for the exact dates see the Stocky shutdown timeline. For the wider tooling choice once your records are clean, see what to use after Stocky, and the organizing sequence for the whole data-prep is the Stocky migration setup checklist.

Limitations

A Shopify inventory audit after Stocky is a review habit, not a Shopify feature and not a service, and this guide does not cover every workflow Stocky used to support. It is not a professional accounting, tax, legal, or financial audit, and it is not an audit service anyone performs for you; it is a checklist you run on your own records. It does not create Shopify purchase orders, it does not import Stocky purchase orders, and it does not create a Stocky supplier CSV, because suppliers cannot be exported from Stocky at all. It is not a one-click migration, and none of it is demand forecasting; the calls you make about each record are judgement a person applies, not steps to run blindly. It does not replace your own review of each record, and Shopify’s inventory records, purchase orders, suppliers, and reports still need source-backed checks against your own store. For the one slice where supplier reliability is the heart of the work, the existing kijun app is one option, scoped honestly: it builds 0-100 supplier scorecards from purchase orders recorded in kijun, on supported supplier and vendor records, and it does not forecast demand or reorder for you. See how supplier scorecards work after Stocky.

This article was drafted with AI assistance and checked against cited sources through kijun’s editorial workflow. Last updated: 2026-07-01.

Stocky and Shopify are trademarks of Shopify Inc. kijun is not affiliated with or endorsed by Shopify.