Just another Cross-Sell mod (support thread)

[yellow1912]

try:

INSERT INTO zen_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Cross-Sell - Display prices?', 'XSELL_DISPLAY_PRICE', 'false', 'Cross-Sell -- Do you want to display the product prices too?
Default: false', 18, 72, 'zen_cfg_select_option(array(true,false), ', now());

[trishac]

Agh, I could kiss you! Thanks so much! This fixed it beautifully! I really appreciate your great information!!!!

[jerrytkc]

Hi yellow,

I have try to install "Cross Sell" mod for quite some time but failed
Admin part seen to be ok, but nothing showing in the product part.

Is there because the "Cross Sell" mod is for 1.3.0 and I am using 1.3.7, will this be a issue?

Jerry

[yellow1912]

Hi yellow,

I have try to install "Cross Sell" mod for quite some time but failed
Admin part seen to be ok, but nothing showing in the product part.

Is there because the "Cross Sell" mod is for 1.3.0 and I am using 1.3.7, will this be a issue?

Jerry

It should work fine for 1.3.7
Check if you edited the right files. You should edit the files in your includes/templates/name_of_the_template_you_use/

Sometimes ppl edited files in their default folder,

[jerrytkc]

follow to the install guide by cross sales,

1. Using the Admin->Tools->Install SQL Patch, run the included SQL file (products_xsell.sql)
Result : I done this.

2. Make sure to change the name of the following directories (from the ZIP) to match your template name:
/includes/modules/YOUR_TEMPLATE
/includes/templates/YOUR_TEMPLATE
/includes/languages/english/YOUR_TEMPLATE
Result:
I change the folder name to "classic" since that I am using the default template given by zencart
/includes/modules/classic
/includes/templates/classic
/includes/languages/english/classic

3. Upload all supplied files in their approporiate folder structure... EXCEPT for the following:
/includes/templates/YOUR_TEMPLATE/templates/SAMPLE_ADDITION_TO_tpl_product_info_display_TEMPLATE_FILE.php
/includes/languages/english/YOUR_TEMPLATE/SAMPLE_ADDITIONS_TO_product_info_LANGUAGE_FILE.php
If you upload these example files, you may encounter template error messages due to the way overrides grab files.

(Do not upload the install.txt or products_xsell.sql files, as they are not needed on the server.)
Result: I uploaded the file, of cause without the "SAMPLE_..."

4. Open includes/languages/english/product_info.php
or includes/languages/english/YOUR_TEMPLATE/product_info.php
and add:
define('TEXT_XSELL_PRODUCTS', 'We Also Recommend :');
just above the final ?> and save it into includes/languages/english/YOUR_TEMPLATE/product_info.php

The SAMPLE_ADDITIONS_TO_product_info_LANGUAGE_FILE.php can be used for this by copying its contents into product_info.php
Result: I edited the includes/languages/english/product_info.php then save it into includes/languages/english/classic/product_info.php

5. Now edit your product-info template file (tpl_product_info_display.php) and insert the following code
at the point where you wish the Cross-Sell box to appear. Usually best at the end of the file:
---------------------------------
<?php
require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');
?>
Result:I add the require code at the bottom of tpl_product_info_display.php to the uploaded file in the /includes/templates/classic


Finally I add cross sales in Admin->Catalog->Cross Sell, when I check in the product page nothing is show except the original product.

Anything wrong with my configuration/steps?

[yellow1912]

Can you send me a link to your site? And to that specific product that you crossed sell.

BTW, make sure that you turn on cross sale in the admin panel as well. (change the min Display Cross-Sell Products to 1)

[jerrytkc]

I have send a PM to you on my site link, FTP user and pwd

[yellow1912]

I installed Cross sell and Just another Cross-Sell mods on the sample site you gave me. Check it.

[jerrytkc]

I installed Cross sell and Just another Cross-Sell mods on the sample site you gave me. Check it.

Great, it work!

Thanks yellow,

[makenoiz]

Hello . We have cross sell already installed so All i did was upload the files then try to run the SQL patch. According to the read me. But the sqil file throws this error:

SQL query: Documentation

SELECT (
@t4 := configuration_group_id
) AS t4
FROM configuration_group
WHERE configuration_group_title = 'Cross Sell';

MySQL said: Documentation
#1146 - Table 'croptcom_zencart.configuration_group' doesn't exist


...all my tables start with zen_ . Can you please tell me what to modify in the query?

Thanks