Featured Product Support v1.5.4

bkellum · August 3, 2008

I installed 161 w/STS 453 instructions(running STS), but have a problem. If I enable Featured Products in the Admin, the Featured Products box "pushes" the main page content ($content) out of the middle column, instead of displayed under the main page content. According to Bill K's excellent instructions, I should be able to position the Featured box anywhere I want it:

Step 15.2:

Add the following STS Tag anywhere on your template pages if you want an individual (separate) Featured Infobox (optional), use this tag ONLY if you turn the Feature option OFF in your store's admin.

$featuredbox

but the $featuredbox tag does not work if I turn off the Featured option in the Admin and when enabled, I get 2 Featured Products on the main page? anybody know what's going on?

thanks,

Jerry, step 15.2 is referring to the smaller Featured infobox that usually would be displayed in the left or right colum of your shop. The box you are referring to is contained within the $content tag of the main column of your site and can be turned off in the admin.

If the Featured box in the main column is throwing off your layout, you may have messed something up in the index.php file during the installation or just need to tweak a td or tr where the Feartured box is being called in that file (index.php).

Hope this helped,

jerrymc · August 3, 2008

Jerry, step 15.2 is referring to the smaller Featured infobox that usually would be displayed in the left or right colum of your shop. The box you are referring to is contained within the $content tag of the main column of your site and can be turned off in the admin.

If the Featured box in the main column is throwing off your layout, you may have messed something up in the index.php file during the installation or just need to tweak a td or tr where the Feartured box is being called in that file (index.php).

Hope this helped,

Bill: Thanks for your reply, but, no, I can't see any problem with index.php. Here's the code..maybe you can spot something I'm missing?

<?php

