· DataEase · Tutorials  · 2 min read

Bulk Update Multi-Location Inventory

Updating variant stock per location for many products manually can be extremely time-consuming. DataEase makes it easy: export your product variants, edit dynamic quantities: {Location} columns in Excel or CSV, and import them back to Shopify—all with validation.

🎯 Goal

Update variant stock per location in bulk using CSV/Excel and DataEase’s dynamic quantities: {Location} columns (and, if needed, the total inventoryQuantity field).

📋 Step-by-Step Instructions

1. Export Products with Variants

In DataEase, go to New Export → Products. Include at least:

Identifiers:

  • id
  • variantId (recommended)
  • Optional: handle, variantSKU

Inventory (per location):

  • Dynamic quantities: {Location} columns

Optional:

  • Total stock: inventoryQuantity (sum across locations)
  • Titles for easier review: title, variantTitle

2. Filter for the Right Scope

Use Collection ID to limit catalog scope (optional).

Use Inventory locations to include only the locations you want to edit.

3. Edit Quantities in Excel/Sheets

Open the exported file in Excel or Google Sheets. For each row you want to update:

Per-location (recommended): Change values in the dynamic columns quantities: {Location Name}.

  • Enter absolute numbers (e.g., 12)
  • Or enter relative adjustments (e.g., +5, -3)
  • Keep column headers and location names exactly as exported

Total only (single-location stores): Update inventoryQuantity.

  • Set variantCommand = UPDATE for rows you want to change
  • Leave a location column blank to keep it unchanged

When done, save the file as .xlsx or .csv.

4. Import & Validate

  1. In DataEase, start New Import
  2. Upload your edited file
  3. Map columns:
    • Variant ID/SKU → variant
    • Dynamic quantities: / inventoryQuantity
  4. Run Validation

Fix any errors flagged in Validation Status (e.g., negative results, unknown locations).

5. Run the Import

After validation passes, click Run Import to apply your inventory changes to Shopify.

Once complete, spot-check several products in Shopify Admin to confirm per-location stock has been updated.

📝 Important Notes

  • Use Variant ID for the most reliable matching — use SKU only if unique
  • Relative edits (+5, -3) are supported only in dynamic quantities: columns; final stock cannot go below 0
  • If your goal is to show items as Sold out, set all relevant location columns to 0 (and consider disabling “Continue selling when out of stock” separately)
  • Locations not present as columns won’t be changed

💡 Minimal CSV Examples

Per-location absolute values:

variantId,variantCommand,quantities: Warehouse A,quantities: Warsaw Hub
gid://shopify/ProductVariant/111,UPDATE,12,0
gid://shopify/ProductVariant/222,UPDATE,5,7

Per-location relative adjustments:

variantId,variantCommand,quantities: Warehouse A,quantities: Warsaw Hub
gid://shopify/ProductVariant/333,UPDATE,+5,-3

Single-location total:

variantId,variantCommand,inventoryQuantity
gid://shopify/ProductVariant/444,UPDATE,25

🎉 That’s it!

Your multi-location inventory is now updated in bulk.
If you run into any issues or have questions, feel free to contact our support team.

Share: