Ultimate Cross Sell [Support Thread]

[parisbubbler]

I'm getting this error, The requested URL /admin/FILENAME_CROSS_SELL_PRODUCTS.php was not found on this server. where admin is my admin folder. all files were copied as suggested in the installation manual.

got 'just another cross sell mod' installed. do i uninstall all files related to that?

can anyone help

[parisbubbler]

Got it sorted

[Paul...the...first]

I have installed the module but get the error shown below when I turn on any of the three side boxes. My whole web site is affected by this, disable the box(es) and the web site is back as it should be.

I am using zen cart 1.3.9h

The error is

1146 Table 'myp********1.TABLE_PRODUCTS_CROSS_SELL2' doesn't exist
in:
[select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id from (TABLE_PRODUCTS_CROSS_SELL2 xp, zen_products p, zen_products_description pd) where xp.products_id = '19' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1']

[weljkodj]

Hi,
Is there a way to display related products on a product page just below the current product info?

I have set up option Display Ultimate Cross Sells on Product Page to 3 (related products) and I dont see any changes.

If I turn on left related.php sidebox, it works fine, but I would like to have it below product info.

[DarkEmotions]

Hi, i have just installed this mod, it is amazing and works perfectly , i am using this mod for linking a single product to several associated products, so i use table 3 = Related Products and then i choose Related Products 1 way only, this means i can only choose one main product at a time to link to several other products. Is there a way that i can link several main products at a time to several same related products, it seems when you choose the link one way option this isn't possible and i have an awful lot of products i need to link up.

I would be grateful with any help regarding this, thanks

[ultimate_zc]

Is there a way that i can link several main products at a time to several same related products, it seems when you choose the link one way option this isn't possible and i have an awful lot of products i need to link up.

The closest solution I can suggest is by using your SQL Query Executor. Let's say for example that you want to add five products 1 way only to your Cross Sell table with the product IDs being 8, 9, 10, 11 and 12 and product ID "8" being the Main Product. You would add the following values:

Main product: 8
Product id(s): 9,10,11,12

and hit "insert" getting a success message at the top showing:

Product 9 has been added as a Cross-Sell to Product 8
Product 10 has been added as a Cross-Sell to Product 8
Product 11 has been added as a Cross-Sell to Product 8
Product 12 has been added as a Cross-Sell to Product 8

This could have also been accomplished by inserting the statement shown below into your SQL Query Executor (Admin > Tools > Install SQL Patches)

INSERT INTO ultimate_cross_sell_3 (ID, products_id, cross_sell_id, sort_order) VALUES
(1, 8, 9, 1),
(2, 8, 10, 1),
(3, 8, 11, 1),
(4, 8, 12, 1);

Therefore, you could perhaps utilize the statement below and add several Main Products at a time. Simply replace the X with your main product and Y1, Y2 etc... with the 1 way only products of your choice. Then copy and paste and/or replace as needed. Remember to BE SURE TO DO A FULL DATABASE BACKUP BEFORE RUNNING A SCRIPT LIKE THIS.


INSERT INTO ultimate_cross_sell_3 (ID, products_id, cross_sell_id, sort_order) VALUES
(NULL, X, Y1, 1),
(NULL, X, Y2, 1),
(NULL, X, Y3, 1),
(NULL, X, Y4, 1);

[ultimate_zc]

Hi,
Is there a way to display related products on a product page just below the current product info?

As stated in the instructions in README.html, you need to add the following code to your tpl_product_info_display.php:

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

You don't necessarily need to place this code immediately above the las </div> tag as per instructions.

In order to have any of the cross sell centerboxes to be shown below the current product info, try inserting the code below "<!--eof Attributes Module -->" or any other place of your choosing. If your settings for Admin > Configuration > Ultimate Cross Sell Settings > Display Ultimate Cross Sells on Product Page are set to either 3 Related Products or 4 ALL, your products should be displayed.

Please provide your website URL in order for me to take a look at your source code and perhaps find out any other issue.

[ultimate_zc]

The error is

1146 Table 'myp********1.TABLE_PRODUCTS_CROSS_SELL2' doesn't exist

Perhaps you could begin by doing the following:

1. Make sure to remove any files related to previous cross sell
2. Remove any code that calls for any previous Cross Sell addon you may still have on your tpl_product_info_display.php
3. Install the Ultimate Cross Sell application

[weljkodj]

Thanks a lot ultimate_zc,

Somehow I inserted the code below the </div>, instead of above.

[ekon79]

Hi,

I installed this mod, and followed the instructions exactly to the point, but when I try to link product 5,6 and then go to the Shopping cart and on purpose buy product 5, I don't get any centerboxes crosselling for product 6. Also, the footer disappeared....

any thoughts?

Thanks