Just another Cross-Sell mod (support thread)

It seems that you are missing the definition of TABLE_PRODUCTS_XSELL. If you are using a custom template, make sure you change the name of the folders (as instructed in the readme file) BEFORE you upload all the files and folders to your server.

I have been trying for days to install the Cross Sell module, and no matter what I do, it just isn't working. I can't get the Cross Sell Products to show up in the catalog as an option.

When I got to one of my product pages, this is the error I get.

Warning: include(includes/modules/FILENAME_XSELL_PRODUCTS.php) [function.include]: failed to open stream: No such file or directory in /home/scentime/public_html/catalog/includes/templates/new_template/templates/tpl_modules_xsell_products.php on line 17

Warning: include() [function.include]: Failed opening 'includes/modules/FILENAME_XSELL_PRODUCTS.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/scentime/public_html/catalog/includes/templates/new_template/templates/tpl_modules_xsell_products.php on line 17

This is a sample product page

http://www.scentimentalprints.com/catalog/index.php?main_page=product_info&cPath=65&products_id=183

I then tried to install the Advanced Cross Sell (even though I recognized it probably wouldn't work if I couldn't get the regular one to work) and when I go to the Advanced Cross Sell tab (which at least shows up), this is the error I get

1146 Table 'scentime_scentimentalprints.TABLE_PRODUCTS_XSELL' doesn't exist
in:
[select p.products_id, p.products_model, pd.products_name, count(p.products_id) as xsells from products p, products_description pd, TABLE_PRODUCTS_XSELL px where p.products_id = pd.products_id and p.products_id = px.products_id and pd.language_id ='1' group by p.products_id]
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.

I am in dire need to help, and don't know much about mySQL stuff!

Thank you!

The same error, the same answer:

It seems that you are missing the definition of TABLE_PRODUCTS_XSELL. If you are using a custom template, make sure you change the name of the folders in the mod (as instructed in the readme file) BEFORE you upload all the files and folders to your server.

I'm not sure if this is the correct place to post this, but since yellow1912 seems to be incredibly knowledgeable, I figured I would give it a shot!

I have Cross Sell installed and working, however, for the life of me I cannot get the images for it to format properly.

Here is a page on the site demonstrating my issue.

http://www.scentimentalprints.com/catalog/index.php?main_page=product_info&cPath=65&products_id=180

When you look at the "Also Available" items, they are pretty much on top of eachother, and no amount of padding or margin is making a difference.

I want them to stack on top of eachother in a column.

Any idea what css to alter to get them to do this? Right now, using Web Developer Toolbar, the only thing I can figure out to alter is called

#crossSell .centerBoxContentsCrossSell centeredContent back

which doesn't seem to be doing anything.

Any help at all would be greatly appreciated!

Remove style="width: 50%;"
That should fix the problem (or at least part of it)

Hey Zenners,

I have a weird issue where my cross sell header appears and disappears. To view this behavior go to this link: http://www.pccapital.ca/notebook-1/test-laptop-please-buy-3.html

Choose the "We Also Recommend" tab. Then, mouse over the header above the Cross Sell Products (it should say "Free Shipping on Two or My Items"). If you can't see it, or want to make it reappear, scroll to the bottom of the page, then mouse over the header area again. Neat, ehh? But I want to get rid of that behavior just the same, :unsure:

I will include the code from my tpl_modules_xsell_products.php below. If anyone can see where there is an issue, or if I have included the wrong code, please let me know.

Thanks!

Code:

<?php
/**
 * Cross Sell products
 *
 * Derived from:
 * Original Idea From Isaac Mualem [email protected] <mailto:[email protected]>
 * Portions Copyright (c) 2002 osCommerce
 * Complete Recoding From Stephen Walker [email protected]
 * Released under the GNU General Public License
 *
 * Adapted to Zen Cart by Merlin - Spring 2005
 * Reworked for Zen Cart v1.3.0  03-30-2006
 */


// calculate whether any cross-sell products are configured for the current product, and display if relevant
include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_XSELL_PRODUCTS));

if (zen_not_null($xsell_data)) {
  $info_box_contents = array();
  $list_box_contents = $xsell_data;
  $title = '';
?>
<!-- bof: tpl_modules_xsell_products -->
<div class="centerBoxWrapper" id="crossSell">
<h2 class="centerBoxHeading"><?php echo TEXT_XSELL_PRODUCTS; ?></h2>
<?php
/**
 * require the list_box_content template to display the cross-sell info. This info was prepared in modules/xsell_products.php
 */
require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php');
?>
<br><br><br>
</div>
<!-- eof: tpl_modules_xsell_products -->
<?php } ?>

Update: I have learned that this is called the "peekaboo bug" and affects IE6 and CSS. I haven't fixed it though. And this bug does only affect me on Cross Sell. Will keep working on it and post again later.

bifficus:

Hey Zenners,

