Cross Sell

[milobloom]

Just installed the Advanced Cross Sell. Thanks! I did not even know that existed.
It works great if you know your product numbers (Doesn't use a drop down) Which I actually prefer.

Only problem i see is that it allows you to put in 6 products. However its only displaying 4. Did I set something up wrong???

[milobloom]

I allways do this...

Of course I had to have something set up wrong...

catalog - > Maximum Values ... Ah there it is...

[mcpisik]

Wah...and ....boohoo

I have done all renames as suggested (i think), etc
But still come up with

Warning:  main(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.main on line ]: failed to open stream: No such file or directory in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17

Warning:  main(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.main on line ]: failed to open stream: No such file or directory in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17

Warning:  main() [function.include on line ]: Failed opening 'includes/modules/FILENAME_XSELL_PRODUCTS.php' for inclusion (include_path='.:/usr/share/pear') in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17 

Mod works fine in Admin, but just doesn't show on my site.
Somebody save me!

[jacque427]

When a customer places more than 12 items in their shopping cart the "Also Purchased" box at the bottom disappears and the following error message appears...

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 = '265' 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 = '268' 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 = '270' 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 = '283' 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 = '292' 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 = '521' 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 = '307' 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 = '314' 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 = '363' 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 = '367' 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 = '365' 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 = '344' 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 = '1229' 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)]

What's causing this?

ZC 1.3.7

Jacque

[mcb650]

Hi guys,

I normally try to exhaust everything before I ask for help and I've spent lots of time searching on here for another answer, but I'm absolutely stumped and I could use some help. Here's the problem page:

http://www.batterygenie.com/index.ph...roducts_id=225

For some reason, the Cross Sell box heading is displaying in black in Firefox (which I don't want) and in white (which I DO want) in IE. Here's the code from the source on the page:

<h2 class="centerBoxHeading">We also recommend :</h2>

My CSS looks fine to me, with the text set to #FFFFFF for the centerBoxHeading class. It looks like this:

h2.centerBoxHeading {
color:#FFFFFF;
font-size:1.3em;
}

Any help you guys can give would be great. I've spent a few hours now trying to track this thing down and I'm just stumped.

[Linux]

I am currently using Zen 1.37. I went to add Cross Sell and all I see is Cross Sell Advanced and it says that you must have Cross Sell installed prior.

Can someone please tell me which one works with 1.37 and which one is correct.

Thanks.

[smoke133]

Is there a way set up the cross sell so when you hover your mouse over the item in the cross sell box that it brings up a short discription of the product?

Also, can a radio box be put in so when it is check, it would be added into the cart when the add to cart button is clicked for the main item they are ordering?
If so, how would I add this?

[smoke133]

I am currently using Zen 1.37. I went to add Cross Sell and all I see is Cross Sell Advanced and it says that you must have Cross Sell installed prior.

Can someone please tell me which one works with 1.37 and which one is correct.

Thanks.

Look under the "Marketing Tools" of the download area.

[dab]

I have just tried installing Cross Sell 1.3.1 and get an error when installing the SQL patch. I installed as the insructions, using the Admin->Tools->Install SQL Patch, browse & upload the included SQL file (products_xsell.sql).

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 'true','false'), ', now())' at line 1
in:
[INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell - Display prices?', 'XSELL_DISPLAY_PRICE', 'false', 'Cross-Sell -- Do you want to display the product prices too?
Default: false', 18, 72, 'zen_cfg_select_option(array('true','false'), ', now());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

The mod still seems to work fine despite the error. This was on one of my test sites. I tried it on a second test site and got exactly the same.
I have Zencart 1.37, and my host uses "MySQL 4.1.22-standard" and "PHP Version 4.4.7"

Although this mod seems to work ok, I am a bit wary of doing it on my live sites with this installation error.

Any help would be appreciated.

[epsports]

Hello all,
I have just installed cross-sell 1.3.1. sql patch uploaded fine, I have uploaded all files, and double checked them, I can modify min/max values for cross-sell, so you'd think that the plug-in should work fine... but... I go into admin-catalog- and there is no cross-sell products option. When I installed the stock attributes plug-in, it worked fine, just appeared in admin, but with cross-sell, I have no link in catalog section, please advise if possible somebody!
Thanks , Chris