Could someone explain to me why whenever I perform a reindex on my magento website any changes I have made within the
catalog_product_index_price table get overwritten.
I have created a module that can set custom tier prices for a customer group and when I set a new tier price I can see that it updates within the database to the new value. However, when I perform a reindex on the website the new value gets overwritten with the old value again.
Any help would be appreciated.
I have just set different values directly into the database and when I reindex they also get overridden and reverted back to their base values. Have I missed a step to make the reindex recognise the changes or is this intended?
Turns out, the table
catalog_product_index_price is a frontend table which explains that whenever changes to this is made they are also shown on the frontend without having to reindex. What I think is happening is the reindex is grabbing its values from a EAV table and overwriting the table record. Currently I don't know which EAV table this values are stored in.