Ultimate Cross Sell [Support Thread]

Hi
Great mod, thanks.
I have loaded and tested by manually creating some linked products. And then changed my settings to get the display just as I want. really great.

I am not a programmer, and I am sure if I was this would be a really stupid question, - is there any way to load all teh linked files using Easy Populate ?
I have looked at the database tables and the links are stored using the zen-cart generated product ids and not my item numbers.
I think I have enough excel skills to create the EP file but I am not sure about which fields

Any ideas ?

Thanks
Sarah
https://www.shopforcostumes.co.uk

I could not honestly say how to upload using easy populate. You could try downloading it from your SQL. I don't work much with SQL so before you attempt anything BACKUP YOUR DATABASE

1. Go to https://www.example.com/phpmyadmin/
2. Click on the Databases Tab
3. Select your database
4. Click on the Export Tab
5. Click on the Unselect All link
6. Hold CTRL and select ultimate_cross_sell_1, ultimate_cross_sell_2 and ultimate_cross_sell_3
7. Choose the format you need. SQL should be the default but there are excel and csv format sice you are more familiar with those
8. Under Structure, Make sure "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT" and "Add CREATE PROCEDURE / FUNCTION / EVENT" are selected (See attached image below)
9. Choose Save as file
10. Click Go
11. Go to Tools > Install SQL Patches and Run that sql file

Basically you will get the code shown below. You could just make the necessary changes to the first, second and third numbers and the actual table you will be using. i.e. 1 = Cross Sell, 2 = Up Sell, 3 = Related Products.

Whatever you do. BACKUP YOUR DATABASE before doing anything.

DROP TABLE IF EXISTS ultimate_cross_sell_1;
CREATE TABLE IF NOT EXISTS ultimate_cross_sell_1 (
  ID int(10) NOT NULL AUTO_INCREMENT,
  products_id int(10) unsigned NOT NULL DEFAULT '1',
  cross_sell_id int(10) unsigned NOT NULL DEFAULT '1',
  sort_order int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (ID),
  KEY idx_products_id_cross_sell (products_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO ultimate_cross_sell_1 (ID, products_id, cross_sell_id, sort_order) VALUES
(1, 12, 13, 1),
(2, 13, 12, 1),
(3, 12, 16, 1),
(4, 16, 12, 1),
(5, 16, 14, 1),
(6, 26, 17, 1),
(7, 27, 9, 1),
(8, 30, 6, 1),
(9, 33, 20, 1);

Hope this helps. Good Luck!

Hi, ive been trying to install your module it doesnt seem to add to my server, most likely my fault ,, i have changed the bit following instruction ,,,

6.Using your favorite Text Editor, add the following code to the bottom of includes\templates\YOUR_TEMPLATE\templates\tpl_product_info_display.php immediately above the last </div> tag.This bit above didnt have the files it only had the example files, not sure if i did this bit right, but was i suppose to edit the sample files and save as a php file???

As i uploaded it but it doesnt show a thing,,, most likely something im not doing right,, hoping you could advice a little Thanks ,,

You have to modify the file: tpl_product_info_display.php. This file is located in the folder includes\templates\template_default\templates. The proper way to do this is by creating your CUSTOM template and add the new and modified tpl_product_info_display.php to it.

Add the following code to the bottom of includes\templates\YOUR_NEW_CUSTOM_TEMPLATE\templates\tpl_product_info_display.php immediately above the last </div> tag.

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

If you need guidance to create/rename your template folder, follow the instructions on How do I create a new Custom Template? on the Zen Cart Tutorials

Hi Thanks for the reply,, the two files have been changed from instruction via the DOC files,, they show up in my custom template files with the changes,,

But nothing happens,, the admin folder and the template folder have been changed etc,,

I can see the files in there respective folders on the server, at first i thought i may have uploaded in the wrong place, but im asuming its in the right place as the custom template files have your changes in them...

presently using: v1.3.9d)

Delete my last post, im talking rubbish not all of the files are in place,,

On one of my pages the "Related Products" are overlapping my add to cart section. I have this code ```php

How can I fix it so it's under the add to cart section not overlapping it? 

Example: [http://frompropertorocker.com/blueberry-pacifier-clip-p-16.html](http://frompropertorocker.com/blueberry-pacifier-clip-p-16.html)

Thanks!

Nvm. I believe I got it. I just moved my add to cart code up further and so far it looks good. :)

Hi there. This is a great mod and my client loves it. I've got a few odd behaviours though.

The drop down list in Catalog>Ultimate Cross Sell is blank (it doesn't show the 1,2,3 as choices) so I have to keep going into the configure to change edit modes. Annoying but not crucial...I believe others mentioned they had this problem as well but no solution was ever posted.

Also, Related Products don't show at the bottom of my Product listing. Upsell items are in a sidebox and show. If I set Related Items to show in a sidebox, they do. But they won't show up in a centered box. (this is extra odd because they DID at one point then we deleted everything out of all the cross sell tables and started over and now it won't show.)

Any thoughts?
I'm using Zen Cart v1.3.9h and am building my test store here (link is to product page that has related items: http://greengrooveconsulting.com/aquasafe_zc_new/index.php?main_page=product_info&cPath=1&products_id=1

cavinggirl:

... Also, Related Products don't show at the bottom of my Product listing. Upsell items are in a sidebox and show. If I set Related Items to show in a sidebox, they do. But they won't show up in a centered box. (this is extra odd because they DID at one point then we deleted everything out of all the cross sell tables and started over and now it won't show.)

Any thoughts?
I'm using Zen Cart v1.3.9h and am building my test store here (link is to product page that has related items: http://greengrooveconsulting.com/aquasafe_zc_new/index.php?main_page=product_info&cPath=1&products_id=1

LOL I ran into this problem too and thought it was just me not re-uploading everything correctly. Glad to know I'm not alone. :smile:

To solve it, I went to includes/modules/your_template/ultimate_cross_sell_products.php and at the very top of the page (right above all the define statements) I added

$cross_sell = 3;

and that made the centerbox show up on my product pages.

It's only a temporary fix as it only allows one centerbox on the product pages, but if one is all you need, then it should work.

kamelion0927:

LOL I ran into this problem too and thought it was just me not re-uploading everything correctly. Glad to know I'm not alone. :smile:

To solve it, I went to includes/modules/your_template/ultimate_cross_sell_products.php and at the very top of the page (right above all the define statements) I added
[PHP]$cross_sell = 3;[PHP]
and that made the centerbox show up on my product pages.

It's only a temporary fix as it only allows one centerbox on the product pages, but if one is all you need, then it should work.

Thanks for the suggestion, but (sigh) unfortunately that didn't fix my problem. It makes me wonder though what would happen if you put [PHP]$cross_sell = 4; [PHP] Since it didn't work for me, I can't say but it might put more centerboxes below the listing for someone else.
What is so frustrating is that it WAS working!:sadwalk:

1st class mod, simple to install & modify with details.
Thanks

The Upsell "Customers who bought this also bought" module on the product page shows the correct number of columns per row, but the same module on the shopping cart page does not. How can I fix/change the number of items displayed in the module that appears on the shopping cart page?

is there a relatively easy way to add in a product description field to the display?

i got as far as adding this to ultimate_cross_sell_products.php before i wasn't sure what else i would need to add where to make it work: ```php
(constant(CROSS_SELL.$cross_sell._DISPLAY_DESCRIPTION)=='true'? '<tr><td colspan="4"><div class="description">' zen_get_products_description($cross_sell_query->fields['products_id']). '</div></td></tr></table>':'')

:)  thanks.

