· DataEase · Tutorials  · 2 min read

Mark Products Sold Out in Shopify

Marking many products as Sold out manually can be time-consuming. DataEase makes it easy: export your product variants, set inventory to 0, disable “Continue selling when out of stock,” and import them back to Shopify—all in just a few steps.

🎯 Goal

Mark many products as Sold out by setting variant inventory to 0 (and disabling “Continue selling when out of stock”) using CSV/Excel and DataEase.

📋 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

Stock:

  • inventoryQuantity (total) and/or dynamic quantities: {Location} columns (e.g., quantities: Warehouse A)

Policy (optional):

  • Variant’s “Continue selling when out of stock” field (appears as variantContinueSelling or inventoryPolicy in exports—use whichever your export shows)

Tip: Use filters like Collection ID, Inventory locations, or out_of_stock_somewhere to narrow the set.

2. Edit Stock to Zero

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

Single-location: Set inventoryQuantity = 0

Multi-location: Set each relevant quantities: {Location} = 0 (keep column headers exactly as exported)

Set variantCommand = UPDATE for rows you change.

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

Turn off “Continue selling when out of stock” for these variants:

  • Set variantContinueSelling = FALSE or
  • Set inventoryPolicy = DENY (depending on your export’s field name)

4. Import & Validate

  1. In DataEase, start New Import
  2. Upload your edited file
  3. Map columns:
    • Variant ID or SKU → variant
    • Inventory fields
    • Policy field
  4. Run Validation

Fix any issues flagged in Validation Status.

5. Run the Import

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

Once complete, spot-check a few products on your storefront—status should be ACTIVE, variants at 0, and the UI should show Sold out.

📝 Important Notes

  • Keeping Product status = ACTIVE preserves product pages while showing “Sold out.” To hide instead, set status = DRAFT (different workflow)
  • Use Variant ID to match reliably — use SKU only if unique
  • For per-location control, combine Inventory locations filter with dynamic quantities: columns
  • Use non-negative integers — 0 means out of stock

💡 Minimal CSV Examples

Set total stock to zero (single location):

variantId,variantCommand,inventoryQuantity,variantContinueSelling
gid://shopify/ProductVariant/111,UPDATE,0,FALSE

Set per-location stock to zero (multi-location):

variantId,variantCommand,quantities: Warehouse A,quantities: Warsaw Hub,variantContinueSelling
gid://shopify/ProductVariant/222,UPDATE,0,0,FALSE

Note: If your export exposes policy as inventoryPolicy, use DENY instead of FALSE.

🎉 That’s it!

Your products are now marked as Sold out in bulk.
If you run into any issues or have questions, feel free to contact our support team.

Share: