Multi Cross Sell mod [Support thread]

[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]

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.

[simon1066]

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.

I attempted to install this mod on a fresh install of v1.50. Had a little trouble merging some of the files - I think I'll wait until gilby is able to issue an upgrade.

As a work around to your admin access problem, using the Admin>Admin Access Management>Admin Page Registration facility and the details in /includes/boxes/extra_boxes/multi_xsell_catalog_dhtml.php one is able to activate the Admin->Catalog->Advanced Cross-Sell option. I'm afraid I can't remember if Admin->configuration->cross sell is subsequently activated of if I navigated there by amending the ?gID= in the Configuration url.

Of course, my installation problems may not have been caused by merging files but by the mods incompatability with v1.50, I don't really know enough to decide which.

Anyway hopefully this might give you something to play with.

Back next year!

[bloomingvine]

Thanks, I was able to go to the page by navigating and changing the url as you suggested, but it seems there is an indefined link in the code on the page. I also moved the boxes/extra_boxes/multi_xsell_catalog_dhtml.php file out into the main admin folder to try to get it to install that way. When I try to type in the admin access page, under filename I am trying all sorts of variations of the path name, but it can't find it. I did just the filename, no path, the whole path with the boxes folder which I uploaded for good measure, and the path to the file I put in the main admin folder. It also returne the error that language is not de4rfined and I need to put the key on the page I think.

As for merging files, I think there was only one file altered, the product info display file. I used the one in template default since I use a heavily modified classic template.

Yeah, I can wait for an update. I am not switching over to the new cart till all my favorite mods are updated. Just testing stuff so far. This is my most important one as I sell artwork on all kinds of products and it is helpful to see all the different products with the same pieces. Happy New Year!

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

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

My test site is technically 'live' (www.mylocalpoolshop.com.au/TanyaPools) but I'm still having problems. I've applied these styles to the same place as the 'also purchased' box but to no satisfaction.

I am no programmer and am not terribly savvy with these things but am certainly learning quite a bit as I go.

Do I have to change the stylesheet or do I have to change the actual files in the downloaded files? If I'm not a wrong path here, can you please advise me what the right path is?

Thanks very much for your help.

[gilby]

My test site is technically 'live' (www.mylocalpoolshop.com.au/TanyaPools) but I'm still having problems. I've applied these styles to the same place as the 'also purchased' box but to no satisfaction.

I am no programmer and am not terribly savvy with these things but am certainly learning quite a bit as I go.

Do I have to change the stylesheet or do I have to change the actual files in the downloaded files? If I'm not a wrong path here, can you please advise me what the right path is?

Thanks very much for your help.

Undo what you have done
You have duplicated id="alsoPurchased"

Then in includes\templates\YOUR_TEMPLATE\templates\tpl_modules_multi_xsell_products.php
around line 30 find..

    <h2 class="centerBoxHeading"><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></h2>

add <span> tags and change to

    <h2 class="centerBoxHeading"><span><?php echo constant('TEXT_MXSELL' . $mxsell . '_PRODUCTS'); ?></span></h2>

See if that works....