Multi Cross Sell mod [Support thread]

[Briann]

I'd just like to say:

THANK YOU!

for this awesome mod. After a problem with Just Another Cross Sell Mod (again) I tried this one, it's much better!

[Berserker]

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks

[gilby]

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks

Not an available option in the default mod
A quick search of zen functions found this function
zen_get_categories_name_from_product($product_id)
It looks useful
Give it the product id and back comes the name of the category

I haven't tried this but this could work

Edit
\includes\modules\YOUR_TEMPLATE\multi_xsell_products.php
Around line 69 near the end of the line find this code segment

zen_products_lookup($xsell_query->fields['products_id'], 'products_model') 

and replace with

zen_get_categories_name_from_product($xsell_query->fields['products_id']) 

See if that works for you?

[gilby]

Hello,

First, i'd like to say this is an awesome mod! Like all the added features.
I was just wondering though, is it possible to show the category the product is from instead of the model?

Thanks

I just tested the code in the previous post and it does work

[beyre]

Just installed this mod and no errors while installing.
However, I can't get the feature to actually show on a product page.

This is the product page I'm working on to start:
http://www.vintagegunleather.com/sho...roducts_id=276

It is supposed to show beneath the add to cart, so it'll be the last thing on the page.

When you view the page source code you see it ends with:

<!--bof Add to Cart Box -->
                  <div id="cartAdd">
    <input type="hidden" name="cart_quantity" value="1" /><input type="hidden" name="products_id" value="276" /><input type="image" src="includes/templates/vgl/buttons/english/button_in_cart.gif" alt="Add to Cart" title=" Add to Cart " />          </div>
  <br class="clearBoth" />
<!--eof Add to Cart Box-->

<!-- BEG: Multi Cross-Sell mod -->

But yet, the actual file from that point on is:

<!--bof Add to Cart Box -->
<?php
if (CUSTOMERS_APPROVAL == 3 and TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE_SHOWROOM == '') {
  // do nothing
} else {
?>
            <?php
    $display_qty = (($flag_show_product_info_in_cart_qty == 1 and $_SESSION['cart']->in_cart($_GET['products_id'])) ? '<p>' . PRODUCTS_ORDER_QTY_TEXT_IN_CART . $_SESSION['cart']->get_quantity($_GET['products_id']) . '</p>' : '');
            if ($products_qty_box_status == 0 or $products_quantity_order_max== 1) {
              // hide the quantity box and default to 1
              $the_button = '<input type="hidden" name="cart_quantity" value="1" />' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            } else {
              // show the quantity box
    $the_button = PRODUCTS_ORDER_QTY_TEXT . '<input type="text" name="cart_quantity" value="' . (zen_get_buy_now_qty($_GET['products_id'])) . '" maxlength="6" size="4" />' . zen_get_products_quantity_min_units_display((int)$_GET['products_id']) . '' . zen_draw_hidden_field('products_id', (int)$_GET['products_id']) . zen_image_submit(BUTTON_IMAGE_IN_CART, BUTTON_IN_CART_ALT);
            }
    $display_button = zen_get_buy_now_button($_GET['products_id'], $the_button);
  ?>
  <?php if ($display_qty != '' or $display_button != '') { ?>
    <div id="cartAdd">
    <?php
      echo $display_qty;
      echo $display_button;
            ?>
          </div>
  <?php } // display qty and button ?>
<?php } // CUSTOMERS_APPROVAL == 3 ?>
<br class="clearBoth" />
<!--eof Add to Cart Box-->

