Multi Cross Sell mod [Support thread]

Just a quick note to say congratulations, Gilby. I know how much work goes in :-) It is appreciated.

Hi, first of all; great mod! Just installed it and it works great.

I've read from another post that in the older version it is possible to increase the number of cross-sells. With the lastest version for ZC1.5 you already added 15 cross-sells. But is it still possible to increase this number?

Hmm... to quick wit my question. Now that I looked again (and better! sry..) there should be no need to do this :P But maybe others may wonder if it is possible or not ;-)

Gerjan:

Hmm... to quick wit my question. Now that I looked again (and better! sry..) there should be no need to do this :P But maybe others may wonder if it is possible or not ;-)

Its hard coded to 15 but you could allter it in the php files if you wish. This is 15 different "header descriptions" of the cross sells.
Such as "We suggest"
or "Similar matching products"

Each of these cross sells (different headers) can have tens of thousands of individual product cross sells each.

Don't confuse the different cross sells (headers) with individual product cross sells.

I use 4 in one of my websites.
15 for most websites is more than enough (imo).
But it can be altered if necessary
nb: Each cross sell (different header) creates a table for its use.

Hi, I am a newly registered member but I have been browsing this forum for years now... I just wanted to thank you for this module I have installed it on Zen 1.5 and it's great! Appreciate your efforts to make this happen. I was wondering if there is a way to display the cross sell product in a sidebox on the product info page! how do you incorporate that into a sidebox? Any suggestions or help will be greatly appreciated.
Thanks

manu_sag:

Hi, I am a newly registered member but I have been browsing this forum for years now... I just wanted to thank you for this module I have installed it on Zen 1.5 and it's great! Appreciate your efforts to make this happen. I was wondering if there is a way to display the cross sell product in a sidebox on the product info page! how do you incorporate that into a sidebox? Any suggestions or help will be greatly appreciated.
Thanks

At this time it is only for center boxes.
No plans for extending to sideboxes or display on the checkout page in the foreseeable future.

That doesn't mean that you couldn't dedicate one of the cross sells to a side box display. It just means you would have to custom code the sidebox yourself.

Thanks for the quick response... I am no expert in php but I'll do some research around this and see if I can make it happen but thank you very much for this great module.

installed in V1.5 and when selected INSTALL i get the error "WARNING: An Error occurred, please refresh the page and try again."

Tried 3 times now, giving up LOL

windsurfer:

installed in V1.5 and when selected INSTALL i get the error "WARNING: An Error occurred, please refresh the page and try again."

Have you checked the cache directory for "error messages"?

I assume you were able to register the page?
(otherwise you wouldn't see an install button)

New (clean) Install?
or upgrade over a previous Multi Cross Sell?
or upgrade from a previous "other" Cross Sell?

gilby:

Have you checked the cache directory for "error messages"?

I assume you were able to register the page?
(otherwise you wouldn't see an install button)

New (clean) Install?
or upgrade over a previous Multi Cross Sell?
or upgrade from a previous "other" Cross Sell?

I have the same question, update from v1.3.9, is there any sql to delete the old install?

hey gilby

have you read the post? i think it is due to this

http://www.zen-cart.com/forum/showpost.php?p=993178&postcount=9

boomup:

I have the same question, update from v1.3.9, is there any sql to delete the old install?

If the old install was Multi Cross Sell then click the "remove" button.

If a different cross sell then check that mod for an uninstall sql.

boomup:

hey gilby

have you read the post? i think it is due to this

http://www.zen-cart.com/forum/showpost.php?p=993178&postcount=9

Yes I aware of that, although to date it hasn't created a problem that I aware of.

gilby:

Yes I aware of that, although to date it hasn't created a problem that I aware of.

Could you tell me how to fix it? thanks a lot

boomup:

Could you tell me how to fix it? thanks a lot

Look in the cache directory for "error messages"?

i installed fresh and not upgrade.
I am using all your files except

it doesn't work with my "tpl_product_info_display.php"
it doesn't work with your "tpl_product_info_display.php"
it doesn't work with merged "tpl_product_info_display.php"

Below is the error log ( I have replaced the name of my admin with ADMIN

[09-Mar-2012 17:54:02 UTC] PHP Fatal error: 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 'TYPE=MyISAM' at line 7 :: CREATE TABLE IF NOT EXISTS products_xsell1 (

`ID` int(10) NOT NULL auto_increment,

`products_id` int(10) unsigned NOT NULL default '1',

`xsell_id` int(10) unsigned NOT NULL default '1',

`sort_order` int(10) unsigned NOT NULL default '1',

PRIMARY KEY  (`ID`), 

KEY `idx_products_id_xsell` (`products_id`) ) TYPE=MyISAM in C:\wamp\www\includes\classes\db\mysql\query_factory.php on line 101

[09-Mar-2012 17:54:02 UTC] PHP Stack trace:

[09-Mar-2012 17:54:02 UTC] PHP 1. {main}() C:\wamp\www\ADMIN\multi_xsell.php:0

[09-Mar-2012 17:54:02 UTC] PHP 2. install_multi_cross_sell() C:\wamp\www\ADMIN\multi_xsell.php:67

[09-Mar-2012 17:54:02 UTC] PHP 3. add_mxs_table() C:\wamp\www\ADMIN\includes\functions\extra_functions\multi_xsell.php:245

[09-Mar-2012 17:54:02 UTC] PHP 4. queryFactory->Execute() C:\wamp\www\ADMIN\includes\functions\extra_functions\multi_xsell.php:294

[09-Mar-2012 17:54:02 UTC] PHP 5. queryFactory->set_error() C:\wamp\www\includes\classes\db\mysql\query_factory.php:208

[09-Mar-2012 17:54:02 UTC] PHP 6. queryFactory->show_error() C:\wamp\www\includes\classes\db\mysql\query_factory.php:86

[09-Mar-2012 17:54:02 UTC] PHP 7. trigger_error() C:\wamp\www\includes\classes\db\mysql\query_factory.php:101

Found the problem.

Got it going and am in admin/catalog/multi cross sell
I have entered the 2 model numbers and haven't got the foggiest idea on what to push next. no matter which button i select it won't save the cross sell and the instructions in the how to use file are pisspoor in my opnion.
Can anybody clarify on how to save a cross sell ?
Thank you

Can have multiple Cross Sell's for different purposes ( don't see where this setting is located)
Customise each Cross Sell's Box headings to be more relevent to its purpose. ( don't see where this setting is located)

Enable and Disable each individual Cross Sell from the admin. ( don't see where this setting is located)