Just another Cross-Sell mod (support thread)

[mmwilcox]

Can you give me an example of it used on your site? All changes are made using the admin >> configuration >> cross sell to tell how many products are show and all layout changes are made by editing the css file in the css folder in your_template..

I will help you with the css if you like. Just need the page and what your desired look will be.

I think I got it. I looked at the css and experimented a bit and found I could widen the scroll box. Can't get too big or it overlaps the sideboxes. That's easy enough to avoid.

Thanks again for this mod. Matt
Here's an example of my usage: 69003

[batteryman]

I think I got it. I looked at the css and experimented a bit and found I could widen the scroll box. Can't get too big or it overlaps the sideboxes. That's easy enough to avoid.

Thanks again for this mod. Matt
Here's an example of my usage: 69003

A couple of suggestions....

...in stylesheet_ORIGINAL.css (line 514)
.centerBoxWrapper
border:0 solid #9A9A9A; <-----Hides Border around Cross Sell Box to shown value
height:1%;
margin:1.1em 0;
}


...in stylesheet_xsell_scroll.css (line 8)

#crossSellDiv {styleshe...croll.css
margin:0 auto;
overflow-x:hidden;
padding:0;
position:relative;
width:1200px; <-------Change here for width to shown value
}


<div id="crossSellScroll" style="display: block; width: 1200px;">
Remove the Width you set in the div shown above. This way you don't have to edit code, only CSS.

You really should set the width of your page to be a specific value for the module to be displayed correctly. That way you can set a width for it and it will always appear the same in any browser and resolution for the most part. Most people are using 1024x768 so I personally set my site to be displayed at 1000px. Zencarts default is 800px.

[llynix]

Just installed. Everything went fine but I'd like to add the following notes:

For step 3 in the installation instructions.. might one be able to change the extension of the two sample files so as to avoid override problems? These files seem a little silly and redundant anyway considering the lines needed are present in the installation instructions.

For step 5 the full path of tpl_product_info_display.php would be useful.
/includes/templates/YOUR_TEMPLATE/templates/

It would be nice if you included a step 7. Go to admin->tools->module manager
and install the module. The cross sell mod causes db errors if you omit this step.

Also is there a reason why configuration says Cross Sell while catalog says Advanced Cross Sell. The different names could be misleading.

Just my nitpicks...
Anthony

[belaze]

Hi,
I am having a bit of problem with this mod, I uploaded all the files into their rightful folders and edited the required files...

When I go to the admin section I don't see "Admin->configuration->cross sell".

I do see: "Admin->Catalog->Advanced Cross-Sell" but with errors...ex:
Product Cross-Sell applies to:
Product XSELL_FORM_INPUT_TYPE(s):

Any help would be greatly appreciated.

Thanks much,
Dario

[AATECH]

Hi,
I am having a bit of problem with this mod, I uploaded all the files into their rightful folders and edited the required files...

When I go to the admin section I don't see "Admin->configuration->cross sell".

I do see: "Admin->Catalog->Advanced Cross-Sell" but with errors...ex:
Product Cross-Sell applies to:
Product XSELL_FORM_INPUT_TYPE(s):

Any help would be greatly appreciated.

Thanks much,
Dario

We are having the same problem...
What shows in the admin section is:

Product XSELL_FORM_INPUT_TYPE(s):

We checked all the Language files and everything is there???
See attached Photo...

Thank you all in advance..

[AATECH]

We are having the same problem...
What shows in the admin section is:

Product XSELL_FORM_INPUT_TYPE(s):

We checked all the Language files and everything is there???
See attached Photo...

Thank you all in advance..

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

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

[urbanfoodie]

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

You absolute super star - thank you, thank you, it really helps!

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