Cross-Sell Advanced!

Hello,

Thanks for the help...

I fixed this by editing the database directly in MySQL. Never did figure out the problem.

Phid:

Say, what would be the point of having both X-sells on at the same time?

I personally need both because some of my items have the same model number. The item titles are different though. But since Cross Sell Advanced looks the item up by model number, some of my products do not show up because there are several with the same model number. Had I known about Cross Sell Advanced from the beginning, I would've made sure they all had different model numbers because now I have to bounce back and forth between the regular version and the advanced version.

:smile:

Thanks a lot for this contribution :thumbsup:

I would like to have add to cart buttons on the cross sell products though, and I am wondering if somebody already has done that (hoping to save me some time ;-) ).

paulm:

Thanks a lot for this contribution :thumbsup:

I would like to have add to cart buttons on the cross sell products though, and I am wondering if somebody already has done that (hoping to save me some time ;-) ).

That would be fantastic. I never thought about that. Duh!

Parse error: syntax error, unexpected T_STRING in /home/airinfan/public_html/catalog/includes/languages/english/airinfan/product_info.php on line **1

**this is what i'm getting when i try to view an item, after i've linked it with another item.

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

is there a syntax error in this line that would cause this problem?

Sounds like space(s) or blank line(s) before the <?php of that file ...

no such luck. there are no spaces or lines before that.

What is on the first 10 lines?

<?php /** * @package languageDefines * @copyright Copyright 2003-2006 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * @version $Id: product_info.php 3159 2006-03-11 01:35:04Z drbyte $ */ define('TEXT_PRODUCT_NOT_FOUND', 'Sorry, the product was not found.'); define('TEXT_CURRENT_REVIEWS', 'Current Reviews:'); define('TEXT_MORE_INFORMATION', 'For more information, please visit this product\'s <a href="%s" target="_blank">webpage</a>.'); define('TEXT_DATE_ADDED', 'This product was added to our catalog on %s.'); define('TEXT_DATE_AVAILABLE', 'This product will be in stock on %s.'); define('TEXT_ALSO_PURCHASED_PRODUCTS', 'Customers who bought this product also purchased...'); define('TEXT_PRODUCT_OPTIONS', 'Please Choose: '); define('TEXT_PRODUCT_MANUFACTURER', 'Manufactured by: '); define('TEXT_PRODUCT_WEIGHT', 'Shipping Weight: '); define('TEXT_PRODUCT_QUANTITY', ' Units in Stock'); define('TEXT_PRODUCT_MODEL', 'Model: '); // previous next product define('PREV_NEXT_PRODUCT', 'Product '); define('PREV_NEXT_FROM', ' from '); define('IMAGE_BUTTON_PREVIOUS','Previous Item'); define('IMAGE_BUTTON_NEXT','Next Item'); define('IMAGE_BUTTON_RETURN_TO_PRODUCT_LIST','Back to Product List'); // missing products //define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s'); //define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products'); //define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected'); define('TEXT_ATTRIBUTES_PRICE_WAS',' [was: '); define('TEXT_ATTRIBUTE_IS_FREE',' now is: Free]'); define('TEXT_ONETIME_CHARGE_SYMBOL', ' *'); define('TEXT_ONETIME_CHARGE_DESCRIPTION', ' One time charges may apply'); define('TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK','Quantity Discounts Available'); define('ATTRIBUTES_QTY_PRICE_SYMBOL', zen_image(DIR_WS_TEMPLATE_ICONS . 'icon_status_green.gif', TEXT_ATTRIBUTES_QTY_PRICE_HELP_LINK, 10, 10) . ' '); ?>

that's the entire product_info.php file. it works fine as is, but when i add that one line it gives me that error when i try to view an item.

also when i try to add the third part of the sql file through the sql patcher it fails. but it seems like that third paragraph is not necessary for x-sell to work?

Where are you adding it?

What kind of TEXT editor are you using?

NOTE: editing via your Control Panel can cause issues ...

After editing it and saving ... if you open it up again do you see any odd characters in the top of the file?

i'm adding the line to the bottom right above the ?>. i was using notepad and it's worked fine until now, but i'm going to go try notepad+.

also is the 3rd paragraph in the sql file required for cross sell to work?

Does anyone have a URL I can look at to see how this Cross Sell works?

Crikey, I just visited jhosford's site and its been hacked: http://www.vtjewelry.net

I also get the following problem when i upload sql via admin

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());]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any ideas anyone?

I found another thread for this problem http://www.zen-cart.com/forum/showthread.php?t=51276&highlight=cross

I had the problem, noted in the above post, but then went ahead and uploaded files and it seemed to have worked, even though the zen sql upload said there was a problem?

so go ahead and upload files and test even if you get this error, probably still works.

i'm on 1.36 by the way

Hi All,

I have zen 1.2.6 installed and all works fine, I got a minor error in the SQL

Error

SQL query:

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

MySQL said: Documentation
#1062 - Duplicate entry 'MIN_DISPLAY_XSELL' for key 2

didnt seem to cause any real issues, however I can only get single columns in my layout, can anyone tell me if the above SQL is related or not ? or can someone help me to get the column mode working, I did have an old version of cross sell which i overwrote with the new version I download from this thread.

I have provided an example in graphic form to show that 3 poducts cross referenced with another product only displays in single column and not 3 columns per row which is my default. Also does anyone know how I can add a small graphic to the area where it says we also recommend.

any help on layouts would be appreciated.

I'd like to see Cross Sell in action. Can someone provide a URL (preferably that is a specific page with cross selling) for review?

creativearc:

I'd like to see Cross Sell in action. Can someone provide a URL (preferably that is a specific page with cross selling) for review?

I'm just now begining to enter the cross-sells. You can see it in action here. Look for the "We Also Recommend :" at the bottom of the page, that is the cross sell.

It's a Very impressive module. As mentioned in another thread it can be a bit cumbersome with many products but I feel that if it is implemented as you enter new products it won't be too bad. Just difficult when adding it to an existing store, as I am. All in all, it ROCKS! Thanks Tony, for putting out such an invaluble tool!

Tim

blackinches:

Parse error: syntax error, unexpected T_STRING in /home/airinfan/public_html/catalog/includes/languages/english/
airinfan/product_info.php on line **1

**this is what i'm getting when i try to view an item, after i've linked it with another item.

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

is there a syntax error in this line that would cause this problem?

Did anyone ever find out why this is happening? I have the same error when trying to view a page and I haven't even started cross-selling yet. I just installed everything and tried to view a couple of items I thought I might want to cross-sell. I have no idea how to fix this. There are no spaces at the beginning or end of my document, and there are no funky looking symbols either. I've edited in cpanel AND notepad. Help! My exact error is:
Parse error: parse error, unexpected T_STRING in /home/accave/public_html/includes/languages/english/custom_1/product_info.php on line 1

First off, I was looking at the wrong file. I was looking at tpl_product_info_display.php instead of the product_info.php. Human error is generally always in there somewhere! Second, however, once I looked at the right file, I noticed that instead of everything written properly on separate lines, notepad (for some crazy reason!) merged all the lines together and when I uploaded it that way, zencart didn't like it. So I went back in and put everything in their correct places (line by line) and that fixed it!