Filtering options#
The Products page offers extensive filtering options that let you precisely select the products you want to work with. Filters can be combined across all sections, and the resulting selection can be saved or used to create a label or a pricing rule.
Basic filters#
Two quick filters are always available at the top of the page:
- Full-text – searches full-text in the product name, its ID, Mergado ID, and URL on the price comparison site.
- Products – a drop-down menu for quickly selecting a predefined group of products (e.g. increased, discounted, repriced, unpaired, etc.).
Next to these filters is a Saved filters bar with the filters you previously saved — click a pill to apply the filter immediately. The Manage button takes you to the management of saved filters and labels.
The + More filters button opens an extended panel with all available filters, divided into sections by data source.
Results summary#
After you apply filters, cards with summary statistics for the currently found products appear below the filter bar:
- Products found – the total number of products matching the filter (with a breakdown by individual price comparison site)
- Orders / Clicks – performance data for the selected period, including CRO
- Turnover – total turnover over the last 30 days
- Average margin – the average margin for the filtered products (if data is available)
Advanced filters (More filters)#
The advanced filter panel is divided into sections in the left menu. Each section corresponds to a different data source. Filters from different sections can be combined.
☆ Favorites#
The Favorites section shows the most frequently used filters across all sections. It contains:
| Filter | Description |
|---|---|
| Full-text | Full-text search in the product name, ID, Mergado ID, and URL |
| Product name | Searches for an exact match in the product name |
| Products | Selection of a predefined group of products |
| Assigned labels | Filtering by product labels |
| Diagnostics | Filtering by the product’s diagnostic state |
| Product ID | Exact search by internal ID |
| Mergado ID | Search by the Mergado identifier |
| Product URL on Heureka | Filtering by the product URL on Heureka |
| Exclude product | Excluding a specific product from the results |
Pricing#
Filters based on data from Pricing Fox’s pricing calculation.
| Filter | Description |
|---|---|
| Sale price | Range from–to |
| Rule | Selection of a specific pricing rule |
| Input price | Range from–to |
| Adjusted price | Range from–to |
| Price difference (from input) | The absolute difference between the input and sale price, range from–to |
| Price difference (abs. value) | The absolute value of the difference, range from–to |
| Price difference (in %) | The percentage price difference, range from–to |
| Repricing direction | Selection: increased / discounted / no change |
| Purchase price (pricing) | The purchase price used in the pricing calculation, range from–to |
| Reference price | The reference price used by the rule, range from–to |
| Markup (in %) | Range from–to |
| Margin (in %) | Range from–to |
Product#
Filters based on product data from the feed (from Mergado).
| Filter | Description |
|---|---|
| Name | Text search in the product name from the feed |
| Price | The sale price from the feed, range from–to |
| Purchase price (feed) | The purchase price from the feed, range from–to |
| VAT | The VAT rate, range from–to |
| Created | The date of the product’s first appearance in the feed, range from–to |
| Number of days in the feed | How long the product has been in the feed, range from–to |
| Changed | The date of the product’s last change in the feed, range from–to |
| CPC | The maximum cost per click from the feed, range from–to |
| Availability | The product’s availability (number of days), range from–to |
| Manufacturer | Text search |
| Supplier | Text search |
| Category | Text search |
| Category path | The full category path, text search |
| EAN | Text search by EAN code |
Heureka#
Filters based on data from the product card on Heureka. Available with an active connection to Heureka.
| Filter | Description |
|---|---|
| Product name on Heureka | Text search |
| Category on Heureka | Text search |
| Manufacturer | Text search |
| Position – Price | The product’s position by price on the card, range from–to |
| Number of stores by price | The number of offers on the card sorted by price, range from–to |
| Position – Bidding | The product’s position in bidding, range from–to |
| Number of stores in bidding | The number of stores participating in bidding on the card, range from–to |
| Number of stores | The total number of stores on the card, range from–to |
| Lowest price on the card (incl. VAT) | Range from–to |
| Highest price on the card (incl. VAT) | Range from–to |
| At TOP position | Filtering by whether the product is at the TOP position (yes/no) |
| Product rating | The average rating of the product card, range from–to |
| Number of ratings | Range from–to |
| Number of reviews | Range from–to |
Heureka – statistics#
Filters based on performance statistics from Heureka. For each metric you can choose a time period: 1d / 7d / 14d / 30d / 90d (the default is 30 days).
| Filter | Description |
|---|---|
| Clicks | The number of clicks over the selected period, range from–to |
| Orders | The number of orders over the selected period, range from–to |
| Turnover | Turnover over the selected period, range from–to |
| Costs | Advertising costs over the selected period, range from–to |
| CRO | The conversion rate over the selected period (7d/14d/30d/90d), range from–to |
| PNO | The cost-to-turnover ratio over the selected period (7d/14d/30d/90d), range from–to |
Heureka – competition#
Filters focused on competitor offers on Heureka product cards.
| Filter | Description |
|---|---|
| Competitor | Selection of a specific competitor store (search by name) |
| Shared products | Filtering by products shared with the selected competitor |
| Position | The competitor’s position on the card |
| Category | Text search |
| Manufacturer | Text search |
| Gift | Text search |
| Price incl. VAT | The competitor’s price including VAT, range from–to |
| Availability | The competitor’s availability |
| Delivery price | The competitor’s delivery price, range from–to |
| Position in bidding | The competitor’s bidding position, range from–to |
| Position by price | The competitor’s price position, range from–to |
| With a gift | Checkbox – shows only products where the competitor offers a gift |
Zboží.cz#
Filters based on data from the product card on Zboží.cz. Available with an active connection to Zboží.cz.
| Filter | Description |
|---|---|
| Diagnostics | Filtering by the product’s diagnostic state on Zboží.cz |
| Product name on Zboží.cz | Text search |
| Card URL | Text search by the product card URL |
| Category on Zboží.cz | Text search |
| Manufacturer | Text search |
| Position – Price | The product’s position by price on the card, range from–to |
| Number of stores by price | The number of offers on the card sorted by price, range from–to |
| Position – Bidding | The product’s position in bidding, range from–to |
| Number of stores in bidding | The number of stores participating in bidding on the card, range from–to |
| Position on the card | The overall position on the product card, range from–to |
| Number of stores | The total number of stores on the card, range from–to |
| Lowest price on the card (incl. VAT) | Range from–to |
| Highest price on the card (incl. VAT) | Range from–to |
Zboží.cz – statistics#
Filters based on performance statistics from Zboží.cz. For each metric you can choose a time period: 1d / 7d / 14d / 30d / 90d (the default is 30 days).
| Filter | Description |
|---|---|
| Clicks | The number of clicks over the selected period, range from–to |
| Orders | The number of orders over the selected period, range from–to |
| Turnover | Turnover over the selected period, range from–to |
| Costs | Advertising costs over the selected period, range from–to |
Zboží.cz – competition#
Filters focused on competitor offers on Zboží.cz product cards.
| Filter | Description |
|---|---|
| Competitor | Selection of a specific competitor store (search by name) |
| Shared products | Filtering by products shared with the selected competitor |
| Category | Text search |
| Manufacturer | Text search |
| Price incl. VAT | The competitor’s price including VAT, range from–to |
| Availability | The competitor’s availability, range from–to |
| Delivery price | The competitor’s delivery price, range from–to |
| Pickup price | The competitor’s in-person pickup price, range from–to |
| Position in bidding | The competitor’s bidding position, range from–to |
| Position by price | The competitor’s price position, range from–to |
Google Merchant Center#
Filters based on Google Merchant Center data. Available with an active connection to GMC.
| Filter | Description |
|---|---|
| Diagnostics | Filtering by the product’s diagnostic state in GMC |
| Suggested price | The price suggested by Google for optimal performance, range from–to |
| Benchmark price | The typical price of the product in Google Shopping, range from–to |
GA4#
Filters based on Google Analytics 4 data. Available with an active connection to GA4. For each metric you can choose a time period: 1d / 7d / 14d / 30d / 90d (the default is 30 days).
| Filter | Description |
|---|---|
| Clicks | The number of clicks over the selected period, range from–to |
| Orders | The number of orders over the selected period, range from–to |
| Turnover | Turnover over the selected period, range from–to |
Shoptet – statistics#
Filters based on Shoptet data. Available with an active connection to Shoptet. For each metric you can choose a time period: 1d / 7d / 14d / 30d / 90d (the default is 30 days).
| Filter | Description |
|---|---|
| Orders | The number of orders over the selected period, range from–to |
| Turnover | Turnover over the selected period, range from–to |
| Profit | Profit over the selected period, range from–to |
Reports#
Filters based on the results of reports in Pricing Fox. They let you filter products by their inclusion in analytical reports.
| Filter | Description |
|---|---|
| Heureka Audit | Filtering by the result of the Heureka Audit (Problems / Warnings / Recommendations) |
| Zboží.cz Audit | Filtering by the result of the Zboží.cz Audit (Problems / Warnings / Recommendations) |
| Performance groups (CSE) | Filtering by inclusion in a performance group (Star, Guzzler, Zero, etc.) |
Test pricing#
Filters based on the results of test pricing — a simulation of repricing with no real impact on prices. They let you filter products by how repricing would turn out in test mode.
| Filter | Description |
|---|---|
| Test price | The resulting price in test pricing, range from–to |
| Test price difference (from input price) | The difference between the test and input price, range from–to |
| Test price difference (abs. value) | The absolute value of the test price difference, range from–to |
| Test repricing direction | Selection: increased / discounted / no change |
| Test markup (%) | The markup calculated in test pricing, range from–to |
| Test margin (%) | The margin calculated in test pricing, range from–to |
Saving and managing filters#
You can save any combination of filters with the Save filters button in the top right corner of the Products page. A saved filter appears in the bar below the search and can be re-applied with a single click. Saved filters can also be used as a basis for pricing rules or for creating a product label.
FAQ#
Can I combine filters from different sections at the same time? Yes. Filters from all sections (Pricing, Heureka, GA4, etc.) can be combined however you like – the result shows products that meet all the specified conditions at once.
Why don’t I see some filter sections (e.g. Heureka or Shoptet)? Sections are displayed only if you have the relevant connection active. Without a connection to Heureka, the Heureka, Heureka – statistics, and Heureka – competition sections won’t be displayed.
How do I use a saved filter in a pricing rule? On the Rules page, when editing a rule, choose the Saved filter option in the product selection section and select the desired filter from the list. We recommend not using filters from the Pricing group, because when rules are applied they may be one repricing cycle behind.
What’s the difference between the Pricing and Test pricing sections? The Pricing section shows the actual results of the last repricing. Test pricing shows the results of a simulation – repricing that you ran in test mode with no real impact on prices. Test pricing comes in handy for verifying how a new rule would work before deploying it live.
How quickly are filters applied with a large number of products? Filters are evaluated immediately for the data available in Pricing Fox. For projects with tens of thousands of products, displaying the results may take a few seconds, especially when using multiple filters at once.