Searching, Filters, and Views
Summary
Nearly every grid in Flxpoint shares the same tools for finding and displaying data: a keyword search bar, field filters, configurable column Views, and CSV exports, with every searchable field also exportable.
Nearly every grid in Flxpoint shares the same tools for finding and displaying data: a keyword search bar, field filters (saved or default), configurable column Views, and dynamic CSV exports. Every field you can search on, you can also export.
- Search bar: keyword search across SKU, MPN, UPC, and Title by default.
- Filter by field: build AND/OR conditions and save them for reuse.
- Views: configure which columns show in the grid.
- Export: export any searchable field to CSV, with custom headers.
- Default filters: Sources, Channels, and Statuses on every screen.
- Tags: filter by tag to work with a set of records.
| Type | How it works |
|---|---|
| Search bar | Keyword match; by default searches Variant SKU, MPN, UPC, and Title. Use the gear icon to add other fields (Ctrl/Cmd-click for several). |
| Filter by field | Conditional filters (Equals, Does Not Contain, Within Last, and more), combined with AND or OR. |
| Date range | Start and end dates, or one side only; switch to date-and-time for minute precision. |
| Default filters | Sources, Channels, and Statuses, present on each screen (Ctrl/Cmd-click to select several). |
| Action | Result |
|---|---|
| Plus beside Filters (AND) | Adds another field; results must meet all conditions. |
| Plus to the right of a field (OR) | Adds an alternative; results match any condition. |
| Start and end date | Results between the two dates. |
| Start date only / end date only | Results after that date / before that date. |
- Adding a column on the fly (Ctrl/Cmd-click a column header) is discarded on refresh or when you switch views. To keep a column layout, save it as a View.
- The search bar only checks four fields by default: Variant SKU, MPN, UPC, and Title. To search other fields, add them with the gear icon.
- Use Manage Filters to save a filter (nest into folders to organize), and Save View to keep a column set. Otherwise your setup resets.
- Every searchable field is exportable and every export is CSV. You control which fields are included and each field’s header.
- The channelCount attribute is available on product parent and variant grids. This field allows you to filter and export products based on the number of connected sales channels they are associated with, utilizing an optimized search pattern for high performance even with large datasets.
- You can filter product and inventory grids using UPC as an identifier. In the grid filter panel, UPC is available as a selectable field within both the 'contains fields' and 'exact match' identifier filter types, allowing for more precise searches alongside SKU and other identifiers.
The filter builder uses dynamic comparators based on field type. Fields that always contain a value, such as Order Number or Order Status, do not show 'Empty' or 'Not Empty' options. Conversely, fields that can be blank, such as a Tracking Number, include these options to help you identify missing data. Boolean (Yes/No) fields that can be unset also provide 'Empty' and 'Not Empty' comparators alongside the standard 'Equals' choice. These logic updates apply across all primary grids, including Orders, Inventory, and Listings, while existing saved filters using these comparators continue to function as expected.
