Ultimate Cross Sell [Support Thread]

ultimate_zc:

Features:

• Centerboxes for Upsell, Cross Sell and Related Products.

• Enable and Disable individual Centerboxes from the admin.

• Also Purchased Products Centerbox on Shopping Cart.

• Cross Sell Products Centerbox on Shopping Cart.

I would like to have just the up-sell box on the product information page and just the cross-sell box (and possibly the related-products and also-purchased boxes) on the cart page. Can anyone suggest code changes to accomplish that?

novastar:

Nice contribution but how do you actually link products for cross sell. This is my first cross sell mod and I can't seem to figure out the Catalog-> UCS page.

In order to link your products, simply go to** Admin > Catalog > Ultimate Cross Sell**. At the top, choose which Table to edit from the dropdown:
1 = Cross Sell,
2 = Up Sell,
3 = Related Products

Below on the same page under New Cross Sell > Cross Sell applies to: > Product id(s), enter two product IDs separated by a comma and click on the "insert" button. You should see a message at the top of the page indicating that the product was sucessfully added to the database. You can click on the "Current Cross Sell" link on the right to see the products that are currently on the database.

Note: By default, when entering products using any of the 3 tables, you'll utilize the format "product id" "comma" "product id" i.e 12,21.

If you would like to change it to a preference of your choice, go to Admin > Configuration > Ultimate Cross Sell Settings and change options 3. Ultimate Cross Sell Input Type To Be Used In Form and 4. Ultimate Cross Sell Product Input Separator.

Incidentally, in order to display your Cross Sell products on your product page, choose option* 5. Display Ultimate Cross Sells on Product Page* and make your changes.

Choose to use cross sell centerbox to be displayed on the product page.

1. Cross Sell
2. Up Sell
3. Related Products
4. ALL

You can also choose the sideboxes method by going to** Admin > Tools > Layout Boxes Controller** and adjusting the settings to your preference for the following sideboxes:

1. sideboxes/YOUR_TEMPLATE/related.php
2. sideboxes/YOUR_TEMPLATE/up_sell.php
3. sideboxes/YOUR_TEMPLATE/cross_sell.php

Thank you very much for this module!

Currently, when a customer clicks the Buy Now button in the center box or side box on product pages, the product is added to their cart, but they are re-directed to a page that says "Sorry, the product was not found." Is there a way to fix this?

mretzloff:

Currently, when a customer clicks the Buy Now button in the center box or side box on product pages, the product is added to their cart, but they are re-directed to a page that says "Sorry, the product was not found." Is there a way to fix this?

There sure is. It's called test, test, test then test some more! (Lesson Learned)

:oops:
I apologize for any inconvenience. I just uploaded a new version to the Downloads page since I had to update four files to correct the problem you were experiencing.

1. Bug Fix - Corrected improper code on the Related Products Sidebox.
2. Added Instructions on How To Use.
3. Bug Fix - Corrected improper redirect which resulted on message "Sorry, the product was not found." after clicking on the "Buy Now" button when Admin > Configuration > My Store > Display Cart After Adding Product was set to false, to redirtect to same Product Info page.

Ok, thank you. Just to make sure, the one you linked to is the latest version, correct? I am asking because it says it was last updated on December 27.

The link I posted directs you to the actual contribution page. When contributions are updated they are posted in the same page. It is a little too early for the Zen Cart Team to have reviewed it yet.

Ok, I will just wait then. Thank you for the help!

I got your e-mail and installed the new module. It works now. Thank you again for the awesome module.

Version 1.2 is available for Download

1. Bug Fix - Corrected improper code on the Related Products Sidebox.
2. Added Instructions on How To Use.
3. Bug Fix - Corrected improper redirect which resulted on message "Sorry, the product was not found." after clicking on the "Buy Now" button when Admin _ Configuration _ My Store _ Display Cart After Adding Product was set to false, to redirtect to same Product Info page.

Click Here for the Download Page

Is there a way to alter the code to have it cross sell by category instead of individual products?

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

Got it sorted

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']

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.

Hi, i have just installed this mod, it is amazing and works perfectly :smile:, 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 :smile:

DarkEmotions:

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);

weljkodj:

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.

Paul...the...first:

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

Thanks a lot ultimate_zc,

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

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