Magento – Magento – Website/Store level indexing

indexing

We are working on Magento 1.7.0.2 (community). We have created multiple websites. Our query is, is there way to indexing on selected website or store? like website or store level configuration.

Consider the the scenario, we have 3 website (WEBSITE1, WEBSITE2, WEBSITE3) and 3 store (STORE1, STORE1, STORE1)
1. If we update WEBSITE1 and STORE1 then indexing will only for WEBSITE1 and STORE1.
2. If we update WEBSITE2 and STORE2 then indexing will only for WEBSITE2 and STORE2.
3. If we update WEBSITE3 and STORE3 then indexing will only for WEBSITE3 and STORE3.

Please help us.

Best Answer

You can try this.

<?php
$mageFilename = 'app/Mage.php';
require_once $mageFilename;
umask(0);

// clean overall cache Mage::app()->cleanCache();
echo "Cache Cleaned!<br/>\n";

// clear 'refresh_layered_navigation'
$storeid = Mage::app()->getRequest()->getParam('storeid');

// Only process if a storeid is passed
if ($storeid) {
  $store = Mage::app()->getStore($storeid);
  Mage::getSingleton('catalogindex/indexer')->plainReindex(null, null, $store); 
  echo 'Layered Navigation Indices was refreshed succesfuly for Store Id: '.$storeid.'<br>';
}
?>

Related Solutions

Indexing – Category Products Indexing Guide

They shouldn't have the same number of records.
The table catalog_category_product contains the links you create in the backend. Here is an example. Let's say you have the following category structure. Using category ids:

2
|-4
|-5
  |-6

And in the backed you associate the product with id 99 to the category with id 6.
Then in catalog_category_product you will have:

category_id = 6
product_id = 99
position = 0 (or whatever)

Let's say category 5 is anchor and category 2 is root. After reindexing you will see in catalog_category_product_index you will have 3 records for each store view where the product is available:

category_id|product_id|position|is_parent|store_id|visibility  
2          |99        |P1      |1        |1       |4  
5          |99        |P2      |1        |1       |4   
6          |99        |P3      |0        |1       |4

P1, P2, P3 are the product positions.See how they are calculated in here.
is_parent is 0 if the product is directly related to the category and 1 if it's related to a child category (I'm not 100% sure about this).

Also, from the _index table only enabled products appear.

Recalculating a Product’s Price with Catalog Price Rules in Magento 1.8

It seems I've stumble upon the answer. To recalculate the 'final' price that gets calculated by applying all of the catalog price rules you need to run this:

Mage::getModel('catalogrule/rule')->applyAllRulesToProduct($product);

One thing that gave me problems is that in messing around trying to figure this out I set a special price with the following:

$product->setSpecialPrice(20.00);
$product->save();

Apparently a special price is higher priority than the price calculated by the price rules. As long as my special price was manually set I could not see that applyAllRulesToProduct was recalculating my prices correctly. I had to first:

$product->setSpecialPrice(null);
$product->save();

And then I could adjust the price in the database, and run:

Mage::getModel('catalogrule/rule')->applyAllRulesToProduct($product);

All of my sales prices for diferent stores and customer groups would get calculated. There is no need to reindex, the applyAllRulesToProduct function reindexes what is necessary.

Unfortunately, with the number of price rules in our store, that function is still slow. However, it is much faster than saving the whole item.

Best Answer

Related Solutions

Indexing – Category Products Indexing Guide

Recalculating a Product’s Price with Catalog Price Rules in Magento 1.8

Related Topic