Multi Cross Sell mod [Support thread]

[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]

I had cross sell installed from before and I tried uninstalling and reinstalling this module and the same happened. Had the normal cross sell and cross sell advanced. I am on PHP 5 too.

I suspect you still have some of the previous mods files or configuration settings.

You can run this in the tools->sql patches to remove the previous mods configuration settings
after BACKING UP AND TESTING FIRST of course

  
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 
  FROM configuration_group
  WHERE configuration_group_title= 'Cross Sell';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

Check that all the previous mods files have been removed

[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?

[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);

[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:

[kconklin]

I love this mod! I have installed and it appears to be working correctly in my Admin area however, I do not see anything on the actual web page? Do I need to add this like suggested in the Cross Sell mod installation?

4. Open includes/languages/english/product_info.php
or includes/languages/english/YOUR_TEMPLATE/product_info.php
and add:
define('TEXT_XSELL_PRODUCTS', 'We Also Recommend :');
just above the final ?> and save it into includes/languages/english/YOUR_TEMPLATE/product_info.php

[gilby]

I love this mod! I have installed and it appears to be working correctly in my Admin area however, I do not see anything on the actual web page? Do I need to add this like suggested in the Cross Sell mod installation?

4. Open includes/languages/english/product_info.php
or includes/languages/english/YOUR_TEMPLATE/product_info.php
and add:
define('TEXT_XSELL_PRODUCTS', 'We Also Recommend :');
just above the final ?> and save it into includes/languages/english/YOUR_TEMPLATE/product_info.php

No that info is found here:
includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defin es.php

You probably haven't edited or merged
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php

If you haven't previously customised this file then you can just rename the sample file:
includes\templates\YOUR_TEMPLATE\templates\SAMPLE_ADDITION_TO_tpl_product_info_d isplay.php
to:
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php