Multi Cross Sell mod [Support thread]

gilby:

Quick fix to use the first XSELL database and hard code it
Cannot try it myself but it looks right

$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
from " . TABLE_PRODUCTS_XSELL1 . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where xp.products_id = '" . $_GET['products_id'] . "'
and xp.xsell_id = p.products_id
and p.products_id = pd.products_id
and pd.language_id = '" . $_SESSION['languages_id'] . "'
and p.products_status = 1
order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL1);

Did not go as expected, I can see the TABLE_PRODUCTS_XSELL1 in PhpmyAdmin, but it still throws this error:

1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL1' doesn't exist
in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL1 xp, zen_products p, zen_products_description pd where xp.products_id = '42' 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 6]

Do you have any other suggestions i should try?
Thanks for taking the time.

andreitero:

Did not go as expected, I can see the TABLE_PRODUCTS_XSELL1 in PhpmyAdmin, but it still throws this error:

1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL1' doesn't exist
in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL1 xp, zen_products p, zen_products_description pd where xp.products_id = '42' 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 6]

> 
> Do you have any other suggestions i should try?
> Thanks for taking the time.

Ahh.. Try this one:

$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
from " . TABLE_PRODUCTS_MXSELL1 . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where xp.products_id = '" . $_GET['products_id'] . "'
and xp.xsell_id = p.products_id
and p.products_id = pd.products_id
and pd.language_id = '" . $_SESSION['languages_id'] . "'
and p.products_status = 1
order by xp.sort_order asc limit " . MAX_DISPLAY_XSELL1);

I managed to install it and started the test. It works great and it's exactly what I am looking for in terms of the functions.

One quick question. There are only 5 cross sells I can use by default. Is it possible I can have more than 5?

Thanks you!

justin2010:

I managed to install it and started the test. It works great and it's exactly what I am looking for in terms of the functions.

One quick question. There are only 5 cross sells I can use by default. Is it possible I can have more than 5?

Thanks you!

Certainly.

Edit: admin\includes\functions\extra_functions\multi_xsell.php
around line 237 you will find this partial code segment...
array('1', '2', '3', '4', '5')
Edit and expand that to however many you want.

Also edit: includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defines.php
Add definitions for the extra headings here.

Then uninstall and reinstall from the admin (the cross sell databases will not be removed)

Thank you for your quick reply, gilby.

Well, you are not going to believe this. I modified these 2 files and upload them to their location. Then when I tried to go to my admin page to login, I got a "HTTP 500" error! The store is still working fine for customers so far. I just can't access to the admin login page. I checked the files on the hosting server, and it doesn't look like it's been hacked or what so ever. Lucky, this is just a test site.

It's late now. I will try and figure out tomorrow. Thank you!

Finally, I set everything right.

Here are something to share with:

1. BACKUP!!!!!!!!!!!!!
   Before you upload the mod files, BACKUP! I probably mess up some file(s) last night :oops:, that's why I got the HTTP 500. Then I tried to fix the files and the xsell tables, but it took more time and efforts and it got more confusing :frusty:, so eventually I erased everything including the public_html and DBs, and used my backup copies to restore the whole store, including files and DBs, and carefully uploaded the Multi Cross mod again. This time it works without any problems. :clap:

2. a little correction to the README file.
   In the README file, it says "Go to Admin->Configuration->Multi Cross Sell
   Click Install
   Go to Admin->Configuration->Cross Sell Settings
   By default one cross sell is installed
   Configure as required.

But I found it, in my case, is actually under "Admin->Catalog->Multi Cross-Sell" to click the "install", then the "Admin->Configuration->Cross Sell Settings" will show up. If this is also true to the developer and others, please modify the README file.

3. some suggestions to the developer(s)
   --by default, it uses "Product models" instead of "product id", I am sure there must be a reason but I think the product id is definitely unique while product models could be the same. I prefer id over model.
   --how about provide an option for the admin to delete a cross-sell and drop the table? If I want to completely get rid of a cross-sell for whatever business reasons, then to delete that cross-sell and drop the whole table is easy and fast.

In general, this is a good module to help promoting sale. All it need is to carefully set it up. Thank you for the great work! :clap:

justin2010:

Finally, I set everything right.

Here are something to share with:

1. BACKUP!!!!!!!!!!!!!
   Absolutely: Never install a mod on a live website.
   Always test first on a test website.
   Particularly if you are also altering the mod.

justin2010:

2. a little correction to the README file.
   In the README file, it says "Go to Admin->Configuration->Multi Cross Sell
   Click Install
   Go to Admin->Configuration->Cross Sell Settings
   By default one cross sell is installed
   Configure as required.

