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

Created by Robin Hoang, Modified on Mon, 12 Feb, 2018 at 12:00 PM by Robin Hoang

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article