How to Bulk Update Shopify Inventory After a Stocktake (Without the Spreadsheet) | AssetScope

Stocktakes are a necessary evil for any Shopify store that holds physical inventory. The count itself is the easy part — the hard part is getting those numbers back into Shopify. For stores with a few dozen products, manual entry is tedious but feasible. For stores with hundreds or thousands of variants across multiple locations, the native Shopify admin becomes a genuine bottleneck. This guide covers the pain points, the native options, and a faster approach.

Why Shopify Inventory Management Becomes Painful at Scale

Shopify’s inventory system works well enough for small stores. You open a product, find the variant, update the quantity, and save. But inventory is tracked at the variant level, not the product level. A store with 500 products averaging 4 variants each has 2,000 individual inventory records to manage. After a full stocktake, every one of those records may need updating.

The native Shopify admin provides no way to update inventory in bulk from a list. You can use the bulk editor to change quantities, but it only shows 50 products at a time and requires you to scroll, find each variant, and type the new value. For a 2,000-variant store, this means 40 pages of scrolling and typing — a process that takes an entire working day and is prone to data entry errors.

The problem compounds for stores with multiple locations. Shopify tracks inventory separately at each location, which means a store with 2,000 variants across 3 locations has 6,000 individual inventory cells to update. At this scale, manual entry is not a viable option.

What Happens During a Shopify Stocktake — and Where It Breaks Down

A typical stocktake follows a straightforward process. Staff count physical stock, record the numbers on a spreadsheet or scanner, and then the totals need to be entered into Shopify so that the system of record matches reality. The first two steps are well-supported by barcode scanners and spreadsheet templates. The third step is where Shopify falls short.

The gap between the physical count and Shopify’s recorded inventory is where errors accumulate. Products that were sold but not yet despatched, returns that were restocked but not scanned back in, and items damaged or lost in the warehouse all contribute to discrepancies. A stocktake is supposed to correct these discrepancies, but if entering the corrections takes so long that new transactions occur during the process, the numbers are already drifting again by the time you finish.

Speed matters. The faster you can reconcile your stocktake against Shopify’s records, the smaller the window for new discrepancies to accumulate.

How to Bulk Update Inventory in Shopify’s Native Admin

Shopify provides two native approaches to bulk inventory updates. The first is the bulk editor: go to Products, select the products you want to update, click Bulk Edit, and add the Inventory columns. You can then type new quantities directly into the table. The limitation is pagination — 50 products per page, no way to filter by location, and no way to paste a column of values from your stocktake spreadsheet.

The second approach is the inventory CSV import. Go to Products → Inventory → Import, and upload a CSV with columns for Handle, Option1 Value, Option2 Value, Option3 Value, Location, and Available. This is faster for large updates but carries the usual CSV risks: encoding errors, column mismatches, and the fact that any missing row will not be updated (it will not be zeroed out — it will simply retain its old value, which may be wrong).

Neither approach supports the most common stocktake workflow: “set the quantity for this variant at this location to exactly this number.” The native tools can add or subtract from the current quantity, but setting an absolute value requires you to calculate the adjustment yourself.

The Three Inventory Adjustment Types: Add, Subtract, Set To

Shopify’s native inventory adjustment works on a delta basis: you add or subtract from the current quantity. If a variant currently shows 15 in stock and your stocktake counted 12, you need to calculate the adjustment (−3) and enter that. This is fine for a single product, but when you are processing hundreds of variants, calculating deltas for every line is slow and error-prone.

A set-to operation is what most stocktakes actually need: set this variant’s inventory to exactly this number, regardless of what Shopify currently shows. The system calculates the delta internally and applies it. This eliminates the mental arithmetic and the risk of entering the wrong adjustment direction.

AssetScope’s Shopify bulk inventory editor supports all three operations: add a fixed quantity to selected variants, subtract a fixed quantity, or set the absolute value. The set-to operation is designed specifically for post-stocktake reconciliation.

Multi-Location Inventory in Shopify: The Extra Complexity

Stores using Shopify’s multi-location inventory face an additional layer of complexity. Each variant has a separate inventory record at each location. A product with 5 variants across 3 locations has 15 individual inventory cells, and each one may need a different post-stocktake value.

The native bulk editor does not handle multi-location inventory well. It shows one location at a time, and switching locations reloads the page and loses any unsaved work. The CSV import approach can handle multi-location updates but requires you to include the location name in every row — and location names must match exactly, including capitalisation.

For multi-location stores, a dedicated inventory tool that shows all variants, all locations, and all quantities in a single view is not a convenience — it is a practical necessity. Without it, the likelihood of entering a correct value at the wrong location (or for the wrong variant) is high enough to undermine the purpose of the stocktake.

How to Bulk Adjust Stock Levels Across All Variants in One Pass

The fastest approach to post-stocktake inventory reconciliation is a dedicated bulk inventory editor that supports set-to operations. The workflow is straightforward: scan your catalogue to load current inventory levels, enter the new values from your stocktake (or paste them from your spreadsheet), and apply all changes in a single batch.

AssetScope’s Shopify bulk inventory editor follows exactly this pattern. Select the products or filter by vendor, product type, or collection to narrow the view to the relevant subset. Enter new quantities directly in the table. Preview the changes — including the delta from the current value — before applying. All updates are written via Shopify’s API in a single batch.

If you are doing this regularly, AssetScope’s inventory editor handles it in one step — free for 7 days. The preview-before-apply step catches data entry errors before they reach your live inventory, which is the single most important safeguard in any bulk inventory operation.

Zeroing Out Discontinued Lines in Bulk

One of the most tedious post-stocktake tasks is zeroing out inventory for discontinued products. When a product line is dropped, every variant at every location needs its inventory set to zero — otherwise the product appears as available in your storefront and customers can place orders for items you no longer stock.

In the native Shopify admin, this means opening each product, navigating to each variant, setting the quantity to zero at each location, and saving. For a product line with 30 variants across 2 locations, that is 60 individual edits. Multiply by the number of discontinued lines in a typical seasonal turnover and the task can consume an entire day.

A bulk inventory editor makes this a single operation: filter to the vendor or product type being discontinued, select all, set inventory to zero, apply. The products remain in your catalogue (preserving SEO equity and order history) but are no longer purchasable. If you later want to remove them entirely, a bulk status manager can archive or draft them in one step.

See all 15 tools in AssetScope →