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!