Cross Sell

[simon-m]

this is the warning i get on each product page:

Warning: main(includes/modules/xsell_products.php): failed to open stream: No such file or directory in /var/www/html/store/includes/templates/Nasheeds/templates/tpl_modules_xsell_products.php on line 17

Warning: main(includes/modules/xsell_products.php): failed to open stream: No such file or directory in /var/www/html/store/includes/templates/Nasheeds/templates/tpl_modules_xsell_products.php on line 17

Warning: main(): Failed opening 'includes/modules/xsell_products.php' for inclusion (include_path='.:/php/includes:/usr/share/php:/usr/share/pear') in /var/www/html/store/includes/templates/Nasheeds/templates/tpl_modules_xsell_products.php on line 17

Admin side i can configure how many X-sell products i want + select them

did you upload 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 so remove them. this may do it?

if not uninstall all of xsell by removing all files and undoing all modified lines by follwing the install.txt step by step.

then do the following:

1) admin - xsell.pp to xsell_products.php

2) admin > extra_datafiles - xsell_definitions.php open and find and change this: define('FILENAME_XSELL_PRODUCTS', 'xsell.php'); to define('FILENAME_XSELL_PRODUCTS', 'xsell_PRODUCTS.php');

3) admin > languages > english - xsell.pp to xsell_products.php

4) then follow the install.txt

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

now need to do anythink with D/B that should be ok.

simon

[gapi78]

Hello,

i have succesfully installed this mod and it's ok, but i would like to have it displayed as a side box with at least 3 rows/products.
Does anyone know show to set it up like a side box which would only be show on product info page if there was any cross sell products active.

Thanks for you help?

[voltage]

There is a link in the stick thread named "Contribution Key" that goes to a cross sell sidebox mod. However, I was unable to get it work on my 1.3., but others have been successful.

[Woodymon]

Installing CrossSell posted in Downloads area on fresh 1.3.0.2 shop (PHP 4.4.2 and MySQL 4.1.19-standard)

Besides the three required repairs:

1. RENAME /admin/xsell.php
TO
/admin/xsell_products.php

2. RENAME /admin/includes/languages/english/xsell.php
TO
/admin/includes/languages/english/xsell_products.php

3. EDIT /admin/includes/extra_datafiles/xsell_definitions.php
change this: define('FILENAME_XSELL_PRODUCTS', 'xsell.php');
TO
define('FILENAME_XSELL_PRODUCTS', 'xsell_products.php');


I'm also observing error when running the last sql statement in products_xsell.sql

INSERT INTO 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());

Error report is:

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 'true','false'), ', now())' at line 1
in:

[INSERT INTO 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());]

I'm staring cross-eyed and cannot locate the issue.

OK I tried this below and it works....

INSERT INTO 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());

Unsure of the author whom uploaded the latest version CrossSell. Could someone be kind enough to apply the above fixes to the CrossSell package in the Zen Cart download area? Again these fixes were only tested on v.1.3.0.2. Thanks.

Woody

[Zapisto]

1. RENAME /admin/xsell.php
TO
/admin/xsell_products.php

2. RENAME /admin/includes/languages/english/xsell.php
TO
/admin/includes/languages/english/xsell_products.php

3. EDIT /admin/includes/extra_datafiles/xsell_definitions.php
change this: define('FILENAME_XSELL_PRODUCTS', 'xsell.php');
TO
define('FILENAME_XSELL_PRODUCTS', 'xsell_products.php');

Woody

Woody can you explain me why this rename ?
i cannot see a good reason beside the fact to better name the file ....
have this mode on my site and never do this change
everything is working great

[Woodymon]

can you explain me why this rename ?

I have not treaded through the code so I am unable to tell you why. The call to the admin page filename was not working before the define change. When I changed it worked fine.

[Woodymon]

I'm also observing error when running the last sql statement in products_xsell.sql

I tried this below and it works....

UPDATE: Not so fast with my sql statemnt fix.

Admin > Config >Product Info

Cross-Sell - Display prices?
Cross-Sell -- Do you want to display the product prices too?
Default: false

Appears correctly except that no radio buttons are rendered to allow change from true to false.

Looks like sql statment it is missing an matching closing parens. And will possibly need to escaping the apostrophes in the sql statment. First need to investigate how params are being passed to the function. Best to look at another True/False sql patch example. In the meantime if anyone has a quicker fix to the SQL code please post.

Woody

[mcpisik]

Wah...and ....boohoo

I have done all renames as suggested (i think), etc
But still come up with

Warning:  main(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.main on line ]: failed to open stream: No such file or directory in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17

Warning:  main(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.main on line ]: failed to open stream: No such file or directory in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17

Warning:  main() [function.include on line ]: Failed opening 'includes/modules/FILENAME_XSELL_PRODUCTS.php' for inclusion (include_path='.:/usr/share/pear') in /var/www/vhosts/partydudes.co.nz/httpdocs/includes/templates/theme014/templates/tpl_modules_xsell_products.php17 

Mod works fine in Admin, but just doesn't show on my site.
Somebody save me!

[jacque427]

When a customer places more than 12 items in their shopping cart the "Also Purchased" box at the bottom disappears and the following error message appears...

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 '-1)' at line 1
in:

[(select p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '265' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '268' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '270' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '283' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '292' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '521' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '307' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '314' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '363' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '367' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '365' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '344' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit 2) UNION (select 
p.products_id, p.products_image from products_xsell xp, products p, 
products_description pd where xp.products_id = '1229' and xp.xsell_id = 
p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and 
p.products_status = '1' order by xp.products_id asc limit -1)]

What's causing this?

ZC 1.3.7

Jacque