Cross Sell

No chance there is a way to order the products in the admin side to list alphabetically instead of by product number is there?

shawnz28:

No chance there is a way to order the products in the admin side to list alphabetically instead of by product number is there?

I'm wondering much the same thing. I see the Cross Sell Advanced allows you to type in a product ID, but is there anyway to sort other than Prod ID?

I have installed zen cart 1.3.6 and cross sell 1.3.0.1 or 1.3 dont know for sure. The problem wich occured recently is that it doesnt show any cross sell products on product info page, but i dont know a couple of weeks it worked fine and there was no changes to any files, only admin changes of adding a product and changing cross sell items.
Any one has any idea?

dab:

I have just tried installing Cross Sell 1.3.1 and get an error when installing the SQL patch..

For anyone else having the same problem I managed to cure it by running the SQL statements one at a time, and without the comments, rather running than the complete file in one go.

I installed the Cross Sell mod today, but it doesn't appear to be working. The entries from the sql patch all seem to have shown up. But, there is nothing in the sql patch that creates a way for me to actually setup the products I want to cross sell.

The instructions say this should be found under Admin-Catalog-Cross Sell Products.
But, there is no Admin-Catalog-Cross Sell Products!?!?!!

:frusty:

Nevermind. I can't believe I made such a silly mistake! :) I uploaded the files to the wrong directory. :)

I installed Cross Sell 1.3.0 and Cross Sell Advanced and all is working fine. Everything OK in Admin and no error messages.
My problem is that my "We Also Recommend" is showing up in my 'Right Side Box.
To my knowledge there is no Layout Box Controller settings to cause this to show in the 'Right Sidebox'.

I am using 1.3.7 with Apple-zen template and CSS_Flyout_Header 1.5.
See what is happening at: http://stunstasersandmore.com

:no:Can't find anything similar in the threads and sure am stumped on this one. Please help.

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.

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.

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

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?

I think I found it but I get

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

**

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.

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.

Yeah thanks forgot to mention I figured it out.

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)]

I got the exact same problem too.
Any one has any idea why?
I got the cross sell and Upsell /Cross Sell Cart mod installed

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)][/QUOTE]

Does anyone have a copy of the xsell sidebox? I tried looking for a copy of it in the download section, but it no longer exists there.

Currently, the Cross Sell and Cross Sell Advanced works only 1 way: meaing it only cross product A to B, C, D, But not via versa.
I wish that when a customer click on Prduct B, it will be crossed with other related products like
A, C, and D.

Any one has any idea how to make the 2 way cross sell works?
help is appreciated.

pensive612 asked this question 2 years ago, however the code has changed.

I have cross-sell installed and working, however, if I add more than 3 products it goes to another row. is there something I can do to adjust the columns per row for cross-sell?

I need it to show 4 rows.

I've tried adjusting the following in modules/xsell_products.php:

if (!defined('SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS')) define('SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUCTS',4);

However it still shows 3. Any ideas would be really appreciated! Thanks in advance

Just found the solution:

Admin -> Configuration -> Product Info

At the bottom set the option "Cross-Sell Products Columns per Row" to 4 (or whatever you wish.

Hi,

I use Zen Cart 1.3.8a. Is it compatible with Cross Sell 1.3.0.it (uploaded Jan 06 2008)?

Thanks.