Issue: Products do not show on the frontend

1. Products do not show on the frontend

==> Try reindexing and flushing cache.

2. I'm adding a product with price scope set to store view, the product is not showing on the frontend and in admin panel on category page I see the price as zero. I have to turn your module off (by setting the price scope to website), add the product, turn it back on and set the prices.

==> The cause: Module Multiple store view pricing  catches event "catalog_product_collection_apply_limitations_after" to set "catalog_product_index_price_store" table from  "catalog_product_index_price"  

If on the site, this event is not caught, product data will still get from table "catalog_product_index_price", not "catalog_product_index_price_store" => new products are not reindexed per storeview

==> Solution: Using module Bss_ProductCollectionRewrite 

https://www.dropbox.com/s/mz8lhgm6eompjfq/Bss_ProductCollectionRewrite.zip?dl=0

Note: If the product price or currency symbol shows incorrectly, please check your currency rate to see if they are set correctly: https://prnt.sc/l137f8

If you need further assistance, please feel free to contact us. As a full-service ecommerce agency, we deliver trusted end-to-end solutions with 14+ years of experience, supporting 75,000+ customers worldwide. 

We specialize in developing 150+ high-quality Magento 2 extensions that enhance functionality, improve user experience, and support scalable growth. Our reputation is built on long-term partnerships, positive feedback, and proven performance-driven solutions.

Discover our top tier extensions:

• BSS Commerce’s Magento 2 B2B Extension is an all-in-one solution that streamlines wholesale operations with advanced pricing, company management, and efficient B2B workflows.
• BSS Commerce’s Magento 2 SEO Extension is a powerful tool that enhances search visibility, automates SEO tasks, and drives more organic traffic to your Magento store.