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