Multi Cross Sell mod [Support thread]

bigduffeye:

thanks gilby - i get what you are saying, but i really do need 50 different cross sell tables, each furniture set can only have items from its own specific set in the cross sell.

Yes and No!

The 2 examples shown use 2 different headers
"Ariel Bedroom Set" and "Cube Bedroom Set"
As they use different headers then yes you need 2 tables to do this
and if you are going to have 50 different headers then yes you will need 50 tables.

BUT if you were to use a more generic header for all of them
such as "Matching Bedroom Set"
You already have the name of the set further up the page displayed boldly
Then you would need ONLY one table to do them all

I still believe you don't quite understand that.
Each set would be isolated strictly to that set ONLY!!!
The sets do NOT get mixed up using one table.

If you were starting from scratch using one table
For the first set you would enter the following Id's into the cross sell
275,271,270,269,273,430,431
then click "insert"

For the second set you would enter the following Id's into the same cross sell
265,470,471,260,264,262,259
then click "insert"

You will now have the same as what you have but with the one same header for both.
You can do all 50 sets like this if you wish into the same one table.

btw: there will probably be a performance hit searching 50 tables at a time
imo: One table is far more efficient with the low number of items that you cross selling

ah ha!

i wasnt aware that you could insert more than one set of id's into one specific cross sell!

thanks for your help!

bigduffeye:

ah ha!

i wasnt aware that you could insert more than one set of id's into one specific cross sell!

thanks for your help!
I suspected that...
It takes a while using it to get your head around how it actually works

I will definitely have to improve the documentation with this mod!

gilby,

I've read this entire thread from end to end. I've also installed and uninstalled both Multi Cross Sell and Cross Sell Advanced Multi Cross Sell. Both allowed me to input cross sells and gave me the ability to view each. My problem is, we will have over 10,000 products in our site. To add that many cross sells will talk a "month of sundays". Is there any other way of inputting cross sells for this many items in a shorter amount of time.

I also have another question. When I did have either of these installed, I was able to input a cross sell for 3 items resulting in 12 cross sells. This worked perfectly. When I went to add an additional cross sell for different items, these new items were set as cross sells of the first set.

What did I do wrong possibly?

Thanks in advance.

I have installed Multi Cross Sell and it seems to be working fine except for how it displays in IE. (see images below).
I cannot seem to figure A) what is happening or B) how to fix it.

The URL for the item is here: http://www.abacuspub.com/shop/index.php?main_page=product_info&cPath=1&products_id=170

Any thoughts?

Thanks!

David

Daviator:

I have installed Multi Cross Sell and it seems to be working fine except for how it displays in IE. (see images below).
I cannot seem to figure A) what is happening or B) how to fix it.

The URL for the item is here: http://www.abacuspub.com/shop/index.php?main_page=product_info&cPath=1&products_id=170

Any thoughts?

Thanks!

David It works in ie6 and ff12
In ie8 it breaks, but lines up ok in "compatability mode"

btw: ie6 is the only one that shows 3 across correctly
The padding appears to be wrong in the others!
It would appear to be a CSS problem but I can't quickly see what it is.

techextreme:

gilby,

I've read this entire thread from end to end. I've also installed and uninstalled both Multi Cross Sell and Cross Sell Advanced Multi Cross Sell. Both allowed me to input cross sells and gave me the ability to view each. My problem is, we will have over 10,000 products in our site. To add that many cross sells will talk a "month of sundays". Is there any other way of inputting cross sells for this many items in a shorter amount of time.
It takes planning!!! :no:
Don't cross sell everything for the sake of cross selling. It will end up confusing the customer.

I prepare my cross sells carefully beforehand in a text file, with suitable comments.
Then I cut and paste them into the input boxes.
I start out small and cross sell a few items to see what it looks like on the website, until I find out what appears best. Often you will end up deleting those few and trying something else.

eg: Maybe you sell iphone4s
They come in 16gb, 32gb and 64gb. Also Black or White. So 6 different phones.
You also sell 10 different cases for these phones.

One way to cross sell:
You could cross sell All ways the 16 items against each other. 240 different cross sells.
When any of these items is displayed the other 15 items would be shown as a cross sell.
Quick and easy to do, but the display may be confusing.

Another way to cross sell:
Create a cross sell with the generic header "Similar Products"
Cross sell All ways the 6 phones against each other.

Create another cross sell with the generic header "Matching Products"
One Way cross sell all the cases to each (all) of the phones.
One way cross sell all the phones to each (all) of the cases.

Now when a phone is displayed.
You will have the cross sell "Similar Products" showing the other 5 phones.
You will also have the cross sell "Matching Products" showing the 10 cases.

If you have a case displayed instead.
You will also have the cross sell "Matching Products" showing the 6 phones that these cases fit.

This is more time consuming to do initially, but gives a better display of the cross sells. (imo)

techextreme:

I also have another question. When I did have either of these installed, I was able to input a cross sell for 3 items resulting in 12 cross sells. This worked perfectly. When I went to add an additional cross sell for different items, these new items were set as cross sells of the first set.

What did I do wrong possibly?

Thanks in advance.You must have a common item in each group
or you entered both groups at the same time instead of separately entering each group.

btw: 3 items cross sell all ways = 6 cross sells
4 items cross sell all ways = 12 cross sells

HI all

I installed this mod with no Isuues at all

I got this at the top after I put in cross sell

Product 75 has been added as a Cross-Sell to Product 179
Product 179 has been added as a Cross-Sell to Product 75

I also have this message

"The heading for this Cross Sell has not been defined in the Catalog"

When I go to either of the items I see nothing there.
I am using the "A modern zen template"
and running 1.5 if that matters

Thanks alot

Dave

dsimon:

"The heading for this Cross Sell has not been defined in the Catalog"Dave
These are defined in the file
\includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defines.php
Check to see that..
You renamed the "YOUR_TEMPLATE" directories to the name of your template before uploading the "includes" directory files.
Then check that the "includes" directory files actually exist on the website.

dsimon:

When I go to either of the items I see nothing there.

DaveAs above check that ALL The includes files are on the website in their correct places

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?

also how do I add more cross sells as well

Thanks for all your help

Dave

https://www.thecoinopshopinc.com

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

dsimon:

also how do I add more cross sells as well
https://www.thecoinopshopinc.comadmin->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

    KEY `idx_products_id_xsell` (`products_id`) ) [B]TYPE[/B]=MyISAM");
```becomes```
    KEY `idx_products_id_xsell` (`products_id`) ) [B]ENGINE[/B]=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.

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

KEY `idx_products_id_xsell` (`products_id`) ) [B]TYPE[/B]=MyISAM");

becomes
KEY idx_products_id_xsell (products_id) ) [B]ENGINE[/B]=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:

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.

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

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?