Zen Cart Logo

Cross Sell

Locked

Views: 36,673

Results 41 to 60 of 131
This thread is locked. New replies are disabled.
4 Jul 2006, 12:21 PM
#41
simon_m avatar

simon_m

New Zenner

Join Date:
Jan 2006
Posts:
71
Plugin Contributions:
0

Cross Sell

what if any part have you got working?

what Warning are you geting?

may need to unistall all files and start a fresh?

simon

Zen Cart:1.3.0.2
MySQL:4.1.19-standard
Linux:2.6.14.2-ts.grh.mh.ht
PHP Version:4.4.2

4 Jul 2006, 12:25 PM
#42
simon_m avatar

simon_m

New Zenner

Join Date:
Jan 2006
Posts:
71
Plugin Contributions:
0

Re: Cross Sell

also are you on a test shop?

or

a LIVE SHOP?

CAN YOU LOOK IN TO UPGRADING TO v1.3.0.2 AS THIS MAY BE WHY IT WORKS FOR ME AND NOT YOU.

SIMON

Zen Cart:1.3.0.2
MySQL:4.1.19-standard
Linux:2.6.14.2-ts.grh.mh.ht
PHP Version:4.4.2

4 Jul 2006, 1:16 PM
#43
meemster avatar

meemster

New Zenner

Join Date:
Jul 2006
Location:
London, UK
Posts:
11
Plugin Contributions:
0

Re: Cross Sell

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

simon-m:

what if any part have you got working?

what Warning are you geting?

may need to unistall all files and start a fresh?

simon

4 Jul 2006, 4:05 PM
#44
simon_m avatar

simon_m

New Zenner

Join Date:
Jan 2006
Posts:
71
Plugin Contributions:
0

Re: Cross Sell

meemster:

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

it is now to look all of the incuded files in the mod inside for xsell.php to xsell_products.php or
i will look at it tonight and post it then.

simon

Zen Cart:1.3.0.2
MySQL:4.1.19-standard
Linux:2.6.14.2-ts.grh.mh.ht
PHP Version:4.4.2

4 Jul 2006, 5:17 PM
#45
simon_m avatar

simon_m

New Zenner

Join Date:
Jan 2006
Posts:
71
Plugin Contributions:
0

Re: Cross Sell

meemster:

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

Zen Cart:1.3.0.2
MySQL:4.1.19-standard
Linux:2.6.14.2-ts.grh.mh.ht
PHP Version:4.4.2

26 Jul 2006, 6:48 PM
#46
gapi78 avatar

gapi78

New Zenner

Join Date:
Jan 2006
Location:
Slovenia
Posts:
30
Plugin Contributions:
0

Re: Cross Sell

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?

26 Jul 2006, 11:02 PM
#47
voltage avatar

voltage

Totally Zenned

Join Date:
Apr 2005
Location:
Houston, TX
Posts:
1,356
Plugin Contributions:
1

Re: Cross Sell

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.

28 Jul 2006, 10:51 AM
#48
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Cross Sell

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

28 Jul 2006, 12:08 PM
#49
zapisto avatar

zapisto

Zen Follower

Join Date:
Aug 2005
Posts:
163
Plugin Contributions:
0

Re: Cross Sell

Woodymon:

  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

28 Jul 2006, 9:03 PM
#50
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Cross Sell

Zapisto:

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.

28 Jul 2006, 11:48 PM
#51
woodymon avatar

woodymon

Totally Zenned

Join Date:
Sep 2004
Posts:
2,309
Plugin Contributions:
1

Re: Cross Sell

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

30 Jul 2006, 6:27 PM
#52
designbydemeter avatar

designbydemeter

Zen Follower

Join Date:
Jun 2006
Location:
Taos,NM
Posts:
225
Plugin Contributions:
0

Re: Cross Sell

Vixay:

http://www.zen-cart.com/forum/showpost.php?p=209627&postcount=2

> 
> I made a modification to cross-sell that allows you to list products with the same model #  (rather than having to setup an entired table).. see above link for my post.
> 
> it is a very small change to the SQL Query...
> 
> maybe some moderator should merge that post here?

