Just another Cross-Sell mod (support thread)

[belaze]

Never mind... It looks like 1.SQL was never ran with the Module Manager... So I ran it in the Admin Sql

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Cross Sell';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'Cross Sell', 'Set Cross Sell Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

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


UPDATE configuration SET configuration_group_id = @t4 WHERE configuration_key IN ('MIN_DISPLAY_XSELL','MAX_DISPLAY_XSELL','SHOW_PRODUCT_INFO_COLUMNS_XSELL_PRODUC TS','XSELL_DISPLAY_PRICE');

INSERT INTO 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
('', 'Input type to be used in form', 'XSELL_FORM_INPUT_TYPE', 'model', 'Choose to use product ID or MODEL as your input type. Check readme file for more info', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\'),');

INSERT INTO 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
('', 'XSell Product Input Separator', 'XSELL_PRODUCT_INPUT_SEPARATOR', ',', 'You will need to insert all product id/model you want to cross-sell in 1 field, so each product id/model needs to be separated by a separator. The default is comma, choose another if you want to', @t4, 1, NOW(), NOW(), NULL, NULL);

INSERT INTO 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
('', 'XSell Sort Order', 'XSELL_SORT_ORDER', 'sort_order', 'Sometimes you may want to display the xsell products randomly, especially if each product xsells with lots of others', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'sort_order\', \'random\'),');


Hope it helps someone...

THANKS MUCH...THAT WAS A BIGG HELP!
Now its working.

[masterrusty]

I have installed the MOD, and added some Cross Sell items.

The MOD appeared fine in the "Module Manager."

"Cross Sell" configuration settings work fine in the Configuration menu; and

The "Advanced Cross Sell" module seemed to work fine in the "Catalog" menu. I entered items, and received positive confirmation of the entries. I can even return to the Module and edit the cross sell items.

My problem is that the items are not showing up on the product pages.

Here is the a link to one of the products.
http://riversidelandsale.com/index.p...oducts_id=4292

[dharma]

Again thank you for this fantastic contribution!

I wanted to suggest, perhaps in a future version the ability to cross sell on the shopping cart page.

[batteryman]

Again thank you for this fantastic contribution!

I wanted to suggest, perhaps in a future version the ability to cross sell on the shopping cart page.

To do this it really easy... 2 steps which are already outlined in his install instructions.. I will display all instructions to help show you..

=========================
INSTALLATION INSTRUCTIONS
=========================

BACK UP BACK UP BACK UP

1. This module needs another module called module_manager to operate properly.
http://code.google.com/p/zencart-mod...downloads/list

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

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

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

4.b. - Repeat step 4 for each of the other product types you intend to use (ie: product_music_info, document_general_info, etc).

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');
?>
-------------------------------
The SAMPLE_ADDITION_TO_tpl_product_info_display_TEMPLATE_FILE.php contains this same code, and you can copy/paste
from that file into your customized tpl_product_info_display.php

5.b. Repeat step 5 for any other product types for which you wish to enable cross-sell display.
(ie: tpl_product_music_info_display.php, etc)

6. Upload your changes from step 4 / 4.b and step 5 / 5.b to your server.


Installation done.

I highlighted the two steps that we are repeating to accomplish this for the shopping cart page

Step 4
Paste this code:

define('TEXT_XSELL_PRODUCTS', 'We Also Recommend :');

into this file, changing YOUR_TEMPLATE to your own of course:

/includes/languages/english/YOUR_TEMPLATE/shopping_cart.php

Step 5.
Paste this code:

<?php
require($template->get_template_dir('tpl_modules_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_xsell_products.php');
?>

into this file, changing YOUR_TEMPLATE to your own of course:

/includes/templates/YOUR_TEMPLATE/templates/tpl_shopping_cart_default.php

Thats it and now you have you Cross Sell on the Shopping Cart Page. The only thing is make sure you place the Step 5 code into a section on the tpl_shopping_cart_default.php that is not a long if statement that is broken up by several php tags. Not sure what that is called, But dont do it.

[dharma]

Thanks for the info!

I gave it a shot, and this method works, but on my cart it requires the old upsell/xsell mod (Merlin 2006) to work...do you have that installed too? or just the code above with yacsm?

and are cross sell items on the shopping cart page limited only to 3 columns max? mine appear to be spaced for 4 but maxed out at 3 (no matter what I change in admin, cart_upsell.php settings or css

[batteryman]

I only have the current version of Advanced Cross Sell.. However I use a modified version of it which I use Jquery with to give it the product the ability to slide if there are more than the min.

You can see how I use it on my site at http://biaf.com/?i=4413

[autoace]

Hello:

I am about to install this addon; Cross Sell - Just Another Cross Sell Mod version: rev186 and have one question.

Do I need to run the the SQL command given in the installation instructions. I do not have rev185 installed, this will be my first installation of this addon.

I do have module mananger installed.

Thank you.

[autoace]

Hi,

It seems that I have installed Cross Sell - Just Another Cross Sell Mod successfully! Cross Sell does show in my Config Menu and and when I clicked to install new modules in my Module Manager, it successfully processed the SQL commands.

Further, when I clicked on 'List all modules" this came up:

2 ri_jaxs 1 Revision 185 update

My only question is that I thought that I had installed rev186? Is that where the SQL command in the instructions comes into play? Do I need to run that SQL command to have rev186 working?

Thanks in advance.

[masterrusty]

I have installed the MOD, and added some Cross Sell items.

The MOD appeared fine in the "Module Manager."

"Cross Sell" configuration settings work fine in the Configuration menu; and

The "Advanced Cross Sell" module seemed to work fine in the "Catalog" menu. I entered items, and received positive confirmation of the entries. I can even return to the Module and edit the cross sell items.

My problem is that the items are not showing up on the product pages.

Here is the a link to one of the products.
http://riversidelandsale.com/index.p...oducts_id=4292

I just wanted to add that I made the changes to the template files. But this mod still does not show up on the live site.

[masterrusty]

Ok. So after a little more research, and modifications, I have the cross sell items showing with the products.

However the "We also Recommend" verbiage is located a little high, and to the right. I added some <br>'s to the "TEXT_XSELL_PRODUCTS" line in the product _info.php file, and tried to add an <align="left"> as well.

This caused the verbiage to drop down, but it did not move it to the left. How can I get it to the left side of the center box wrapper?