how do I make "buy it now" link in featured products on the front page?

[dharam1987]

Any helps?

Though the above post is on Aug 2006. I would like to add the answer to it. So, that it will be helpful to anybody else coming to next after me.

You need to use the function zen_get_buy_now_button. This function is being used in tpl_modules_products_all_listing.php page (may be in some other pages also)

BTW, I wil be giving a link to download the total code which you can use with zencart3.8 which will display

vendor name
description
buynow button

for featured products in the main page.

[dharam1987]

Though the above post is on Aug 2006. I would like to add the answer to it. So, that it will be helpful to anybody else coming to next after me.

You need to use the function zen_get_buy_now_button. This function is being used in tpl_modules_products_all_listing.php page (may be in some other pages also)

BTW, I wil be giving a link to download the total code which you can use with zencart3.8 which will display

vendor name
description
buynow button

for featured products in the main page.

zen_get_buy_now_button($featured_products->fields['products_id'],'<a href="' . zen_href_link($_GET['main_page'], zen_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $featured_products->fields['products_id']) . '">' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT) . '</a>&nbsp;');

USE THE ABOVE CODE

[dharam1987]

zen_get_buy_now_button($featured_products->fields['products_id'],'<a href="' . zen_href_link($_GET['main_page'], zen_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $featured_products->fields['products_id']) . '">' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT) . '</a>&nbsp;');

USE THE ABOVE CODE

http://www.zen-cart.com/forum/showth...607#post704607

You can also visit the thread above and can find out much more information.

[milkyway]

Thank you very much!, thats solved the problem

[dharam1987]

You are most welcome. I am glad that I have helped you

[andrew55]

Glad to find this. I think I understand the basics of what is instructed. I went to graper's site and found it helpful.

When I view my "Featured Product" section on home page, the buy now and more info buttons are showing.

Only problems are

1. the 2 columns are gone (only a list now)

2. when the buy now button is clicked, it redirects to the product page instead of just adding product to cart (even product with no attributes).

I'm not skilled at php, but here is the code I came up with if anyone is willing to take a look. Anyone have a working featured_products.php to post? Thanks for any suggestions.

<?php

/**

 * featured_products module - prepares content for display

 *

 * @package modules

 * @copyright Copyright 2003-2007 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: featured_products.php 6424 2007-05-31 05:59:21Z ajeh $

 */

if (!defined('IS_ADMIN_FLAG')) {

  die('Illegal Access');

}



// initialize vars

$categories_products_id_list = '';

$list_of_products = '';

$featured_products_query = '';

$display_limit = '';



if ( (($manufacturers_id > 0 && $_GET['filter_id'] == 0) || $_GET['music_genre_id'] > 0 || $_GET['record_company_id'] > 0) || (!isset($new_products_category_id) || $new_products_category_id == '0') ) {

  $featured_products_query = "select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id, pd.products_description

                           from (" . TABLE_PRODUCTS . " p

                           left join " . TABLE_FEATURED . " f on p.products_id = f.products_id

                           left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )

                           where p.products_id = f.products_id

                           and p.products_id = pd.products_id

                           and p.products_status = 1 and f.status = 1

                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

} else {

  // get all products and cPaths in this subcat tree

  $productsInCategory = zen_get_categories_products_list( (($manufacturers_id > 0 && $_GET['filter_id'] > 0) ? zen_get_generated_category_path_rev($_GET['filter_id']) : $cPath), false, true, 0, $display_limit);



  if (is_array($productsInCategory) && sizeof($productsInCategory) > 0) {

    // build products-list string to insert into SQL query

    foreach($productsInCategory as $key => $value) {

      $list_of_products .= $key . ', ';

    }

    $list_of_products = substr($list_of_products, 0, -2); // remove trailing comma

    $featured_products_query = "select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id, pd.products_description

                                from (" . TABLE_PRODUCTS . " p

                                left join " . TABLE_FEATURED . " f on p.products_id = f.products_id

                                left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id)

                                where p.products_id = f.products_id

                                and p.products_id = pd.products_id

                                and p.products_status = 1 and f.status = 1

                                and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

                                and p.products_id in (" . $list_of_products . ")";

  }

}

if ($featured_products_query != '') $featured_products = $db->ExecuteRandomMulti($featured_products_query, MAX_DISPLAY_SEARCH_RESULTS_FEATURED);



$row = 0;

$col = 0;

$list_box_contents = array();

$title = '';



$num_products_count = ($featured_products_query == '') ? 0 : $featured_products->RecordCount();



// show only when 1 or more