I have a weird issue where my cross sell header appears and disappears. To view this behavior go to this link: http://www.pccapital.ca/notebook-1/test-laptop-please-buy-3.html

Choose the "We Also Recommend" tab. Then, mouse over the header above the Cross Sell Products (it should say "Free Shipping on Two or My Items"). If you can't see it, or want to make it reappear, scroll to the bottom of the page, then mouse over the header area again. Neat, ehh? But I want to get rid of that behavior just the same, :unsure:

I will include the code from my tpl_modules_xsell_products.php below. If anyone can see where there is an issue, or if I have included the wrong code, please let me know.

Thanks!

Code:

<?php /** * Cross Sell products * * Derived from: * Original Idea From Isaac Mualem [email protected] <mailto:[email protected]> * Portions Copyright (c) 2002 osCommerce * Complete Recoding From Stephen Walker [email protected] * Released under the GNU General Public License * * Adapted to Zen Cart by Merlin - Spring 2005 * Reworked for Zen Cart v1.3.0 03-30-2006 */ // calculate whether any cross-sell products are configured for the current product, and display if relevant include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_XSELL_PRODUCTS)); if (zen_not_null($xsell_data)) { $info_box_contents = array(); $list_box_contents = $xsell_data; $title = ''; ?> <!-- bof: tpl_modules_xsell_products --> <div class="centerBoxWrapper" id="crossSell"> <h2 class="centerBoxHeading"><?php echo TEXT_XSELL_PRODUCTS; ?></h2> <?php /** * require the list_box_content template to display the cross-sell info. This info was prepared in modules/xsell_products.php */ require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php'); ?> <br><br><br> </div> <!-- eof: tpl_modules_xsell_products --> <?php } ?> ```

Hi,

Got this message on when i ran the sql "products_xsell.sql" to get the basic cross sell mod in.

Anyone have any idea how to fix this?

"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 zen_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());]

its a virgin instaltion of zen cart except for an added language pack, which i don't see how it could create a conflict with this.

the table is created, and when tested i can add data, and it displays.

What is missing is the display price Y/N in the admin panel, and the price is not displayed in the front end.

(hope that is all that 's not working), so just to be on the safe side, i'd appreciate it if someone has an answer on how to fix this.

thanks
nev

Please note that Cross Sell mod was written and supported by another author.

Anyway, try to run this on your phpmyadmin, see if you can get it through:
INSERT INTO zen_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());

:no: didnt work

got this back

SQL query:

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

MySQL said:

#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

any other ideas?

yeah i know that it was written by someone else.. but.. i ran into so many questions on the original here i figured i'd try :blush:

and thank you for helping

I'm not able to install the sql file for Cross Sell. I get the following error:
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 zen_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.

I mistakenly installed the Advanced Cross Sell program first and then went back to install Cross Sell. Did I mess this up? If so, what can I do to fix this?

try:

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

Agh, I could kiss you! Thanks so much! This fixed it beautifully! I really appreciate your great information!!!!

Hi yellow,

I have try to install "Cross Sell" mod for quite some time but failed:(
Admin part seen to be ok, but nothing showing in the product part.

Is there because the "Cross Sell" mod is for 1.3.0 and I am using 1.3.7, will this be a issue?

Jerry

jerrytkc:

Hi yellow,

I have try to install "Cross Sell" mod for quite some time but failed:(
Admin part seen to be ok, but nothing showing in the product part.

Is there because the "Cross Sell" mod is for 1.3.0 and I am using 1.3.7, will this be a issue?

Jerry

It should work fine for 1.3.7
Check if you edited the right files. You should edit the files in your includes/templates/name_of_the_template_you_use/

Sometimes ppl edited files in their default folder,

follow to the install guide by cross sales,

1. Using the Admin->Tools->Install SQL Patch, run the included SQL file (products_xsell.sql)
   Result : I done this.

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
   Result:
   I change the folder name to "classic" since that I am using the default template given by zencart
   /includes/modules/classic
   /includes/templates/classic
   /includes/languages/english/classic

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.)
   Result: I uploaded the file, of cause without the "SAMPLE_..."

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
   **Result: I edited the includes/languages/english/product_info.php then save it into includes/languages/english/classic/product_info.php **

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'); ?>

**Result:I add the require code at the bottom of tpl_product_info_display.php to the uploaded file in the /includes/templates/classic **

Finally I add cross sales in Admin->Catalog->Cross Sell, when I check in the product page nothing is show except the original product.

Anything wrong with my configuration/steps?

Can you send me a link to your site? And to that specific product that you crossed sell.

BTW, make sure that you turn on cross sale in the admin panel as well. (change the min Display Cross-Sell Products to 1)

I have send a PM to you on my site link, FTP user and pwd

I installed Cross sell and Just another Cross-Sell mods on the sample site you gave me. Check it.

yellow1912:

I installed Cross sell and Just another Cross-Sell mods on the sample site you gave me. Check it.

Great, it work! :clap:

Thanks yellow, :D