Context
Part of a long engagement on tintadlaplastykow.pl (custom CMS, 36k+ SKU, since 2022) — this thread: catalog and search. At over 36,000 SKU, classic OFFSET pagination and weak search hurt both users and the database. The path from finding a product to cart had to shrink without hammering MySQL on deep scroll.
Scope
- Doofinder search — autocomplete, partial matches, typo tolerance, live suggestions.
- Infinite scroll with cursor pagination — AJAX loading without OFFSET; no performance drop on deeper pages.
- Faceted filtering — instant attribute and variant filters (backend + front).
- Bestsellers and related products — ranking from sales history and relationships on product cards.
- Data import/export — CSV and Google Sheets for product structure and attributes.
Result
- B2B customers find a product via search or filters and add to cart without a sluggish list.
- Custom CMS catalog at 36k+ SKU — Doofinder, cursor pagination, faceted filters, CSV/Sheets sync.