Layered navigation block - Multistore Setup instruction please?

[Teapot Creative]

Hi

 

Does anyone out there have a comprehensive 'how to' instructions to set up the "Layered navigation block" on a multistore.. having real issues with it not acting the same on all stores (we have x4 stores x 4 currencies)

 

Works OK on the default store, but then on other stores 'prices slider' missing and sub categories not showing..

 

Any pointers on set up much appreciated, sort of running out of ideas here.. 

 

Thanks in advance.. 

 

NickC

Edited February 14, 2014 by Teapot Creative (see edit history)

[thrillmetoo]

Is there a sollution to your problem yet? I'm having the same problem it seems.

[cafetango]

Me too.  I'm having similar problems.

[Teapot Creative]

Bump...

[benjamin utterback]

How does it not work with Multistore, an example would be great to look into. That module is a tricky one and it makes sense that with Multistore you'll find some inconsistencies. If we can figure out together what those are, we can fix them. 

[Teapot Creative]

Hi

 

The  price slider does not work for Multi-Store with Multiple Currencies. (Our current  stores: x4 stores x4 currencies)

 

We have tried to create templates for each store including the Price slider option, but it does not show in all stores. We have re-indexed missing prices and all other indexing option, but still the prices filter does not work. Although it does work for ll other filter options.

 

Nick

[shaun_imakr]

In my case it doesn't work at all. It works when I install the module (without price slider and colour swatches), but straight after the first indexing it disappears in all but the main store. Reinstalling it and setting the view again helps, but I'm afraid that's not a solution.

[HaCos]

Try the following from here

 

Okay I have found a quick workaround for this issue.

 

Edit file modules/blocklayered/blocklayered.php

 

Go to the line 881 and replace

Db::getInstance()->execute('
INSERT INTO `'._DB_PREFIX_.'layered_product_attribute` (`id_attribute`, `id_product`, `id_attribute_group`, `id_shop`)
SELECT pac.id_attribute, pa.id_product, ag.id_attribute_group, product_attribute_shop.`id_shop`
FROM '._DB_PREFIX_.'product_attribute pa'.
Shop::addSqlAssociation('product_attribute', 'pa').'
INNER JOIN '._DB_PREFIX_.'product_attribute_combination pac ON pac.id_product_attribute = pa.id_product_attribute
INNER JOIN '._DB_PREFIX_.'attribute a ON (a.id_attribute = pac.id_attribute)
INNER JOIN '._DB_PREFIX_.'attribute_group ag ON ag.id_attribute_group = a.id_attribute_group
'.(is_null($id_product) ? '' : 'AND pa.id_product = '.(int)$id_product).'
GROUP BY a.id_attribute, pa.id_product , product_attribute_shop.`id_shop`'
);

with

Db::getInstance()->execute('
            INSERT INTO `'._DB_PREFIX_.'layered_product_attribute` (`id_attribute`, `id_product`, `id_attribute_group`, `id_shop`)
            SELECT pac.id_attribute, pa.id_product, ag.id_attribute_group, pas.id_shop
            FROM '._DB_PREFIX_.'product_attribute pa
            INNER JOIN '._DB_PREFIX_.'product_attribute_shop pas ON pas.id_product_attribute = pa.id_product_attribute
            INNER JOIN '._DB_PREFIX_.'product_attribute_combination pac ON pac.id_product_attribute = pa.id_product_attribute
            INNER JOIN '._DB_PREFIX_.'attribute a ON (a.id_attribute = pac.id_attribute)
            INNER JOIN '._DB_PREFIX_.'attribute_group ag ON ag.id_attribute_group = a.id_attribute_group
            '.(is_null($id_product) ? '' : 'AND pa.id_product = '.(int)$id_product).'
            GROUP BY a.id_attribute, pa.id_product, pas.id_shop'
        );

I'll try to send a pull request to developers because I don't like "hardcoding" like this 

 

[boghsteren]

There is a problem with the indexing of prices in a multistore, multi currency setup - it indexes all prices across all stores as the default currency of the default store, instead of setting each store currency appropriately. Any tips on how to fix this?