Ultimate Cross Sell [Support Thread]

[shop4costumes]

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
www.shopforcostumes.co.uk

[ultimate_zc]

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

[ultimate_zc]

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.p hp 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

[sash]

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)

[sash]

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

[nolsowski]

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

<!--bof Form close-->
<!-- 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 -->

clear at the end of my tpl_product_info_display.php The code is not even close to my add to cart code.

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

Example: http://frompropertorocker.com/bluebe...clip-p-16.html

Thanks!

[nolsowski]

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

[cavinggirl]

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/aqu...&products_id=1

[kamelion0927]

... 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/aqu...&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.

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.

[cavinggirl]

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.

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!