Multi Cross Sell mod [Support thread]

[andreitero]

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.

[gilby]

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

[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!

[gilby]

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_defin es.php
Add definitions for the extra headings here.

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

[justin2010]

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!

[justin2010]

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

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!

[gilby]

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.

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.

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.

[sgflowers]

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??

[kconklin]

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