I have one request further - could it be possible to sort by the header you click on, namely ID#, Category, Alpha, etc. The d/b by ID# is pretty useless to me as I would never memorize product that way.

Thanx!

Laura M Collins Invitation Designs

"The best way to navigate in a new area is to first get totally lost in it."...Mike L. Stein

9 Aug 2006, 1:20 PM
#53
hertspool avatar

hertspool

New Zenner

Join Date:
Aug 2006
Posts:
16
Plugin Contributions:
0

Re: Cross Sell

Looks like an awesome tool. Do I need to change the sql from
CREATE TABLE products_xsell (....
to CREATE TABLE zen_products_xsell (....
and
INSERT INTO configuration (configuration_title...
to
INSERT INTO zen_configuration (configuration_title...
as my tables all have zen_

Thanks

9 Aug 2006, 2:05 PM
#54
hertspool avatar

hertspool

New Zenner

Join Date:
Aug 2006
Posts:
16
Plugin Contributions:
0

Re: Cross Sell

Everything installed fine. I didn't need to add zen_ to the sql file
Works like a dream. Thanks for the posts on here as well. No problems encountered.

22 Aug 2006, 1:07 PM
#55
kookiewookie avatar

kookiewookie

New Zenner

Join Date:
Jun 2006
Posts:
75
Plugin Contributions:
0

Re: Cross Sell

I have a problem with the Crosssell contri.

Have a product and add as crosssell product Giftcertificates.
I have Giftcertificates setup as one product with 10 attributes ( giftceet. values )...
but when i go to the frontend of the shop, clikc the product only the first price attribute of the Giftcertificate shows selected. The rest is not diplayed at all.

Anyone an idea?

Thanks!

22 Aug 2006, 1:24 PM
#56
kookiewookie avatar

kookiewookie

New Zenner

Join Date:
Jun 2006
Posts:
75
Plugin Contributions:
0

Re: Cross Sell

kookiewookie:

I have a problem with the Crosssell contri.

Have a product and add as crosssell product Giftcertificates.
I have Giftcertificates setup as one product with 10 attributes ( giftceet. values )...
but when i go to the frontend of the shop, clikc the product only the first price attribute of the Giftcertificate shows selected. The rest is not diplayed at all.

Anyone an idea?

Thanks!

Just "stupid" .... you have the MultiSelect option to select all the attributes from the GiftCert..... there was selected only 1.

26 Aug 2006, 4:32 PM
#57
reza avatar

reza

Zen Follower

Join Date:
Aug 2006
Posts:
166
Plugin Contributions:
0

Re: Cross Sell

ididdy:

Cross-Sell (X-Sell) Admin will not load the next page of data when you select a page # or hit the >>. It reloads Page 1 only. We just installed cross_sell_v1.3.0 on Zen-Cart 1.3.0.

Any help is appreiated.
I have also the same problem in loading the next page with x sell.
i also had a problem, I could not put the sql patch into the zen database, because she says the database is already exist or some error in accepting the queries like this. besides this x sell works.

add switches for: MIN_DISPLAY_XSELL, MAX_DISPLAY_XSELL

INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added )
VALUES (

'Display Cross-Sell Products', 'MIN_DISPLAY_XSELL', 1, 'This is the minimum number of configured Cross-Sell products required in order to cause the Cross Sell information to be displayed.<br />Default: 1', 2, 17, now( )

please any idae to soving these two problem; pages and sql?

12 Sep 2006, 4:09 PM
#59
davale avatar

davale

Zen Follower

Join Date:
Apr 2006
Posts:
117
Plugin Contributions:
0

Re: Cross Sell

Does Cross Sell 1.3.0. work with ZC 1.3.5?

13 Sep 2006, 9:30 AM
#60
reza avatar

reza

Zen Follower

Join Date:
Aug 2006
Posts:
166
Plugin Contributions:
0

Re: Cross Sell

davale:

Does Cross Sell 1.3.0. work with ZC 1.3.5?
yes, I have installed on 1.3.5, it seems to work, but the problem of not loading the pages in admin still remains,
apart this, i can see cross products under selected product.