Multi Cross Sell mod [Support thread]

Quote:

---

Originally Posted by dsimon

Thanks alot
I went thru all the files and found 1 that for some reason didnt copy. So the "The heading for this Cross Sell has not been defined in the Catalog" is now gone THANK YOU
But I still dont see The cross sell in my site.
When I click on "list all cross sells 1" it show it fine, but nothing on either item
Any ideas?

---

Did you have an existing override file here?
\includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php

If you did you need to "merge" the code to make it display with this file

If you didn't have this override file here..
Then rename the "SAMPLE_ADDITION_TO_tpl_product_info_display.php"
to "tpl_product_info_display.php" and upload

Quote:

---

Originally Posted by dsimon

also how do I add more cross sells as well
www.thecoinopshopinc.com

---

admin->configuration->Cross Sell Settings

Be aware there is some confusion regarding how many you need.
Most websites will be fine with just ONE as it can handle tens of thousands of cross sells

You ONLY need more, if you want to have a different text header that is shown on the cross sell

THANK YOU

Its works now

Dave

Hi,

I am having a bit of trouble with this mod, in that I have set up test cart on my own computer (without a database, just manually added a few products) and it worked fine. Now making a test site on my server (with database installed), it installed fine, I have the admin areas, but it does show any cross sells.

I had previously had Just another Cross Sell installed on my v.1.3.9 (which is the database that I have imported into my test v.1.5) and have renamed the products_xsell to products_xsell1 before importing the database and pressing the "Install" button in admin to install Multi Cross Sell. I have also merged the tpl_product_info_display but still no cross sell of my products show.

Would someone be able to point me in the right direction for where I may be going wrong??

Thank you in advance for your help,

Jeff

Not to worry......I just re-entered my cross sell items in my v.1.5 cart to get it up and live.

Thanks,

Jeff

Hi,
I experienced a problem with Multi Cross module because I can’t run installation in Catalog/Multi Cross Sell
When I press install button I get this:

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 'TYPE=MyISAM' at line 7
in:
[CREATE TABLE IF NOT EXISTS zen_products_xsell1 ( `ID` int(10) NOT NULL auto_increment, `products_id` int(10) unsigned NOT NULL default '1', `xsell_id` int(10) unsigned NOT NULL default '1', `sort_order` int(10) unsigned NOT NULL default '1', PRIMARY KEY (`ID`), KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I uploaded all files and also amended the tpl_display_info file with the provided code.

One thing more. I have this module installed previously but the Multi Cross products haven't appeared on a product page. For this reason I decided to reinstall the module (I removed the module from the admin and also deleted all uploaded files before the new installation).

Many thanks.

I've no idea where the sudden interest in installing this mod came from, but in the last 3 days I've seen at least 3 people post the same issue about "an xsell mod" in various places around the forum ... and the mod has been available and actively installed since February.

Anyway, there's a small "bug" in the plugin code insomuch that one of the SQL statements is designed for MySQL4, and most servers are using MySQL5.

Make the following change to the code:
/YOUR_RENAMED_ADMIN/includes/functions/extra_functions/multi_xsell.php

Code:

---

    KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM");

---

becomes

Code:

---

    KEY `idx_products_id_xsell` (`products_id`) ) ENGINE=MyISAM");

---

You may need to "uninstall" and then re-"install" the module to get a properly usable installation.

I've never used this mod, so I can't comment on more than what I've found here by investigating a fix for this specific issue.

Quote:

---

Originally Posted by DrByte

I've no idea where the sudden interest in installing this mod came from, but in the last 3 days I've seen at least 3 people post the same issue about "an xsell mod" in various places around the forum ... and the mod has been available and actively installed since February.

Anyway, there's a small "bug" in the plugin code insomuch that one of the SQL statements is designed for MySQL4, and most servers are using MySQL5.

Make the following change to the code:
/YOUR_RENAMED_ADMIN/includes/functions/extra_functions/multi_xsell.php

Code:

---

    KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM");

---

becomes

Code:

---

    KEY `idx_products_id_xsell` (`products_id`) ) ENGINE=MyISAM");

---

You may need to "uninstall" and then re-"install" the module to get a properly usable installation.

I've never used this mod, so I can't comment on more than what I've found here by investigating a fix for this specific issue.

---

Thanks DrByte for replying. I installed this mod successfully following your instruction now but another issue has appeared.
When I choose the products that Cross sell applies to, I got the warning "No Product was Found with the id:..." These products definitely exist in the products catalog so I can't find out what is going on.

Many thanks.

An update for my previous answer:

I solved the problem with product id but no cross products appear on the product page. I put the code as required in tpl_product_info_display file.

This is the code:

<!-- BEG: Multi Cross-Sell mod -->
<?php
// THIS CODE WOULD BE ADDED INTO YOUR TPL_PRODUCT_INFO_DISPLAY.PHP WHEREVER YOU WANT TO DISPLAY ALL THE CROSS_SELL BOXES:
if(defined('MXSELL_ENABLED') && MXSELL_ENABLED == 'true') {
for ( $mxsell = 1; $mxsell <= MXSELL_NUM_OF_TABLES; $mxsell++ ) { // show all cross sells
require($template->get_template_dir('tpl_modules_multi_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_multi_xsell_products.php');
}
}
?>
<!-- END: Multi Cross-Sell mod -->

Quote:

---

Originally Posted by Hampstead

Thanks DrByte for replying. I installed this mod successfully following your instruction
Many thanks.

---

And if you have gone back 3 pages to post 291 you would also have found that answer.
Sometimes these questions have already been asked and answered and just need a (small) bit of searching.

Quote:

---

Originally Posted by Hampstead

I solved the problem with product id but no cross products appear on the product page.

---

And for the next person who has this problem the solution was.....?

Quote:

---

Originally Posted by Hampstead

no cross products appear on the product page. I put the code as required in tpl_product_info_display file.

This is the code:

<!-- BEG: Multi Cross-Sell mod -->
<?php
// THIS CODE WOULD BE ADDED INTO YOUR TPL_PRODUCT_INFO_DISPLAY.PHP WHEREVER YOU WANT TO DISPLAY ALL THE CROSS_SELL BOXES:
if(defined('MXSELL_ENABLED') && MXSELL_ENABLED == 'true') {
for ( $mxsell = 1; $mxsell <= MXSELL_NUM_OF_TABLES; $mxsell++ ) { // show all cross sells
require($template->get_template_dir('tpl_modules_multi_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_multi_xsell_products.php');
}
}
?>
<!-- END: Multi Cross-Sell mod -->

---

Did you put this into the "template over ride" version or the default version?
What is the exact path to this file that you have altered?