Searching for products and filtering your product list

All your products are listed in the Products area in Shopify. A list of 50 products are listed on each page. To organize the list of products, and to find products in a list that spans many pages, you can sort, search, and filter the list.

The way that your products are sorted or filtered in the Products area of the admin doesn't affect how your products are displayed in other apps or sales channels, such as on your online store. If you need to change the way that your products display to customers in your online store, then change the sort order for the products in a collection.

Sort your product list

You can sort your product list to help you find the products that you need to update or review. For example, to view which of your products are running low in stock, you can sort your product list by inventory.

By default, your product list is sorted by created date, starting from the newest product. You can change the sort order of your product list to a different sorting option, or invert the order of the sort order. For example, you can change the default created date to display the oldest product first instead of the newest.

Note

If you change the sort order of your product list in the Shopify admin on desktop, then the product list reverts to the default sort order after it's refreshed, such as when you navigate to a product's details page or to a different view. You can save an alternative sort order using the Shopify mobile app.

You can change the sort order of your product list to any of the following options:

Shopify admin product list sorting options

Sorting option	Value	Description
Product	Sorted alphabetically from A-Z or Z-A.	This option displays products by title in alphabetical order.
Created	Sorted by date from Newest first or Oldest first.	This option displays products in the order that they were created. By default, the product list is sorted by Created: Newest first.
Updated	Sorted by date from Newest first or Oldest first.	This option displays products in the order that they were last updated.
Inventory	Sorted by amount from Ascending or Descending.	This option displays products by inventory quantity.
Product type	Sorted alphabetically from A-Z or Z-A.	This option displays products by product type in alphabetical order.
Publishing	Sorted by date from Ascending or Descending.	This option displays products by publishing status.
Vendor	Sorted alphabetically from A-Z or Z-A.	This option displays products by vendor in alphabetical order.

Steps:

1. From your Shopify admin, go to Products.

2. Click the icon.

3. In the Sort by menu, select a sort option.

Edit columns in your product list

You can edit columns in both default and custom product views, and the changes that you make apply only to the product view that you're currently on. You can hide or unhide columns, as well as reorder the columns. This can help you focus your product views on the content that matters to you, and hide the content that's unnecessary.

Steps:

1. From your Shopify admin, go to Products.

2. Click the icon.

3. In the Columns section, do any of the following actions:

   • Click to rearrange a column up or down. Moving a column up places it further left in the table, and moving a column down places it further right.
   • Click or to hide or unhide a column in the table.

Filter your product list

By default, all your products are listed on the Products area of your Shopify admin. You can filter this list to display a smaller subset of the products.

Filtering your product list can help you find the specific products that you need to edit, review, or update. The following filter options are available:

• Vendors - Displays the products that are from the selected product vendor.
• Tag - Displays the products that are tagged with the specified value.
• Statuses - Displays the products with an archived, active or draft status.
• Categories - Displays the products that are included in the selected standard product category.
• Sales channel - Displays the products that are included in or excluded from a sales channel. Some sales channels might display multiple channel connections with more than one region or account for you to filter products from.
• Region catalog - Displays the products that are included in or excluded from a market.
• B2B catalog - Displays the products that are included in or excluded from a B2B catalog.
• Company location catalog - Displays the products that are included in or excluded from a B2B company location's catalog.
• Retail catalog - Displays the products that are included in or excluded from a retail catalog.
• Unassigned catalog - Displays the products that are included in or excluded from an unassigned catalog.
• Types - Displays the products that are of the selected product type.
• Collection - Displays the products that are available in a collection.
• Publishing error - If you use sales channels other than Online Store, then this displays the products that have publishing errors on the sales channel that you select.
• Gift card - Displays the gift card products available for your store.
• Combined listings - Displays only combined listings or excludes them.
• Metafields - Displays the products that have a specific metafield value. To use this feature, you must have Use as filter in admin activated in your metafield definition.

For example, if you sell clothing and want to view a list of only your T-shirts, then you can filter by the product type T-shirt. Only the products of that type will then be displayed in the product list, making it easier for you to review and update that subset of products.

If you add more than one filter, then only the products that match all of the conditions are displayed.

If you have products that need attention for compliance related concerns, then an automated pre-filtered Suspensions view is displayed.

Steps:

1. From your Shopify admin, go to Products.

2. Optional: Click All to open the view menu, and then select the view that you want to filter.

3. Select an operator and value for your filter. The available values are different depending on the filter that you select.

4. Optional: Continue typing keywords to continue adding different filters and values to refine your search:

   • To include an additional filter with an and operator to your search, click or add a space, and then start typing the name of the additional filter that you want to include.
   • To include an additional value with an or operator to a filter, add a comma, and then start typing the name of the additional value that you want to include.

5. Optional: Click the filter chips of any filter in the search bar to edit the filter.

6. Optional: To save your current sequence of filters as a new view, click Save and then give the new view a name.

Search for a product

You can find products based on words that are in their titles, descriptions, or tags.

Tip

You can use Spotlight search on your iOS device to search for orders, products, collections, and customers. Tap an item to open it in the Shopify app.

Steps:

1. From your Shopify admin, go to Products.

2. Enter the search words into the Search and filter field.

3. Press Enter on your keyboard. The product list refreshes to display only the products that have the words in the product titles, descriptions, and tags.

Search queries for products

You can search for products using a search query to improve the accuracy of your search results.

Refer to Search syntax on Shopify.dev to learn more about queries and how you can use them.

Search for products by title

