Multi Cross Sell mod [Support thread]

[gilby]

Thanks for that, but im still not quite sure...

I have around 80 product ranges
with around 6 products in each range
So id like to cross sell to work when a user clicks on a particular range
the other products in that range are displayed.

So i started setting up the cross sells (using product id numbers)
Cross sell 1
11,12,13,14,15
Cross sell 2
14,15,15,17,18
etc
How do i combine the cross sells for different products within one header?

Thanks again

Start off and use ONE cross sell only
Assuming you are using the "multi way" cross sell
Entering 11,12,13,14,15
Means if you view product 11, then 12,13,14,15 will be shown as cross sells for that product
View: 11 CrossSell: 12,13,14,15
View: 12 CrossSell: 11,13,14,15
View: 13 CrossSell: 11,12,14,15
View: 14 CrossSell: 11,12,13,15
View: 15 CrossSell: 11,12,13,14
You end up with 5 products that show 4 cross sells for that product

Now still using the 1st Cross Sell
Entering 21,22,23
Means if you view product 21, then 22,23 will be shown as cross sells for that product
View: 21 CrossSell: 22,23
View: 22 CrossSell: 21,23
View: 23 CrossSell: 21,22
You end up with 3 products that show 2 cross sells for that product

You now have 8 products in total that show cross sells

If you want you can keep entering your 80 product ranges of 6 items each here, all under the one cross sell

------------------------

Heres an example of ONE way cross sells using one header
www(dot)p a n d o r a b e a d s(dot)com(dot)au/index.php?main_page=product_info&cPath=77&products_id=1760
(remove spaces and change (dot) to .)

click thru to the next products and you will see the cross sells change to suit the product.

Heres an example of MULTI way cross sells using a different (relevent to the product) header
www(dot)p a n d o r a b e a d s(dot)com(dot)au/index.php?main_page=product_info&cPath=77&products_id=1760

click thru to the following products..

This website use 4 different headers
and has hundreds of different of cross sells

The other 2 headers used are here:
www(dot)p a n d o r a b e a d s(dot)com(dot)au/index.php?main_page=product_info&cPath=52&products_id=1069
and here:
www(dot)p a n d o r a b e a d s(dot)com(dot)au/index.php?main_page=product_info&cPath=16&products_id=129

[Cookiepus]

Start off and use ONE cross sell only
Assuming you are using the "multi way" cross sell
Entering 11,12,13,14,15
Means if you view product 11, then 12,13,14,15 will be shown as cross sells for that product
View: 11 CrossSell: 12,13,14,15
View: 12 CrossSell: 11,13,14,15
View: 13 CrossSell: 11,12,14,15
View: 14 CrossSell: 11,12,13,15
View: 15 CrossSell: 11,12,13,14
You end up with 5 products that show 4 cross sells for that product

Now still using the 1st Cross Sell
Entering 21,22,23
Means if you view product 21, then 22,23 will be shown as cross sells for that product
View: 21 CrossSell: 22,23
View: 22 CrossSell: 21,23
View: 23 CrossSell: 21,22
You end up with 3 products that show 2 cross sells for that product

You now have 8 products in total that show cross sells

If you want you can keep entering your 80 product ranges of 6 items each here, all under the one cross sell

Thanks for taking the time and I totally get how this works.
What i cant understand about above is:
If the item numbers are all entered in one continuous cross sell as above, whats to stop items 22,23 showing up with items 12,13 etc

If you want you can keep entering your 80 product ranges of 6 items each here, all under the one cross sell

wouldn't this just look like : 1,2,3,4,5,6,7,8 etc
isn't there some sort of delimiter needed between each group of numbers.
I hope there will be a bolt of lightning hitting my think head soon!
Thank you

[gilby]

Thanks for taking the time and I totally get how this works.
What i cant understand about above is:
If the item numbers are all entered in one continuous cross sell as above, whats to stop items 22,23 showing up with items 12,13 etc

wouldn't this just look like : 1,2,3,4,5,6,7,8 etc
isn't there some sort of delimiter needed between each group of numbers.
I hope there will be a bolt of lightning hitting my think head soon!
Thank you

You are missing how this works....
The database tables are organised as pairs of ids
A main ID and a crossell ID

If you cross sell 12 with 13 one way you get one entry is the cross sell database
Main: CrossSell:
12.......13
So whenever the product displayed is 12, then 13 shows as cross sell

If you cross sell 12 with 13 multi ways you get two entries is the cross sell database
Main: CrossSell:
12.......13
13.......12
So whenever the product displayed is 12, then 13 shows as cross sell
and whenever the product displayed is 13, then 12 shows as cross sell

If you cross sell 12, 13 and 14 multi ways you get six entries is the cross sell database
Main: CrossSell:
12.......13
12.......14
13.......12
13.......14
14.......12
14.......13
So whenever any of these 3 products are displayed then the 2 others are shown as cross sells

Now if If you cross sell 22 with 23 multi ways you get two entries is the cross sell database
Main: CrossSell:
22.......23
23.......22

These two entries have no relationship with 12, 13 or 14
So none of these other cross sells will show with these.

[Cookiepus]

ive followed your instructions best i could:

i have range A i would like to cross sell whose IDs are:
1061,1062,1067,1063,1066,1069,1068,1064,1065


i have range B i would like to cross sell whose IDs are:
983,984,985,986,987,988,989,990,991,992,993

so i set up anew cross ell and entered
1061,1062,1067,1063,1066,1069,1068,1064,1065,983,984,985,986,987,988,989,990,991 ,992,993

As i expected, the 2 different ranges are now linked and mixed up in each others cross sell.

"If you want you can keep entering your 80 product ranges of 6 items each here, all under the one cross sell"

But how do i keep the 2 ranges from getting mixed up with each other, while still under the one cross sell?

[Cookiepus]

my link

http://www.ezlivingfurniture.ie/bedr...ogart-bedframe

Thank You for being so patient!

[gilby]

ive followed your instructions best i could:

i have range A i would like to cross sell whose IDs are:
1061,1062,1067,1063,1066,1069,1068,1064,1065


i have range B i would like to cross sell whose IDs are:
983,984,985,986,987,988,989,990,991,992,993

so i set up anew cross ell and entered
1061,1062,1067,1063,1066,1069,1068,1064,1065,983,984,985,986,987,988,989,990,991 ,992,993

As i expected, the 2 different ranges are now linked and mixed up in each others cross sell.

"If you want you can keep entering your 80 product ranges of 6 items each here, all under the one cross sell"

But how do i keep the 2 ranges from getting mixed up with each other, while still under the one cross sell?

If you want to cross sell these..
983,984,985,986,987,988,989,990,991,992,993
Then enter these as listed into the "New Cross Sells 1" and click insert

If you then want to cross sell these..
983,984,985,986,987,988,989,990,991,992,993
Then enter these as listed into the "New Cross Sells 1" and click insert

TWO separate operations!!!
This way there will not be any overlap

----------------------
Don't combine them like this1061,1062,1067,1063,1066,1069,1068,1064,1065,983,984,985,986,987,988,989,990 ,991,992,993
As you will cross sell them all together this way

If you have done this then you will have a lot of deleting to do to clear them out....

[Cookiepus]

U R E K A

That's the info ive been lookin for for 2 days!

Nice one Gilby!