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
Log in to your Admin Area and go to Inventory > Categories.
Hover over the category you want to modify and select Edit.
Enter into the Category Name field the appropriate range you wish to configure for the category (for example, "$50-$100").
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