Cross Sell

[Qwert302]

I am using image handler along with cross sell. Right now my additional images appear below my cross sell box, and I would like it to appear above the box. I'm not sure which files of which plug-in I need to alter, so I'm asking on both support threads. Thanks.

[jeking]

I am using image handler along with cross sell. Right now my additional images appear below my cross sell box, and I would like it to appear above the box. I'm not sure which files of which plug-in I need to alter, so I'm asking on both support threads. Thanks.

You can edit your tpl_product_info_display.php file to move where the cross sell box displays.

[teebo]

I've been using cross sell for awhile now, however I had direct checkout system so it never actually worked in the way it was meant to meaning, it would never really show the products people purchase but only the products i added manually to show. THe problem is now that my checkout system is working fine at the shopping cart page it shows we recommend, and what others have purchased now.

I tried removing the line

"<?php require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_CART_UPSELL)); ?>"

but it removes we recommend as well as what others have purchased, how do i remove just what others have purchased?

[teebo]

I think I found it but I get


Warning: Division by zero in mypath/cart_upsell.php on line 120

[jacdesigner]

teebo,

I think you mean to hide the Also Purchased box? To do so I believe you can just go in the Zencart admin to Configuration > Product Info and change the Also Purchased Products per row to 0. I can't recall if there might also be another switch for that.

[teebo]

teebo,

I think you mean to hide the Also Purchased box? To do so I believe you can just go in the Zencart admin to Configuration > Product Info and change the Also Purchased Products per row to 0. I can't recall if there might also be another switch for that.

Yeah thanks forgot to mention I figured it out.

[teebo]

Does this have to do with this mod, get it when I add 13 products to cart


Got this error when I tried to add 13 products



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 '-1)' at line 1
in:
[(select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '31' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '99' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '86' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '94' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '9' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '100' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '12' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '11' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '91' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '90' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '81' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '8' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from widgetproducts_xsell xp, widgetproducts p, widgetproducts_description pd where xp.products_id = '13' 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.products_id asc limit -1)]