Ultimate Cross Sell [Support Thread]

I upgraded Zen cart from 1.3.9 to 1.5 and realized that the links from the Admin were removed with the upgrade. I managed to manually add the links back in one by one with the Admin Page Registration tool and this mod now works on my 1.5 site.
Admin Access Management => Admin Page Registration

Page Key: Ultimate Cross Sell
Page Name: _CATALOG_MULTI_CROSS_SELL_PRODUCTS
Page Filename: FILENAME_CONFIGURATION
Page Parameters: gID=XXXX (Lookeup in phpMyAdmin configuration_group)
Menu: configuration
Display on Menu? Y
Sort Order: whatever you want
The configuration menu for Ultimate Cross Sell should now be visible on 1.5
Admin Access Management => Admin Page Registration
Page Key: Ultimate Cross Sell mod
Page Name: _CATALOG_MULTI_CROSS_SELL_PRODUCTS
Page Filename: FILENAME_CROSS_SELL_PRODUCTS
Page Parameters: gID=XXXX (Looke up in phpMyAdmin configuration_group)
Menu: Modules
Display on Menu? Y
Sort Order: whatever you want
The Modules menu for Ultimate Cross Sell should now be visible on 1.5

This is a great app, but I can't figure out one thing. I would like to have the same few items show up in cross sell no matter what the customer views or adds to cart. (I have thousands of items.)

Can someone share how to make this mod do that, or suggest another mod that would better suite my needs?

Thanks!

This one is amazing add-on.

Is it, however, possible somehow to pick entire category to cross-sell - for instance, if I'm selling LCD TV's, I want to offer my customers another related product or extended warranty or whatever. Is it possible to choose entire category at once, instead of selecting ID's of each product one-by-one?

Thanks.

@Frank, Just double, triple checking. You have this working on 1.5 without any problems or errors? I would like to try it but have been waiting for the promised upgrade and wondered if the current version would break things.

Many Thanks

FrankStephen:

I upgraded Zen cart from 1.3.9 to 1.5 and realized that the links from the Admin were removed with the upgrade. I managed to manually add the links back in one by one with the Admin Page Registration tool and this mod now works on my 1.5 site.
Admin Access Management => Admin Page Registration

Page Key: Ultimate Cross Sell
Page Name: _CATALOG_MULTI_CROSS_SELL_PRODUCTS
Page Filename: FILENAME_CONFIGURATION
Page Parameters: gID=XXXX (Lookeup in phpMyAdmin configuration_group)
Menu: configuration
Display on Menu? Y
Sort Order: whatever you want
The configuration menu for Ultimate Cross Sell should now be visible on 1.5
Admin Access Management => Admin Page Registration
Page Key: Ultimate Cross Sell mod
Page Name: _CATALOG_MULTI_CROSS_SELL_PRODUCTS
Page Filename: FILENAME_CROSS_SELL_PRODUCTS
Page Parameters: gID=XXXX (Looke up in phpMyAdmin configuration_group)
Menu: Modules
Display on Menu? Y
Sort Order: whatever you want
The Modules menu for Ultimate Cross Sell should now be visible on 1.5

So you didn't have to make a change in the files at all? I see one place where I thought a change should be needed. I have a client who wants this, so think I'll have it ready shortly.

It takes more than "adding the links back with Admin Page Registration". Just because you CAN make it work with ZC150 in this way, doesn't mean you SHOULD.

For example, did you check to make sure the old SQL file is compatible with the new db structure of ZC150? Or, have you gone through all of the pages of this mod to check the code for security issues such as destructive GETS and replace them with POSTS (if any)? Many changes were made in ZC150 in regards to security, and mods need to be updated to be in compliance with those security features - especially mods that make heavy use of the db as this mod does. Did you do any of that?

Don't get me wrong, I would LOVE to have this mod for ZC150, but I've been waiting for the mod author to complete and release the update because I KNOW he will do all those things and that using his mod will ensure safety and reliability.

If someone else can complete all of that before he can, I'm sure he'd appreciate it - as would everyone waiting on an update of this mod. But it's unfair to the community to prematurely release an update that isn't all that it should be.

I hope I'm not offending you, as that is not my intent. Just want to make sure you are aware of these things and find out whether or not you evaluated the code for necessary changes. Here's an article about updating mods to work with ZC150

FrankStephen:

