Start Free Trial
Start Free Trial

Bulk hide or delete Shopify products without images

featured - export and delete hide Shopify products without images Matrixify Excel XLSX CSv

When you have imported data from your supplier or just have older Products, you might need to bulk hide or delete Shopify Products without Images.
Let’s take a look at this quick tutorial on how to do just that by using the Matrixify app.

Steps, in short, to hide or delete Shopify Products without images.

  1. Export Products with Basic columns and Images.
  2. Edit the exported file.
  3. Save and import your file.
  4. Enjoy your updated Products.

1 - export and delete hide Shopify products without images Matrixify Excel XLSX CSv

1. Export Products with Basic columns and Images

On the Matrixify app Home page “Export” section press the “New Export” button to create an export in the app.

We suggest selecting export format “Matrixify: Excel”. It will export to an Excel XLSX file which is a lot more user-friendly and easier to work with than a CSV file.
If you prefer CSV, you can select the “Matrixify: CSV” export format.

Select to export “Products” by clicking the “select sheets” button. Then select “Basic Columns” and “Images”.

Exporting Images

You do not need to select any other export checkboxes or change any export options.

Start the export by pressing the “Export” button.
Once it finishes press the “Download Exported File” button to download the file.

Download Exported file

2. Edit the exported file

Now that you have the file, it can be edited to hide or delete Shopify Products without images.

2.1. Remove products from the file that have images

In the file you can see some products have multiple rows, it means that this product has multiple images.
Filter the exported file by Image Src column to show only rows that are not empty.

4 - export and delete hide Shopify products without images Matrixify Excel XLSX CSv

Now select all the filtered rows except column headers, right-click on them and select “Delete Row”.

5 - export and delete hide Shopify products without images Matrixify Excel XLSX CSv

Remove the Filters from the Image Src column and you should be only left with rows of Products that do not have any values in the Image Src column. It means that those Products do not have any images and you can hide or delete them.

6 - export and delete hide Shopify products without images Matrixify Excel XLSX CSv

2.2. Set values to hide or delete products without images

Now that you have a list of products that do not have any images you can decide what we want to do with those Products.

Delete Shopify products without images

To delete these Products you need to set column Command to value DELETE.

7 - export and delete hide Shopify products without images Matrixify Excel XLSX CSv

Hide Shopify products without image

To hide these Products from your store set column Status to value Draft.

When setting products to Draft status, Command column stays the same as when it was exported.

8 - export and delete hide Shopify products without images Matrixify Excel XLSX CSv

3. Save and import your file

Once you have finished editing the file you can save it and head back to the Matrixify app in your store.
Upload your file in the apps Home page Import section.

You do not need to select or change any import options. Wait for the app to analyze the file, double-check that product count and other job details look correct, and start the import.Deleting Products with no Images

If you set products to be hidden from the store, you will see progress on how many Products are Updated, if deleting Products you will see how many Products are being deleted.

4. Enjoy your updated Products

After the import is finished, you can go and check your updated Products in your Shopify admin!

10- export and delete hide Shopify products without images Matrixify Excel XLSX CSv

Good to know!