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.
- Export Products with Basic columns and Images.
- Edit the exported file.
- Save and import your file.
- Enjoy your updated Products.
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”.
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.
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.
Now select all the filtered rows except column headers, right-click on them and select “Delete Row”.
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.
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.
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.
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.
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!
Good to know!
- When doing an export, you can also apply various Filters to only export specific Products, for example, only Products with specific Tags or from specific Collections.
- See other Matrixify Product related tutorials.
- Check out tutorials on how to bulk import images in Shopify.
- Read Shopify manuals about Product Images.
