Filtering and Sorting Items
All the items that you create or import are listed in the Items module. You can filter them based on certain criteria and you can sort them based on Name, SKU or Rate.
IN THIS PAGE…
Filtering Items
Filtering items allows you to view a specific set of items based on a certain criteria. In the Items module, there is a list of default filters which you can use to filter the items. You can also create your own custom views based on the criteria of your choice. In this section, we’ll learn about using default filters and creating new custom views.
Default Item Filters
Default item filters will help you to quickly filter the items based on their criteria. The table below lists the default filters available in Zoho Billing.
Filter Name | Description |
---|---|
All | All the items in Zoho Billing will be displayed. By default, the Items module displays the items using this filter. |
Active | All the active items are listed when you use this filter. By default, all the items you create will be active unless you mark them as inactive. |
Inactive | All the items that you’ve marked as inactive will be displayed when you use this filter. |
Services | All the items where you’ve chosen the item type as Services will be displayed when you use this filter. |
To filter items:
- Go to Items module in the left sidebar.
- Click the All Items filter dropdown and select a filter.
A list of items based on the applied filter is displayed.
Custom Views
Custom Views are your own customized filters that you create by specifying a criteria. When you apply a custom view to the items, a filtered list of items is displayed.
To create a custom view:
- Go to Items module.
- Click the filter dropdown and select + New Custom View from the bottom of the list.
- Enter a Name for the custom view.
- Click the dropdown under Define the criteria section and select one of the fields from the dropdown.
- Click the next dropdown and select the appropriate condition.
- Enter an appropriate value in the next field.
- Click + Add Criteria to add another criterion and repeat the previous 3 steps.
- Click the + on each field that is listed under the Available Columns table to add them under the Selected Columns table.
- Choose if you want this filter to be displayed to every user in your organization or only to you.
- Click Save.
Now, the filter will be displayed under the default filters and you can filter the contacts based on the new criteria.
Editing Custom Views
To edit the custom view that you’ve created:
- Go to Items module.
- Click the filter dropdown and select the filter you wish to edit.
- Hover your mouse cursor next to the filter name and click on the Edit icon.
- Edit the custom view.
- Click Save.
Sorting Items
Sorting items allows you to view all the items in a particular order. You can sort any list of items based on the default sorting options that are available in the Items module. The table below gives you the list of the sorting options available.
Sort By | Description |
---|---|
Name | Sorting by Name allows you to list the items in alphabetical order or in the reverse alphabetical order. By default, the items are listed in the alphabetical order. |
SKU | Sorting by SKU allows you to list the items in the alphabetical order of the SKU or in the reverse alphabetical order of the SKU. |
Rate | Sorting by Rate allows you to list the items in the ascending order of the rate or in the descending order of the rate. |
To sort the items:
- Go to Items module in the left sidebar.
- Click the Hamburger icon and select Name or SKU or Rate, depending on the field by which you want to sort the list of items.
- Select the same option again to reverse the order in which the items are sorted. You can change the alphabetical to reverse alphabetical and ascending to descending.