Multi Cross Sell mod [Support thread]

windsurfer:

Found the problem.

And to help me and others who read this...
Was it a Multi Cross Sell problem? (so I can fix it)
or was it another issue?

windsurfer:

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

Are you getting an error message on the top line?

The default setup is to use product ID numbers separated by commas, NOT Model numbers
Unless you changed it in Admin->Configuration->Cross Sell Settings

Yes the documentation is a mish mash of old mod documentation and new mod documentation. Documentation is not what I do well.

windsurfer:

Can have multiple Cross Sell's for different purposes ( don't see where this setting is located)Admin->Configuration->Cross Sell Settings

windsurfer:

Customise each Cross Sell's Box headings to be more relevent to its purpose. ( don't see where this setting is located)
includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defines.php
You need to edit this file as required and reupload it.

windsurfer:

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

First i did change the setting to model number
Second, there are 2 fields that can have an entry
Product Cross Sell applies to:
Product model(s):
and

Edit Current Cross Sell
Product model:

there are also 3 buttons on the screen
Update
Insert
Search

That's it
Now when i enter a model number in the "Product Cross Sell applies to:" field with the insert button beside it

and a model number in the " Product model:" field with the search button beside it

No matter which button i select it does nopt save the cross sell and i have no idea as to how to save it.
I know the model numbers i enter are correct so i am at a loss here.
Like i said, there are no instructions on how to go about using this mod and it's certainly not self explanatory, so any help would be appreciated.
Also where are the instructions on how to edit the includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defines.php
and what do we edit ?

windsurfer:

First i did change the setting to model number
Second, there are 2 fields that can have an entry
Product Cross Sell applies to:
Product model(s):
and

Edit Current Cross Sell
Product model:

there are also 3 buttons on the screen
Update
Insert
Search

That's it
Now when i enter a model number in the "Product Cross Sell applies to:" field with the insert button beside it

and a model number in the " Product model:" field with the search button beside it

No matter which button i select it does nopt save the cross sell and i have no idea as to how to save it.
I know the model numbers i enter are correct so i am at a loss here.
Like i said, there are no instructions on how to go about using this mod and it's certainly not self explanatory, so any help would be appreciated.
Also where are the instructions on how to edit the includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defines.php
and what do we edit ?

When you click either of these 3 buttons
You should get a message on the top line that is either success or error with some details of the error or results of the success
Are you getting these messages?

Assuming the entry is set to Model Number and the separater is a comma.
If you have 4 items to cross sell with Model numbers
790423 790444 790524AZ and 42786-40

You would type into the NEW cross sells box
790423,790444,790524AZ,42786-40
and press ENTER of click the INSERT button
You should then get a list of 12 success messages or some error messages at the top of the next page.

Are you receiving these messages????

you edit includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defin es.php
on your computer and upload it to the correct position on your website.
This file contains a list of defines such as...```php
define('TEXT_MXSELL1_PRODUCTS', 'Suggested Matching Items...');
define('TEXT_MXSELL2_PRODUCTS', 'We also Suggest...');
define('TEXT_MXSELL3_PRODUCTS', 'Suggested Cross Sell 3...');
define('TEXT_MXSELL4_PRODUCTS', 'Suggested Cross Sell 4...');
define('TEXT_MXSELL5_PRODUCTS', 'Suggested Cross Sell 5...');
define('TEXT_MXSELL6_PRODUCTS', 'Suggested Cross Sell 6...');

These are the headers that appear on the different cross sells. Edit them to what you want and upload it to your website.

gilby:

Look in the cache directory for "error messages"?

there is no error info, just a warning when i try to install, it is as:

WARNING: An Error occurred, please refresh the page and try again.

I refreshed my website again and again, it is always there.

I checked my database, the old tables are there, could you give me a sql to delete the old ones, so that i could install again

boomup:

there is no error info, just a warning when i try to install, it is as:

WARNING: An Error occurred, please refresh the page and try again.

I refreshed my website again and again, it is always there.

Is this a live website or is it on your computer?

Did you rename the YOUR_RENAMED_ADMIN directory to your admin name?

Did you rename the 3 YOUR_TEMPLATE directories to your template names before uploading to your website?

I deleted all table concerning multi cross sell, and re-install, the same warning info shown, and can not continue, when i change my browser to IE, there is a 500 error, no error info in cache directory

Hey gilby

i got the error info, just as following, please help me out, thanks a lot

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 zen_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 /public_html/includes/classes/db/mysql/query_factory.php on line 101

boomup:

Hey gilby

i got the error info, just as following, please help me out, thanks a lot

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 zen_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 /public_html/includes/classes/db/mysql/query_factory.php on line 101

Edit YOUR_RENAMED_ADMIN\includes\functions\extra_functions\multi_xsell.php
Around line 294 find```php
KEY idx_products_id_xsell (products_id) ) TYPE=MyISAM");

Change to```php
    KEY `idx_products_id_xsell` (`products_id`) ) ENGINE=MyISAM");

TYPE is now deprecated
and ENGINE is the correct replacement.
See if that works?

I changed mine to ENGINE and that worked

windsurfer:

I changed mine to ENGINE and that worked

Thanks for confirming that worked for you.

Another bug fix to add to the next version!!!

Hey gilby

i changed it into ENGINE, and it works well now, thanks a lot

boomup:

Hey gilby

i changed it into ENGINE, and it works well now, thanks a lot

2 out of 2 :P

ZC 1.5 new install
MySQL 5.0.45
PHP 5.2.12
https://www.bestdealcaraudio.com

Hi I am getting an error and the product info page doesn't display and it looks like it has something to do with the Multi Cross Sell Mod! Any idea what this may be I looked at the subject file and I don't see anything changed it was working fine before!
Any help or advice will be greatly appreciated
Thanks in advance

[31-Mar-2012 09:33:37] 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 'MAX_DISPLAY_XSELL' at line 8 :: select distinct p.products_id, p.products_image, pd.products_name
from TABLE_PRODUCTS_XSELL xp, products p, products_description pd
where xp.products_id = '137'
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.sort_order asc limit MAX_DISPLAY_XSELL in bestdealcaraudio/includes/classes/db/mysql/query_factory.php on line 101

After some more research I have resolved the problem. Thanks anyway it had nothing to do with a previous cross sell Mod installed. it was a problem with the tabbed product display
Thanks

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

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

bigduffeye:

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.

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/index.php?main_page=product_info&cPath=8_31_41&products_id=275
and then we need a new cross sell for a different furniture set like this
http://www.wearebeds.com/catalog/index.php?main_page=product_info&cPath=8_31_37&products_id=265

but you solved my problem anyway! thanks a lot!