Cross Sell Advanced

I have uploaded the cross sell advanced mod to the downloads section. Many of you may find it a simpler way to assign cross sell products.

Enjoy!

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=597

Here is a screen shot:

Hi Voltage,

:thumbsup: Just wanted to say thank you for this great mod. I'm using it and loving it!

Steve

Most of the thanks goes to Absolute. He did the hard coding. I just came up with idea and the $$$ to pay him to do it. ;)

Before this mod, I could not stand setting up the cross sell items. It would take way too long searching for the right item in the list. Now, you can just use the catalog side to decide what to cross sell, and then simply type in the model #'s.

StevenB:

Hi Voltage,

:thumbsup: Just wanted to say thank you for this great mod. I'm using it and loving it!

Steve

It says that is required cross sell to be installed but i cant find the cross sale..

:(

Thanks a lot, nice idea :thumbsup:

I did a quick hack which allows to copy existing cross sells quickly. The zip is attached to this post (includes a short readme and screenshot).

When a customer places more than 12 items in their shopping cart the "Also Purchased" box at the bottom disappears and a very long sql error messages appears. This only occurs if there are more than 12 items in the box.

I have removed all cross sell items, but it still appears.

"Also Purchased" is not the same as "Cross Sell". Sounds like a wierd error though.

a very long sql error messages appears"very long" is not clear enough. You should post the exact message here.

Here's the complete error text. I associated it with cross sell because of some of the text.

1064 You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near '-1)' at line 1
in:

[(select p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '265' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '268' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '270' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '283' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '292' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '521' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '307' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '314' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '363' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '367' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '365' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '344' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '1229' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit -1)]

I am using ZC 1.3.7

jacque

The last part:

limit -1
could be the problem. I tried to reproduce the issue but I did not encounter the same error (not using the newest MySQL version though).

I have some products with the same model number. Cross Sell Advanced doesn't seem to do anything when I enter cross sells for those products. Is this normal, or should it add them for the first product with that model number, or all products with that model number?