How to completely remove the Multiple Store View Pricing extension with the database script included?

Question:

I would like to completely uninstall the module

Answer:

We would like to send you the guidance to completely remove the Multiple Store View Pricing extension together with the database script includes as below:

- 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

For more information about product, please refer Multiple Store View Pricing page.

If you need any further assistance, please feel free to contact us.

Please visit our site for more useful Magento 1 Extensions: https://bsscommerce.com/extensions.html