An international merchant is complaining that changes are taking too long to be reflected on the frontend after a full product import.
Thinking it may be database issues, the Adobe Commerce developer collects the following entity counts:
* Categories: 900
* Products: 300k
* Customers: 700k
* Customer groups : 106
* Orders: 1600k
* Invoices: 500k
* Creditmemos: 50k
* Websites : 15
* Stores : 45
What is a probable cause for this?
The probable cause for the delay in reflecting the changes on the frontend after a full product import is the combination of the number of products, customer groups and websites. This leads to a huge amount of values being stored in the price index which is too large to be processed at a normal speed. The price index calculates the final price of each product for each customer group and website, taking into account various factors such as tax, discounts, catalog price rules, etc. When there are many products, customer groups and websites, the price index becomes very complex and time-consuming to update. Verified Reference: [Magento 2.4 DevDocs] [Magento Stack Exchange]
Carman
20 days agoVilma
25 days agoMarcelle
1 month agoRomana
1 month agoKatina
3 months agoWilda
3 months agoRyan
3 months agoKeneth
3 months agoEleni
3 months agoDyan
4 months agoThurman
4 months agoLashandra
4 months agoRefugia
4 months agoBarbra
4 months agoDelbert
4 months agoSol
5 months agoTiara
5 months agoMerissa
6 months agoLeonardo
6 months agoLai
6 months agoThea
6 months agoIzetta
6 months agoLaura
6 months agoRuby
4 days agoTequila
9 days agoDalene
15 days ago