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

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

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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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/j2.../crossSell.png


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

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