Multi Cross Sell mod [Support thread]

[gilby]

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?

[gilby]

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.

[gilby]

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

Admin->Configuration->Cross Sell Settings

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_defin es.php
You need to edit this file as required and reupload it.

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

Admin->Configuration->Cross Sell Settings

[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_defin es.php
and what do we edit ?

[gilby]

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_defin es.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...

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.

[boomup]

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.

[boomup]

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

[gilby]

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?

[boomup]

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

[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