Your store's category settings can be configured in a variety of ways to display products to your customers. This article will explain how you can configure your store's category settings to display a list of products based on price range (e.g. products priced between $10 and $50).

Configuring your Category

  1. Log in to your Admin Area and go to Inventory > Categories.
  2. Hover over the category you want to modify and select Edit.
  3. Enter into the Category Name field the appropriate range you wish to configure for the category (for example, "$50-$100").
  4. Under Advanced Settings > Misc in the Custom SQL Filter field, enter the SQL query that will return all products in your store within the price range you wish to configure and click Save.

Example 1 - Products Under $500

To create a category displaying all items under $500, the SQL would be:

ProductPrice <= 500.00

Example 2 - Products Between $50 and $100

To create a category displaying all items priced $50 - $100, the SQL would be:

ProductPrice BETWEEN 50.00 AND 100.00

Example 3 - Products Less than $50 or More than $100

If you want to create a category displaying all items less than $50 or more than $100, the SQL would be:

ProductPrice < 50 OR ProductPrice > 100
Did this answer your question?