-
Multi Cross Sell mod [Support thread]
Multi Cross Sell mod
Download Link: http://www.zen-cart.com/downloads.php?do=file&id=1128
Based on Cross Sell - Just Another Cross Sell Mod by yellow1912
Link to the original: http://www.zen-cart.com/index.php?ma...roducts_id=694
New Features:
1. Removal of module_manager to operate properly.
2. Customise what to show apart from the Cross Sell image.
Display the Products Name.
Display the Products Model Number.
Display the Products Buy Now / More Info Link.
3. Enable, Disable and Remove this module from the admin.
4. Ability to create and display unlimited Cross Sell Tables.
Can have multiple Cross Sell's for different purposes
Customise each Cross Sell's Box headings to be more relevent to its purpose.
Enable and Disable each individual Cross Sell from the admin.
Existing Features:
All of yellow1912's "Just Another Cross Sell Mod" including
1. Allow unlimited number of product cross sells
2. Accept product id or model as input value.
3. Clean up table.
4. Given a list of n products, the mod will go through and cross-sell EACH pair together.
With this mod, if you give it 3 products: A - B - C, it will cross-sell:
A to B, B to A
A to C, C to A
B to C, C to B
-
Re: Multi Cross Sell mod [Support thread]
Thank you for this contibution I have managed to get it working on my site. The only thing I need help on is how do I get it to display the price and a add to cart button.
-
Re: Multi Cross Sell mod [Support thread]
I was just wondering if it is my setup, but I see this displayed on the product info page:-
Quote:
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 = '16025' 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 rand() limit ]
It all installed nicely in the admin and I followed the instructions. Thanks for developing this module also.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
michellepchy
Thank you for this contibution I have managed to get it working on my site. The only thing I need help on is how do I get it to display the price and a add to cart button.
admin->configuration->Cross Sell Settings
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
HeathenMagic
I was just wondering if it is my setup, but I see this displayed on the product info page:-
Quote:
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 = '16025' 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 rand() limit ]
It all installed nicely in the admin and I followed the instructions. Thanks for developing this module also.
Check:
admin->configuration->Cross Sell Settings
make sure that..
Cross Sell 1 - Display Products - Max
has a numeric value (not empty)
-
Re: Multi Cross Sell mod [Support thread]
Hello there,
It has 6 as default. I tried to change it and the other settings and it still has the error. I have 2 cross sells defined so far. Is there anything else I could try? Should I drop the sql tables and star from scratch maybe? Maybe something got scrambled on our setup during install.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
HeathenMagic
Hello there,
It has 6 as default. I tried to change it and the other settings and it still has the error. I have 2 cross sells defined so far. Is there anything else I could try? Should I drop the sql tables and star from scratch maybe? Maybe something got scrambled on our setup during install.
Did you have any previous cross sells installed?
or is this a new installation?
You could uninstall from the admin and install again.
It won't remove the tables
What php version are you using?
-
Re: Multi Cross Sell mod [Support thread]
I had cross sell installed from before and I tried uninstalling and reinstalling this module and the same happened. Had the normal cross sell and cross sell advanced. I am on PHP 5 too.
-
Re: Multi Cross Sell mod [Support thread]
-
Re: Multi Cross Sell mod [Support thread]
I have installed the files and got it to work in the admin panel, but items I have set to cross sell do not display the other product on the product pages. I am assuming when you go to the "A Bug's Life" page after the additional images there should be a photo of the "Microsoft IntelliMouse", but there is nothing. So not sure what I did wrong.:huh:
Here is the screen shot in the admin panel showing I have a bugs life and a mouse linked to cross sell;
http://i81.photobucket.com/albums/j2.../crossSell.png
Here is where I put the code for templates/premium2a/templates/tpl_product_info_display.php
http://i81.photobucket.com/albums/j2...ve/phpcode.png
I'm on v1.3.9d, PHP 5.3.2, no other version of a cross sell mod.
-
Re: Multi Cross Sell mod [Support thread]
I figured it out, I'm sorry.
This file had not transfered over.
includes/modules/premium2a/multi_xsell_products.php
works great now!!!!
Thank you so much for the hard work.:clap:
-
Re: Multi Cross Sell mod [Support thread]
Hello, I'm looking to install this mod on one of my websites. Before i do, i would like to know if it is compatible with Tabbed products pro last version. Has anyone tried this combination so far?
Thanks!
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
HeathenMagic
I had cross sell installed from before and I tried uninstalling and reinstalling this module and the same happened. Had the normal cross sell and cross sell advanced. I am on PHP 5 too.
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
Code:
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
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
andreitero
Hello, I'm looking to install this mod on one of my websites. Before i do, i would like to know if it is compatible with Tabbed products pro last version. Has anyone tried this combination so far?
Thanks!
I don't use "Tabbed products pro" so I don't know
You would need to compare both mods directory structure to find any duplicate files.
These duplicate files would then need to be "merged"
-
Re: Multi Cross Sell mod [Support thread]
Hello Gilby,
Thanks so much for your assistance, it worked a treat. I cleared the files from the last version and ran the sql statement you quoted and it did it. Where can people send a donation to you?
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
I don't use "Tabbed products pro" so I don't know
You would need to compare both mods directory structure to find any duplicate files.
These duplicate files would then need to be "merged"
Thanks for that, i did install this contribution, but got an error:
1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL' doesn't exist in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL xp, zen_products p, zen_products_description pd where xp.products_id = '90' 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]
Double checked the Cross Sell 1 - Display Products - Max, it has value '6' . What else should i look at to fix it?
Also, in order to get it to work with Tabbed products pro, i would need to change this bit to match multi_cross_sell database table instead of xsell table. I am unsure about the changes i should make, can you please give me some advice?
Code:
$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
from " . TABLE_PRODUCTS_XSELL . " 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_XSELL);
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
andreitero
Thanks for that, i did install this contribution, but got an error:
1146 Table 'lemycouk_zc1.TABLE_PRODUCTS_XSELL' doesn't exist in:
[select distinct p.products_id, p.products_image, pd.products_name from TABLE_PRODUCTS_XSELL xp, zen_products p, zen_products_description pd where xp.products_id = '90' 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]
Double checked the Cross Sell 1 - Display Products - Max, it has value '6' . What else should i look at to fix it?
Also, in order to get it to work with Tabbed products pro, i would need to change this bit to match multi_cross_sell database table instead of xsell table. I am unsure about the changes i should make, can you please give me some advice?
Code:
$xsell_query = $db->Execute("select distinct p.products_id, p.products_image, pd.products_name
from " . TABLE_PRODUCTS_XSELL . " 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_XSELL);
Quick fix to use the first XSELL database and hard code it
Cannot try it myself but it looks right
Code:
$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);
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
HeathenMagic
Hello Gilby,
Thanks so much for your assistance, it worked a treat. I cleared the files from the last version and ran the sql statement you quoted and it did it. Where can people send a donation to you?
Glad you solved the problem
Donate instead to the zen-cart admins here:
-
Re: Multi Cross Sell mod [Support thread]
I love this mod! I have installed and it appears to be working correctly in my Admin area however, I do not see anything on the actual web page? Do I need to add this like suggested in the Cross Sell mod installation?
4. Open includes/languages/english/product_info.php
or includes/languages/english/YOUR_TEMPLATE/product_info.php
and add:
define('TEXT_XSELL_PRODUCTS', 'We Also Recommend :');
just above the final ?> and save it into includes/languages/english/YOUR_TEMPLATE/product_info.php
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
kconklin
I love this mod! I have installed and it appears to be working correctly in my Admin area however, I do not see anything on the actual web page? Do I need to add this like suggested in the Cross Sell mod installation?
4. Open includes/languages/english/product_info.php
or includes/languages/english/YOUR_TEMPLATE/product_info.php
and add:
define('TEXT_XSELL_PRODUCTS', 'We Also Recommend :');
just above the final ?> and save it into includes/languages/english/YOUR_TEMPLATE/product_info.php
No that info is found here:
includes\languages\english\extra_definitions\YOUR_TEMPLATE\multi_xsell_box_defin es.php
You probably haven't edited or merged
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php
If you haven't previously customised this file then you can just rename the sample file:
includes\templates\YOUR_TEMPLATE\templates\SAMPLE_ADDITION_TO_tpl_product_info_d isplay.php
to:
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
Quick fix to use the first XSELL database and hard code it
Cannot try it myself but it looks right
Code:
$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:
Code:
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.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
andreitero
Did not go as expected, I can see the TABLE_PRODUCTS_XSELL1 in PhpmyAdmin, but it still throws this error:
Code:
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:
Code:
$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);
-
Re: Multi Cross Sell mod [Support thread]
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!
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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_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)
-
Re: Multi Cross Sell mod [Support thread]
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!
-
Re: Multi Cross Sell mod [Support thread]
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:
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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.
Quote:
Originally Posted by
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.
Quote:
Originally Posted by
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.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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
Code:
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?
Code:
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 ]
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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?
Code:
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??
-
Re: Multi Cross Sell mod [Support thread]
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:
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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:
-
Re: Multi Cross Sell mod [Support thread]
Hello,
I also had a previous version of cross sell installed and I am getting the error.
Code:
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:
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
anworks
Hello,
I also had a previous version of cross sell installed and I am getting the error.
Code:
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.
-
Re: Multi Cross Sell mod [Support thread]
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.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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
-
Re: Multi Cross Sell mod [Support thread]
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!
-
Re: Multi Cross Sell mod [Support thread]
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
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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
PHP Code:
zen_products_lookup($xsell_query->fields['products_id'], 'products_model')
and replace with
PHP Code:
zen_get_categories_name_from_product($xsell_query->fields['products_id'])
See if that works for you?
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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
-
Re: Multi Cross Sell mod [Support thread]
Just installed this mod and no errors while installing.
However, I can't get the feature to actually show on a product page.
This is the product page I'm working on to start:
http://www.vintagegunleather.com/sho...roducts_id=276
It is supposed to show beneath the add to cart, so it'll be the last thing on the page.
When you view the page source code you see it ends with:
Code:
<!--bof Add to Cart Box -->
<div id="cartAdd">
<input type="hidden" name="cart_quantity" value="1" /><input type="hidden" name="products_id" value="276" /><input type="image" src="includes/templates/vgl/buttons/english/button_in_cart.gif" alt="Add to Cart" title=" Add to Cart " /> </div>
<br class="clearBoth" />
<!--eof Add to Cart Box-->
<!-- BEG: Multi Cross-Sell mod -->
But yet, the actual file from that point on is:
Code:
<!--bof Add to Cart Box -->
<?php
if (CUSTOMERS_APPROVAL == 3 and TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE_SHOWROOM == '') {
// do nothing
} else {
?>
<?php
$display_qty = (($flag_show_product_info_in_cart_qty == 1 and $_SESSION['cart']->in_cart($_GET['products_id'])) ? '<p>' . PRODUCTS_ORDER_QTY_TEXT_IN_CART . $_SESSION['cart']->get_quantity($_GET['products_id']) . '</p>' : '');
if ($products_qty_box_status == 0 or $products_quantity_order_max== 1) {
// hide the quantity box and default to 1
$the_button = '<input type="hidden" name="cart_quantity" value="1" />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
} else {
// show the quantity box
$the_button = PRODUCTS_ORDER_QTY_TEXT . '<input type="text" name="cart_quantity" value="' . (zen_get_buy_now_qty($_GET['products_id'])) . '" maxlength="6" size="4" />' . zen_get_products_quantity_min_units_display((int)$_GET['products_id']) . '' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
}
$display_button = zen_get_buy_now_button($_GET['products_id'], $the_button);
?>
<?php if ($display_qty != '' or $display_button != '') { ?>
<div id="cartAdd">
<?php
echo $display_qty;
echo $display_button;
?>
</div>
<?php } // display qty and button ?>
<?php } // CUSTOMERS_APPROVAL == 3 ?>
<br class="clearBoth" />
<!--eof Add to Cart Box-->
<!-- BEG: Multi Cross-Sell mod -->
<?php
if(defined('MXSELL_ENABLED') && MXSELL_ENABLED == 'true') {
for ( $mxsell = 1; $mxsell <= MXSELL_NUM_OF_TABLES; $mxsell++ ) { // show all cross sells
require($template->get_template_dir('tpl_modules_multi_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_multi_xsell_products.php');
}
}
?>
<!-- END: Multi Cross-Sell mod -->
<!--bof Prev/Next bottom position -->
<?php if (PRODUCT_INFO_PREVIOUS_NEXT == 2 or PRODUCT_INFO_PREVIOUS_NEXT == 3) { ?>
<?php
/**
* display the product previous/next helper
*/
require($template->get_template_dir('/tpl_products_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_next_previous.php'); ?>
<?php } ?>
<!--eof Prev/Next bottom position -->
<!--bof Quantity Discounts table -->
<?php
if ($products_discount_type != 0) { ?>
<?php
/**
* display the products quantity discount
*/
require($template->get_template_dir('/tpl_modules_products_quantity_discounts.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_products_quantity_discounts.php'); ?>
<?php
}
?>
<!--eof Quantity Discounts table -->
<!--bof Product URL -->
<?php
if (zen_not_null($products_url)) {
if ($flag_show_product_info_url == 1) {
?>
<p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($products_url), 'NONSSL', true, false)); ?></p>
<?php
} // $flag_show_product_info_url
}
?>
<!--eof Product URL -->
<!--bof also purchased products module-->
<?php require($template->get_template_dir('tpl_modules_also_purchased_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_also_purchased_products.php');?>
<!--eof also purchased products module-->
<!--bof Form close-->
</form>
<!--bof Form close-->
</div>
So, something in the cross sell code above is breaking the page's code. I don't know enough about PHP to pinpoint the problem. This is a direct copy and past from the Sample file. What was in the Document file didn't have that first "if" line (about Enabling).
Zencart V 3.1.8a
I have the module set for 1 cross sell box, 3 products across, 3 products max.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
beyre
Just installed this mod and no errors while installing.
However, I can't get the feature to actually show on a product page.
So, something in the cross sell code above is breaking the page's code. I don't know enough about PHP to pinpoint the problem. This is a direct copy and past from the Sample file. What was in the Document file didn't have that first "if" line (about Enabling).
Zencart V 3.1.8a
I have the module set for 1 cross sell box, 3 products across, 3 products max.
As you are using v138a install this
http://www.zen-cart.com/index.php?ma...roducts_id=860
so that you can find the php error that is causing the error
You could also try using the included file to see if that works instead of modifying yours.
If that works there could be a conflict with other customisations you have made to this file.
-
Re: Multi Cross Sell mod [Support thread]
Thanks for your reply.
It seemed the tpl_modules_multi_xsell_products.php file didn't upload when I told it to and I didn't pay attention to that.
But now, on that same product page, I get the following 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 products_xsell1 xp, products p, products_description pd where xp.products_id = '276' 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 rand() limit ]
This was also in the debugging file:
161
[24-Aug-2010 07:23:18] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/templates/template_default/templates/tpl_modules_multi_xsell_products.php' (include_path='.:.:') in /var/www/vhosts/vintagegunleather.com/httpdocs/shoppe/includes/templates/vgl/templates/tpl_product_info_display.php on line 161
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
beyre
Thanks for your reply.
It seemed the tpl_modules_multi_xsell_products.php file didn't upload when I told it to and I didn't pay attention to that.
Thats what the debug error message was telling you was missing.
Quote:
Originally Posted by
beyre
But now, on that same product page, I get the following 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 products_xsell1 xp, products p, products_description pd where xp.products_id = '276' 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 rand() limit ]
You have had a previous cross sell installed and haven't totally removed it.
See post #34 for the answer
-
Re: Multi Cross Sell mod [Support thread]
Thank you so much. That was the winning ticket!
Easy enough solution - just needed someone to interpret the gobblety-gook to get there! :clap:
-
Re: Multi Cross Sell mod [Support thread]
@gilby
I currently use Just another Cross-Sell mod on 1.3.8. After finding that it does not work on my 1.3.9 I saw this mod.
a few questions though.
Q1
is the data base exactly the same? i.e so i can transfer my current table to be use with this mod in 1.3.9?
Q2
when it says about the removal of modle manager, do you mean so it can work without the need for module manager? as apposed to having to actually remove module manager? I ask because other mods I have use mod manager?
Q3
is this mod compatible with cart upsell?
look forward to hearing from you.
Thanks
Phil
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
philip937
@gilby
I currently use Just another Cross-Sell mod on 1.3.8. After finding that it does not work on my 1.3.9 I saw this mod.
a few questions though.
Q1
is the data base exactly the same? i.e so i can transfer my current table to be use with this mod in 1.3.9?
Q2
when it says about the removal of modle manager, do you mean so it can work without the need for module manager? as apposed to having to actually remove module manager? I ask because other mods I have use mod manager?
Q3
is this mod compatible with cart upsell?
look forward to hearing from you.
Thanks
Phil
Q1 Yes!
From the included docs:
To retain any existing Cross Sells rename the "products_xsell" table to "products_xsell1"
It needs to be renamed before clicking the install button on this new mod.
Otherwise a "products_xsell1" table will be created as none was found.
Q2 You don't need module manager to run this mod
Whether it is installed or not makes no difference
Q3 Or.. Is Cart Upsell compatible with this mod?
Cart Upsell expects one cross sell only not many.
So you can use it, as is, to display one of the cross sells.
Work out which cross sell you want to use there and edit that mod so you rename references to "products_xsell" table to "products_xsell1" for example if you want to use the first cross sell for that purpose.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
Q1 Yes!
From the included docs:
To retain any existing Cross Sells rename the "products_xsell" table to "products_xsell1"
It needs to be renamed before clicking the install button on this new mod.
Otherwise a "products_xsell1" table will be created as none was found.
Q2 You don't need module manager to run this mod
Whether it is installed or not makes no difference
Q3 Or.. Is Cart Upsell compatible with this mod?
Cart Upsell expects one cross sell only not many.
So you can use it, as is, to display one of the cross sells.
Work out which cross sell you want to use there and edit that mod so you rename references to "products_xsell" table to "products_xsell1" for example if you want to use the first cross sell for that purpose.
I am going to remove the cross sell I have completley and backup the table products_xsell then delete it, then install this new Mod.
Almost there, however I still have "Cross Sell" under admin/configuration?? Looking through the mod files there was no uninstall database for it??
any Idea how I can safely remove? or does your mod just overwrite this?
thanks in advance.
Phil
-
Re: Multi Cross Sell mod [Support thread]
FANTASTIC ALL done and working!
Looks great, need to work out the cart upsell so I will take a look at the files and see if I can find where it references the table :o)
-
Re: Multi Cross Sell mod [Support thread]
@gilby
Quote:
Originally Posted by
gilby
Q1 Yes!
Q3 Or.. Is Cart Upsell compatible with this mod?
Cart Upsell expects one cross sell only not many.
So you can use it, as is, to display one of the cross sells.
Work out which cross sell you want to use there and edit that mod so you rename references to "products_xsell" table to "products_xsell1" for example if you want to use the first cross sell for that purpose.
I have tried what you suggested but its not working for some reason.
this is what I did:
I added this line to
includes/extra_datafiles/multi_xsell_definitions.php
PHP Code:
define('TABLE_PRODUCTS_XSELL', DB_PREFIX . 'products_xsell1');
then I have to change in
includes/modules/MY_TEMPLATE/cart_upsell.php
PHP Code:
if (@file_exists(DIR_WS_MODULES . zen_get_module_directory('xsell_products.php'))) {
to
PHP Code:
if (@file_exists(DIR_WS_MODULES . zen_get_module_directory('multi_xsell_products.php'))) {
and
PHP Code:
require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');
to
PHP Code:
require($template->get_template_dir('tpl_modules_multi_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_multi_xsell_products.php');
but this still does not work. can you advise any further?
Many Thanks
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
philip937
@gilby
I have tried what you suggested but its not working for some reason.
this is what I did:
I added this line to
includes/extra_datafiles/multi_xsell_definitions.php
PHP Code:
define('TABLE_PRODUCTS_XSELL', DB_PREFIX . 'products_xsell1');
then I have to change in
includes/modules/MY_TEMPLATE/cart_upsell.php
PHP Code:
if (@file_exists(DIR_WS_MODULES . zen_get_module_directory('xsell_products.php'))) {
to
PHP Code:
if (@file_exists(DIR_WS_MODULES . zen_get_module_directory('multi_xsell_products.php'))) {
and
PHP Code:
require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');
to
PHP Code:
require($template->get_template_dir('tpl_modules_multi_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_multi_xsell_products.php');
but this still does not work. can you advise any further?
Many Thanks
At this stage no I can't help
and I am away from my test computer for the next 10 days so I can't test it out at this time
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
At this stage no I can't help
and I am away from my test computer for the next 10 days so I can't test it out at this time
ok no worries, i'll keep looking at it to see if I can see any reason why its not working.
-
Re: Multi Cross Sell mod [Support thread]
ok, well I got it to work, however, its does not work using the file tpl_modules_multi_xsell_products.php
so as a fix, I just included the old file on my server as well solely for cart upsell to use unless someone can work out what the difference is that causes it not to work.
so all I did was specified the table products_xsell1 and made sure I had includes/templates/MY_TEMPLATE/templates/tpl_modules_xsell_products.php
so that when cart upsell calls it here:
PHP Code:
require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php'); }
its works.
like I say, bit of a fudge but I really like cart upsell. :o)
-
Re: Multi Cross Sell mod [Support thread]
After several unsuccessful installation, I want to ask: there must be installed before installing multi_cross_sell_v1.00 module_manager not ah?
Since I installed multi_cross_sell_v1.00 including previously installed module_manager still can not display the Admin-> Catalog-> Advanced Cross-Sell
Dear brothers and sisters would help. I am using a host of bluehost.com: MySQL version 5.1.47. PHP Version 5.2.13
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
bovo_cn
After several unsuccessful installation, I want to ask: there must be installed before installing multi_cross_sell_v1.00 module_manager not ah?
Since I installed multi_cross_sell_v1.00 including previously installed module_manager still can not display the Admin-> Catalog-> Advanced Cross-Sell
Dear brothers and sisters would help. I am using a host of bluehost.com: MySQL version 5.1.47. PHP Version 5.2.13
You may be mixing up your mods here...
This mod is stand alone...
Module manager is not used with this mod at all
"Admin-> Catalog-> Advanced Cross-Sell" is from a different cross sell mod, and is not used with this mod
This mod uses:
"Admin-> Catalog-> Multi Cross-Sell"
You should try uploading the files again to their correct position.
And maybe removing any other cross sell mods that you may have had installed previously
-
Re: Multi Cross Sell mod [Support thread]
I have installed this on a site i look after.
It seems to work fine on a product which has multiple product images:
see here:
http://www.projobdistribution.co.uk/...roducts_id=218
But the styling breaks when there are not multiple product images:
see here:
http://www.projobdistribution.co.uk/...roducts_id=221
Any ideas?
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
DVDTitan
Add the following line just before the start of the mod on the product_info page
PHP Code:
<br class="clearBoth" />
See if that fixes your problem
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
Add the following line just before the start of the mod on the product_info page
PHP Code:
<br class="clearBoth" />
See if that fixes your problem
Yes, this fixed it. Many thanks!
-
Re: Multi Cross Sell mod [Support thread]
Thanks for the fix for the category name.
Im trying to get the product name to be beside the image instead of below it, which file am I supposed to edit? I only have 1 product per row so having the name below the image takes too much space.
Thanks
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
Berserker
Thanks for the fix for the category name.
Im trying to get the product name to be beside the image instead of below it, which file am I supposed to edit? I only have 1 product per row so having the name below the image takes too much space.
Thanks
\includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
would be the place to start
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
\includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
would be the place to start
Thanks!
I have managed to get the product name to be beside the image using css (thanks to your tableless design) and just need one more thing.
How can I truncate the product name?
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
Berserker
Thanks!
I have managed to get the product name to be beside the image using css (thanks to your tableless design) and just need one more thing.
How can I truncate the product name?
Managed to truncate the product name by editing line 67. Changed it to below (last part of the line)
zen_trunc_string($xsell_query->fields['products_name'],35)
If this is the wrong way of doing it, please correct me.
-
Re: Multi Cross Sell mod [Support thread]
I have recently installed the latest version of Zen cart and added the multi cross sell mod.
Everything is great except for the cross products are listed several times on the page, please see attached link
I am sure I have done something wrong but cant work it out. Any help would be good. Thanks
Trice
http://www.styleuboutique.com/catalo...roducts_id=168
-
Re: Multi Cross Sell mod [Support thread]
Hi, I'm having trouble setting up this add-on.
The instructions say to go to Admin->Configuration->Multi Cross Sell to install, but that link is not in the Configuration menu.
From previous posts on this thread it sounds like the correct place to install is actually Catalog > Multi Cross-Sell, but when I go to that page it takes me back to the home page of the site. (Not the home page of the admin, the site's home page.)
I removed a previous cross-sells add-on before installing multi cross-sells. I deleted the files only: I didn't make any changes to the database.
Any ideas of what could be causing this problem would be appreciated. Thanks!
(Also, the readme says that the file path is "admin\includes\multi_xsell.php", but in my download that file was in "admin\multi_xsell.php". Which is correct?)
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
aeolidia2
Hi, I'm having trouble setting up this add-on.
The instructions say to go to Admin->Configuration->Multi Cross Sell to install, but that link is not in the Configuration menu.
From previous posts on this thread it sounds like the correct place to install is actually Catalog > Multi Cross-Sell, but when I go to that page it takes me back to the home page of the site. (Not the home page of the admin, the site's home page.)
Catalog->Multi Cross-Sell is correct
Quote:
Originally Posted by
aeolidia2
I removed a previous cross-sells add-on before installing multi cross-sells. I deleted the files only: I didn't make any changes to the database.
Any ideas of what could be causing this problem would be appreciated. Thanks!
You should have uninstalled the previous version
Use the uninstall sql for that version to remove it
(Don't remove the xsell database if you want to reuse it)
Quote:
Originally Posted by
aeolidia2
(Also, the readme says that the file path is "admin\includes\multi_xsell.php", but in my download that file was in "admin\multi_xsell.php". Which is correct?)
The download is correct, "admin\multi_xsell.php"
-
Re: Multi Cross Sell mod [Support thread]
I installed the mod, and I made 5 cross sells.
But they are not showing on my site.
https://webstore.jellybeanfabrics.co...iv2lrprbj22pi4
This product should link to the corresponding kit.
My settings under config are set to true so it should be on, right?
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
Andi98640
You have a custom tpl_product_info_display.php file
You haven't "merged" the display code into this
You will find sample code in the mod here
\includes\templates\YOUR_TEMPLATE\templates\SAMPLE_ADDITION_TO_tpl_product_info_ display.php
-
Re: Multi Cross Sell mod [Support thread]
Hi, hoping this is just a quick one, I've installed CrossSell and is working pretty much perfectly, problem is though that I want the related products to be all on one row - for some reason it's on two rows. Does anyone have any clue as to how they can all be on one row?
http://www.chichairandbeauty.co.uk/b...&products_id=3
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
coxdabd
Hi, hoping this is just a quick one, I've installed CrossSell and is working pretty much perfectly, problem is though that I want the related products to be all on one row - for some reason it's on two rows. Does anyone have any clue as to how they can all be on one row?
http://www.chichairandbeauty.co.uk/b...&products_id=3
I've fixed it. If any Googler should stumble across this, the way to add more related products to a row is in the MySQL database in the 'configuration' table.
-
Re: Multi Cross Sell mod [Support thread]
I've just installed this on a 1.3.9h store. It replaced the Advanced Cross-Sell mod in the old 1.3.8a store which I am upgrading. I renamed the products_xsell table to products_xsell1. In the admin, everything looks great, I can see all the cross-sells. However, on the product page that the customer sees, I get this error:
Quote:
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 products_xsell1 xp, products p, products_description pd where xp.products_id = '474' 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 ideas on what could be causing this?
Thanks!
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
Danielle
I've just installed this on a 1.3.9h store. It replaced the Advanced Cross-Sell mod in the old 1.3.8a store which I am upgrading. I renamed the products_xsell table to products_xsell1. In the admin, everything looks great, I can see all the cross-sells. However, on the product page that the customer sees, I get this error:
Any ideas on what could be causing this?
Thanks!
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.
-
Re: Multi Cross Sell mod [Support thread]
I had a question....Is there any way I can upload a whole list of related products to the database at one time, instead of doing it through the admin section? I have over 5000 products and I have a whole spreadsheet of related products to model number...can i do a bulk upload and have all those products relate to each other?
I am using 1.3.9d
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
kal130
I had a question....Is there any way I can upload a whole list of related products to the database at one time, instead of doing it through the admin section? I have over 5000 products and I have a whole spreadsheet of related products to model number...can i do a bulk upload and have all those products relate to each other?
I am using 1.3.9d
There is nothing built in for this, sorry
You could create a custom sql script to do this
-
Re: Multi Cross Sell mod [Support thread]
Can you point in the the right direction on where to look?
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
philip937
ok, well I got it to work, however, its does not work using the file tpl_modules_multi_xsell_products.php
so as a fix, I just included the old file on my server as well solely for cart upsell to use unless someone can work out what the difference is that causes it not to work.
so all I did was specified the table products_xsell1 and made sure I had includes/templates/MY_TEMPLATE/templates/tpl_modules_xsell_products.php
so that when cart upsell calls it here:
PHP Code:
require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php'); }
its works.
like I say, bit of a fudge but I really like cart upsell. :o)
Hi,
I tried the same as your instructions above but it's not working for me. I changed the Table in the cart-upsell.php page on line 35 and 39 to TABLE_PRODUCTS_XSELL1
and uploaded the tpl_modules_xsell_products.php to the correct template folder online. But nothing appears when I add products to the cart, the cross sell works fine on the product pages.
Am I forgetting something else? I think it is seeing the correct table as when I don't change the table name it gives an error.
Thanks,
B
-
Re: Multi Cross Sell mod [Support thread]
I have a couple questions.
I did have the same problem everyone else had with the error code showing up in the product description. I have followed what you said and got most of it off. All but this ?>.
I also noticed that the module is showing the products twice. You can see them here http://frompropertorocker.com/index....products_id=45
Where do I go to fix these?
Thanks in advance!
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
nolsowski
I have a couple questions.
I did have the same problem everyone else had with the error code showing up in the product description. I have followed what you said and got most of it off. All but this ?>.
I also noticed that the module is showing the products twice. You can see them here
http://frompropertorocker.com/index....products_id=45
Where do I go to fix these?
Thanks in advance!
You have added the multi cross sell code twice in
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php
Thats giving you the double display
Its also giving you those 3 extra characters
Edit that file to fix this problem
-
Re: Multi Cross Sell mod [Support thread]
Hi there,
Is it possible to create a cross sell table but have this show for certain products only? For example, we have a Camera Directory and want all the products here to have an "Accessories" cross sell table but dont want this to appear for other products i.e. clothes etc.
All the best
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
Berserker
Hi there,
Is it possible to create a cross sell table but have this show for certain products only? For example, we have a Camera Directory and want all the products here to have an "Accessories" cross sell table but dont want this to appear for other products i.e. clothes etc.
All the best
You can do this with a normal cross sell as it is.
The downside is all cross sells will have the same generic header.
Using multiple tables allows you customise the header shown for that table,
eg: You could have a "Camera Accessories" header for the cameras.
Note: that with all the cross sells, they work on a product basis, not a category that they are in, basis.
So if you have cameras in linked categories. The cross sell will show whenever that product is viewed, regardless of which category it came from.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
You have added the multi cross sell code twice in
includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php
Thats giving you the double display
Its also giving you those 3 extra characters
Edit that file to fix this problem
Thank you! I didn't realize I had the code in there twice.
-
Re: Multi Cross Sell mod [Support thread]
I am looking through my error log in my Cpanel and I came across this error.
Tue Jan 18 11:17:09 2011] [error] [client 188.165.234.114] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant 11 in /home/fromprop/public_html/includes/modules/alysa_rounded/multi_xsell_products.php on line 43
I re downloaded the module and opened that multi_xsell_products.php and the one I have in Winmerge and I got a message saying that it's identical.
I don't understand what this error message is telling me.
Thanks!
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
nolsowski
I am looking through my error log in my Cpanel and I came across this error.
Tue Jan 18 11:17:09 2011] [error] [client 188.165.234.114] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant 11 in /home/fromprop/public_html/includes/modules/alysa_rounded/multi_xsell_products.php on line 43
I re downloaded the module and opened that multi_xsell_products.php and the one I have in Winmerge and I got a message saying that it's identical.
I don't understand what this error message is telling me.
Thanks!
You have remnants of a previous cross sells confiquration installed
in this case MIN_DISPLAY_XSELL
See post #31
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
You have remnants of a previous cross sells confiquration installed
in this case MIN_DISPLAY_XSELL
See post #31
Am I supposed to search with that in the quotations or without? Reason asking is because I have went into my phpadmin and searched with and got nothing. But I searched without the quotations and I got a error that says this:
Error
SQL query: Documentation
SELECT *
FROM `zen_configuration`
WHERE `configuration_id` = MIN_DISPLAY_XSELL
LIMIT 0 , 30
MySQL said: Documentation
#1054 - Unknown column 'MIN_DISPLAY_XSELL' in 'where clause'
Sorry I am completely lost when it comes the the phpadmin.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
nolsowski
Am I supposed to search with that in the quotations or without? Reason asking is because I have went into my phpadmin and searched with and got nothing. But I searched without the quotations and I got a error that says this:
Error
SQL query: Documentation
SELECT *
FROM `zen_configuration`
WHERE `configuration_id` = MIN_DISPLAY_XSELL
LIMIT 0 , 30
MySQL said: Documentation
#1054 - Unknown column 'MIN_DISPLAY_XSELL' in 'where clause'
Sorry I am completely lost when it comes the the phpadmin.
Try this instead...
SELECT *
FROM `zen_configuration`
WHERE `configuration_key` = 'MIN_DISPLAY_XSELL'
LIMIT 0 , 30
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
Try this instead...
SELECT *
FROM `zen_configuration`
WHERE `configuration_key` = 'MIN_DISPLAY_XSELL'
LIMIT 0 , 30
Just tried this too and it's saying it's coming up empty.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
nolsowski
Just tried this too and it's saying it's coming up empty.
browse this table
goto the end
page backwards until you find it
then delete it
ignore the same key that has a number after it
eg MIN_DISPLAY_XSELL1
MIN_DISPLAY_XSELL2
MIN_DISPLAY_XSELL3 etc
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
browse this table
goto the end
page backwards until you find it
then delete it
ignore the same key that has a number after it
eg MIN_DISPLAY_XSELL1
MIN_DISPLAY_XSELL2
MIN_DISPLAY_XSELL3 etc
Thanks! I got it deleted.
-
Re: Multi Cross Sell mod [Support thread]
Hi
I got your mod installed correctly i think, but im stuck on the entering my first cross sell.
getting the error 'Please input at least 2 products ids/models to cross-sell'
there are only 2 text entry boxes -new cross sells & edit cross sells
i didnt merge the file tpl_product_info_display.php becuse its not in my custom template folder.
tho i have that file in a template_default folder.
im on Zen 3.8
Thank You!
-
Re: Multi Cross Sell mod [Support thread]
Hi
i had to remove all the multi cross sell files entirely.
when i clicked on any of my product thumbnail/links to view product page the page was blank :no:
when i removed all the multi cross files they came back, thank God.
still need a mod like this though.
eg we have a product category 'coffee tables'
when a visitor looks at 'Acme coffee table'
i want the to see below listing...also in this range...
-'acme bookshelf' 'acme lamp table' etc
any help advice appreciated.
Cookie
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
Cookiepus
Hi
I got your mod installed correctly i think, but im stuck on the entering my first cross sell.
getting the error 'Please input at least 2 products ids/models to cross-sell'
there are only 2 text entry boxes -new cross sells & edit cross sells
i didnt merge the file tpl_product_info_display.php becuse its not in my custom template folder.
tho i have that file in a template_default folder.
im on Zen 3.8
Thank You!
In the "New Cross Sell"
Enter a list of items that you want to cross sell sepearated with the defined separater
ege: product1,product2,product3 will cross sell these 3 products in all possible ways
Read yellow1912's tutorial in docs\how_to_use.txt
If the file tpl_product_info_display.php becuse its not in my custom template folder
then rename the sample file
SAMPLE_ADDITION_TO_tpl_product_info_display.php
to
tpl_product_info_display.php
and make sure it is in your overide folder
\includes\templates\YOUR_TEMPLATE\templates\
renaming "YOUR_TEMPLATE" to your template name of course
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
Cookiepus
Hi
i had to remove all the multi cross sell files entirely.
when i clicked on any of my product thumbnail/links to view product page the page was blank :no:
when i removed all the multi cross files they came back, thank God.
still need a mod like this though.
eg we have a product category 'coffee tables'
when a visitor looks at 'Acme coffee table'
i want the to see below listing...also in this range...
-'acme bookshelf' 'acme lamp table' etc
any help advice appreciated.
Cookie
Almost certainly to do with the file
tpl_product_info_display.php if you merged it with the original instead of putting it in the overide folder
You can use this to debug
http://www.zen-cart.com/index.php?ma...roducts_id=860
Also https://www.zen-cart.com/tutorials/index.php?article=82
-
Re: Multi Cross Sell mod [Support thread]
Thank you very much!
i'll try this out later today
Cookie
-
Re: Multi Cross Sell mod [Support thread]
How do I get the price to be center under the cross sell product title?
http://frompropertorocker.com/index....oducts_id=1520 It looks horrible when it's just one cross sell product.
It doesn't look so bad when there is more than one like here but the price is still off centered.
Thanks!
-
Re: Multi Cross Sell mod [Support thread]
Does anyone know how to set up the cross sell as a sidebox instead of having it under the products??
Cheers
Phil
-
Re: Multi Cross Sell mod [Support thread]
I tried to delete both MAX_DISPLAY_XSELL and MIN_DISPLAY_XSELL, but the problem still exists as #34. Anyone who followed instructions on #32 and got the problem fixed. Please show me the steps that you went through. Thanks so much.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
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
I tried to delete them, but I don't get the problem fixed. The error message is similar to #29.
Anyone who get the problem fixed, please show me the procedures how to fix the problem. Thanks so much.
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
ttmb33
I tried to delete them, but I don't get the problem fixed. The error message is similar to #29.
Anyone who get the problem fixed, please show me the procedures how to fix the problem. Thanks so much.
Not sure what you have done...
Did you find MAX_DISPLAY_XSELL?
Did you then try to delete it but this key is still there?
-
Re: Multi Cross Sell mod [Support thread]
Quote:
Originally Posted by
gilby
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.
I also have this problem but it is happening on a fresh 1.3.9h install with no previous versions installed. In this case, post #31 does not apply. Please help.
Thanks
-
Re: Multi Cross Sell mod [Support thread]
I installed this on my site. I am able to add items to the xsell in admin but when I go to the page it throws this 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 ntt_zen_products_xsell1 xp, ntt_zen_products p, ntt_zen_products_description pd where xp.products_id = '1665' 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 ]
-
Re: Multi Cross Sell mod [Support thread]
I did install Cross Sell - Just Another Cross Sell Mod previously.
