Cross Sell

just wondering...

i have cross-sell installed and working great. 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?

thanks in advance.

can somebody point me where to change these color as it is hard to see because of the white font...see attachmenets! :smile:

tajul_ashyqin:
try admin/xsell.php

colours seem to be defined in this file.

pensive612:

just wondering...

i have cross-sell installed and working great. 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?

thanks in advance.

go to includes/modules/YOUR TEMPLATE NAME/xsell_products.php

in the version i have, line 31, or look for:

        if ($col > 2) {

change the number 2. Basically this is saying if it is greater than 3 columns, add a new row. So if you wanted 6 items on a row, you would change this to 5.

let me know how it works out.

I'm trying to show the product model number between product name and product price within the 'Related Products' block at the bottom of the product info display.

Anyone who has ever done that?

Located the probable position of the code to change at line 49 of the includes/modules/xsell_products.php file being:

$list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsCrossSell centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"',
'text' => '<a href="' . zen_href_link(zen_get_info_page($xsell_query->fields['products_id']), 'products_id=' . (int)$xsell_query->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $xsell_query->fields['products_image'], $xsell_query->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br /><a href="' . zen_href_link(zen_get_info_page($xsell_query->fields['products_id']), 'products_id=' . $xsell_query->fields['products_id']) . '">' . $xsell_query->fields['products_name'] . '</a>' . (XSELL_DISPLAY_PRICE=='true'? '<br />'.zen_get_products_display_price($xsell_query->fields['products_id']):'') );

Tried several syntaxes but all failed causing the entire 'Related Product' block not to load. Must be missing a database call at line 23 but none of my attempts worked.

Could somebody please help me with this modification?

Forgive me if I've missed this issue elsewhere, but I'm having an issue since I upgraded to 1.3.5 and also upgraded to IH for 1.3.5. I also have the Cross-sell mod installed, and I think there's an issue between the new IH and the Cross-sell mod (for 1.3.0).

In my upgraded site, when I go to IH in the admin section to add an additional picture, it is also showing all of the photos for anything that is a cross-sell for that item. So, what ends up happening is that all of the cross-sell photos are displayed twice on the product page - as additional photos directly under the main product photo, and also at the bottom of the page under "We also recommend...". This only seems to be happening to products where I go in to add an additional photo, but not to other pages with no additional photo, even if they also have defined cross-sell products.

Here's an example of a page showing the problem: http://superbuzzy.com/index.php?main_page=product_info&products_id=294

I went to add the picture with the finished bags, and found that all of the cross-sell pictures were displayed as additional pictures as well. Does anyone have a suggestion as to what might be going on? There isn't yet a Cross-sell mod update for 1.3.5, so that may be part of the problem... Thanks!

How are you naming your images before you upload them? Are there any similarities between the naming? For example, if you name an image: product, and another product2, the product2 image will show up as an additional image for product.

voltage:

How are you naming your images before you upload them? Are there any similarities between the naming? For example, if you name an image: product, and another product2, the product2 image will show up as an additional image for product.

Yup! That was the ticket... all the images started with "marine". Thanks so much! Learn something new everyday!

reza:

... but the problem of not loading the pages in admin still remains, apart this, i can see cross products under selected product.

the problem is the module using $HTTP_GET_VARS and you probably are using a host or have PHP.INI on your server set to have register_globals turned off.

http://www.zen-cart.com/forum/showthread.php?t=45220

in admin/xsell.php replace all $HTTP_GET_VARS to $_GET and it will start working when you get it uploaded to your host/server.

Is this to say we have to open the Globals to use cross sell????

Sorry about that.. I re-read the posts on this and I have it working fine with the globals closed. So please ignore my post.

DesignbyDemeter:

I have one request further - could it be possible to sort by the header you click on, namely ID#, Category, Alpha, etc. The d/b by ID# is pretty useless to me as I would never memorize product that way.

Thanx!

This too is of interest to me, at least to change the sort to Alpha would be perfect. Can someone give me a clue how to achieve this?

Thanks

This one was easy... line 149 admin/xsell.php change to -

order by pd.products_name asc';

I'm having difficulty getting the cross sell products to appear in two columns. No matter what I seem to do, they just keep returning in a single column. I am using Zen_cart 1.36.

I tried to modify the xsell_products.php file, but can't seem to figure out how to get more than 1 column.

It's probably a simple thing, but I'm stumped.

Any help would be appreciated.

Thanks,

NurseryGuy

Is there any way to cross-sell by category? This module is very time consuming as you need to add each product to each product individually...

numinix:

Is there any way to cross-sell by category? This module is very time consuming as you need to add each product to each product individually...

There is a module called Better Together that is pretty impressive, although I don't know off-hand if you can cross sell by category. You can cross-sell and give a discount. (2nd one 50% off, for example) However, the associations must be hard coded and the logic is such that it gave me a headache, so I gave up and went with this mod. I've decided that I'll just start inputting the associations as I enter new products. That in conjunction with doing some of the most obvious in my store all at once will make for a complete package in time.

I sell computer hardware so for example, if someone is buying a cpu/processor, I want it to automatically cross-sell all products from the cpu fans category. Or all X2 processors when displaying an AM2 motherboard, etc.

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

Hello,

I want to implement the Cross Sell for the latest version of Zen Cart 1.3.7.

When I try to install the availabe Cross Sell, which is for version 1.3.1.

I get the following error:

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

Can anyone help me in this matter?

I really need to implement this. Any help would be appreciated.

Thanks in advance.

I'm getting the same error as Kedar, has this been resolved?

Jacque

Figured it out, used copy/past.