Multi Cross Sell mod [Support thread]

[jetx]

Great mod, thanks.

[Nineve]

I have installed the files and got it to work in the admin panel, but items I have set to cross sell do not display the other product on the product pages. I am assuming when you go to the "A Bug's Life" page after the additional images there should be a photo of the "Microsoft IntelliMouse", but there is nothing. So not sure what I did wrong.

Here is the screen shot in the admin panel showing I have a bugs life and a mouse linked to cross sell;



Here is where I put the code for templates/premium2a/templates/tpl_product_info_display.php


I'm on v1.3.9d, PHP 5.3.2, no other version of a cross sell mod.

[Nineve]

I figured it out, I'm sorry.
This file had not transfered over.
includes/modules/premium2a/multi_xsell_products.php


works great now!!!!
Thank you so much for the hard work.

[andreitero]

Hello, I'm looking to install this mod on one of my websites. Before i do, i would like to know if it is compatible with Tabbed products pro last version. Has anyone tried this combination so far?
Thanks!

[gilby]

Hello, I'm looking to install this mod on one of my websites. Before i do, i would like to know if it is compatible with Tabbed products pro last version. Has anyone tried this combination so far?
Thanks!

I don't use "Tabbed products pro" so I don't know
You would need to compare both mods directory structure to find any duplicate files.
These duplicate files would then need to be "merged"

[HeathenMagic]

Hello Gilby,

Thanks so much for your assistance, it worked a treat. I cleared the files from the last version and ran the sql statement you quoted and it did it. Where can people send a donation to you?

[gilby]

Hello Gilby,

Thanks so much for your assistance, it worked a treat. I cleared the files from the last version and ran the sql statement you quoted and it did it. Where can people send a donation to you?

Glad you solved the problem
Donate instead to the zen-cart admins here:

[andreitero]

I don't use "Tabbed products pro" so I don't know
You would need to compare both mods directory structure to find any duplicate files.
These duplicate files would then need to be "merged"

Thanks for that, i did install this contribution, but got an error:
1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL' doesn't exist in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL xp, zen_products p, zen_products_description pd where xp.products_id = '90' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]

Double checked the Cross Sell 1 - Display Products - Max, it has value '6' . What else should i look at to fix it?

Also, in order to get it to work with Tabbed products pro, i would need to change this bit to match multi_cross_sell database table instead of xsell table. I am unsure about the changes i should make, can you please give me some advice?

				$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
									 from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
									 where xp.products_id = '" . $_GET['products_id'] . "'
									  and xp.xsell_id = p.products_id
									  and p.products_id = pd.products_id
									  and pd.language_id = '" . $_SESSION['languages_id'] . "'
									  and p.products_status = 1
									 order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL);

[gilby]

Thanks for that, i did install this contribution, but got an error:
1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL' doesn't exist in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL xp, zen_products p, zen_products_description pd where xp.products_id = '90' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]

Double checked the Cross Sell 1 - Display Products - Max, it has value '6' . What else should i look at to fix it?

Also, in order to get it to work with Tabbed products pro, i would need to change this bit to match multi_cross_sell database table instead of xsell table. I am unsure about the changes i should make, can you please give me some advice?

				$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
									 from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
									 where xp.products_id = '" . $_GET['products_id'] . "'
									  and xp.xsell_id = p.products_id
									  and p.products_id = pd.products_id
									  and pd.language_id = '" . $_SESSION['languages_id'] . "'
									  and p.products_status = 1
									 order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL);

Quick fix to use the first XSELL database and hard code it
Cannot try it myself but it looks right

$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
 from " . TABLE_PRODUCTS_XSELL1 . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
 where xp.products_id = '" . $_GET['products_id'] . "'
  and xp.xsell_id = p.products_id
  and p.products_id = pd.products_id
  and pd.language_id = '" . $_SESSION['languages_id'] . "'
  and p.products_status = 1
 order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL1);

[andreitero]

Quick fix to use the first XSELL database and hard code it
Cannot try it myself but it looks right

$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
 from " . TABLE_PRODUCTS_XSELL1 . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
 where xp.products_id = '" . $_GET['products_id'] . "'
  and xp.xsell_id = p.products_id
  and p.products_id = pd.products_id
  and pd.language_id = '" . $_SESSION['languages_id'] . "'
  and p.products_status = 1
 order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL1);

Did not go as expected, I can see the TABLE_PRODUCTS_XSELL1 in PhpmyAdmin, but it still throws this error:

1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL1' doesn't exist
in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL1 xp, zen_products p, zen_products_description pd where xp.products_id = '42' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by xp.sort_order asc limit 6]

Do you have any other suggestions i should try?
Thanks for taking the time.