Magento – Price is not updating in all store views even though scope is set to global

magento-1.7pricescopestore-view

We have multiple store views but we want prices to be universal across all stores views. We have the scope set to global but when I update prices either via upload through Magmi or manually it doesn't always update in all store views. I need to be able to update in admin or default store and it should change in all stores.

Can anyone please help me because I am getting one price in the product page and another price in the shopping cart on the front end. It seems like the product page gets the price from default store view and the shopping cart is taking from the admin values. I need them all to be in sync.

Thank you

Best Answer

I spent days on figuring this out. But I finally got it done.

Actually it seems the product price scope is global - unless you have some kind of module which is overriding it. However the root of the issue can be found in catalog_product_entity_decimal table:

SELECT * FROM catalog_product_entity_decimal WHERE attribute_id = 75 // price attribute ID

If it shows you multiple rows for different store_ids you are facing the same issue like me. Because there should ONLY be one entry (one for store_id 0, if you set price to global and inherit the price from default scope).

How to fix?

  1. Backup catalog_product_entity_decimal table
  2. Run following query:

    DELETE FROM catalog_product_entity_decimal WHERE attribute_id = 75 AND store_id <> 0;
    

Please double check if price attribute id = 75 in your setup!