Multi Cross Sell mod [Support thread]

[gilby]

I've just installed this on a 1.3.9h store. It replaced the Advanced Cross-Sell mod in the old 1.3.8a store which I am upgrading. I renamed the products_xsell table to products_xsell1. In the admin, everything looks great, I can see all the cross-sells. However, on the product page that the customer sees, I get this error:



Any ideas on what could be causing this?

Thanks!

Same problem as in Post# 29
Answer is in Post# 31

You will need something like phpmyadmin to search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And then delete it.

[kal130]

I had a question....Is there any way I can upload a whole list of related products to the database at one time, instead of doing it through the admin section? I have over 5000 products and I have a whole spreadsheet of related products to model number...can i do a bulk upload and have all those products relate to each other?

I am using 1.3.9d

[gilby]

I had a question....Is there any way I can upload a whole list of related products to the database at one time, instead of doing it through the admin section? I have over 5000 products and I have a whole spreadsheet of related products to model number...can i do a bulk upload and have all those products relate to each other?

I am using 1.3.9d

There is nothing built in for this, sorry

You could create a custom sql script to do this

[kal130]

Can you point in the the right direction on where to look?

[breda]

ok, well I got it to work, however, its does not work using the file tpl_modules_multi_xsell_products.php

so as a fix, I just included the old file on my server as well solely for cart upsell to use unless someone can work out what the difference is that causes it not to work.

so all I did was specified the table products_xsell1 and made sure I had includes/templates/MY_TEMPLATE/templates/tpl_modules_xsell_products.php

so that when cart upsell calls it here:

      require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');    } 

its works.

like I say, bit of a fudge but I really like cart upsell. :o)

Hi,
I tried the same as your instructions above but it's not working for me. I changed the Table in the cart-upsell.php page on line 35 and 39 to TABLE_PRODUCTS_XSELL1
and uploaded the tpl_modules_xsell_products.php to the correct template folder online. But nothing appears when I add products to the cart, the cross sell works fine on the product pages.

Am I forgetting something else? I think it is seeing the correct table as when I don't change the table name it gives an error.
Thanks,
B

[nolsowski]

I have a couple questions.

I did have the same problem everyone else had with the error code showing up in the product description. I have followed what you said and got most of it off. All but this ?>.

I also noticed that the module is showing the products twice. You can see them here http://frompropertorocker.com/index....products_id=45

Where do I go to fix these?

Thanks in advance!

[gilby]

I have a couple questions.

I did have the same problem everyone else had with the error code showing up in the product description. I have followed what you said and got most of it off. All but this ?>.

I also noticed that the module is showing the products twice. You can see them here http://frompropertorocker.com/index....products_id=45

Where do I go to fix these?

Thanks in advance!

You have added the multi cross sell code twice in
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php
Thats giving you the double display
Its also giving you those 3 extra characters
Edit that file to fix this problem

[Berserker]

Hi there,

Is it possible to create a cross sell table but have this show for certain products only? For example, we have a Camera Directory and want all the products here to have an "Accessories" cross sell table but dont want this to appear for other products i.e. clothes etc.

All the best

[gilby]

Hi there,

Is it possible to create a cross sell table but have this show for certain products only? For example, we have a Camera Directory and want all the products here to have an "Accessories" cross sell table but dont want this to appear for other products i.e. clothes etc.

All the best

You can do this with a normal cross sell as it is.
The downside is all cross sells will have the same generic header.

Using multiple tables allows you customise the header shown for that table,
eg: You could have a "Camera Accessories" header for the cameras.

Note: that with all the cross sells, they work on a product basis, not a category that they are in, basis.
So if you have cameras in linked categories. The cross sell will show whenever that product is viewed, regardless of which category it came from.

[nolsowski]

You have added the multi cross sell code twice in
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php
Thats giving you the double display
Its also giving you those 3 extra characters
Edit that file to fix this problem

Thank you! I didn't realize I had the code in there twice.