Ultimate Cross Sell [Support Thread]

This Contribution is a combination/modification of several others in order to include with one installation three separate centerboxes to display your store's upsell, cross sell and related products along with their sideboxes to give you more flexibility with the look of your store. In addition, a Cross Sell on Shopping Cart and a Also Purchased Products are included.

Features:

• Centerboxes for Upsell, Cross Sell and Related Products.
• Display the Products Name.
• Display the Products Model Number.
• Display the Products Buy Now / More Info Link.
• Enable, Disable and Remove this module from the admin.
• Enable and Disable individual Centerboxes from the admin.
• Also Purchased Products Centerbox on Shopping Cart.
• Cross Sell Products Centerbox on Shopping Cart.
• Sideboxes for Upsell, Cross Sell and Related Products.

Click here to download

Hello,
I installed your mod, the admin part works perfectly, but when I go to view what's in my shopping cart, this is what I get

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, ' at line 13
in:
[(select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, zen_products p, zen_products_description pd where xp.products_id = '79' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by rand() limit 6) UNION (select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, zen_products p, zen_products_description pd where xp.products_id = '81' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by rand() limit 6)(select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, zen_products p, zen_products_description pd where xp.products_id = '79' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by rand() limit 6) UNION (select p.products_id, p.products_image from zen_ultimate_cross_sell_1 xp, zen_products p, zen_products_description pd where xp.products_id = '81' and xp.cross_sell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 order by rand() limit 6)]

Hello artistcsi,

I have tried recreating the problem that you are experiencing. The only way I can do so it's by giving the option "Cross Sell - Display Products - Max" a negative value but that is not your case.

I noticed that you have a table prefix on your installation and it appears to have mixed settings. Click Here

Looking at the forum I found the following two threads that might be able to help, 1064 You have an error in your SQL syntax: "limit -3" and Unknown error in SQL syntax.

I know it's not much help. I'll continue searching for a much more better answer.:mellow:

ultimate_zc:

Hello artistcsi,

I have tried recreating the problem that you are experiencing. The only way I can do so it's by giving the option "Cross Sell - Display Products - Max" a negative value but that is not your case.

I noticed that you have a table prefix on your installation and it appears to have mixed settings. Click Here

Looking at the forum I found the following two threads that might be able to help, 1064 You have an error in your SQL syntax: "limit -3" and Unknown error in SQL syntax.

I know it's not much help. I'll continue searching for a much more better answer.:mellow:

Thanks for the quick reply.
I fixed it!
I had a couple of the other mods installed, cross sell and upsell/crosssell or something like that so I figured something wasn't playing nice between them. I uninstalled all files that were associated with the other two cross sells, being careful NOT to uninstall the ones that Ult cross sell shared with them, re-examined my tpl_product_info_display file and now I am good to go.

It not only looks great, but it works just like you said that it would. :clap:

I installed the Ultimate Cross Sell for Zen Cart and I am not seeing the new layout boxes in the layout boxes controller. I'm using the 1.3.9h version.

The site is westcoastdogbeds.com

Thanks.

screamingfingers:

I installed the Ultimate Cross Sell for Zen Cart and I am not seeing the new layout boxes in the layout boxes controller. I'm using the 1.3.9h version.

The site is westcoastdogbeds.com

Thanks.

I am having the same problem.

My apologies for the late response. I have just spent two days trying to get rid of a virus that infected my computer.

The "Utlimate Cross Sell for Zen Cart" contribution utilizes the template override system. The download contains the following files:
includes\modules\sideboxes\YOUR_TEMPLATE\cross_sell.php
includes\modules\sideboxes\YOUR_TEMPLATE\related.php
includes\modules\sideboxes\YOUR_TEMPLATE\up_sell.php

If loaded properly, these files should be displayed under your Admin > Tools > Layout boxes Controller, regardless of template. With that being said, once you adjust the settings to your preference, you should see the sideboxes in your store, providing that you have changed the "YOUR_TEMPLATE" folder name to match that of your current template.

There are 17 files contained among five folders which are dependant upon the folder's name being properly changed to that of the current store.

Please verify whether you have/have not uploaded all neccessary files to your website and make tha appropriate changes.

includes\languages\english\extra_definitions\YOUR_TEMPLATE\
includes\modules\sideboxes\YOUR_TEMPLATE
includes\modules\YOUR_TEMPLATE\
includes\templates\YOUR_TEMPLATE\css\
includes\templates\YOUR_TEMPLATE\

Hi ultimate_zc,

Thanks for the module, it looks very promising and gets points for it's all-in-one functionality.

I'm having a problem with my admin area. I've uploaded all the files and triple-checked to make sure all are in place.

After I upload the files and go to log into my admin, I get a blank screen (we call it the White Screen of Death in Drupal :blink:)

I wanted to try to narrow down which file was causing the issue and I think I have. When I remove
/myadmin/includes/functions/extra_functions/ultimate_cross_sell.php, my admin area magically reappears. When I re-upload this file, I get the white screen again. Now that I don't have ../extra_functions/ultimate_cross_sell.php uploaded the server, it looks like I can go ahead and install this mod from the admin area, but obviously I don't want to do this without all the files being ready to go on the server!