if ($num_products_count > 0) {

  if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS == 0) {

    $col_width = floor(100/$num_products_count);

  } else {

    $col_width = floor(100/SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS);

  }

  while (!$featured_products->EOF) {

    $products_price = zen_get_products_display_price($featured_products->fields['products_id']);

    if (!isset($productsInCategory[$featured_products->fields['products_id']])) $productsInCategory[$featured_products->fields['products_id']] = zen_get_generated_category_path_rev($featured_products->fields['master_categories_id']);


    $list_box_contents[$row][$col] = array('params' =>'class="centerBoxContentsFeatured centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"',

    'text' => (($featured_products->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) ? '' : '<a href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'cPath=' . $productsInCategory[$featured_products->fields['products_id']] . '&products_id=' . $featured_products->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $featured_products->fields['products_image'], $featured_products->fields['products_name'], IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH, IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT) . '</a><br />') . '<a href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'cPath=' . $productsInCategory[$featured_products->fields['products_id']] . '&products_id=' . $featured_products->fields['products_id']) . '">' . $featured_products->fields['products_name'] . '</a><br />' . $products_price);

$product_link=zen_href_link( zen_get_info_page(  $featured_products->fields['products_id']), 'products_id=' . $featured_products->fields['products_id']);
      $product_image=zen_image(DIR_WS_IMAGES . $featured_products->fields['products_image'], $featured_products->fields['products_name'], IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH, IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT);
      $product_name=$featured_products->fields['products_name'];
      $product_desc=zen_trunc_string( zen_clean_html( stripslashes( zen_get_products_description( $featured_products->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION);
      $product_id=$featured_products->fields['products_id'];
      $product_addtocart=zen_href_link( $_GET['main_page'], 'products_id=' . $product_id .'&action=buy_now');
	  
	  $list_box_contents[$row][$col] = array('params' =>'class="featured_prod back"'
		. '','text' => '<div class="featured_prod_name"><a href="' . $product_link . '">' . $product_name . '</a></div>'
		.' <div class="featured_prod_description"><a class="featured_prod_image" href="' . $product_link . '">' . $product_image. '</a>'
		. $product_desc . '</div><div class="clearBoth"></div>'
		. ' <div class="custom_prod_price">' . $product_price .'</div>'
		. ' <div class="custom_prod_links"><a href="' . $product_addtocart . '">' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT) . '</a>   <a href="' . $product_link . '"><img src="/biz/includes/templates/farm/buttons/english//button_more_reviews.gif" /></a></div>' );

    $col ++;

    if ($col > (SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS - 1)) {

      $col = 0;

      $row ++;

    }

    $featured_products->MoveNextRandom();

  }



  if ($featured_products->RecordCount() > 0) {

    if (isset($new_products_category_id) && $new_products_category_id !=0) {

      $category_title = zen_get_categories_name((int)$new_products_category_id);

      $title = '<h2 class="centerBoxHeading">' . TABLE_HEADING_FEATURED_PRODUCTS . ($category_title != '' ? ' - ' . $category_title : '') . '</h2>';

    } else {

      $title = '<h2 class="centerBoxHeading">' . TABLE_HEADING_FEATURED_PRODUCTS . '</h2>';

    }

    $zc_show_featured = true;

  }

}

?>

[spawnie69]

I my dilemma is similar.

I would like to display my featured products on the front page with some description with prices and buy now buttons (links to the product page).
I would like the featured products to be displayed in rotation in 2 columns on the front page.

I made my own version in html and placed in my admin main page.

I was wondering if zen cart already had a feature like this in the admin somewhere.
It would be nice to see the featured items in rotation at the front top.

advice is appreciated.
Here is the site:
www.gelcandlecompany.com

[milkyway]

Of course you can,

If you follow the code above it will work.

I made similar way for many of my client's sites, here one of the example:
http://cvtreasures.com

[milkyway]

This is incorrect:

$product_addtocart=zen_href_link( $_GET['main_page'], 'products_id=' . $product_id .'&action=buy_now'); 

It should be:

$product_addtocart = zen_get_buy_now_button($featured_products->fields['products_id'],'<a href="' . zen_href_link($_GET['main_page'], zen_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $featured_products->fields['products_id']) . '">' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT) . '</a>&nbsp;'); 

[andrew55]

milkyway - I played around with your code but I can't see how it fits yet. Anyway, this is the best I've come up with so far (without being a coder).

This featured products page has a "buy now" and "more info" button, it displays the short description (integrated with "Short Description" addin) right below the thumbnail and above the buttons.

I have it looking OK in 3 columns, which I couldn't figure out how to do with dharam1987's contribution. So what I have is a mix-match of different ideas from this community.

I think many people here could benefit from this, if the code is correct (if you are skilled in php and see any errors, please let me know).

If anyone knows how to change this code so it doesn't direct to category page when buy now button is clicked, please please let me know. I'd love for users to be able to add "non attributes" items to the cart without redirection.