I upgraded Zen cart from 1.3.9 to 1.5 and realized that the links from the Admin were removed with the upgrade. I managed to manually add the links back in one by one with the Admin Page Registration tool and this mod now works on my 1.5 site.
Admin Access Management => Admin Page Registration

Page Key: Ultimate Cross Sell
Page Name: _CATALOG_MULTI_CROSS_SELL_PRODUCTS
Page Filename: FILENAME_CONFIGURATION
Page Parameters: gID=XXXX (Lookeup in phpMyAdmin configuration_group)
Menu: configuration
Display on Menu? Y
Sort Order: whatever you want
The configuration menu for Ultimate Cross Sell should now be visible on 1.5
Admin Access Management => Admin Page Registration
Page Key: Ultimate Cross Sell mod
Page Name: _CATALOG_MULTI_CROSS_SELL_PRODUCTS
Page Filename: FILENAME_CROSS_SELL_PRODUCTS
Page Parameters: gID=XXXX (Looke up in phpMyAdmin configuration_group)
Menu: Modules
Display on Menu? Y
Sort Order: whatever you want
The Modules menu for Ultimate Cross Sell should now be visible on 1.5

I have a bit of loop with this mod - in order to do a fresh install, the user has to press the install button. Yet, in 1.5, you can't get it to show up on the menu without it being installed. I have yet to come up with a way to do a fresh install through the code. I'm afraid the upgrade itself will take a lot more coding then i had realized and that might well be why the mod developer has yet to get this done.

ScriptJunkie is correct that it is more than was reported earlier. However, I'm struggling with the gets myself. There are a few of them and I may just not be the one to do the fixes for that either. Very disappointing since I have a client who wants it now!

delia:

I have a bit of loop with this mod - in order to do a fresh install, the user has to press the install button. Yet, in 1.5, you can't get it to show up on the menu without it being installed. I have yet to come up with a way to do a fresh install through the code. I'm afraid the upgrade itself will take a lot more coding then i had realized and that might well be why the mod developer has yet to get this done.

ScriptJunkie is correct that it is more than was reported earlier. However, I'm struggling with the gets myself. There are a few of them and I may just not be the one to do the fixes for that either. Very disappointing since I have a client who wants it now!

Re: the GETS....it's only destructive GETS that need to be replaced with POSTS. Non-destructive GETS can be left in place. Since I'm not a coder, I don't really know the difference or how to identify the two different types. Add to it that this is a huge and complex mod that very well might need some kind of auto-installer (or in the least, an old fashioned install.sql file) to get up and running and I knew I had to keep my hands off. It's going to take someone with a whole lot more than I got to update this one.

