How to bulk delete products with zero inventory?

Shopify Discussion

Topic summary

Bulk removal of products with zero inventory across all variants, without affecting items that still have in-stock variants. In Shopify, the user’s automated Collection rule “Inventory Stock Less Than 1” captures products that only have some variants at 0, not exclusively products entirely out of stock.

Variants are product options (e.g., sizes) with separate stock counts; Collections are rule-based groups of products. Because export reports list inventory per variant, verifying whole-product stock status is time-consuming.

Manual deletion (sorting by low inventory and using Shopify’s 50-item batch delete) is impractical for thousands of products. The user seeks a scalable method to purge obsolete, fully out-of-stock entries safely.

Suggested solution: Use the third-party app “Smart Bulk Delete Products” to delete all out-of-stock products. A screenshot and a YouTube demo link are provided to show how it works.

Outcome: No confirmation from the original poster. The discussion remains open; next step is to evaluate and test the suggested app with care to ensure only fully out-of-stock products are removed.

Summarized with AI on January 19. AI used: gpt-5.
1

I’ve done some searching, but I haven’t had much luck finding a clear way to delete the full product entries and variants if there is 0 inventory across the full entry.

Using Collections I’ve made one using “Inventory Stock Less Than 1” but it still populates with products that have inventory, just maybe a 0 in a particular size. What I’m trying to do is purge our inventory of obsolete entries that are out of stock completely, without breaking items that are current with certain variants that are out of stock.

I’d sort by low inventory and do it manually, but our inventory is a few thousand items strong and that wouldn’t be realistic going 50 items at a time. At the same time exporting a report goes by individual variants, and manually going through the inventory to make sure I’m not breaking them is a time intensive task.

Any help would be much appreciated!

2 Likes
2

Hi Eric,

It is possible to delete all out-of-stock products in your store by using our app, “Smart Bulk Delete Products.”

movsumov_0-1694333454759.png
movsumov_0-1694333454759.png1384×1170 79.7 KB

Watch our demo below to see it in action.