Cart Upsell / Cross sell

I downloaded this contribution from http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_47&products_id=283 and it works fine apart from the heading not appearing properly. Doesn't seem to be reading the correct name. Does anyone have an idea how to fix this. I'm sure it's just something simple but I don't know php very well. Thanking you in advance.

Hmm... there doesn't seem to be a support thread for this contrib. You might try PMing the author.

http://www.zen-cart.com/forum/member.php?u=18411

Good luck,
Scott

Can't get it to work.

Added the files then Looked for:

includes/modules/classic/cart_upsell.php

its not there,

is this a stand alone? or do I need to install "Cross Sell" or something else first?

thanks

Got it to working by installing Cross Sell v1.3.0

But the recommendation box displays: TEXT_XSELL_PRODUCTS

Where do I change this?

also I see that the installation directions mention :
4. Open includes/modules/classic/cart_upsell.php and modify any of the defined parameters you desire...

There is no such file in there, do you mean ncludes/modules/YOUR_TEMPLATE/cart_upsell.php ?

If you have the cross sell mod installed, you should have added the following line to /includes/languages/english/product_info.php:

define('TEXT_XSELL_PRODUCTS', 'We Also Recommend For: ');

Please use YOUR_TEMPLATE in place of classic when following the path to the cart_upsell.php file to modify the defines.

I uploaded an updated version of the mod that fixes this problem.

Ok I have installed Upsell ( new version) on my 1.3.7 shop but for the life of me I can not figure out where in the admin, front end etc.. I try to use this feature?

We have followed the install text to the letter and have no error but don't see anything different about the cart?

Can someone help? thanks!
~Renee

Can anyone tell me how to use this feature once installed?
~Renee

Anyone in there? Tap tap :)
~Renee

The cross sell portion is a separate mod to be installed if you desire. It adds a section of products of your choosing to be displayed on whatever product pages you desire. If you do install it, this mod will then display the cross sell window on the shopping cart page as well, keying off the items in the shopping cart.

The up sell portion is already built into zen cart and is the "customers who purchased this item also purchased..." box which displays on any products page for which other customers have purchased **that exact same item, along with other items. This mod then also displays that box on the shopping cart page, keying off whatever items are in the cart.

**If there are not completed orders in your installation of zen cart, then there is no buying history of "customers who purchased this item also purchased..." to be able to display.

On the admin side, the only configuration of this mod is setting the number of columns per row to display in the upsell box which is done under configuration->Product Info and as the install.txt states, "open includes/modules/YOUR_TEMPLATE/cart_upsell.php and modify any of the defined parameters you desire...".

"The cross sell portion is a separate mod to be installed if you desire. It adds a section of products of your choosing to be displayed on whatever product pages you desire. If you do install it, this mod will then display the cross sell window on the shopping cart page as well, keying off the items in the shopping cart."

Does the Cross Sell mod 1.3.1 work with 1.3.7? And will it work on it's own as well without the other mod?

Thanks!
~Renee

Does the Cross Sell mod 1.3.1 work with 1.3.7? And will it work on it's own as well without the other mod?

Just installed it on a 1.3.7 (on his own) and it works fine.

I am doing an upgrade from 1.3.6 to 1.3.7 and started with a fresh install and now I am adding my mod. I ran into a problem with cross sell.

The product page that should have the cross sell product listed below has errors:

?>
Warning: main(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.main]: failed to open stream: No such file or directory in /home/artwax/public_html/md137/includes/templates/mydanilo/templates/tpl_modules_xsell_products.php on line 17

Warning: main(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.main]: failed to open stream: No such file or directory in /home/artwax/public_html/md137/includes/templates/mydanilo/templates/tpl_modules_xsell_products.php on line 17

Warning: main() [function.include]: Failed opening 'includes/modules/FILENAME_XSELL_PRODUCTS.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/artwax/public_html/md137/includes/templates/mydanilo/templates/tpl_modules_xsell_products.php on line 17

I know I had the same issue last time I upgrades but I can't figure out anymore why this is? Anybody a clue?
I did everything the install.txt said. :mellow:

Well, it did not sit well with me that this is not working.

Here is what I did. I deleted all cross sell files out of my template and started with a new set of files from the cross_sell_advanded mod. I followed the install file step by step and voila! IT IS NOW WORKING. No idea what so ever why it did not work in the first place.

:lookaroun

This mod is kind of working okay but I get the following showing on the screen if I add a lot of items to the cart.

14 items and the screen below the cart shows:

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 '-2)' at line 1
in:
[(select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '478' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '581' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '468' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '451' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '479' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '476' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '471' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '588' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '481' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '582' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '473' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '586' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '447' 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.products_id asc limit 2) UNION (select p.products_id, p.products_image from fmproducts_xsell xp, fmproducts p, fmproducts_description pd where xp.products_id = '475' 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.products_id asc limit -2)]

Anyone else getting this and is there a fix please.

MG

i get the error

1044 Access denied for user: 'tiazen@%' to database 'tiazen'
in:
[create temporary table cross_sell ( products_id int(11), products_image varchar(64) )]

anybody?:frusty:

sirryche:

i get the error

1044 Access denied for user: 'tiazen@%' to database 'tiazen'
in:
[create temporary table cross_sell ( products_id int(11), products_image varchar(64) )]This most likely means that the user ID that you are using to access your database and which was inserted into your configure files when Zen Cart was installed is allowed to read and write data from and to your database, but is not allowed to create temporary tables.

Did you create the database user profile yourself, or was this done for you by your host or a database administrator? If the latter, discuss with them, adding the table creation option to your profile. If you created it yourself, you'll probably know how to do this in whatever tool you used.

I have a shopping cart layout problem with this mod. My estimate shipping button is overlapping the upsell header where it sais:
Customers who selected the items in your cart also chose...

How can I change the layout, or just add some space so it does not overlap? I tried to find a CSS setting but did not succeed. Help please.

See the attached jpg if you are not sure what I am talking about.

Danilo,

I've got the exact same problem. I'll post if I find an answer.

I knew I had figured this out on another site. Go to Admin>Configuration?Shipping/Packaging and set Shipping Estimate Button to '2'.

IMHO, a much better user experience to not leave the page to get a rate quote.