Cart Upsell / Cross sell

Yes this works. Thank you.

I still would like to find out how to change the layout with the setting 1.

Layout should not overlap....must be a css setting or something.

Without actually seeing your site, we can only make wild guesses. This is going to be about the interaction of your HTML and your CSS which can't be seen in a screenshot.

Hi Kuroi,

You may see it here: http://www.artwax.com/candlestore

Just put an item in the cart and you will see my problem.

Thanks for looking...

This added to your stylesheet will clear the immediate problem> #crossSell {clear:both}But there are also a number of structural problems on the page, such as tags not closed properly and DIVs inside links where they're not allowed that should really be dealt with.

Thanks, I will apply the stylesheet suggestion.

Do you think the other problems you mentioned on my page are from the upsell, cross-sell contribution? Or something else....?

Just added: #crossSell {clear:both}

No effect in firefox and ie. Any other suggestions?

I'm having similar problems with my line 17 after installing Cross Sell and the Cross Sell Advanced.

I can use the config portion without any problems but when it displays on the page, I get the following error:

Warning: main(includes/modules/FILENAME_XSELL_PRODUCTS.php): failed to open stream: No such file or directory in /home/content/s/t/e/steveo3279elec/html/includes/templates/template_default/templates/tpl_modules_xsell_products.php on line 17

Warning: main(includes/modules/FILENAME_XSELL_PRODUCTS.php): failed to open stream: No such file or directory in /home/content/s/t/e/steveo3279elec/html/includes/templates/template_default/templates/tpl_modules_xsell_products.php on line 17

Warning: main(): Failed opening 'includes/modules/FILENAME_XSELL_PRODUCTS.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/s/t/e/steveo3279elec/html/includes/templates/template_default/templates/tpl_modules_xsell_products.php on line 17

ANY IDEAS?

Thanks,
Steve

mydanilo:

Just added: #crossSell {clear:both}

No effect in firefox and ie. Any other suggestions?That's because you're now using Also Purchased instead of Cross Sell. To fix the problem for Also Purchased you would need to add> #alsoPurchased{clear:both}

steveo3279:

I'm having similar problems with my line 17 after installing Cross Sell and the Cross Sell Advanced.

I can use the config portion without any problems but when it displays on the page, I get the following error:

Warning: main(includes/modules/FILENAME_XSELL_PRODUCTS.php): failed to open stream: No such file or directory in /home/content/s/t/e/steveo3279elec/html/includes/templates/template_default/templates/tpl_modules_xsell_products.php on line 17

Warning: main(includes/modules/FILENAME_XSELL_PRODUCTS.php): failed to open stream: No such file or directory in /home/content/s/t/e/steveo3279elec/html/includes/templates/template_default/templates/tpl_modules_xsell_products.php on line 17

Warning: main(): Failed opening 'includes/modules/FILENAME_XSELL_PRODUCTS.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/s/t/e/steveo3279elec/html/includes/templates/template_default/templates/tpl_modules_xsell_products.php on line 17

ANY IDEAS?

Thanks,
SteveThis looks like an installation problem. Check that your xsell_definitions.php file has made it into your includes/extra_definitions folder.

TY TY TY

That fixed it!

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

Thanks again,
Steve

steveo3279:

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. :P

#alsoPurchased{clear:both}

did the trick. Thank you Kuroi, you rock! :clap:

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.

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.

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.

:blush:

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:

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:

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

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... :(

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?

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

Upper part of code read: