Multi Cross Sell mod [Support thread]

[bigduffeye]

hello - i am using version 1.03 on zen cart 1.3.9h. i need to have at least 50 seperate cross sells (we sell sets of furniture so need to have each sets products cross selling to each other) now i have made some progress in changing the default 15 cross sells, from editing line 270 in admin/includes/functions/extra_functions/multi_xsell.php and changing the maximum value in the array to 50, but the problem is that when i then go to install the cross sell mod in the cross sell admin - it will only write a maximum of 25 cross sell tables to the db - this is also the same for the configuration table.
therefore if i try to edit any cross sells above 25 it falls over

anyone have any ideas on how to get around this? help would be much appreciated

[gilby]

hello - i am using version 1.03 on zen cart 1.3.9h. i need to have at least 50 seperate cross sells (we sell sets of furniture so need to have each sets products cross selling to each other)

Unless I have missed something here...
From what you have said, you ONLY need one cross sell table to do this NOT 50
Each Cross Sell Table can do thousands of different cross sells.

Having more than one table is useful if you want different header descriptions.
So... if all you want to do is have a header such as "Make a Set with this Matching Furniture"
with lots of different sets of Furniture.
Then you need only 1 table.

now i have made some progress in changing the default 15 cross sells, from editing line 270 in admin/includes/functions/extra_functions/multi_xsell.php and changing the maximum value in the array to 50, but the problem is that when i then go to install the cross sell mod in the cross sell admin - it will only write a maximum of 25 cross sell tables to the db - this is also the same for the configuration table.
therefore if i try to edit any cross sells above 25 it falls over

anyone have any ideas on how to get around this? help would be much appreciated

If you really need 50 cross sells (and I suggest you don't as you are misunderstanding how this works)
admin/multi_xsell.php around line 90

      if(!defined('MIN_DISPLAY_XSELL'. $counter) && ($counter <= 25)) { 
        // hard code a max of 25 so we don't crash the server 

You ONLY need more cross sell tables if the Header is distinctly different.
Same header, use the same table for as many "sets" as you want.

[bigduffeye]

thanks gilby - i get what you are saying, but i really do need 50 different cross sell tables, each furniture set can only have items from its own specific set in the cross sell.

see here
http://www.wearebeds.com/catalog/ind...roducts_id=275
and then we need a new cross sell for a different furniture set like this
http://www.wearebeds.com/catalog/ind...roducts_id=265

but you solved my problem anyway! thanks a lot!

[gilby]

thanks gilby - i get what you are saying, but i really do need 50 different cross sell tables, each furniture set can only have items from its own specific set in the cross sell.

Yes and No!

The 2 examples shown use 2 different headers
"Ariel Bedroom Set" and "Cube Bedroom Set"
As they use different headers then yes you need 2 tables to do this
and if you are going to have 50 different headers then yes you will need 50 tables.

BUT if you were to use a more generic header for all of them
such as "Matching Bedroom Set"
You already have the name of the set further up the page displayed boldly
Then you would need ONLY one table to do them all

I still believe you don't quite understand that.
Each set would be isolated strictly to that set ONLY!!!
The sets do NOT get mixed up using one table.

If you were starting from scratch using one table
For the first set you would enter the following Id's into the cross sell
275,271,270,269,273,430,431
then click "insert"

For the second set you would enter the following Id's into the same cross sell
265,470,471,260,264,262,259
then click "insert"

You will now have the same as what you have but with the one same header for both.
You can do all 50 sets like this if you wish into the same one table.

btw: there will probably be a performance hit searching 50 tables at a time
imo: One table is far more efficient with the low number of items that you cross selling

[bigduffeye]

ah ha!

i wasnt aware that you could insert more than one set of id's into one specific cross sell!

thanks for your help!

[gilby]

ah ha!

i wasnt aware that you could insert more than one set of id's into one specific cross sell!

thanks for your help!

I suspected that...
It takes a while using it to get your head around how it actually works

I will definitely have to improve the documentation with this mod!

[techextreme]

gilby,

I've read this entire thread from end to end. I've also installed and uninstalled both Multi Cross Sell and Cross Sell Advanced Multi Cross Sell. Both allowed me to input cross sells and gave me the ability to view each. My problem is, we will have over 10,000 products in our site. To add that many cross sells will talk a "month of sundays". Is there any other way of inputting cross sells for this many items in a shorter amount of time.

I also have another question. When I did have either of these installed, I was able to input a cross sell for 3 items resulting in 12 cross sells. This worked perfectly. When I went to add an additional cross sell for different items, these new items were set as cross sells of the first set.

What did I do wrong possibly?

Thanks in advance.

[Kevin205]

thanks gilby - i get what you are saying, but i really do need 50 different cross sell tables, each furniture set can only have items from its own specific set in the cross sell.

see here
http://www.wearebeds.com/catalog/ind...roducts_id=275
and then we need a new cross sell for a different furniture set like this
http://www.wearebeds.com/catalog/ind...roducts_id=265

but you solved my problem anyway! thanks a lot!

Wow. How did you get your site to show the cross sell products with check boxes and automatic cart updates? I would love to know how you did it! I would really appreciate your feed back. Thank you.

[Kevin205]

Before I start I wanted to thank you for your contribution.

Running Zen Cart 1.5.1

I installed the “multi_cross_sell_v1.03” plug-in without any problems. This is a fresh install without any prior similar plug-ins.

<!-- BEG: Multi Cross-Sell mod -->
<?php
// THIS CODE WOULD BE ADDED INTO YOUR TPL_PRODUCT_INFO_DISPLAY.PHP WHEREVER YOU WANT TO DISPLAY ALL THE CROSS_SELL BOXES:
  if(defined('MXSELL_ENABLED') && MXSELL_ENABLED == 'true') {
    for ( $mxsell = 1; $mxsell <= MXSELL_NUM_OF_TABLES; $mxsell++ ) { // show all cross sells
      require($template->get_template_dir('tpl_modules_multi_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_multi_xsell_products.php');
    }
  }
?>
<!-- END: Multi Cross-Sell mod -->

I placed the above php code before "/form"

I created 4 products, 1 main product called “PRODUCT A” and 3 parts called “Part 1”, “Part 2” & “Part 3”as follow:
ID for “PRODUCT A” is 24
ID for “Part 1” is 25
ID for “Part 2” is 26
ID for “Part 3” is 27

Under admin/catalogue/Multi Cross Sell, I created a new cross sell as follow:


Under admin/configuration/Multi Cross Settings, my setup is as follow:


When I select “PRODUCT A” I see the following under the “product_info” page



So far so everything is OK.

Question 1) Why is it when I select, add to cart, in the above scenario, “Part 2” gets added to the cart instead of “PRODUCT A”? I have tried this many times on different products and it seems to add the first product on the left from the “Suggested Matching Items…”! What have done wrong? What am I doing wrong?

Question 2) Is there any way to code in and get a “Quantity Box” instead of “Buy Now” button on the product_info_display page only, so the customer could have the choice of picking the quantities of the items he needs to the cart from this page, instead of going back and forth to add related products?

[gilby]

Question 1) Why is it when I select, add to cart, in the above scenario, “Part 2” gets added to the cart instead of “PRODUCT A”? I have tried this many times on different products and it seems to add the first product on the left from the “Suggested Matching Items…”! What have done wrong? What am I doing wrong?

You need to move the </form> as well.
See post 364

Question 2) Is there any way to code in and get a “Quantity Box” instead of “Buy Now” button on the product_info_display page only, so the customer could have the choice of picking the quantities of the items he needs to the cart from this page, instead of going back and forth to add related products?

Could be done (but hasn't as I didn't require it)