How to Delete Multiple Store View Pricing extension¶
Step 1: Go to Admin -> System -> Configuration -> Catalog -> Catalog Price Scope
You change Catalog Price Scope to Website or Global
Step 2: Go to Admin -> Catalog-> Attributes -> Manage Attributes
You need to delete 2 attributes with attribute code as “tier_price_for_store” and “group_price_for_store”
Step 3: Setup base currency again by navigating to Admin -> System -> Configuration -> Currency Setup -> Base Currency
Step 4: Delete product prices at each store view
You upload the delete_price_store.php file to Magento root folder and run it. It is noticeable that you had better backup the catalog_product_entity_decimal table in DB before running.
This is the script of the delete_price_store.php file:
<?php
require_once('app/Mage.php');
umask(0);
Mage::app();
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$writeConnection = $resource->getConnection('core_write');
$query = "SELECT attribute_id FROM " . Mage::getSingleton('core/resource')->getTableName('eav/attribute') . "
WHERE attribute_code = 'price' AND backend_model != '' LIMIT 1";
$attribute_id = $readConnection->fetchOne($query);
if($attribute_id) {
$query = "DELETE FROM ".Mage::getSingleton('core/resource')->getTableName('catalog_product_entity_decimal')."
WHERE `attribute_id` = ".$attribute_id." AND `store_id` != '0'";
$writeConnection->query($query);
}
echo 'Delete price per store view success.';
echo '<br>';
$query = "SELECT attribute_id FROM " . Mage::getSingleton('core/resource')->getTableName('eav/attribute') . "
WHERE attribute_code = 'special_price' AND backend_model != '' LIMIT 1";
$attribute_id = $readConnection->fetchOne($query);
if($attribute_id) {
$query = "DELETE FROM ".Mage::getSingleton('core/resource')->getTableName('catalog_product_entity_decimal')."
WHERE `attribute_id` = ".$attribute_id." AND `store_id` != '0'";
$writeConnection->query($query);
}
echo 'Delete special price per store view success.';
Step 5: Remove the code of the module
You delete the folder: app/code/local/Bss/MultiStoreViewPricing and
also remove the file: app/etc/modules/Bss_MultiStoreViewPricing.xml
Step 6: Finally, you should clear all caches