I feel your pain Delia :(

well, the good news is that I'm almost there. Asked for help about the gets - think I have them figured out. Got a small database problem that's due to my skill level that I may have to break down and ask a more advanced coder about. Stay tuned!

novastar:

Forgive me forum users, but on the UCS page in the dropdown list used to select which table you wish to edit, there are no numbers showing up. Has anyone else experienced or resolved this?

I'm having the same issue.

Also, when I toggle to show All (Cross, Related, Upsell) on the product page nothing actually shows. Although they work when I choose only one to show on the product page.

yeah I've read through this entire thread and I didn't see a solution to this issue.

although just wanted to say that this is a great plugin, thanks to the lead dev.

Hi
Just installed this mod and everything 'appears' to be working, except....

I have added an 'Upsell' to a product, which I would like the customer to see a better product (as we do)

I set the admin to 'Upsell' and chose 'One Way Only' then my cheaper item placed in the 'Main Product' and then the expensive item in the 'Product Models' box and saved.

No problem so far.... If I go to the cheaper item, then the upsell is showing beneath the add to cart (central) BUT, if I now go to the 'Upsell' item there is my cheaper item displayed as an 'Upsell'

I thought the 'One Way' meant it should not display on the up sell item page?

Read through all the posts but failed to see this listed... Any help??

Thanks

Hi,

Got almost all of this useful Addon working well for me, but stuck with an issue that appears only in the Cart Up Sell module (which is refered to in the Admin panel as Cross Sell on Shopping Cart)

Up sell and cross sell both display fine in product listing, but in the cart the cross sell shown by cart_upsell.php returns this error:

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

Any help much appreciated.

Andrew

@Rizla - I'm running same way as you with One Way enabled and I do notsee the same problem. You don't have any earlier versions of cross sell/up sell installed do you? I've got a clean Ultimate Cross sell installed and one way upsells really do seem to work fine for me on 1.3.9f

Is it definietly just showing Up sells? (Admin > Configuration > Ultimate > Display Ultimate Cross Sells on Product Page = 2 and you're not seeing some other cross sell you accidentally setup instead of an up sell? Check for other cross sells and delete them?

Re. Post #193 above.

Jose, this is on zen cart 1.3.9f, on the shopping cart page.

Screenshot here:

Error can be seen where cross sell products should appear. Full text reads:
1044 Access denied for user 'web-wssdev'@'%' to database 'web-wssdev'
in:
[create temporary table cross_sell ( products_id int(11), products_image varchar(64) )]

But in my tests I can see any attempt to CREATE in the DB from the shopping cart page fails in the same way. I thought at first it might be be using SSL on checkout page, but I'm on a test server at the moment and have turned off SSL access to shopping cart.

Someone else with a similar problem:
http://www.zen-cart.com/showthread.php?187642-Ultimate-Cross-Sell-Database-Error-Question

Your help would be much appreciated.

Andrew

A link to the page would be of enormous since it would allow me to recreate the problem and look at the source code.

Some suggestions:

1. Make sure any files belonging to any other cross sells have been deleted.
2. Make sure that you have added the correct code at the bottom of the tpl_shopping_cart_default.php, immediately above the last div.

<!-- bof Ultimate Cross Sell Combo -->
<?php require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_CART_UPSELL)); ?>
<?php require($template->get_template_dir('tpl_modules_also_purchased.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_also_purchased.php'); ?>
<!-- eof Ultimate Cross Sell Combo --> 

IMPORTANT, The code for tpl_product_info_display.php calls for tpl_modules_ultimate_cross_sells.php while the code for the tpl_shopping_cart_default.php calls for tpl_modules_also_purchased.php.

Thanks,

A development copy of the site can be found at the link below:
http://www.prepressrips.co.uk/

I can't link you directly to the page as you'll need an active shopping cart.

You'll see the cross sell and up sell mods run fine on the product listing as seen here:
http://www.prepressrips.co.uk/760mm-x-760mm-mx-square-stone-resin-shower-tray-p-9.html

But add this item to the cart and you'll see the database permissions error.

Yes I carefully followed your installation document so the code has been correctly pasted in before the closing </div> - and tpl_modules_also_purchased is present. We can see this is true because the cart is executing the code which ultimately runs cart_upsell.php where the line which is causing the error exists.

It's line 54 of cart_upsell.php which is returning the error
create temporary table cross_sell ( products_id int(11), products_image varchar(64) )

Seems to be being called in a way that my database thinks the user isn't allowed to create objects in the database. My database user that's setup in zencart's configure.php does have the rights to create tables (Hence the rest of your mod and plenty of other features on the site work!) but when the above line is called by your code only on the cart page it seems to be with a user or in a way that my DB server doesn't think it's allowed.....

You have other files in the mod which make similar calls to "create temporary table ..." these all work fine, it's just the one in cart_upsell.php that causes the error.

Thank you very much for taking a look.

Regards,
Andrew

While trying to fix this issue, I found another of much lesser importance.

The code at the bottom of tpl_modules_also_purchased.php lines 94 - 100 leaves out a closing division tag when the shopping cart is empty.

<div class="centerBoxWrapper" id="alsoPurchased">
<?php
      require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php');
    }
  }
?>
</div>

You should replace it with the code shown below or something similar.

<?php
	echo '<div class="centerBoxWrapper" id="alsoPurchased">';
      require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php');
      echo '</div>';
    }
  }
?>

As for the original problem. I don't think it has anything to do with Ultimate Cross Sell but rather with the permissions to read and write data from and to your database as specified by kuroi on this thread: Re: Cart Upsell / Cross sell #17

Thanks for looking and yes I will update the other issue you spotted.

Yes I already read that thread before contacting you, as I say in my report above we know the user has the correct permissions as other parts of your mod also create temporary tables and those all work fine, it's only when you try to do it from the shopping cart page that it fails. It's as if the checkout page somehow uses a different user or gets different priviledges to the same user on the rest of the site. I'm stumped. :frusty:

I'll keep looking, I'll post the resolution here if I find one.

I've confirmed it's nothing to do with actual privilidges on the database:

'web38-wssdev'@'%' has the following permissions

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE

So that's not what's causing the error...