How do I change the number of lines columns in the "To go with the items in your cart we also suggest.." box? Thanks

Is there a way, on any given product page, to display any item from that products category as a related products, without having to manually enter each individual product's Model or ID # under catalog/Ultimate Cross sell.

I guess what I'm asking: Is there a way to have related products automatically generated from products within the same category ?

Thanks,
Kathleen

help guys please..after uploading all the files i went to install

and i get this

Warning: define() expects at least 2 parameters, 1 given in ........................NeW/admin/includes/functions/extra_functions/ultimate_cross_sell.php on line 281

and this is on line 281 of that file

if ($num_cross_sell == '1') define($mxs_selected_table = 'Cross Sell');

Thank you

Change the 3 lines to:

if ($num_cross_sell == '1') define($mxs_selected_table = 'Cross Sell', '');
if ($num_cross_sell == '2') define($mxs_selected_table = 'Upsell', '');
if ($num_cross_sell == '3') define($mxs_selected_table = 'Related', '');

I've literally just fixed this problem and it worked for me.

Bob

I am running Ultimate Cross Sell on a local site which is an EXACT ############## of a live site. The Cross Sell Mod works fine locally but when I put it live nothing shows.

All I have is related products on the product detail page.

The only thing that is different is that Simple SEO is enabled on LIVE but not locally as it won't work on my Windows server but when I disable this on live the related products still won't show.

There is no markup being written to the page at all.

Any ideas what I am missing. I have uploaded the files 3 times to make sure I didn't miss anything.

Thanks

Hi, great mod! My related products, upsell and even cross sell products are showing in one single row (down), instead of showing in 3 rows (across). Is there a way to fix this problem? I already put the number 3 in PRODUCTS COLUMNS PER ROW. Thank you!

Been looking around all the forums and no one seems to have an answer for this :frusty: