caching - how to refresh magento tier price cache after sql insert -
I have imported new level prices in the Magnu database using the SQL shown below and when I see the product in the admin Yes, the levels are correct. However, at the front end, the tires are not displayed under the product save in the back-end.
I have removed the host / cache, reproduced the catalog index, rebuilt the inventory stock status (?), And tried to attribute bulk updates on those products, none of which The price does not refresh the cache I can not get any price in the product entity table which is related to level for the tier.
I think the value
is in the object Mage_CatalogIndex
I think it needs to be refreshed ...
I am using Magenta v1.3.2.4 and I am using two hundred SKUs, which I do not want to manually save in backend! Select '' '' '0', '5', '12', 'unit', '10' to `10 '.
`catalog_product_entity_tier_price` (all_groups, customer_group_id, qty, entity_id,` value 'Catalog_product_entity`) where category_id = 3;
>
I wonder what will help to help you do something like this? $ code = $ productsforcatalogIndexUpdate = Array (123,1231); // Add your product ID here (count ($ productsForCatalogIndexUpdate)) {Mage :: log ("About updating the list price index on the following products") (',', $ ProductsForCatalogIndexUpdate)); Dana :: Millmodel ('Catendex / Index') - & gt; Plain Ree Done :: getModel ("catalogindex / supervisor") -> clearPriceAggregation ();}
if I remember correctly Then it rebuilds price index tables for certain prices.
Comments
Post a Comment