Cart Upsell / Cross sell

[kuroi]

I'm curious...how did you go about troubleshooting that?

Your warning messages included references to "FILENAME_XSELL_PRODUCTS". Upper case terms like this are almost always PHP constants that should be resolved to their values, but in this case clearly hadn't.

Definition are usually done in the language folders if they're language-dependent, but a filename isn't, which led me to the language-independent extra-definitions folder.

I think that's how anyway. I really just looked at the warning message and instantly knew what the problem was (but I didn't think that would be a very helpful explanation!!!) and then softened my language slightly to account for the 1% chance that it was something else.

[mydanilo]

#alsoPurchased{clear:both}

did the trick. Thank you Kuroi, you rock!

[coolglobal]

Cross sell and cart upsell are installed and working Ok.

I just have a layout problem.

Cart upsell items are only showing 3 across, then displaying on the next row.
I would like them to display 4 across on one row.

This is the way Cross sell items are displaying in product info pages.

Your help is greatly appreciated.

[bigbadboy]

Installed and working fine, just having a problem with the layout.

Firstly the Header title isn't showing
I've been through all the possible files with:
define('TEXT_XSELL_PRODUCTS', 'We Also Recommend :'); but nothing.

Also, everything is left aligned in rows. I need 3 products,defined in admin, in columns.

I think the problem lies in the fact that this mod uses tpl_columnar_display.php for the display:

In tpl_modules_xsell_products.php -

<!-- bof: tpl_modules_xsell_products -->
<div class="xsell" id="crossSell">
<h2 class="centerBoxHeading"><?php echo TEXT_XSELL_PRODUCTS; ?></h2>
<?php
/**
 * require the list_box_content template to display the cross-sell info. This info was prepared in modules/xsell_products.php
 */
require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php');
?>
</div>
<!-- eof: tpl_modules_xsell_products -->

Obviously I can change the css for this but then that'll change everything else.

Is there a way to not use tpl_columnar_display.php ?

I have temporarily put a green border around the box to help find what's going on.
If you can possibly help I will PM you the URL as I can't post it here.

Thanks in advance.

[bigbadboy]

Missed the edit deadline!

Sorted the header problem, it was in white, against a white background but wasn't in the place I thought it was.

[nguyenkhv]

Hello all,

I have installed the mod and it seems to work fine with or without the Cross Sell mod. Only when I add item number 13th into the shopping cart, I got this error. Please help. I have zen cart version 1.3.8a .
--------------------
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 27
in:
[(select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7045' and opa.orders_id = opb.orders_id and opb.products_id != '7045' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7044' and opa.orders_id = opb.orders_id and opb.products_id != '7044' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7043' and opa.orders_id = opb.orders_id and opb.products_id != '7043' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7042' and opa.orders_id = opb.orders_id and opb.products_id != '7042' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7041' and opa.orders_id = opb.orders_id and opb.products_id != '7041' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7037' and opa.orders_id = opb.orders_id and opb.products_id != '7037' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7005' and opa.orders_id = opb.orders_id and opb.products_id != '7005' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6726' and opa.orders_id = opb.orders_id and opb.products_id != '6726' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6357' and opa.orders_id = opb.orders_id and opb.products_id != '6357' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6514' and opa.orders_id = opb.orders_id and opb.products_id != '6514' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6728' and opa.orders_id = opb.orders_id and opb.products_id != '6728' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6701' and opa.orders_id = opb.orders_id and opb.products_id != '6701' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6777' and opa.orders_id = opb.orders_id and opb.products_id != '6777' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc:

[Tim Ware]

Hello all,

I have installed the mod and it seems to work fine with or without the Cross Sell mod. Only when I add item number 13th into the shopping cart, I got this error. Please help. I have zen cart version 1.3.8a .
--------------------
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 27
in:
[(select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7045' and opa.orders_id = opb.orders_id and opb.products_id != '7045' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7044' and opa.orders_id = opb.orders_id and opb.products_id != '7044' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7043' and opa.orders_id = opb.orders_id and opb.products_id != '7043' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7042' and opa.orders_id = opb.orders_id and opb.products_id != '7042' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7041' and opa.orders_id = opb.orders_id and opb.products_id != '7041' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7037' and opa.orders_id = opb.orders_id and opb.products_id != '7037' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7005' and opa.orders_id = opb.orders_id and opb.products_id != '7005' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6726' and opa.orders_id = opb.orders_id and opb.products_id != '6726' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6357' and opa.orders_id = opb.orders_id and opb.products_id != '6357' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6514' and opa.orders_id = opb.orders_id and opb.products_id != '6514' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6728' and opa.orders_id = opb.orders_id and opb.products_id != '6728' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6701' and opa.orders_id = opb.orders_id and opb.products_id != '6701' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 2) UNION (select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '6777' and opa.orders_id = opb.orders_id and opb.products_id != '6777' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc:

I am also experiencing this exact issue.. If anybody has any clues they would be much appreciated?

[R y u]

I've been searching for days and i've only found an up sell mod for zencart v 1.3.6. I'm using zencart v 1.3.8 btw, is this still compatible with the newer versions the upsell mod from the download section? I have also read that upsell was built in to zencart, but i don't have any ideas to on how to setup this... Any help or clarification for this please...

[Girdy74]

I am having this exact issue. I am running v 1.3.8 and using this mod along with advanced cross sell, quanity discounts, preview discounts.

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 products_xsell xp, products p, products_description pd where xp.products_id = '136' 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 products_xsell xp, products p, products_description pd where xp.products_id = '141' 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 products_xsell xp, products p, products_description pd where xp.products_id = '137' 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 products_xsell xp, products p, products_description pd where xp.products_id = '140' 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 products_xsell xp, products p, products_description pd where xp.products_id = '138' 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 products_xsell xp, products p, products_description pd where xp.products_id = '142' 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 products_xsell xp, products p, products_description pd where xp.products_id = '143' 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 products_xsell xp, products p, products_description pd where xp.products_id = '144' 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 products_xsell xp, products p, products_description pd where xp.products_id = '145' 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 products_xsell xp, products p, products_description pd where xp.products_id = '147' 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 products_xsell xp, products p, products_description pd where xp.products_id = '148' 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 products_xsell xp, products p, products_description pd where xp.products_id = '149' 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 products_xsell xp, products p, products_description pd where xp.products_id = '129' 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)]

Help!! Does anyone know what is happening here?

[Girdy74]

I just posted the above comment. I changed:
includes/modules/YOUR_TEMPLATE/cart_upsell/php

Upper part of code read:
<?
/*
$Id: cart_upsell.php, v1
Copyright (c) 2006 TooLateSmart
Released under the GNU General Public License for zencart
*/

// number of upsells/xsells to display
define('NUMBER_UPSELLS_DISPLAY', '9');
define('NUMBER_XSELLS_DISPLAY', '9');

and I changed it to:
<?
/*
$Id: cart_upsell.php, v1
Copyright (c) 2006 TooLateSmart
Released under the GNU General Public License for zencart
*/

// number of upsells/xsells to display
define('NUMBER_UPSELLS_DISPLAY', '50');
define('NUMBER_XSELLS_DISPLAY', '50');

And now I don't get the error!>>> it was a guess.....

Anyone see anything wrong with that (all you awesome programmers!)? Just want to make sure!!