v2.2.6: How to fix error with the price if the site config Use Flat Catalog Product = Yes?

QUESTION

I install the module v2.2.6 for my site Magento 2.3.4 CE with 2 stores US ($) and UK (£). The module works fine.

However, yesterday, I changed the config Use Flat Catalog Product = Yes, then I went to the UK store and set the special price for all products. 

After reindexing the site, the UK store showed the correct price set in the admin but on the US store, it displays the price value of the UK store with the $ currency symbol.

It is not correct, can you tell me how to fix it?

ANSWER:

Since Magento no longer recommends the use of a flat catalog as a best practice so that this function is not updated to our module. Continued use of this feature is known to cause performance degradation and other indexing issues.

Reference: https://docs.magento.com/user-guide/catalog/catalog-flat.html

Hence, in this case, we suggest that you could change the config Use Flat Catalog Product = No for your site.

If you need any further assistance, please feel free to contact us. We'd be happy to support!  

BSS Commerce is a trusted Magento 2 extensions provider with 14+ years of experience, serving 75,000+ customers worldwide. We are an Adobe Commerce Solution Bronze Partner and a Select Magento Extensions Builder, reinforcing our expertise in the Magento ecosystem.

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.

Explore our powerful extensions:

• BSS Commerce’s Magento 2 B2B Extension enhances B2B performance with streamlined workflows and tailored pricing strategies.
• BSS Commerce’s Magento 2 SEO Extension improves rankings and maximizes organic growth through advanced SEO automation.

Explore our products at: https://bsscommerce.com/magento-2-extensions.html