Cross Sell

Now a new question, how can I increase the number of records I see on the admin side. Default is 20.

jacque

After installation my images have moved (see example at..http://www.freshabundance.com/index.php?main_page=product_info&products_id=477)

Is this supposed to occur?

Jacque

Found the answer to the number of records to display.

It's in the Configuration, Maximum Values, Number of Search Records to Display setting.

zen-cart version 1.3.7, is it work fine ?
how to it work on 1.3.7 ? help me!

I am using 1.3.7 and cross-sell 1.3.1 and my shop is working just fine.

can you share it ?
im very need them....
tks!

numinix:

The thing about this module that makes it difficult is that you have to navigate through all your product listings to add each product to the cross sell...

Hence the reason the cross sell advanced was created. However it requires that each item have a unique model #:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=597

Even that contribution has it's limitations. Cross selling by category would be a very important contribution and I'm surprised it hasn't been written yet...

I currently use advanced, and find it 10 times better than the regular cross sell module.

Is there a way to set the cross sell to just pick all the items that are in that catagory?

If not. Wouldnt that be a great idea for a mod? Instead of having to add for each item which takes alot of time.

Oops

As if that wasnt what was just talked about... Sorry I didnt look at the recent post.

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???

I allways do this...

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

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

:lookaroun

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! :smile:

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

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.php?main_page=product_info&cPath=1_77&products_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;
}

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.

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?

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.

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

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.

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