Multi Cross Sell mod [Support thread]

I've just installed this mod and everything is working fine.

However, is there any way to cross sell 1 product to ALL products in a particular category without having to enter each product manually?

Thanks.
Bob.

bobmoss:

I've just installed this mod and everything is working fine.

However, is there any way to cross sell 1 product to ALL products in a particular category without having to enter each product manually?

Thanks.
Bob.

Short answer no!

Which way are you tryint to cross sell?

Every product in that category will have the (same) one product as a crossell
or
This one product will have every product in the category as cross sell products?

I have the same question. For example, I want my category of rubber stamps to all have the cross sell of items to mount the rubber stamps. So, each rubber stamp sheet (from the same category) would have the same cross sell of mounting supplies (from a different category). The rubber stamp sheets would not be cross selling with each other.

Is there a way to do that without entering each product from the category?

tracib:

I have the same question. For example, I want my category of rubber stamps to all have the cross sell of items to mount the rubber stamps. So, each rubber stamp sheet (from the same category) would have the same cross sell of mounting supplies (from a different category). The rubber stamp sheets would not be cross selling with each other.

Is there a way to do that without entering each product from the category?

Again the short answer is no.
The reason I don't have that, is that there could be hundreds of items in some categories and cross selling them like this could enable the creation of tens or hundreds of thousands of cross sell records in one go. It would be far too easy to overload the server if used inappropriately.

How many items are in each of the 2 categories?

The way I would do it is create the 2 lists of cross sells in wordpad and cut and paste them to the entry boxes in the mods admin page.

The version v1.02 allows you to do "multi" one way cross sells

Use the "New Cross Sells" section
Click the "Cross Sell 1 way only? "
Copy your list of stamps to "Main product(s): "
Copy your list of mounting supplies to "Product model(s): "
and click "insert"
and its done

If you have made any typos in your lists you can go back to wordpad, edit them and run it again.
It will only add cross sells that don't already exist.

gilby:

Again the short answer is no.
The reason I don't have that, is that there could be hundreds of items in some categories and cross selling them like this could enable the creation of tens or hundreds of thousands of cross sell records in one go. It would be far too easy to overload the server if used inappropriately.
Oh, true--I hadn't thought of that since I don't have tons of items in each category

gilby:

The way I would do it is create the 2 lists of cross sells in wordpad and cut and paste them to the entry boxes in the mods admin page.

The version v1.02 allows you to do "multi" one way cross sells

Use the "New Cross Sells" section
Click the "Cross Sell 1 way only? "
Copy your list of stamps to "Main product(s): "
Copy your list of mounting supplies to "Product model(s): "
and click "insert"
and its done

If you have made any typos in your lists you can go back to wordpad, edit them and run it again.
It will only add cross sells that don't already exist.

Thanks, that's what I thought I needed to do, but wanted to double check. Thanks for getting back to me so fast.

Hello,

Does this module work for 1.5.0?

Thx

uncharted:

Hello,

Does this module work for 1.5.0?

Thx

Not yet.
It will be updated when the production 1.5.0 final version is released.

Hi, I'm using v1.3.9h, I installed multi cross sell yesterday and everything seems to work fine except.. When I try to change cross sells, (from 1 to 2 etc.) in the admin when I click 'go' it goes to my login panel. I have added to my
(array('1','2','3','4'), ')");--all the way to 13-- in my admin/includes/functions/extra_functions/multi_xsell and added to my
includes/lang../english/extra_definitions/ashley_pink/multi_xsell_box_defines'

define('TEXT_MXSELL1_PRODUCTS', 'Suggested Matching Items...');
define('TEXT_MXSELL2_PRODUCTS', 'We also Suggest...');
define('TEXT_MXSELL3_PRODUCTS', 'Other Items of Intrest...');
etc. etc...
I even added a copy of this to my extra_definitions folder. What am I dong wrong.
help Please,
Doug@CandlesPlus:frusty:

guirfdlr:

Hi, I'm using v1.3.9h, I installed multi cross sell yesterday and everything seems to work fine except.. When I try to change cross sells, (from 1 to 2 etc.) in the admin when I click 'go' it goes to my login panel. I have added to my
(array('1','2','3','4'), ')");--all the way to 13-- in my admin/includes/functions/extra_functions/multi_xsell and added to my
includes/lang../english/extra_definitions/ashley_pink/multi_xsell_box_defines'

define('TEXT_MXSELL1_PRODUCTS', 'Suggested Matching Items...');
define('TEXT_MXSELL2_PRODUCTS', 'We also Suggest...');
define('TEXT_MXSELL3_PRODUCTS', 'Other Items of Intrest...');
etc. etc...
I even added a copy of this to my extra_definitions folder. What am I dong wrong.
help Please,
Doug@CandlesPlus:frusty:

(array('1','2','3','4'), ')");--all the way to 13-- in myWhy have edited this ???
By default it supports up to 15 cross sells
Upload the original again.

Check your cache folder for php errors
Almost certainly its a problem editing a file

gilby:

In this version its hard coded to a maximum of 5.
edit admin\includes\functions\extra_functions\multi_xsell.php
around line 237 you will find this code fragment

array('1', '2', '3', '4', '5')

> Add as many more as you want.
> 
> Also
> \includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defines.php
> Add more defines for the additional cross sell headers here
> 
> Go to Admin->Configuration->Cross Sell Settings
> print this page to save the settings
> Go to Admin->Catalog->Multi Cross Sell 
> Click UnInstall
> Upload the 2 edited files
> Refresh
> Click Install
> Go to Admin->Configuration->Cross Sell Settings
> Reenter the previous settings
> Uninstall the

Thanks for replying Well as you can see, this is why. The problem existed before I did any editing. i will try as you suggest. I'll get back with you. Thanks, The original code was this     select_option(array(\'1\'), ')");

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:frusty:

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:frusty:

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

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:blink:

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:blink:

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:blink:

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.

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

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!

niccol:

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.

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!

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.

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.