<!-- BEG: Multi Cross-Sell mod -->
<?php
  if(defined('MXSELL_ENABLED') && MXSELL_ENABLED == 'true') {
    for ( $mxsell = 1; $mxsell <= MXSELL_NUM_OF_TABLES; $mxsell++ ) { // show all cross sells
      require($template->get_template_dir('tpl_modules_multi_xsell_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_multi_xsell_products.php');
    }
  }
?>
<!-- END: Multi Cross-Sell mod -->

<!--bof Prev/Next bottom position -->
<?php if (PRODUCT_INFO_PREVIOUS_NEXT == 2 or PRODUCT_INFO_PREVIOUS_NEXT == 3) { ?>
<?php
/**
 * display the product previous/next helper
 */
 require($template->get_template_dir('/tpl_products_next_previous.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_products_next_previous.php'); ?>
<?php } ?>
<!--eof Prev/Next bottom position -->

<!--bof Quantity Discounts table -->
<?php
  if ($products_discount_type != 0) { ?>
<?php
/**
 * display the products quantity discount
 */
 require($template->get_template_dir('/tpl_modules_products_quantity_discounts.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_products_quantity_discounts.php'); ?>
<?php
  }
?>
<!--eof Quantity Discounts table -->

<!--bof Product URL -->
<?php
  if (zen_not_null($products_url)) {
    if ($flag_show_product_info_url == 1) {
?>
    <p id="productInfoLink" class="productGeneral centeredContent"><?php echo sprintf(TEXT_MORE_INFORMATION, zen_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($products_url), 'NONSSL', true, false)); ?></p>
<?php
    } // $flag_show_product_info_url
  }
?>
<!--eof Product URL -->

<!--bof also purchased products module-->
<?php require($template->get_template_dir('tpl_modules_also_purchased_products.php', DIR_WS_TEMPLATE, $current_page_base,'templates'). '/' . 'tpl_modules_also_purchased_products.php');?>
<!--eof also purchased products module-->

<!--bof Form close-->
</form>
<!--bof Form close-->
</div>

So, something in the cross sell code above is breaking the page's code. I don't know enough about PHP to pinpoint the problem. This is a direct copy and past from the Sample file. What was in the Document file didn't have that first "if" line (about Enabling).

Zencart V 3.1.8a
I have the module set for 1 cross sell box, 3 products across, 3 products max.

[gilby]

Just installed this mod and no errors while installing.
However, I can't get the feature to actually show on a product page.

So, something in the cross sell code above is breaking the page's code. I don't know enough about PHP to pinpoint the problem. This is a direct copy and past from the Sample file. What was in the Document file didn't have that first "if" line (about Enabling).

Zencart V 3.1.8a
I have the module set for 1 cross sell box, 3 products across, 3 products max.

As you are using v138a install this
http://www.zen-cart.com/index.php?ma...roducts_id=860
so that you can find the php error that is causing the error

You could also try using the included file to see if that works instead of modifying yours.
If that works there could be a conflict with other customisations you have made to this file.

[beyre]

Thanks for your reply.

It seemed the tpl_modules_multi_xsell_products.php file didn't upload when I told it to and I didn't pay attention to that.

But now, on that same product page, 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 '' at line 7
in:
[select distinct p.products_id, p.products_image, pd.products_name from products_xsell1 xp, products p, products_description pd where xp.products_id = '276' 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 rand() limit ]

This was also in the debugging file:

161
[24-Aug-2010 07:23:18] PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/templates/template_default/templates/tpl_modules_multi_xsell_products.php' (include_path='.:.:') in /var/www/vhosts/vintagegunleather.com/httpdocs/shoppe/includes/templates/vgl/templates/tpl_product_info_display.php on line 161

[Trice]

I have recently installed the latest version of Zen cart and added the multi cross sell mod.

Everything is great except for the cross products are listed several times on the page, please see attached link

I am sure I have done something wrong but cant work it out. Any help would be good. Thanks

Trice

http://www.styleuboutique.com/catalo...roducts_id=168

[aeolidia2]

Hi, I'm having trouble setting up this add-on.

The instructions say to go to Admin->Configuration->Multi Cross Sell to install, but that link is not in the Configuration menu.

From previous posts on this thread it sounds like the correct place to install is actually Catalog > Multi Cross-Sell, but when I go to that page it takes me back to the home page of the site. (Not the home page of the admin, the site's home page.)

I removed a previous cross-sells add-on before installing multi cross-sells. I deleted the files only: I didn't make any changes to the database.

Any ideas of what could be causing this problem would be appreciated. Thanks!

(Also, the readme says that the file path is "admin\includes\multi_xsell.php", but in my download that file was in "admin\multi_xsell.php". Which is correct?)

[gilby]

Hi, I'm having trouble setting up this add-on.

The instructions say to go to Admin->Configuration->Multi Cross Sell to install, but that link is not in the Configuration menu.

From previous posts on this thread it sounds like the correct place to install is actually Catalog > Multi Cross-Sell, but when I go to that page it takes me back to the home page of the site. (Not the home page of the admin, the site's home page.)

Catalog->Multi Cross-Sell is correct

I removed a previous cross-sells add-on before installing multi cross-sells. I deleted the files only: I didn't make any changes to the database.

Any ideas of what could be causing this problem would be appreciated. Thanks!

You should have uninstalled the previous version
Use the uninstall sql for that version to remove it
(Don't remove the xsell database if you want to reuse it)

(Also, the readme says that the file path is "admin\includes\multi_xsell.php", but in my download that file was in "admin\multi_xsell.php". Which is correct?)

The download is correct, "admin\multi_xsell.php"