Quote Originally Posted by Cookiepus View Post
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.