Blog Sections Open
Building Multi-Condition TV Filters with SQL Logic in Evolution CMS
How to build a compound filter when multiple TVs need to work together in one date-like or range-like condition.
Some catalog filters are too specific for a simple one-TV comparison. The original example needed one condition when a year TV was below the target value, and a second condition when the year matched but a month TV still had to be checked.
This is exactly where a more explicit SQL-based filter becomes useful. Instead of pretending the data is flat, you model the real business rule directly: one TV handles the primary comparison, another TV refines the tie case.
That pattern appears often in delivery dates, release periods, staged availability, and property ranges where one field alone is not expressive enough. The key is to treat the SQL condition as a business rule, not just a syntax puzzle.
Calling Wayfinder Conditionally from the if Snippet in Evolution CMS
How to run Wayfinder only for selected parent sections by wrapping the call in the if snippet without breaking parsing.
Importing Catalog Data from CSV into Shopkeeper with CatalogFill
A practical import pattern for moving spreadsheet catalog data from Excel-style CSV files into a Shopkeeper-backed Evolution CMS site.