Multi Cross Sell mod [Support thread]

[gilby]

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?ma...roducts_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

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

[HeathenMagic]

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.

[gilby]

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)

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

[gilby]

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?

[gilby]

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

[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

[kconklin]

This is so great!! I did not have the sample file uploaded once I did and then renamed it everything worked great!! Thanks so much for your help! This is a great module