Magento: Get product price from another store?

magento product
Relja picture Relja · Mar 8, 2011 · Viewed 15.5k times · Source

I have multi-store Magento installation, and different product prices are set in different stores. I want to display on one page the actual product price from the current store, and the price from other store (I have its ID), but I'm not sure how to get that info?

The prices are set for each store view for each product, no tier-pricing or special-pricing was used.

Answer

Oğuz Çelikdemir picture Oğuz Çelikdemir · Mar 8, 2011

If you know the storeId, set in setStoreId :

/**
 * call the Magento catalog/product model
 * set the current store ID
 * load the product
 */
$product = Mage::getModel('catalog/product')
            ->setStoreId($storeId)
            ->load($key);

Display in a block :

echo $product->getName();

We can also use print_r to see the values :

print_r($product->getData());

The following code will show current store ID :

$storeId    = Mage::app()->getStore()->getId();

To get all product ID's with each store view :

$product    = Mage::getModel('catalog/product');
$products   = $product->getCollection()->addStoreFilter($storeId)->getData();

If you change the $storeId will show different product.

Related questions

Magento Product Attribute Get Value

How to get specific product attribute value if i know product ID without loading whole product?

Read More
How to get a category listing from Magento?

I want to create a page in Magento that shows a visual representation of the categories.. example CATEGORY product 1 product 2 ANOTHER CATEGORY product 3 My problem is, their database is organised very differently to what I've seen in the past. They …

Read More
Magento get all products

I am trying to get the entire magento product collection, without any filters or restrictions, but I fail to get all products. I've tried various methods already, but they all give me a very limited selection of products. Let's say …

Read More