Totally Zenned
- Join Date:
- Aug 2005
- Location:
- Vic, Oz
- Posts:
- 1,816
- Plugin Contributions:
- 0
Multi Cross Sell mod [Support thread]
Cookiepus:
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 etcwouldn'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.
Contribs: - Time Zone Fix/Offset ■ Google Adsense ■ betterCategoriesEzInfo ■ Multi Cross Sell