What is this?

Admin note: This is a collection of “Ready-to-Use Recipes” for managing your e-shop. It provides practical examples of how to combine different search rules to solve real business problems, like tracking low stock or finding products with many variants.

Who is this for? Administrators should read this to see what’s possible and find templates they can copy and adapt for their own needs. It’s the most practical guide for daily e-shop management.

Key benefits for the e-shop:

Inventory Alerts: Instantly find products that are running low on stock so you can reorder.
Catalog Analysis: Spot product families with many variants and review recently added variants.
Price Management: Monitor your margins and VAT calculations to ensure your pricing is always accurate.
Recent Activity: Quickly see which products received new variants this year.

Practical Filter Examples

Explore real-world recipes designed to help you manage your e-shop more effectively. These examples combine basic conditions, advanced relations, and powerful functions.

E-commerce Analytics

Large Product Families

Find products that have more than 10 variants with a combined price exceeding 100,000.

count(variants) > 10 and sum(variants.priceWithVat) > 100000

[badge:Analytics|secondary|right]

Recently Added Variants

Find products that have more than 5 variants created in 2024.

count(variants[year(createdAt) = 2024]) > 5

[badge:Sales|secondary|right]

Inventory Management

Low Stock Alerts

Identify storage cards that are running low: fewer than 10 units, but still in stock.

stockQuantity < 10 and stockQuantity > 0

[badge:Inventory|secondary|right]

Out of Stock for a Supplier

Find out-of-stock storage cards for products from a specific supplier.

stockQuantity = 0 and product.supplier.name = "Acme"

[badge:Inventory|secondary|right]

Price and Discount Recipes

VAT Calculations

Filter products where the price with 21% VAT exceeds $500.

priceWithVat * 1.21 > 500

[badge:Pricing|secondary|right]

Discount Monitoring

Find products where a 10% discount would bring the price below $100.

priceWithVat - (priceWithVat * 0.1) < 100

[badge:Pricing|secondary|right]

Best Practices

Use Case-Insensitive Operators

Both like and ilike operators are case-insensitive. You should use them interchangeably for better readability.

name like "macbook" or name ilike "macbook"

Leverage Lookup Values

Use lookup values for cleaner, more readable filters instead of deep relation joins. Recommended:

supplier = "code:ACME"

Also works, but more verbose:

supplier.code = "ACME"

Use Parentheses for Clarity

Always use parentheses when combining and and or to ensure your conditions are evaluated in the correct order.

(priceWithVat < 100 or priceWithVat > 1000) and supplier.name = "Acme"

Optimize with “Begins”

When searching for text at the start of a field, use begins instead of like with a wildcard. It is faster and more precise.

name begins "iPhone"

Technical Reference

Field Types & Quotes

Strings: Use double quotes "Text" or single quotes 'Text'.
Numbers: Enter directly 42, 3.14, or -1.
Booleans: Use true or false.
Escaping: Use a backslash to escape quotes within a string: "Escaped \"quotes\"".

Dates

Enter dates as quoted ISO strings.

createdAt >= "2024-01-01" and updatedAt <= "2024-12-31"

[navigate:/help/en/user-flows/advanced-filtering|Advanced Filtering Guide|filter]
[navigate:/help/en/user-flows/ai-filtering|Find products with natural language|filter]
[navigate:/help/en/api/query|Query Language Documentation|search]
[navigate:/help/en/api/imports|Import System Documentation|upload]