I had previously installed Multi Cross Sell, but unistalled/disabled it, and running the SQL page that you include in your documentation results in a message that the table "new address book" does not exist.

Can you offer any insight or perhaps a patch for this problem? I'm running ZC v1.3.9h.


Thanks!
Catherine

Please take a look at artistcsi's possible solution for your problem.

artistcsi:

I had a couple of the other mods installed, cross sell and upsell/crosssell or something like that so I figured something wasn't playing nice between them. I uninstalled all files that were associated with the other two cross sells, being careful NOT to uninstall the ones that Ult cross sell shared with them, re-examined my tpl_product_info_display file and now I am good to go.

Make sure any prior cross sell mods files are deleted. Also, if you could, please post any other mods you have installed and any cache/myDEBUG-xxxxxxxx-xxxxx.log message. Doing so would give me a better understanding of the error you are experiencing. :huh:

Thanks

Hi ultimate_zc,

Thanks for getting back to me. And you solved my problem! I had not removed all of the old files from the Multi Cross Sell module I had previously installed, and something in there must have been causing conflicts. Now that I have your mod installed, I can see how similar they are, so it makes sense. Looking forward to getting this configured today! Thanks for the speedy support. :clap:

All the best,
CG

There are so many cross sell modules, for those who have tried others and are now using this mod (ultimate cross sell), how do you say this mod compares?

Thank you for your great module, ultimate_zc. My problem is the words such as Cross sell, UpSell, Related Products and Main Product in the admin menu cannot be defined to other language. How to correct this problem?

Thank you.

icemanchai:

My problem is the words such as Cross sell, UpSell, Related Products and Main Product in the admin menu cannot be defined to other language. How to correct this problem?

I'm not very familiar with the language packs. Perhaps downloading and installing one of the language packs for the admin might give you an idea of how to create the files you need for the language of your interest.

I will make an assumption here and say that once your admin language pack is installed, copy these files,

YOUR_ADMIN\includes\languages\english\ultimate_cross_sell.php and YOUR_ADMIN\includes\languages\english\extra_definitions\ultimate_cross_sell_definitions.php

and place them in,

YOUR_ADMIN\includes\languages\YOUR_LANGUAGE\ultimate_cross_sell.php and YOUR_ADMIN\includes\languages\YOUR_LANGUAGE\extra_definitions\ultimate_cross_sell_definitions.php

Once in the new language folder of your choice, you should be able to make the changes that you need.

In other words, line 33 on YOUR_ADMIN\includes\languages\YOUR_LANGUAGE\extra_definitions\ultimate_cross_sell_definitions.php you see the following:

[PHP]define('CATALOG_TEXT_CROSS_SELL_PRODUCT_NAME', 'Product Name: ');[/PHP]

go to the Google Translate website (click here), copy and paste the second portion of that line "Product Name: " select the language of your choice from the drop menu and click translate.

In the above example, if translating to French, the result would be:

[PHP]define('CATALOG_TEXT_CROSS_SELL_PRODUCT_NAME', 'Nom du produit: ');[/PHP]

DO NOT CHANGE THE ALL CAPS PORTION

You might also want to search the forum for threads related to languages in the Admin section. This page Language Files - What are they and how are they used? might also be of some help.

I hope I was able to answer your question.

Thank you for your quick reply, ultimate_zc. Actually, I already did what you said but I cannot find any define statements related to the words "Cross Sell", "UpSell", "Related Products" and "Main Product" in the language files of admin menu. That is why I request for help.

Now I discovered that a term called "$mxs_selected_table" in admin/includes/functions/extra_function/ultimate_cross_sell.php (line 281)

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

and

a term called "$main_product" in admin/ultimate_cross_sell.php (line 262)

<input type="checkbox" name="cross_sell_one_way" value="1" onclick="return add_remove_main_product_field(cross_sell_one_way,'<?php echo $main_product; ?>');" /><?php echo $mxs_selected_table . CATALOG_TEXT_CROSS_SELL_ONE_WAY; ?>

should related to the words I has mentioned. Could you know how to turn these "$mxs_selected_table" and "$main_product" into define statements in admin language files?

Thank you.

The text "1 = Cross Sell, 2 = Up Sell, 3 = Related Products" found at the top, next to the dropdown on Admin > Catalog > Ultimate Cross Sell can be replaced by changing line 15 on the file YOUR_ADMIN_FOLDER\includes\languages\englisg\extra_definitions\ultimate_cross_sell.php

[PHP]define('CATALOG_TEXT_DEFINE_TABLES', '  <strong>1 = Cross Sell, 2 = Up Sell, 3 = Related Products</strong>');[/PHP]

