Hi Cybrosys Techno Solutions

Thank you so much for your detailed response!

Your explanation about the AJAX and OWL rendering in Odoo 19 was the "aha!" moment that helped me understand the root cause of the problem. I was completely focused on the backend code and didn't realize the frontend was replacing my results after my controller had already done its job perfectly.

I tried overriding _get_search_domain as you suggested. For some strange reason on my specific local installation, the method was never executed (I confirmed this with logs). It seems my environment has a conflict with overriding internal controller methods that don't have a route.

However, your diagnosis that the frontend was replacing my results was 100% correct. It led me to understand that I needed to update more than just the product list. Following your lead, another user pointed out that I also needed to recalculate the bins variable, and that was the final key to the solution.

I really appreciate you taking the time to explain the 'why' behind the problem. It was a crucial step in finding the final solution. Thank you!

Hi,

In Odoo 19, your issue happens because the /shop page uses AJAX and OWL rendering, which reloads product results after your controller runs. Even though your Python filtering works, the frontend replaces your filtered list with the default one.

The proper fix is to override Odoo’s search domain before products are loaded instead of re-rendering the template. By customizing the _get_search_domain() method, you can apply whole-word filtering that works with Odoo’s frontend logic.

Try the following code.

# -*- coding: utf-8 -*-

import re

import logging

from odoo import http

from odoo.http import request

from odoo.addons.website_sale.controllers.main import WebsiteSale

_logger = logging.getLogger(__name__)

class CustomWebsiteSearch(WebsiteSale):

    def _get_search_domain(self, search, category, attrib_values, search_in_description=True):

        domain = super()._get_search_domain(search, category, attrib_values, search_in_description)

        if search:

            pattern = r'\b' + re.escape(search.lower()) + r'\b'

            products = request.env['product.template'].sudo().search([])

            filtered_ids = [p.id for p in products if re.search(pattern, p.name.lower())]

            domain = [('id', 'in', filtered_ids)] if filtered_ids else [('id', '=', 0)]

            _logger.info("Whole-word search applied for '%s' -> %s", search, filtered_ids)

        return domain

* Add this controller to your custom module.

* Restart Odoo and upgrade the module.

* Search in /shop — now only exact word matches (e.g., “ram”) will appear.

Hope it helps

There is more to the /shop/... routes than is covered by your source - see also https://github.com/odoo/odoo/blob/19.0/addons/website_sale/controllers/main.py#L487.

What's most crucial to your scenario is the bins key.

A working source - but far from being optimized nor covering all aspects such as filters etc. - is:

# -*- coding: utf-8 -*-

import logging
import re
from odoo.tools import lazy
from odoo import http
from odoo.http import request
from odoo.addons.website_sale.controllers.main import WebsiteSale, TableCompute

_logger = logging.getLogger(__name__)


class CustomWebsiteSearch(WebsiteSale):
    @http.route([
        '/shop',
        '/shop/page/<int:page>',
        '/shop/category/<model("product.public.category"):category>',
        '/shop/category/<model("product.public.category"):category>/page/<int:page>',
    ], type='http', auth="public", website=True, sitemap=WebsiteSale.sitemap_shop)
    def shop(self, page=0, category=None, search='', min_price=0.0, max_price=0.0, ppg=False, **post):
        response = super(CustomWebsiteSearch, self).shop(
            page=page, category=category, search=search, min_price=min_price,
            max_price=max_price, ppg=ppg, **post
        )

        website = request.env['website'].get_current_website()
        ppr = website.shop_ppr or 4

        if not search or not response.qcontext.get('products'):
            return response

        _logger.info("--- 1. Netdata Controller INITIALIZED for: '%s' ---", search)
        all_products = response.qcontext['products']
        term = search.lower()
        relevant_products = []
        for product in all_products:
            pattern = r'\b' + re.escape(term) + r'\b'
            if re.search(pattern, product.name.lower()):
                relevant_products.append(product)

        _logger.info("--- 2. Products AFTER filter: %s ---", [p.name for p in relevant_products])
        qcontext = response.qcontext
        qcontext['products'] = http.request.env['product.template'].browse([p.id for p in relevant_products])
        qcontext['search_product'] = http.request.env['product.template'].browse([p.id for p in relevant_products])
        qcontext['bins'] = lazy(lambda: TableCompute().process(relevant_products, ppg, ppr))
        qcontext['search_count'] = len(relevant_products)
        return request.render('website_sale.products', qcontext)