How to Update Global Prices and Delete Website Prices in Magento

magmiscope

In Magento I configured global prices – 1 price for all websites/stores/languages.
Unfortunately, Magmi imported prices in the website tables (in case there is anything like a website table).
So now I've got global prices if I manually enter a product and I if use Magmi to import a product into two different languages, I've got website scope prices.

Is it somehow possible to delete the website prices and tell Magento (or does it do it by itself) to use the global prices?

Thanks,
Chris

Best Answer

First, I would do what Sanders said and change your price scope to "Global". Then, if for whatever reason you have website prices that persists, I would run the following query, which will return all of the non global prices saved on your database.

SELECT d.entity_id AS product_id,d.value AS price
FROM catalog_product_entity_decimal AS d
    INNER JOIN `eav_attribute` AS a
        ON d.`attribute_id` = a.`attribute_id`
WHERE a.`attribute_code` = 'price'
    AND d.store_id != 0

First examine these records, if any. If you're seeing website prices, this query should return some results. If you remove these records, all prices will fall back to the global price (store_id = 0). Proceed with caution and always test it on a dev environment first!

Related Solutions

Magento – Attributes with Website Scope Empty in Frontend When Imported with Store ID

The problem was caused from another part of the script which loaded the product again to set the store view specific values. And the problem was to set the store id before loading the product.

My old code:

$product_de = Mage::getModel('catalog/product');
$product_de
    ->setStoreId('1')
    ->load($id)
    ... // set some store view specific data
    ->save();

The fixed code:

$product_de = Mage::getModel('catalog/product');
$product_de
    ->load($id)
    ->setStoreId('1')
    ... // set some store view specific data
    ->save();

Now only one entry get's inserted in the catalog_product_entity_* table – with store_id = 0.

Strange because I've seen it in the other order e.g. here: http://www.webguys.de/magento/produkte-mehrsprachig-importieren/ (german website)

Don't know if this is a bug, or there is a reasonable explanation for this behaviour.

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

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?

Backup catalog_product_entity_decimal table

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!

Best Answer

Related Solutions

Magento – Attributes with Website Scope Empty in Frontend When Imported with Store ID

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

Related Topic