In order to change the text that reads "Clean Up Fix to the Cross Sell", "New Fix to the Cross Sell", "Edit Fix to the Cross Sell", and "Current Fix to the Cross Sell", with "Cross Sell" being either Cross Sell, Up Sell and/or Related Products, you'll need to change the lines 193, 194 and 195 on YOUR_ADMIN_FOLDER\ultimate_cross_sell.php

[PHP] if ($mxs_table == '1') define($mxs_selected_table = 'Cross Sell', $mxs_selected_definition = CATALOG_TEXT_CROSS_SELL_CROSS_SELL_DEFINITION);
if ($mxs_table == '2') define($mxs_selected_table = 'Upsell', $mxs_selected_definition = CATALOG_TEXT_CROSS_SELL_UPSELL_DEFINITION);
if ($mxs_table == '3') define($mxs_selected_table = 'Related Products', $mxs_selected_definition = CATALOG_TEXT_CROSS_SELL_RELATED_DEFINITION);[/PHP]

In order to change the words Cross Sell, Upsell and Related as in Admin > Configuration > Ultimate Cross Sell Settings > Related - Display Products - Min, you'll need to:

1. Back Up your databse.
2. Go to Admin > Configuration > Ultimate Cross Sell and click uninstall and reinstall again. The products from your "database" should not suffer any loss or changes

As for the words "Main Product", there is no such term in the Ultimate Cross Sell with the same capitalization. The closest you can find is "Main product" on line 116 on YOUR_ADMIN_FOLDER\ultimate_cross_sell.php. Once again, any changes to take place on this file I just mentioned need to be done by installing and reinstalling the mod after you Back Up your files and database.

Thank you very much, ultimate_zc. You guided me to right direction. I successfully changed the words "Cross sell", "Upsell", "Related Products" and "Main product" to other language.

Now I found that a word "model" cannot be changed. So I

1. inserted after line 195 of admin/ultimate_cross_sell.php with

if (CROSS_SELL_FORM_INPUT_TYPE == "id") define(CROSS_SELL_INPUT_TYPE = CROSS_SELL_INPUT_TYPE_ID);
if (CROSS_SELL_FORM_INPUT_TYPE == "model") define(CROSS_SELL_INPUT_TYPE = CROSS_SELL_INPUT_TYPE_MODEL);

2. inserted in admin/includes/languages/english/extra_definitions/ultimate_cross_sell_definitions.php with

define('CROSS_SELL_INPUT_TYPE_ID', ' ID ');
define('CROSS_SELL_INPUT_TYPE_MODEL', 'Model');

3. in admin/includes/languages/english/ultimate_cross_sell.php,
replaced all
CROSS_SELL_FORM_INPUT_TYPE
to
CROSS_SELL_INPUT_TYPE

However, I got a blank page in admin menu. Could you guide me how to turn the word "model" to other language?

Thank you.

If you are referring to the words "Product Model" found on the table heading at Admin > Catalog > Ultimate Crodss Sell > List All... Change line 29 on YOUR_ADMIN\includes\languages\extra_definitions\ultimate_cross_sell_definitions.php

http://farm6.static.flickr.com/5004/5360629399_7ed50b556f.jpg

[PHP]define('CATALOG_TEXT_CROSS_SELL_MODEL', 'Product Model');[/PHP]

If however, you are referring to the word "Model" on Admin > Configuration > Ultimate Cross Sell Settings where it is displayed 6 times as in "Cross Sell - Display Model Number?" you'll need to uninstall, make changes to YOUR_ADMIN\includes\functions\extra_functions\ultimate_cross_sell.php on lines 309 and 324.

http://farm6.static.flickr.com/5244/5360655649_553b686a9b.jpg

[PHP] $db->Execute("INSERT INTO " . TABLE_CONFIGURATION . " (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES ('', '" . $mxs_selected_table . " - Display Model Number?', 'CROSS_SELL" . $num_cross_sell . "_DISPLAY_MODEL', 'true', 'Do you want to display the model number too?<br />Default: true', @t4, $offset+270, now(), now(), NULL, 'zen_cfg_select_option(array(\'true\',\'false\'),')");[/PHP]

[PHP] $db->Execute("INSERT INTO " . TABLE_CONFIGURATION . " (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES ('', '" . $mxs_selected_table . " - Sidebox Display Model Number?', 'CROSS_SELL" . $num_cross_sell . "_SIDEBOX_DISPLAY_MODEL', 'true', 'Do you want to display the model number too?<br />Default: true', @t4, $offset+303, now(), now(), NULL, 'zen_cfg_select_option(array(\'true\',\'false\'),')");[/PHP]

Once done with any changes reinstall. Again, your database should not experience any changes but it is always a good idea to back up your database prior to any changes.

Ultimate_zc, sorry for misleading. You can see in Admin > Catalog > Ultimate Cross Sell, the word "model" is in New Related Product and Edit Related Product. (Please check the attached file, the word "model" in two red circles). I cannot figure out how to change this word to other language.

Thank you for your affort.

I installed this mod and everything is great but when ever I navigate to the product info display page the footer and side-boxes disappear. Obviously a problem. any thoughts?

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.