Multi Cross Sell mod [Support thread]

Multi Cross Sell mod
Download Link: http://www.zen-cart.com/downloads.php?do=file&id=1128


Based on Cross Sell - Just Another Cross Sell Mod by yellow1912
Link to the original: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=694


New Features:
1. Removal of module_manager to operate properly.
2. Customise what to show apart from the Cross Sell image.
Display the Products Name.
Display the Products Model Number.
Display the Products Buy Now / More Info Link.
3. Enable, Disable and Remove this module from the admin.
4. Ability to create and display unlimited Cross Sell Tables.
Can have multiple Cross Sell's for different purposes
Customise each Cross Sell's Box headings to be more relevent to its purpose.
Enable and Disable each individual Cross Sell from the admin.


Existing Features:
All of yellow1912's "Just Another Cross Sell Mod" including
1. Allow unlimited number of product cross sells
2. Accept product id or model as input value.
3. Clean up table.
4. Given a list of n products, the mod will go through and cross-sell EACH pair together.
With this mod, if you give it 3 products: A - B - C, it will cross-sell:
A to B, B to A
A to C, C to A
B to C, C to B

Thank you for this contibution I have managed to get it working on my site. The only thing I need help on is how do I get it to display the price and a add to cart button.

I was just wondering if it is my setup, but I see this displayed on the product info page:-

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '16025' 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 rand() limit ]

It all installed nicely in the admin and I followed the instructions. Thanks for developing this module also.

michellepchy:

Thank you for this contibution I have managed to get it working on my site. The only thing I need help on is how do I get it to display the price and a add to cart button.

admin->configuration->Cross Sell Settings

HeathenMagic:

I was just wondering if it is my setup, but I see this displayed on the product info page:-

Quote:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '16025' 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 rand() limit ]


It all installed nicely in the admin and I followed the instructions. Thanks for developing this module also.

Check:
admin->configuration->Cross Sell Settings
make sure that..
Cross Sell 1 - Display Products - Max
has a numeric value (not empty)

Hello there,

It has 6 as default. I tried to change it and the other settings and it still has the error. I have 2 cross sells defined so far. Is there anything else I could try? Should I drop the sql tables and star from scratch maybe? Maybe something got scrambled on our setup during install.

HeathenMagic:

Hello there,

It has 6 as default. I tried to change it and the other settings and it still has the error. I have 2 cross sells defined so far. Is there anything else I could try? Should I drop the sql tables and star from scratch maybe? Maybe something got scrambled on our setup during install.

Did you have any previous cross sells installed?
or is this a new installation?

You could uninstall from the admin and install again.
It won't remove the tables

What php version are you using?

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.

Great mod, thanks.

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.:huh:

Here is the screen shot in the admin panel showing I have a bugs life and a mouse linked to cross sell;
http://i81.photobucket.com/albums/j222/Nineve/crossSell.png


Here is where I put the code for templates/premium2a/templates/tpl_product_info_display.php
http://i81.photobucket.com/albums/j222/Nineve/phpcode.png

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

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.:clap:

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!

HeathenMagic:

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

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!

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"

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:

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

andreitero:

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

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?

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

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

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

No that info is found here:
includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defines.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_display.php
to:
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php