How to Filter and Export your Products List on Shopify

Chien Nguyen
Chien Nguyen September 19, 2018

Share:

In the case, you have a long product list which you only want to change some of your goods but not all of them, how can you do it? You can add a filter to shorten the list in your CSV file which which makes things easier for you rather than dealing with your entire list.

Related Posts:

Below is the writing that demonstrates How to filter and export your products list on Shopify.

How to filter your products list on Shopify

Step 1: Open product list

On the left-hand side of the admin screen of Shopify, go to Product.

filter your products 1

Step 2: Click Filter

On the top of the page, hit Filter.

filter your products 2

Step 3: Select filter condition

A small dialog box appears on the screen, you can select the filter in the menu Show all product where and your items will be classified into the following condition:

  • Availability: demonstrate the number of products you have in stock

  • Publishing error: it will show the items that have publishing errors when you upload them from a different channel from Online Store

  • Product types: display the product in categories

  • Product vendor: show the suppliers of the commodities

filter your products 3

Step 4: Select value tagged with product

Select the value tagged with your product in the box select a value. For example, the goods will be displayed according to their availability on different channels like Facebook, online store and point of sales.

filter your products 4

Step 5: Click Add filter

Hit Add filter, the screen will display the commodities that satisfied your condition and tagged values.

How to export your products list on Shopify

After finishing adding your filter on your product list, we continue with how to export your product

Step 1: Click Export

On the product page, click on the Export button which has an upward arrow on the top of the page.

export your products 1

Step 2: Choose export option

A dialog box will show up and ask what you would like to export. Remember to choose the option to export only the products matching your filter. The choice is either to export goods on your current page or n products matching search (n is the number of products)

export your products 2

Step 3: Choose export file

Choosing the type of CSV file that you want for export.

I suggest you select CSV file for Excel, Numbers, or another spreadsheet program if you want to use a spreadsheet program to adjust your CSV file. If you plan on using a plain-text editor, please choose plain CSV file.

export your products 3

Step 4: Export products list

Please click on the Export products button, a notification will show up to inform you the number of products and a CSV file will be downloaded to your computer or emailed to you.

If you export 50 commodities and below (one page), the CSV file will be downloaded by your browser. For 51 and more( more than one page), the CSV file will be sent to you and the owner of the account.

export your products 4

After making any changes, you can import the edited version of your CSV back to Shopify.

Conclusion

This writing is a basic guide for you on How to filter and export your products list on Shopify. I hope you have a great time reading and applying this guideline while running your shop, and if you want more similar posts like this one, check out our Shopify Tutorials.

Products

Use Shopify Image Editor Hide One or All Products Hide Out-of-Stock Products in Default Catalog Collection Hide Out of Stock Products from Collections Mail Gift Card to Customer Export Gift Card Products to CSV View Product's Inventory History Use Custom Logo on Apple Wallet Passes Use Custom Banner on Apple Wallet Passes Update Automatic Fulfillment Settings of Gift Cards Publish Gift Card Product Filter Gift Cards Disable Gift Card Remove Gift Card Denomination Add Gift Card Product to Collection Enable Apple Wallet Passes Disable Apple Wallet Passes Change Text and Background Colors on Apple Wallet Passes Change Sort Order for Products in a Collection Change Gift Card Expiry Settings Change the Featured Image of Collection Disable Shipping for Digital Product Receive Inventory Import Products After Making Changes to CSV File Enable Inventory Tracking Common Import Issues Issue Gift Card Information Issue Gift Card Import Products With a CSV File Create Transfer Sort Product List Filter Product List Edit Theme Settings Change the Availability of Collection Add or Update a Gift Card Product Filter and Export Products List Export Products Add Links to Collections Change Name or Description of Collection Adjust Inventory Levels Set Up Inventory Tracking Search Product Add Multiple Product Images to CSV File Import CSV Files into Google Sheets Edit Variants In a New Way Delete Variant Edit Product's Options Scan Barcode With Device's Camera Remove Product Edit Search Engine Listing Preview


Chien Nguyen
Chien Nguyen
Shopify Expert. My name is Chien, I am a Shopify expert and also a customer supporter with over 4 years of experience. I had done no less than 400 custom work projects in Shopify like building a store from scratch, adding custom features, installing apps, optimizing speed and SEO, etc

Comments for Filter and Export Products List



People also searched for

Subscribe

Stay in the know

Get special offers on the latest news from AVADA.

Earn $10 in reward now!

Earn $10 in reward now!

comment
iphone
go up