Filter records in the admin console
Summary
The Optimizely Configured Commerce Advanced Filter functionality makes it easy to find the perfect product, customer, or order record in just a few clicks. Sort product records by model number, customers by city, and order history by Sales Rep, or choose from any of the numerous options to personalize your record view.
Advanced filter functionality
The Advanced Filter is available in multiple sections of the Admin Console, including Sales, Catalog, and Customers. To access the Advanced Filter, click a correlating section, like Customers.
The Category filter is available on the Products page in the Catalog section to filter the product list by category assignment. The filter displays a website-scoped, hierarchical category tree with search and select/deselect all options. Select a category to display only products assigned to it.
Assigning advanced filters
To activate the Advanced Filter, click Advanced Filter (down triangle) on the left side of the screen. Each Admin Console section includes its own list of filtering options; for example, Customers may be filtered by more than forty different options, including Country, Default Warehouse, and Primary Sales Rep. Click an option to add it to the List Action Bar.
Note
Once an option is added to the List Action Bar, it no longer appears in the Advanced Filter drop-down.
Click the added filter option to assign values. Different options present" different values; for example, click Country to view a list of selectable countries, and choose one or multiple countries. Once the option has been assigned a value, the value appears next to the filter option in the List Action Bar. If multiple values are assigned, the word "Multiple" appears.
To remove a filter option, click Remove (X). When a filter option is removed from the List Action Bar, it reappears in the Advanced Filter drop-down. Removing all filters resets the list and displays all records.
Custom properties defined in the Application Dictionary are available as filter options in applicable Admin Console grids. Custom property filters appear in the Advanced Filter dropdown alongside default filters. Filter by custom properties the same way you filter by default properties.
Advanced filter types
Some filter options require additional text input; for example, the Customer section's Postal Code option.
- Add Postal Code as a filter option, then click it.
- Enter a number in the text box at the top of the list, then select one of the radio button options, like Starts with. The list automatically updates to include the chosen values.
- Select Empty at the bottom of the radio button list to view all records without existing data in that field.
- Select Not empty at the bottom of the list to view all records with that field filled.
Some filter options support Boolean, or binary values; for example, the Customer section's Ignore Product Restrictions option.
- Select either Yes or No from the drop-down; both values may not be selected.
- Clear the "clutter" from the Advanced Filter values using the Show Selected option.
- Select one or multiple records using the checkboxes, then click Advanced Filter.
- Scroll to the bottom of the options list, then choose Show Selected to view only the selected records.
- Alternately, click Show Archived to view all archived records. This option is not available for non-archivable entities.