Start Free Trial
Start Free Trial

Hide out-of-stock Products from Shopify Store

Out of Stock Products|Export Products and Variants|Exported Products with Quantities|Insert Pivot Table|Fill Pivot Table|Sorted Pivot Table|Unpublished Products||

Sometimes you don’t want to show Products that are out of stock on your Shopify store.

Such products can be easily hidden using the property Published = FALSE, by the app. Let’s take a look at 3 cases:

  • if a Product has only one Variant and it is out of stock, then we will hide this Product;
  • if a Product has several Variants and only some of them are out of stock, we will not hide this Product. Customer will be able to see the Product and select Variants. If out of stock variant will be selected, the appropriate message will appear. Basically, we will not hide this product and any of its Variants;
  • if a Product has several Variants and all of them are out of stock, then we will hide this Product.

Let’s see how it is done, following these steps.

1. Export Products with Variants.

Exporting Basic Columns and inventory/variants

Download and open the exported file. There is Variant Inventory Qty column that contains data about Variant quantities.

Exported Products with Quantities

We need to know, what products to hide. This means we need to know what Products have all Variants with quantity equals 0.

We will find them with the help of Pivot table in the next step.

2. Find all out of stock products

In the Excel file go to Insert -> Pivot Table:

Insert Pivot Table

Click OK.

Drag and Drop field Handle to the Rows, field Variant Inventory Qty to the Values. Ensure, that there is Sum of Variant…  displayed in the Values (this means, that quantities of all Variants for particular Product Handle will be summed up).

Fill Pivot Table

Now we have a table of all Product Handles and Total Variant quantity.

Let’s sort this table by Sum of Variant Inventory Qty from Smallest to Largest:

Sorted Pivot Table

Now we have the Handles for all products that are out of stock and can import them into the Shopify Store with Published column value set to FALSE (this will unpublish your products from your sales channels).

3. Import out-of-stock Products as unpublished

You can create new Excel file. It should have only 2 columns: Handle and Published. Copy Handles of all products with Sum of Variants Inventory Qty that have 0 from the Pivot Table into column Handles. Put FALSE value for all products in the column Published. Remeber to name the Sheet Products.

Unpublished ProductsSave the file and import it with the app.

Hide Products Import Successfully Completed

Let’s check on the Store page:

Out of stock products are hidden

5 products of 10 are displayed, as 5 were out of stock and are unpublished at the moment.


Good to know.

  • Remember to put Published = TRUE, when you have these Products back in Stock. You can do that in a very similar manner, just find all products with Sum of Variants Inventory Qty > 0 and import their Handles with Published = TRUE.