/*

$Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require('includes/application_top.php');

// the following cPath references come from application_top.php

$category_depth = 'top';

if (isset($cPath) && tep_not_null($cPath)) {

$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$cateqories_products = tep_db_fetch_array($categories_products_query);

if ($cateqories_products['total'] > 0) {

$category_depth = 'products'; // display products

} else {

$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

$category_parent = tep_db_fetch_array($category_parent_query);

if ($category_parent['total'] > 0) {

$category_depth = 'nested'; // navigate through the categories

} else {

$category_depth = 'products'; // category has no products, but display the 'no products' message

}

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<?php

if ($category_depth == 'nested') {

$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");

$category = tep_db_fetch_array($category_query);

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<tr>

<?php

if (isset($cPath) && strpos('_', $cPath)) {

// check to see if there are deeper categories within the current category

$category_links = array_reverse($cPath_array);

for($i=0, $n=sizeof($category_links); $i<$n; $i++) {

$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");

$categories = tep_db_fetch_array($categories_query);

if ($categories['total'] < 1) {

// do nothing, go through the loop

} else {

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

break; // we've found the deepest category the customer is in

}

} else {

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

}

$number_of_categories = tep_db_num_rows($categories_query);

$rows = 0;

while ($categories = tep_db_fetch_array($categories_query)) {

$rows++;

$cPath_new = tep_get_path($categories['categories_id']);

$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';

echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";

if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {

echo ' </tr>' . "\n";

echo ' <tr>' . "\n";

}

// needed for the new products module shown below

$new_products_category_id = $current_category_id;

?>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table></td>

</tr>

</table></td>

<?php

} elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

asort($define_list);

$column_list = array();

reset($define_list);

while (list($key, $value) = each($define_list)) {

if ($value > 0) $column_list[] = $key;

}

$select_column_list = '';

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

switch ($column_list[$i]) {

case 'PRODUCT_LIST_MODEL':

$select_column_list .= 'p.products_model, ';

break;

case 'PRODUCT_LIST_NAME':

$select_column_list .= 'pd.products_name, ';

break;

case 'PRODUCT_LIST_MANUFACTURER':

$select_column_list .= 'm.manufacturers_name, ';

break;

case 'PRODUCT_LIST_QUANTITY':

$select_column_list .= 'p.products_quantity, ';

break;

case 'PRODUCT_LIST_IMAGE':

$select_column_list .= 'p.products_image, ';

break;

case 'PRODUCT_LIST_WEIGHT':

$select_column_list .= 'p.products_weight, ';

break;

}

// show the products of a specified manufacturer

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only a specific category

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

}

} else {

// show the products in a given categorie

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only specific catgeory

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

}

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

if ($column_list[$i] == 'PRODUCT_LIST_NAME') {

$HTTP_GET_VARS['sort'] = $i+1 . 'a';

$listing_sql .= " order by pd.products_name";

break;

}

} else {

$sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

$sort_order = substr($HTTP_GET_VARS['sort'], 1);

switch ($column_list[$sort_col-1]) {

case 'PRODUCT_LIST_MODEL':

$listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_NAME':

$listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

break;

case 'PRODUCT_LIST_MANUFACTURER':

$listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_QUANTITY':

$listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_IMAGE':

$listing_sql .= " order by pd.products_name";

break;

case 'PRODUCT_LIST_WEIGHT':

$listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_PRICE':

$listing_sql .= " order by final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

}

?>

<tr>

<tr>

<td class="pageHeading"><?php if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$category_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

$category = tep_db_fetch_array($category_query);

if ($category['manufacturers_name'] != "") {echo $category['manufacturers_name'];} else { echo HEADING_TITLE;}

} else {

$category_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");

$category = tep_db_fetch_array($category_query);

if ($category['categories_name'] != "") {echo $category['categories_name'];} else { echo HEADING_TITLE;}

}

?></td>

<?php

// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

} else {

$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";

}

$filterlist_query = tep_db_query($filterlist_sql);

if (tep_db_num_rows($filterlist_query) > 1) {

echo ' <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);

$options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));

} else {

echo tep_draw_hidden_field('cPath', $cPath);

$options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));

}

echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);

while ($filterlist = tep_db_fetch_array($filterlist_query)) {

$options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);

}

echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');

echo tep_hide_session_id() . '</form></td>' . "\n";

}

// Get the right image for the top-right

$image = DIR_WS_IMAGES . 'table_background_list.gif';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

$image = tep_db_fetch_array($image);

$image = $image['manufacturers_image'];

} elseif ($current_category_id) {

$image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$image = tep_db_fetch_array($image);

$image = $image['categories_image'];

}

?>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

</tr>

</table></td>

<?php

} else { // default page

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<?php

include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);

?>

</table></td>

</tr>

</table></td>

<?php

}

?>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

</table></td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Carol_A · August 5, 2008

First of all I wanted to thank you for such complete instructions. It was all very understandable, even for a beginner like me except for the sql section. I think I may have figured it out. But I do have a problem.

I've worked all day trying to install Featured Products 161 with STS. I managed to make it through all the steps except for the ones for STS Template. In the admin side it will let me activate Featured and change how many products I wanted displayed. It also let me add products to Featured. But when I try to go to my live site it won't come up. It shows this message: Fatal error: Call to a member function add_current_page() on a non-object in /home/doglady8/public_html/includes/application_top.php on line 312

I don't understand it, I never changed anything on that line of the code. It seemed like it was going pretty good. I did the manual install so none of the changes to text and colors would be lost.

Please help me out. This is the first contribution I've been brave enough to try to install but I thought since your instructions were so good that I would be able to do it. Now I don't know what to do unless I restore the backup I made before starting.

I'm at a stand-still! Please help me figure out what is wrong.

bkellum · August 5, 2008

First of all I wanted to thank you for such complete instructions. It was all very understandable, even for a beginner like me except for the sql section. I think I may have figured it out. But I do have a problem.

I've worked all day trying to install Featured Products 161 with STS. I managed to make it through all the steps except for the ones for STS Template. In the admin side it will let me activate Featured and change how many products I wanted displayed. It also let me add products to Featured. But when I try to go to my live site it won't come up. It shows this message: Fatal error: Call to a member function add_current_page() on a non-object in /home/doglady8/public_html/includes/application_top.php on line 312

I don't understand it, I never changed anything on that line of the code. It seemed like it was going pretty good. I did the manual install so none of the changes to text and colors would be lost.

Please help me out. This is the first contribution I've been brave enough to try to install but I thought since your instructions were so good that I would be able to do it. Now I don't know what to do unless I restore the backup I made before starting.

I'm at a stand-still! Please help me figure out what is wrong.

Carol,

An easy solution would be for you to use a file comparison utility such as Beyond Compare or WinMerge to compare your files with those from the contribution. This will quickly show you where you may have gone wrong.

Hope this helps,

kmb40 · August 6, 2008

We've installed 1.59 and everything works as suggested with one exception. The only products that will show in the featured box on the front page are specials. Products that are not currently in the specials sections will not show in the features display on the front page.

Any ideas?

MindTwist · August 7, 2008

Hi - there seems to be *BUG* with the latest (1.61) version of this contribution... The author adds joins for the Special products (evidentally to display the prices, etc...), however this makes it so that NO featured products will be displayed UNLESS they are on special...

I fixed mine (for the moment) by using the includes/modules/featured.php file in the Contribs page just before the 1.60 (or 160) update...

+1 on that...

I just came here after trying to install Featured Products 161 with STS 453 instructions.zip on my store. Everything seems to be working quite well, except for the fact that only "featured products" that have a "special price" will be showing up on the featured products boxes.

There is a post from yesterday that says this also happens with 1.59 installed, so I will try to compare SQL queries on the latest versions to try and find out how to fix it, but with the version I have installed myself, Out of all the products I add as featured, they will only show uyp as featured on the store if they have a special price.

MindTwist · August 7, 2008

Since everything else seems to be working fine, I just changed the file /includes/modules/featured.php by a previous version, looking for one that would work ok and show products that do not have a special price.

I have installed the latest version available as of today, "Featured Products 161 with STS 453 instructions" uploaded by Phocea on 25/Jun/2008

I tried the file /includes/modules/featured.php from 1.60, also by Phocea on 25/Jun/2008. No luck, I was geting a strange SQL error, probably that's why he uploaded 1.61 the same day.

I then tried the small featured.php file uploaded by itjust on 10/Jun/2008. That one seemed to work ok and I was seeing all products, but it displays no prices at all. No normal prices, no special prices, just the products :(

Then I went all the way back to 1.5.9, uploaded by bkellum on 15/Jul/2007. Using the included /includes/modules/featured.php on that version, my problem has been solved. Now all the featured products I select will be shown, no matter if they have special price or not.

kmb40 · August 7, 2008

Since everything else seems to be working fine, I just changed the file /includes/modules/featured.php by a previous version, looking for one that would work ok and show products that do not have a special price.

I have installed the latest version available as of today, "Featured Products 161 with STS 453 instructions" uploaded by Phocea on 25/Jun/2008

I tried the file /includes/modules/featured.php from 1.60, also by Phocea on 25/Jun/2008. No luck, I was geting a strange SQL error, probably that's why he uploaded 1.61 the same day.

I then tried the small featured.php file uploaded by itjust on 10/Jun/2008. That one seemed to work ok and I was seeing all products, but it displays no prices at all. No normal prices, no special prices, just the products :(

Then I went all the way back to 1.5.9, uploaded by bkellum on 15/Jul/2007. Using the included /includes/modules/featured.php on that version, my problem has been solved. Now all the featured products I select will be shown, no matter if they have special price or not.

Hi Mindtwist. Thats exactly what I had to do verbatim to resolve my issue. Seems like somewhere along the line after the revised bkellum version, the DB query stopped showing all of the products and or prices.

It would be nice to have these versions better governed. maybe every install has to be changed docs only. Or every package has to include all documents , including revised docs.

August 12, 2008

Can someone PLEASE advise on how you can sort the featured products by price and ensure it doesn't randomly display the products? I have searched everywhere and have found no answers and I can't have this featured products on the home page displaying products on the fly, it needs to be set. As a suggestion, I would include this functionality in this contribution as a rather important aspect.

Brenda

bkellum · August 12, 2008

Can someone PLEASE advise on how you can sort the featured products by price and ensure it doesn't randomly display the products? I have searched everywhere and have found no answers and I can't have this featured products on the home page displaying products on the fly, it needs to be set. As a suggestion, I would include this functionality in this contribution as a rather important aspect.
Brenda

Brenda,

As a quick solution, download and install my version of the contribution. I know it gives you complete control over the products listed (that is one of the best features of the Featured Products contribution to begin with).

MindTwist · August 12, 2008

Can someone PLEASE advise on how you can sort the featured products by price and ensure it doesn't randomly display the products? I have searched everywhere and have found no answers and I can't have this featured products on the home page displaying products on the fly, it needs to be set. As a suggestion, I would include this functionality in this contribution as a rather important aspect.
Brenda

You want Featured to show the products you choose? Then choose only the number of products you are displaying on the main page... If you are displaying maybe 6 products, don't "feature" more than 6 products, and those will always be showing on the main index.

If you want to sort the, edit /includes/modules/featured.php and you need to replace on the SQL queries "order by rand($mtm)" for something like "order by p.products_price". Notice there are two SQL queries, one for the index, and one for sub categories.

August 12, 2008

Brenda,

As a quick solution, download and install my version of the contribution. I know it gives you complete control over the products listed (that is one of the best features of the Featured Products contribution to begin with).

Hi, This is the product I downloaded and installed; featureds Products 161 with STS. Everytime the home page is refreshed the items are randomly ordered. I'd be happy to accept a sort by price as long as it sticks, but that doesn't seem to happen. it would be nice if the featured products had a sort like the product sort contribution so you can explicitly set the items you want in your own desired orders vs price, mfg, etc.

August 12, 2008

You want Featured to show the products you choose? Then choose only the number of products you are displaying on the main page... If you are displaying maybe 6 products, don't "feature" more than 6 products, and those will always be showing on the main index.

If you want to sort the, edit /includes/modules/featured.php and you need to replace on the SQL queries "order by rand($mtm)" for something like "order by p.products_price". Notice there are two SQL queries, one for the index, and one for sub categories.

The number I am displaying on featured is what is set in the admin tool. All the products are being diaplsyed as desired, it is just the sort order and on every page load it keeps changing. I did try changing the rand with no success, but will try again, perhaps I missed one of the statements. Thanks.

August 12, 2008

I installed V 1.59 of Featured Products and have encountered a very strange issue. If I enable Display Featured Products, and use the mods shown, the center column displays the featured products as expected. However, then nothing in any category or sub category will display. When you click on a category or subcategory, only the featured products show. I also am using the SPPC mod. My setup is php 5.2.5, osCommerce 2.2-MS2, mySQL 4.1.22. :blink: Any ideas?

August 12, 2008

Thank you!!!! It is now working perfectly! I must have missed the second occurence to change before.

Brenda

Tsuri Japan · August 14, 2008

I'm having strange problems with this contrib...it's working on my site but it's only showing one product in the main index even though I have selected 6 or so. On the right info box I have the featured section working fine with alll 6 products showing up right. Why won't the index section not work right?

Thanks,

Nigel

Edited August 14, 2008 by Tsuri Japan

ivanrok · August 15, 2008

hi

the same problem , in the center module of index.php just show 1 product (even if in the admin section I have 6 prods to shown), and looking for why , I found that the only product shown is in "specials" too. so the central module it only shows prods that are in specials too .

I have this contribution : Featured Products 161 with STS 453.

I don't work with STS

solution?

bye

Edited August 15, 2008 by ivanrok

Tsuri Japan · August 15, 2008

I ran into the same problem and this solved it for me as well and is probably worth repeating:
I downloaded the package 'Featured Products 161 with STS 453 instructions' and installed everything but did not have the Featured Products section show up on my store's homepage. I repeated the entire install thinking I missed something with no luck.

Following Didgemandu's suggestion I went to the submission titled: 'featured.php now showing products from all nested subcategories' and uploaded the file: includes/modules/featured.php and the Featured Products displayed properly on my homepage.

Here's the file you'll need:

http://addons.oscommerce.com/info/651

To find the message about this just go to page 11 I think and you'll find it!

Just in case here's the post that totally got this to work:

http://www.oscommerce.com/forums/index.php?s=&...t&p=1273107

Got it, this worked for me! Great contrib because I was doing a sale on one of my catagories.... then I dropped this contrib below the banner where the sale is being promoted!! Perfect for sales then adding the items you want to sell below it!!!

Thanks very much.....

Nigel

Edited August 15, 2008 by Tsuri Japan

ivanrok · August 15, 2008

hi

ok it works, but that archive would have to be in the last version (I think)

thanks

bye

August 16, 2008

It was all going so well LOL! Back end seems find but this error at the front?

1146 - Table '******_osc2.TABLE_FEATURED' doesn't exist

select featured_id from TABLE_FEATURED where status = '1' and now() >= expires_date and expires_date > 0

[TEP STOP]

I ran both sql queries/files and I can see the table in the list and view it but outside of that I don't know what else to do, could someone in the know please direct me in a wee solution, purty please? :blush:

Thanks

Heather

August 16, 2008

No matter, I installed the back up for now as I have the weekend child free to work on things and I needed to be able to view the front page for design edits. I will try again another day. cheers!

August 16, 2008

It was all going so well LOL! Back end seems find but this error at the front?
1146 - Table '******_osc2.TABLE_FEATURED' doesn't exist

select featured_id from TABLE_FEATURED where status = '1' and now() >= expires_date and expires_date > 0

[TEP STOP]
I ran both sql queries/files and I can see the table in the list and view it but outside of that I don't know what else to do, could someone in the know please direct me in a wee solution, purty please? :blush:

Thanks

Heather

It appears you might have run the same sql setup twice. Select the corect ersion to setup, open phpMyAdmin and first run a query using the DROP table NAME_OF_TABLE. That will clean out the old tables. The run the correct script to set up the table you need.

Good luck!

:rolleyes:

Edited August 16, 2008 by mmeachm

August 17, 2008

It appears you might have run the same sql setup twice. Select the corect ersion to setup, open phpMyAdmin and first run a query using the DROP table NAME_OF_TABLE. That will clean out the old tables. The run the correct script to set up the table you need.

Good luck!

:rolleyes:

Thank you, it is very possible that I did that, another lesson learned, tables dropped and all is well. Cheers :)

zaini · August 17, 2008

Hello,

thanks for the contrib !

I would like to display this FEATURES MENU in the main menu, not on the left column...

And I'd like to display a black background on this "feature" area.

Is it possible or not?

Thanks a lot !

zaini · August 17, 2008

For background color:

in featured_products.php :

modify to

Featured Product Support v1.5.4

Recommended Posts

bkellum

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

germ

bkellum

jerrymc

Carol_A

bkellum

kmb40

MindTwist

MindTwist

kmb40

Guest

bkellum

MindTwist

Guest

Guest

Guest

Guest

Tsuri Japan

ivanrok

Tsuri Japan

ivanrok

Guest

Guest

Guest

Guest

zaini

zaini

Join the conversation

germ

bkellum

Browse

Activity