Magento - Update Prices Script - Multiple Stores

Magento - Update Prices Script - Multiple Stores

August 14, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Update Prices Script - Multiple Stores

Updating Magento Prices Across Multiple Stores Without Plugins: A Comprehensive Guide

When working with multiple stores in Magento, updating prices for specific groups of products can be a complex task. In this post, we’ll guide you through the process of updating prices from one store to another while excluding certain product types using Magento-friendly code.

Understanding the Magento Data Structure

Before diving into the code, it’s crucial to understand where the required data is stored in your database:

  • Product Prices: The catalog_product_entity table stores the base price and tier price for each product. You can join this with other tables like catalog_category_product, catalog_product_attribute_value, etc., to get more information.
  • Product Attributes (including Entity Label): The eav_attribute table contains all attribute details, while the catalog_product_entity_varchar or catalog_product_entity_int tables store the values of these attributes for each product.

Accessing Magento Data Programmatically

To access this data programmatically, we’ll use Magento’s model system in combination with its resource models. Here’s how you can load a specific product and retrieve its details:

Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

$productId = '8782';

// Load the product using the catalog_product entity model
$collection = Mage::getModel('catalog/product')->load($productId);

// Access basic information like name, SKU, and attribute set ID
echo "Collection: " . $collection->getName() . "<br>";
echo "Attribute Set: " . $collection->getAttributeSetId() . " SKU: " . $collection->getSku() . "<br>";

// To access additional information like the entity ID or product type (attribute label), you'll need to load the data using specific attribute codes
$entityId = $collection->getEntity_id();
$productType = Mage::getModel('catalog/product_type')->load($collection->getProducttype())->getName();

echo "Entity ID: " . $entityId . " Product Type (Attribute Label): " . $productType . "<br>";

Updating Prices for Specific Product Types

Now, let’s update the prices of specific products from one store to another. In this example, we’ll increase the price by 120% for all shirts:

// Load all products in the desired category (replace 'shirts' with your actual category name)
$category = Mage::getModel('catalog/category')->loadByAttribute('name', 'Shirts');
$collection = $category->getProductCollection()->addAttributeToSelect(array('sku', 'price'));

foreach ($collection as $product) {
    // Check if the product is a shirt (assuming you have an attribute called "product_type")
    if ($product->getData('product_type') == 'Shirt') {
        $newPrice = $product->getPrice() * 1.20; // Increase the price by 120%
        $product->setPrice($newPrice);

        try {
            $product->save();
            echo "Updated product {$product->getSku()} with new price: {$newPrice}<br>";
        } catch (Exception $e) {
            echo "Error updating product {$product->getSku()}: " . $e->getMessage() . "<br>";
        }
    }
}

Conclusion

In this post, we demonstrated how to update prices for specific groups of products across multiple Magento stores using native PHP and Magento’s built-in models. By understanding the data structure and leveraging Magento’s resource models, you can achieve your goal without resorting to external plugins or raw SQL queries.

Remember that updating prices programmatically requires careful handling of exceptions and validation to ensure data integrity. Always test your scripts thoroughly before deploying them in a production environment.

For more advanced Magento development techniques, be sure to check out the extensive tutorials available at Laravel Company.

Catalog Database Extensions Admin

Our network