Multi Cross Sell mod [Support thread]

gilby:

\includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
would be the place to start

Thanks!
I have managed to get the product name to be beside the image using css (thanks to your tableless design) and just need one more thing.
How can I truncate the product name?

Berserker:

Thanks!
I have managed to get the product name to be beside the image using css (thanks to your tableless design) and just need one more thing.
How can I truncate the product name?

Managed to truncate the product name by editing line 67. Changed it to below (last part of the line)

zen_trunc_string($xsell_query->fields['products_name'],35)

If this is the wrong way of doing it, please correct me.

I have recently installed the latest version of Zen cart and added the multi cross sell mod.

Everything is great except for the cross products are listed several times on the page, please see attached link

I am sure I have done something wrong but cant work it out. Any help would be good. Thanks

Trice

http://www.styleuboutique.com/catalog/index.php?main_page=product_info&cPath=39_42&products_id=168

Hi, I'm having trouble setting up this add-on.

The instructions say to go to Admin->Configuration->Multi Cross Sell to install, but that link is not in the Configuration menu.

From previous posts on this thread it sounds like the correct place to install is actually Catalog > Multi Cross-Sell, but when I go to that page it takes me back to the home page of the site. (Not the home page of the admin, the site's home page.)

I removed a previous cross-sells add-on before installing multi cross-sells. I deleted the files only: I didn't make any changes to the database.

Any ideas of what could be causing this problem would be appreciated. Thanks!

(Also, the readme says that the file path is "admin\includes\multi_xsell.php", but in my download that file was in "admin\multi_xsell.php". Which is correct?)

aeolidia2:

Hi, I'm having trouble setting up this add-on.

The instructions say to go to Admin->Configuration->Multi Cross Sell to install, but that link is not in the Configuration menu.

From previous posts on this thread it sounds like the correct place to install is actually Catalog > Multi Cross-Sell, but when I go to that page it takes me back to the home page of the site. (Not the home page of the admin, the site's home page.)
Catalog->Multi Cross-Sell is correct

aeolidia2:

I removed a previous cross-sells add-on before installing multi cross-sells. I deleted the files only: I didn't make any changes to the database.

Any ideas of what could be causing this problem would be appreciated. Thanks!
You should have uninstalled the previous version
Use the uninstall sql for that version to remove it
(Don't remove the xsell database if you want to reuse it)

aeolidia2:

(Also, the readme says that the file path is "admin\includes\multi_xsell.php", but in my download that file was in "admin\multi_xsell.php". Which is correct?)
The download is correct, "admin\multi_xsell.php"

I installed the mod, and I made 5 cross sells.
But they are not showing on my site.
https://webstore.jellybeanfabrics.com/index.php?main_page=product_info&cPath=2&products_id=372&zenid=1ipv78nbq1niiv2lrprbj22pi4
This product should link to the corresponding kit.
My settings under config are set to true so it should be on, right?

Andi98640:

I installed the mod, and I made 5 cross sells.
But they are not showing on my site.
https://webstore.jellybeanfabrics.com/index.php?main_page=product_info&cPath=2&products_id=372&zenid=1ipv78nbq1niiv2lrprbj22pi4
This product should link to the corresponding kit.
My settings under config are set to true so it should be on, right?

You have a custom tpl_product_info_display.php file
You haven't "merged" the display code into this

You will find sample code in the mod here
\includes\templates\YOUR_TEMPLATE\templates\SAMPLE_ADDITION_TO_tpl_product_info_display.php

Hi, hoping this is just a quick one, I've installed CrossSell and is working pretty much perfectly, problem is though that I want the related products to be all on one row - for some reason it's on two rows. Does anyone have any clue as to how they can all be on one row?

http://www.chichairandbeauty.co.uk/bang/index.php?main_page=product_info&cPath=6&products_id=3

coxdabd:

Hi, hoping this is just a quick one, I've installed CrossSell and is working pretty much perfectly, problem is though that I want the related products to be all on one row - for some reason it's on two rows. Does anyone have any clue as to how they can all be on one row?

http://www.chichairandbeauty.co.uk/bang/index.php?main_page=product_info&cPath=6&products_id=3

I've fixed it. If any Googler should stumble across this, the way to add more related products to a row is in the MySQL database in the 'configuration' table.

I've just installed this on a 1.3.9h store. It replaced the Advanced Cross-Sell mod in the old 1.3.8a store which I am upgrading. I renamed the products_xsell table to products_xsell1. In the admin, everything looks great, I can see all the cross-sells. However, on the product page that the customer sees, I get this error:

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 products_xsell1 xp, products p, products_description pd where xp.products_id = '474' 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 ]

Any ideas on what could be causing this?

Thanks!

Danielle:

I've just installed this on a 1.3.9h store. It replaced the Advanced Cross-Sell mod in the old 1.3.8a store which I am upgrading. I renamed the products_xsell table to products_xsell1. In the admin, everything looks great, I can see all the cross-sells. However, on the product page that the customer sees, I get this error:

Any ideas on what could be causing this?

Thanks!

Same problem as in Post# 29
Answer is in Post# 31

You will need something like phpmyadmin to search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And then delete it.

I had a question....Is there any way I can upload a whole list of related products to the database at one time, instead of doing it through the admin section? I have over 5000 products and I have a whole spreadsheet of related products to model number...can i do a bulk upload and have all those products relate to each other?

I am using 1.3.9d

kal130:

I had a question....Is there any way I can upload a whole list of related products to the database at one time, instead of doing it through the admin section? I have over 5000 products and I have a whole spreadsheet of related products to model number...can i do a bulk upload and have all those products relate to each other?

I am using 1.3.9d

There is nothing built in for this, sorry

You could create a custom sql script to do this

Can you point in the the right direction on where to look?

philip937:

ok, well I got it to work, however, its does not work using the file tpl_modules_multi_xsell_products.php

so as a fix, I just included the old file on my server as well solely for cart upsell to use unless someone can work out what the difference is that causes it not to work.

so all I did was specified the table products_xsell1 and made sure I had includes/templates/MY_TEMPLATE/templates/tpl_modules_xsell_products.php

so that when cart upsell calls it here:

  require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');    }

> 
> its works.
> 
> like I say, bit of a fudge but I really like cart upsell.  :o)

Hi,
I tried the same as your instructions above but it's not working for me. I changed the Table in the cart-upsell.php page on line 35 and 39 to TABLE_PRODUCTS_XSELL1
and uploaded the tpl_modules_xsell_products.php to the correct template folder online. But nothing appears when I add products to the cart, the cross sell works fine on the product pages.

Am I forgetting something else? I think it is seeing the correct table as when I don't change the table name it gives an error.
Thanks,
B

I have a couple questions.

I did have the same problem everyone else had with the error code showing up in the product description. I have followed what you said and got most of it off. All but this ?>.

I also noticed that the module is showing the products twice. You can see them here http://frompropertorocker.com/index.php?main_page=product_info&cPath=1_7_19&products_id=45

Where do I go to fix these?

Thanks in advance!

nolsowski:

I have a couple questions.

I did have the same problem everyone else had with the error code showing up in the product description. I have followed what you said and got most of it off. All but this ?>.

I also noticed that the module is showing the products twice. You can see them here http://frompropertorocker.com/index.php?main_page=product_info&cPath=1_7_19&products_id=45

Where do I go to fix these?

Thanks in advance!

You have added the multi cross sell code twice in
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php
Thats giving you the double display
Its also giving you those 3 extra characters
Edit that file to fix this problem

Hi there,

Is it possible to create a cross sell table but have this show for certain products only? For example, we have a Camera Directory and want all the products here to have an "Accessories" cross sell table but dont want this to appear for other products i.e. clothes etc.

All the best

Berserker:

Hi there,

Is it possible to create a cross sell table but have this show for certain products only? For example, we have a Camera Directory and want all the products here to have an "Accessories" cross sell table but dont want this to appear for other products i.e. clothes etc.

All the best

You can do this with a normal cross sell as it is.
The downside is all cross sells will have the same generic header.

Using multiple tables allows you customise the header shown for that table,
eg: You could have a "Camera Accessories" header for the cameras.

Note: that with all the cross sells, they work on a product basis, not a category that they are in, basis.
So if you have cameras in linked categories. The cross sell will show whenever that product is viewed, regardless of which category it came from.

gilby:

You have added the multi cross sell code twice in
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php
Thats giving you the double display
Its also giving you those 3 extra characters
Edit that file to fix this problem

Thank you! I didn't realize I had the code in there twice.