Bulk Edit Product Quantity

Update inventory for many products at once — including per-location stock — using DataEase with dynamic “quantities” columns and the total “inventoryQuantity” field.

Steps:

1. Export Products with Variants

In DataEase, create a New Export → Products. Include at least: product id, handle, variantId, variantSKU, inventoryQuantity, and the dynamic “Inventory quantities” columns. (They appear per location, e.g., location: Warehouse A”, location: Warsaw Hub”.)

Use filters (tag, vendor, collection, status, out_of_stock_somewhere …) to target the right items.

2. Edit quantities

• Single-location stores: change inventoryQuantity (total on hand) to the exact number you want.
• Multi-location stores: edit the dynamic columns location: {Location Name}. You can enter absolute values (e.g., 10) or relative adjustments (e.g., “+5”, “-3”). Keep the column headers and location names exactly as exported.
• Set variantCommand = UPDATE for rows you want to change.

3. Import & validate

In DataEase, create a New Import, upload the file, map columns (Variant ID or SKU → variant; inventoryQuantity and/or the dynamic quantities columns), and run Validation.

Open the validation file and review the “Validation Status” column; fix any issues.

4. Run the import

After completion, download the result file. Spot-check a few products in the admin to confirm new stock levels (including per location) are applied.

Tips

• Use one approach per row: either set total via inventoryQuantity or set per-location via the dynamic quantities columns.
• Prefer matching by Variant ID; use SKU only if it’s unique and stable.
• Use non-negative integers for absolute values; relative adjustments are supported only in the dynamic quantities columns (e.g., “+5”, “-3”).
• To zero stock at a location, put 0 in that location’s dynamic column.

Minimal CSV (example) / Update total quantity (single location)

Minimal CSV (example) / Update per-location quantities (dynamic columns)

References

• Shopify Variants: export/import steps, commands, and fields.