1. Home
  2. Docs
  3. Magento 1 Administration Extenions
  4. Multiple Store View Pricing
  5. Uninstallation

Uninstallation

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 '
';
 
 
$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

Was this article helpful to you? Yes No

How can we help?