Also, I am working to get a quantity field box next to the buttons for each product (customer enters in desired amount and it's submitted when buy now button is clicked). I've been looking at product_listing.php for the box field code, but my efforts have been disaserous so far. If anyone has insights into this, please share. Here is my code so far:

<?php

/**

 * featured_products module - prepares content for display

 *

 * @package modules

 * @copyright Copyright 2003-2007 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: featured_products.php 6424 2007-05-31 05:59:21Z ajeh $

 */

if (!defined('IS_ADMIN_FLAG')) {

  die('Illegal Access');

}



// initialize vars

$categories_products_id_list = '';

$list_of_products = '';

$featured_products_query = '';

$display_limit = '';



if ( (($manufacturers_id > 0 && $_GET['filter_id'] == 0) || $_GET['music_genre_id'] > 0 || $_GET['record_company_id'] > 0) || (!isset($new_products_category_id) || $new_products_category_id == '0') ) {

  $featured_products_query = "select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id, pd.products_short_desc

                           from (" . TABLE_PRODUCTS . " p

                           left join " . TABLE_FEATURED . " f on p.products_id = f.products_id

                           left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )

                           where p.products_id = f.products_id

                           and p.products_id = pd.products_id

                           and p.products_status = 1 and f.status = 1

                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";

} else {

  // get all products and cPaths in this subcat tree

  $productsInCategory = zen_get_categories_products_list( (($manufacturers_id > 0 && $_GET['filter_id'] > 0) ? zen_get_generated_category_path_rev($_GET['filter_id']) : $cPath), false, true, 0, $display_limit);



  if (is_array($productsInCategory) && sizeof($productsInCategory) > 0) {

    // build products-list string to insert into SQL query

    foreach($productsInCategory as $key => $value) {

      $list_of_products .= $key . ', ';

    }

    $list_of_products = substr($list_of_products, 0, -2); // remove trailing comma

    $featured_products_query = "select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id, pd.products_short_desc

                                from (" . TABLE_PRODUCTS . " p

                                left join " . TABLE_FEATURED . " f on p.products_id = f.products_id

                                left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id)

                                where p.products_id = f.products_id

                                and p.products_id = pd.products_id

                                and p.products_status = 1 and f.status = 1

                                and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'

                                and p.products_id in (" . $list_of_products . ")";

  }

}

if ($featured_products_query != '') $featured_products = $db->ExecuteRandomMulti($featured_products_query, MAX_DISPLAY_SEARCH_RESULTS_FEATURED);



$row = 0;

$col = 0;

$list_box_contents = array();

$title = '';



$num_products_count = ($featured_products_query == '') ? 0 : $featured_products->RecordCount();



// show only when 1 or more

if ($num_products_count > 0) {

  if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS == 0) {

    $col_width = floor(100/$num_products_count);

  } else {

    $col_width = floor(100/SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS);

  }

  while (!$featured_products->EOF) {

    $product_price = zen_get_products_display_price($featured_products->fields['products_id']);	
	  $product_link=zen_href_link( zen_get_info_page(  $featured_products->fields['products_id']), 'products_id=' . $featured_products->fields['products_id']);
      $product_id=$featured_products->fields['products_id'];
      $product_addtocart=zen_href_link( $_GET['main_page'], 'products_id=' . $product_id .'&action=buy_now');
	  $product_image=zen_image(DIR_WS_IMAGES . $featured_products->fields['products_image'], $featured_products->fields['products_name'], IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH, IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT);
      $product_name=$featured_products->fields['products_name'];
	  $featured_products->fields['products_short_desc'] = zen_get_products_short_desc($featured_products->fields['products_id']);

    if (!isset($productsInCategory[$featured_products->fields['products_id']])) $productsInCategory[$featured_products->fields['products_id']] = zen_get_generated_category_path_rev($featured_products->fields['master_categories_id']);
	

    $list_box_contents[$row][$col] = array('params' =>'class="centerBoxContentsFeatured centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"',

    'text' => (($featured_products->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) ? '' : '<a href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'cPath=' . $productsInCategory[$featured_products->fields['products_id']] . '&products_id=' . $featured_products->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $featured_products->fields['products_image'], $featured_products->fields['products_name'], IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH, IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT) . '</a><br />') . '<a href="' . zen_href_link(zen_get_info_page($featured_products->fields['products_id']), 'cPath=' . $productsInCategory[$featured_products->fields['products_id']] . '&products_id=' . $featured_products->fields['products_id']) . '">' . $featured_products->fields['products_name'] . '</a><div class="products_short_desc">' . $featured_products->fields['products_short_desc'] . '</div><div class="clearBoth"></div>'
		. ' <div class="featured_prod_price">' . $product_price .'</div>'
		. ' <div class="featured_prod_links"><a href="' . $product_addtocart . '">' . zen_image_button(BUTTON_IMAGE_BUY_NOW, BUTTON_BUY_NOW_ALT) . '</a>   <a href="' . $product_link . '"><img src="/biz/includes/templates/mytemplate/buttons/english/mypic.gif" /></a></div>' );


    $col ++;

    if ($col > (SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS - 1)) {

      $col = 0;

      $row ++;

    }

    $featured_products->MoveNextRandom();

  }



  if ($featured_products->RecordCount() > 0) {

    if (isset($new_products_category_id) && $new_products_category_id !=0) {

      $category_title = zen_get_categories_name((int)$new_products_category_id);

      $title = '<h2 class="centerBoxHeading">' . TABLE_HEADING_FEATURED_PRODUCTS . ($category_title != '' ? ' - ' . $category_title : '') . '</h2>';

    } else {

      $title = '<h2 class="centerBoxHeading">' . TABLE_HEADING_FEATURED_PRODUCTS . '</h2>';

    }

    $zc_show_featured = true;

  }

}

?>