Just another Cross-Sell mod (support thread)

[yellow1912]

JUST ANOTHER CROSS SELL MOD
Version: aplha 1

Based on Advanced Cross-sell originally coded by Absolute
Link to the original:
http://www.zen-cart.com/index.php?ma...roducts_id=597


Features:
1. Allow unlimited number of product fields instead of only 5.
2. Accept product id or model as input value.
3. Clean up table.
4. Given a list of n products, the mod will go through and cross-sell EACH pair together.
IMPORTANT: This is the VERY different from the way the old cross-sell mod work! As a seller, I realize that when I cross-sell A and B I want the customers to see the product B while they are viewing A and VICE VERSA.
With the old cross-sell and the Advanced Cross-Sell mod I had to add A to B then B to A, which is lots of work.

With this mod, if you give it 3 products: A - B - C, it will cross-sell:
A to B, B to A
A to C, C to A
B to C, C to B

Screenshot:
https://svn.rubikintegration.com/zen...screenshot.gif

Bug report:
http://www.rubikintegration.com/mantis
Latest (unstable) version:
https://svn.rubikintegration.com/zen...sell_advanced/
Latest (stable) version:
link should be available here soon!

yellow1912

[scitrenbaum]

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/ca...roducts_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!

[yellow1912]

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.

[scitrenbaum]

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/ca...roducts_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!

[yellow1912]

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

[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/t...ase-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,

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 } ?>

[fbords]

I just installed this on another site of mine and when doing so, the contents in the "We Also Recommend:" centerbox have no padding at the top. The image touches right up against the title. Is there a way I can get it spaced like the Featured products box? I'm not sure which style to edit.

[PatF]

I just installed this on another site of mine and when doing so, the contents in the "We Also Recommend:" centerbox have no padding at the top. The image touches right up against the title. Is there a way I can get it spaced like the Featured products box? I'm not sure which style to edit.

Not the best practice coding suggestion but

in includes/templates/YOURTEMPLATE/tpl_modules_xsell_products.php add a couple of <br><br> as shown below and it pads it out for you. Just spent half an hour trying to find where to amend the stylesheet with no joy so took a short cut ;)

<!-- bof: tpl_modules_xsell_products -->
<div class="centerBoxWrapper" id="crossSell">
<h2 class="centerBoxHeading"><?php echo TEXT_XSELL_PRODUCTS; ?></h2>
<br /><br />
<?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');
?>
</div>
<!-- eof: tpl_modules_xsell_products -->

[yellow1912]

What prevents you from using css to do that, my friend?

[PatF]

What prevents you from using css to do that, my friend?

Probably because I am a gobsh!te ;)

Figured this is where it was calling the CSS in tpl_modules_xsell_products

<div class="centerBoxWrapper" id="crossSell">

this class was not in my templates css file so I added it and copied it from the default templates etc. but could not get it to pad out changing the border put a border around the box etc so I could not figure out why it would not pad out.

Had me baffled as for example the also purchased function also goes to this class but the also purchased box has the padding in it whereas the cross sell did not.

Spent half an hour at it and then thought ah sod it go for the quick and easy short cut but would really appreciate if you could steer me towards where I went wrong :)