Multi Cross Sell mod [Support thread]

[guirfdlr]

I did as you suggested, and the results are the same. I put everything back in original, I even went over the merge of tpl_product_info_display. The only difference between the sample and mine was the insertion of my social network button at the top of the document. I checked the cache, the only thing produced by the action of pressing the 'go' button was, It produced 2 query_selects.
I went over the query_selects, no errors.
I hope you have so more suggestions, I really Like this mod.
I'n running v1.3.9h, with an ashley_pink template, and I have a facebook like button installed.
I hope you can helpm, Thanks
Doug
candlesplusonline.com

[gilby]

I did as you suggested, and the results are the same. I put everything back in original, I even went over the merge of tpl_product_info_display. The only difference between the sample and mine was the insertion of my social network button at the top of the document. I checked the cache, the only thing produced by the action of pressing the 'go' button was, It produced 2 query_selects.
I went over the query_selects, no errors.
I hope you have so more suggestions, I really Like this mod.
I'n running v1.3.9h, with an ashley_pink template, and I have a facebook like button installed.
I hope you can helpm, Thanks
Doug
candlesplusonline.com

I am away from my computer until next week. won't be able to offer more suggestions until I am back.

[My_Red_Zebra]

Hi, I've loaded up the Multi Cross Sell module and functionality is working really nicely. My problem is aesthetic. The box doesn't appear correctly per our template. Included in my box is the correct appearance (based on 'Customer who bought this product also purchased.....) and the box below which is the Multi Cross Sell addition (suggested matching items....).

Question: Why is it not appearing correctly? What do I have to do to correct this?

Thanks,
Red Zebra

[My_Red_Zebra]

Hi, I've loaded up the Multi Cross Sell module and functionality is working really nicely. My problem is aesthetic. The box doesn't appear correctly per our template. Included in my box is the correct appearance (based on 'Customer who bought this product also purchased.....) and the box below which is the Multi Cross Sell addition (suggested matching items....).

Question: Why is it not appearing correctly? What do I have to do to correct this?

Thanks,
Red Zebra

[gilby]

Hi, I've loaded up the Multi Cross Sell module and functionality is working really nicely. My problem is aesthetic. The box doesn't appear correctly per our template. Included in my box is the correct appearance (based on 'Customer who bought this product also purchased.....) and the box below which is the Multi Cross Sell addition (suggested matching items....).

Question: Why is it not appearing correctly? What do I have to do to correct this?

Thanks,
Red Zebra

It easier to work out with a live site.....

However Multi Cross Sell uses..
class="centerBoxWrapper" and class="centerBoxHeading"

So find what styling has been applied to the "also purchased box" and apply it to these classes.

[niccol]

@Gilby
Firstly, I like this module. Like you I never understood the module manager approach.

Secondly, perhaps because I tend to do modified, quite highly structured sites, I often need the number of images to be constant, so as not to break the formatting of the page. So, what I tend to do is 'pad' the number of cross sells with other products, so that, for instance, four products are always shown. If only two xsells are set then two other products are used to make up the numbers.

This padding might be a nice feature to include in the module. Because I tend to do it for a specific site I haven't done all the coding ( for instance an admin switch to turn this on and off ) but thought I'd send you the changes that I make. Just a quick change to the query really:

$sql1 = "(select distinct p.products_id, p.products_image, pd.products_name
                   from " . TABLE_PRODUCTS_MXSELL . $mxsell . " xp, " . TABLE_PRODUCTS . " p, " .
                   TABLE_PRODUCTS_DESCRIPTION . " pd
                   where xp.products_id = '" . $_GET['products_id'] . "'
                   and xp.xsell_id = p.products_id
                   and p.products_id = pd.products_id
                   and pd.language_id = '" . $_SESSION['languages_id'] . 
                   $xsell_sort_by.')'; 

$sql2 = "(select distinct p.products_id, p.products_image, pd.products_name
                   from  " . TABLE_PRODUCTS . " p, " .
                   TABLE_PRODUCTS_DESCRIPTION . " pd
                   where p.products_id = pd.products_id
                   and p.products_id != '" . $_GET['products_id'] . "'
                   and pd.language_id = '" . $_SESSION['languages_id'] . 
                   'order by rand()'.')'; 

$sql = $sql1. ' union '.$sql2." limit " . constant('MAX_DISPLAY_XSELL' . $mxsell);

  $xsell_query = $db->Execute($sql);

It evidently would not be too hard to include a if statement that either uses or doesn't use the second query depending on an admin switch. I just have never done it because I haven't needed it.

As I say you have my respect for having taken this mod on.

[MK1990]

Hi,

I would like to make the cross sells show up at the bottom of the shopping cart as well.

Is there a portion of the cross sell module code that I can copy&paste to the shopping cart?
(I tried to do this myself by copy-pasting the whole or different portions of the module, but somehow it didn't work.)

Thanks a lot!

[gilby]

Secondly, perhaps because I tend to do modified, quite highly structured sites, I often need the number of images to be constant, so as not to break the formatting of the page. So, what I tend to do is 'pad' the number of cross sells with other products, so that, for instance, four products are always shown. If only two xsells are set then two other products are used to make up the numbers.

This padding might be a nice feature to include in the module. Because I tend to do it for a specific site I haven't done all the coding ( for instance an admin switch to turn this on and off ) but thought I'd send you the changes that I make. Just a quick change to the query really:

It evidently would not be too hard to include a if statement that either uses or doesn't use the second query depending on an admin switch. I just have never done it because I haven't needed it.

Interesting idea...
I will add it to my (potential) list of improvements to this mod.

[gilby]

Hi,

I would like to make the cross sells show up at the bottom of the shopping cart as well.

Is there a portion of the cross sell module code that I can copy&paste to the shopping cart?
(I tried to do this myself by copy-pasting the whole or different portions of the module, but somehow it didn't work.)

Thanks a lot!

Not quite as simple as that unfortunately...

The basic cross sell selects a number of cross sell products for ONE main product.

Adding it to the shopping cart increases the number of MAIN products to select cross sells for.
So you have to select cross sells for ALL the products in the shopping cart.
Merge them.
Then cut it down to a workable number of cross sells to display.

In this mod which allows multiple headers you could end up with a number of different cross sell center boxes as well. so that would also have to be taken into account.

There are at least 2 existing cross sell mods that have had a go at it.
I don't see myself including it in the near future.

[bloomingvine]

Just setting up an upgrade shop with 1.5 released. I uploaded from the old database and installed multi-cross sell, which I really need in my shop. It is the best mod. However, in 1.5, there is no boxes folder in the admin, so there is no way to install the mod through admin. Is there any way to get a sql patch ti install it? I loaded the3 old database and pasted into product infodisplay in template default, and all my cross sells from the old store are there and displaying. there is just no way to add more or access the mod from admin. Thanks. no hurry.