Hi, we are new to Odoo so I might be asking a basic question. I don't need an exact answer to make it work though it will be helpful. I just need to know if this is possible and potentially how to do it.

We are in process of setting up an Odoo Enterprise (not yet bought). We do plan to buy success pack however this is pre-sales.

Problem

What we need is a way for products to show on certain selected  websites. So say we create 4 websites. Now we want a product to only show on Website1 and Website3. Similarly some products may show on 3 or all 4 websites.

I know we have an option to select either none (so product shows on all) or select any one and product shows on selected site.

What we have done

To  achieve this we used Studio to add a field called "Websites" which is a many-to-many and widget for checkboxes so I am able to select the website. We further wrote a sample module to override WebsiteSale class and change the query going in to only show selected products and that works.

However we are seeing sitemap.xml and product page still opening. There may be other places as well.

Question

Is there an alternate approach to achieve the same? Is there a module that will allow us to do thisWill really appreciate any way you can guide us towards this.​

Thanks
Amit