Hide Out-of-Stock Products in Shopify (Bulk with DataEase)

Hide many products at once when all variants are out of stock by changing product status to DRAFT via DataEase.

Steps:

1. Export Products

In DataEase, create a New Export → Products. Apply the filter “out_of_stock_somewhere” (filters products that are out of stock in at least one location). Include at minimum: id, handle, status. If you need to analyze stock by locations, also include “Inventory quantity” and “Inventory quantities” so you can confirm in Excel that all locations are zero.

2. Review the export in Excel

Use “Inventory quantity” / “Inventory quantities” to verify which products should be hidden (e.g., zero across all locations). Keep only the rows you want to hide.

3. Edit the file

Set command = UPDATE and status = DRAFT for the selected products. Save the file.

4. Run the Import

Create a New Import in DataEase, upload the edited file, map columns, and run Validation. Check the Validation Status column and fix issues if needed. Run the Import. After it completes, download the result file and confirm the selected products now have status DRAFT (hidden from the storefront).

Tips

• To unhide later, set status back to ACTIVE and import again.
• This hides entire products. If you only want to stop purchases but keep product pages visible, handle that at the variant level.
• Prefer matching by Product ID; use handle only if ID is missing.

Minimal CSV (example)

References

• Shopify Products: export/import steps, commands, and status field.