But I found it, in my case, is actually under "Admin->Catalog->Multi Cross-Sell" to click the "install", then the "Admin->Configuration->Cross Sell Settings" will show up. If this is also true to the developer and others, please modify the README file.
Yes, thanks for catching that typo. It will be corrected in the next version.

justin2010:

3. some suggestions to the developer(s)
   --by default, it uses "Product models" instead of "product id", I am sure there must be a reason but I think the product id is definitely unique while product models could be the same. I prefer id over model.
   --how about provide an option for the admin to delete a cross-sell and drop the table? If I want to completely get rid of a cross-sell for whatever business reasons, then to delete that cross-sell and drop the whole table is easy and fast.
   "Products model number" as default worked for me as all my model numbers are unique.
   If your model numbers are not unigue then the admin functions may not work as expected.
   I have used both ways on my sites. It depends on the situation at the time.
   However only use the model number way if you have unigue model numbers. Product ID's are always unique.

If there is enough demand for that feature I will look at the abilty to empty a single cross sell table.

gilby:

I suspect you still have some of the previous mods files or configuration settings.

You can run this in the tools->sql patches to remove the previous mods configuration settings
after BACKING UP AND TESTING FIRST of course

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Cross Sell';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

> 
> Check that all the previous mods files have been removed

hi i am having this issue

i updated from 1.3.7 to 1.3.9d with a fresh install on the files
i ran the above sql to remove the old cross sell but i still get an error

any ideas?

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 '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '1852' 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 ]

sgflowers:

hi i am having this issue

i updated from 1.3.7 to 1.3.9d with a fresh install on the files
i ran the above sql to remove the old cross sell but i still get an error

any ideas?

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 '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '1852' 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 ]

any idea what files i should be looking at to figure this out??

This is so great!! I did not have the sample file uploaded once I did and then renamed it everything worked great!! Thanks so much for your help! This is a great module:thumbsup:

sgflowers:

any idea what files i should be looking at to figure this out??

I am assuming you had a previous cross sell installed??
Almost certainly some of the previous mods configuration values are still there.

Search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And delete this entry.

While you at it see if "MIN_DISPLAY_XSELL" is also there and delete it as well

gilby:

I am assuming you had a previous cross sell installed??
Almost certainly some of the previous mods configuration values are still there.

Search the configuration table for configuration_key = "MAX_DISPLAY_XSELL"
And delete this entry.

While you at it see if "MIN_DISPLAY_XSELL" is also there and delete it as well

Thanks that fixed it - it was driving me nuts!:clap:

Hello,

I also had a previous version of cross sell installed and I am getting the 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 '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '66' 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 ]

I have gone through all the posts and sugestions but have not been able to find any files from previous versions or anything in the database. Anyone have any ideas? :lamo:

anworks:

Hello,

I also had a previous version of cross sell installed and I am getting the 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 '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from zen_products_xsell1 xp, zen_products p, zen_products_description pd where xp.products_id = '66' 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 ]

> 
> I have gone through all the posts and sugestions but have not been able to find any files from previous versions or anything in the database.  Anyone have any ideas? :lamo:


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.

Hi gilby,

First of all great mod - I really like the new customisable features you have added :smile:

Just wondering if it is possible to make this compatible with the Tabbed Products Pro module ??

Cheers.

gaffettape:

Hi gilby,

First of all great mod - I really like the new customisable features you have added :smile:

Just wondering if it is possible to make this compatible with the Tabbed Products Pro module ??

Cheers.

Earlier in this thread someone else tried a hard coded hack to display the first cross sell.
It probably works but makes using this mod pointless as it only uses features of the previous mod.

I am sure TPP can be altered to incorporate this mod.
But as I have never used that mod, it is not on my "to do" list at this time, Sorry

I'd just like to say:

THANK YOU!

for this awesome mod. After a problem with Just Another Cross Sell Mod (again) I tried this one, it's much better!

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks

Berserker:

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks

Not an available option in the default mod
A quick search of zen functions found this function
zen_get_categories_name_from_product($product_id)
It looks useful
Give it the product id and back comes the name of the category

I haven't tried this but this could work

Edit
\includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
Around line 69 near the end of the line find this code segment

zen_products_lookup($xsell_query->fields['products_id'], 'products_model')

and replace with

zen_get_categories_name_from_product($xsell_query->fields['products_id'])

See if that works for you?

Berserker:

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks
I just tested the code in the previous post and it does work