Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

rule based related products, cross-sells and up-sells
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

What would be great is if a rule could be established for displaying cross-sells, up-sells and related products, as opposed to having to add a product cross-sell / related priduct manually to each product. the ‘promotions’ rules structure could be adapted and expanded to accomodate this.

e.g. a rule such as;

if ‘title’ or ‘sku’ contains ‘toothbrush’
then in related products show products with ‘title’ or ‘sku’ ‘toothpaste’

or

if ‘title’ or ‘sku’ contains ‘apple’
then in related products show products with ‘category’ = ‘fruit’

or

if ‘category’ = ‘lampshades’
then in related products show products with ‘category’ = ‘light switches’

setting such as

list;

max number of items
randomise / list alphabetical / list by other sorting method
sort based on reviews (number of stars)
sort based on popularity (qty sold / number of views)

this is imho a very powerful and crucial features that will DRAMATICALLY reduce store admin times. as it stands, doing related products and cross-sells is an extremely labour intensive task. adding a new item to the store and wishing for it to be added to ‘related products’ for a given category is a headache and simply should not be.

an essential and overlooked core (killer) feature if you ask me.

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

I am finding I ::REALLY:: need this feature especially when it comes to cross-sells at checkout..

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

me again. i can not stress how desperately i need this feature.
what would take minutes is taking me hours on a store which has a modest amount of products.

related products as they currently stand (adding one by one, no rules based related products) can not scale in the slightest, hindering the extension of customer spending.

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

this appears to be a step in the right direction but still totally lacking;

http://www.magentocommerce.com/extension/549/mass-product-relater

 
Magento Community Magento Community
Magento Community
Magento Community
 
Charles
Member
 
Avatar
Total Posts:  73
Joined:  2008-03-27
Belgium
 

Hi Alex,

I’d look into the catalog/block/product/list.php file.

You’ll find the function _prepareData.

In it, you’ll find these lines:

$this->_itemCollection $product->getRelatedProductCollection()
            ->
addAttributeToSelect('required_options')
            ->
addAttributeToSort('position''asc')
            ->
addStoreFilter()
        ;

My best guess is that you can tweak these lines into your needs and add new attributes, filters and sort fields.

Good luck and please let us know.

Greetings

 
Magento Community Magento Community
Magento Community
Magento Community
 
benfrain.com
Sr. Member
 
Total Posts:  142
Joined:  2008-08-15
 

Mmm, this is potentially a very handy addition. I’m not great with amending code. But Charles has intrigued me…

Charles, are you able to give any specifics of how you believe one may use this section of code to relate one category with another? For example, if I wanted to always show ‘extended warranty’ products (which all live within one category) items as related products to say any item within ‘Televisions’ (all within a different category)?

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

add comments here;

http://www.magentocommerce.com/bug-tracking/issue?issue=4765

 
Magento Community Magento Community
Magento Community
Magento Community
 
sonician
Member
 
Total Posts:  49
Joined:  2008-11-29
 

Hi,

am I getting this wrong, or isn’t this available in the Mass_Product_Relater community package from Magento Connect?

/Henrik

 
Magento Community Magento Community
Magento Community
Magento Community
 
alex.bsc
Guru
 
Total Posts:  340
Joined:  2008-06-06
 

Such functionality is not available in the mass product relater.
There is no way to set rules which will activate given products / categories.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Amasty
Mentor
 
Avatar
Total Posts:  3988
Joined:  2009-11-10
 

Hello,

you can also check out this extension - Fast Product Relator

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top