---
title: Configuring Categories to Display Items by Price Range
description: Your store's category settings can be configured in a variety of ways to display products to your customers.
---

[Skip to content](https://help.volusion.com/s/configuringcategoriestodisplayitemsbypricerange#main-content)

English - United States

Show submenu for translations

![Volusion Logo](https://help.volusion.com/hs-fs/hubfs/Color_Logo_Horizontal.png?width=1500&height=1500&name=Color_Logo_Horizontal.png)

Open main navigation

Close main navigation

- English - United States
  
  Show submenu for translations
- [Contact Us](https://volusion.com/contact)

[Contact Us](https://volusion.com/contact)

 Search the Help Center

- There are no suggestions because the search field is empty.

1. [Volusion Help Center](https://help.volusion.com/s?hsLang=en-us)
2. [V1](https://help.volusion.com/s/v1?hsLang=en-us)

# Configuring Categories to Display Items by Price Range

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

```
ProductPrice < 500
```

Example 2 - Products Between $50 and $100

```
ProductPrice BETWEEN 50.00 AND 100.00
```

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

```
ProductPrice < 50 OR ProductPrice > 100
```

- [Getting started](https://help.volusion.com/s/getting-started?hsLang=en-us)
- [Manage Your Store](https://help.volusion.com/s/manage-your-store?hsLang=en-us)
- [Marketing for Success](https://help.volusion.com/s/marketing-for-success?hsLang=en-us)
- [Volusion Payment Powered by Stripe](https://help.volusion.com/s/volusion-payment-powered-by-stripe?hsLang=en-us)
- [Partner Marketplace](https://help.volusion.com/s/partner-marketplace?hsLang=en-us)
- [Support](https://help.volusion.com/s/support?hsLang=en-us)
- [V1](https://help.volusion.com/s/v1?hsLang=en-us)
- [Security](https://help.volusion.com/s/security?hsLang=en-us)

[![Volusion Logo](https://help.volusion.com/hs-fs/hubfs/Color_Logo_Horizontal.png?width=1500&height=1500&name=Color_Logo_Horizontal.png "Volusion Logo")](https://volusion.com/)

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2026, Volusion