You can search for products by title. Enter title:[search-term] into the search bar and replace the [search-term] with the product title. For example, if you know the exact product title that you're looking for, such as Pitcher, then you can search for title:Pitcher.

If you want to search for titles that contain a word beginning with specific characters, then you can use a prefix search. Prefix searches need to include an asterisk symbol * at the end of the search term that you're searching for. For example, searching with the query title:ani* could return the product titles 'Animals of the Jungle' Documentary, 'Best Animated Films (2000)' Box Set, and Mouse Animatronic, but wouldn't return the product title 'Baking with Vanilla' DVD.

Searching for a specific partial set of characters in the middle or end of a word isn't supported.

Search for products that use a specific metafield

You can search for products by metafield. In this example, you have a metafield for your products with a custom material definition that has Use as filter in admin activated. The metafield value in the product is silk.

To search for the products that use the silk metafield value, limit the results to products, and then search for:

metafields.custom.material:silk

Learn more about metafields.

Search for a product tag

To display products tagged with new, search for:

tag:new

However, if the word in your product tag is used in other tags, for example New Zealand, then you need to exclude results for those other tags. Limit the results to products, and then search for:

tag:new AND NOT tag:"new zealand"

Managing product views

When you search for or filter your products, you can save the search or filter as a product view so that you can use it again later. A product view is a customized view of your products based on criteria that you set up to help you manage your products more efficiently. Product views display as a menu to the left of the search bar. You can customize product views, and create, rename, or delete views. When you create a new product view, it's added as a new menu option in the search bar.

The following product views are the default views:

• All (the default, unfiltered view)
• Active
• Draft
• Archived

In any product view except All, you can make the following changes and save them to the current view or save them as a new view:

• Select filters
• Filter with a custom search term
• Rename the view
• Delete the view

Although you can't change or delete the default views, you can create a new view that is based on the All view.

The products included in saved views are updated automatically. For example, if you saved a filter for Active products, then any products that become active are added to that product view automatically.

Create a new product view

You create new product views from the default All view. You can change the filters and sort order after you save to a new view.

Note

You can only save changes to product views using your Shopify admin on your desktop computer.

Steps:

1. From your Shopify admin, go to Products.

2. Using the search bar, apply customizations to the default view, such as adding filters, editing columns, or changing the sort order.

3. Click Save.

4. Enter a name for the new view, and then click Create view.

Duplicate a product view

You can duplicate an existing view and then apply new filters or customizations to the duplicate.

Steps:

1. From your Shopify admin, go to Products.

2. Click the search bar, and then select the view that you want to duplicate.

3. Click the name of the view in the search bar, and then click Duplicate.

4. Enter a name for the new view, and then click Create view.

5. Apply customizations to the view, such as adding filters, editing columns, or changing the sort order.

6. Click Save.

Edit a product view

You can save filter changes to any view except the All view. You can also rename the product view to better describe the contents of the view. Changes to the sort order aren't saved to views.

Note

You can save changes to product views only by using your Shopify admin on your desktop computer.

Steps:

1. From your Shopify admin, go to Products.

2. Click the search bar, and then select the product view that you want to make changes to.

3. Optional: Apply customizations to the view, such as adding filters, editing columns, or changing the sort order, and then click Save.

4. Optional: To rename the product view, do the following actions:

   1. Click the product view name, and then click Rename.
   2. Enter a new name for the product view.
   3. Click Save.

Delete a product view

You can delete product views that you don't need anymore, with the exception of the default product views. Deleting a product view can't be undone.

Note

You can save changes to product views only by using your Shopify admin on your desktop computer.

Steps:

1. From your Shopify admin, go to Products.

2. Click the search bar, and then select the product view that you want to delete.

3. Click the product view name, and then click Delete.

4. To confirm the deletion, click Delete view.

Use bulk actions with a product view or filter

In any product view, you can select some or all of the products and perform bulk actions on them. You can switch between product views to continue selecting products, and apply filters or search using keywords to display only relevant products that you can also select.

Note

If you're on a desktop device, then you can click Show all selected to display only the products that you've currently selected.

Learn more about using bulk actions in your Shopify admin.

Tip

You can perform bulk actions on any product view with or without saving the filters. However, if you perform a bulk action often, then saving the filters to a product view can help you to work faster when completing the same task. For example, you might want to quickly archive all products that aren't being restocked. You can use bulk actions so that you don't have to open each product and manually archive them.

Steps:

1. From your Shopify admin, go to Products.

2. Optional: In the search bar, start typing the name of a saved view, and then select the name of the view to display only the applicable products in the products list.

3. Select the items that you want to edit.

4. Click an action, such as Bulk edit, or click ..., and then select an action from the list.

5. If you're prompted to confirm an action, then confirm your choice.

Tip

You can perform bulk actions on any product view with or without saving the filters. However, if you perform a bulk action often, then saving the filters to a product view can help you to work faster when completing the same task. For example, you might want to quickly archive all products that aren't being restocked. You can use bulk actions so that you don't have to open each product and manually archive them.

Troubleshooting product search and filtering

Finding products that have no tags

The search bar and filters in the Shopify admin don't support searching for products that are missing a specific attribute, such as products with no tags. If you search for products without tags, the results might be incomplete or unreliable.

To identify all products with no tags, export your product list and check the Tags column in a spreadsheet:

Steps:

1. From your Shopify admin, go to Products.

2. Click Export, and then select All products.

3. Click Export products. Shopify sends a CSV file to your email.

4. Open the exported CSV file in a spreadsheet application.

5. Sort or search the Tags column for blank cells. Rows with no value in the Tags column are products with no tags.

Learn more about exporting your products.