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

Created by Jane D, Modified on Wed, 12 May, 2021 at 10:52 AM by Jane D

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!  

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article