64 replies to this topic

[DunWeb]

This is the official support thread for Featured Products v2.3.x for use with osCommerce version 2.3.x


Please post all questions here about this revised version. I will not be monitoring the Support Thread of version 1.6.3.

Please download the .zip here:

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

Edited by Jan Zonjee, 09 February 2011, 08:11.

[BenjaminJ.Gremillion]

Just installed featured products and I'm getting a SQL 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 '-0, MAX_DISPLAY_FEATURED_PRODUCTS' at line 6

select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_date_added DESC, pd.products_name limit -0, MAX_DISPLAY_FEATURED_PRODUCTS

Also, there's no listing for Featured under admin/configuration after the install.

Any ideas on what I may have done wrong?

[DunWeb]

Hi Ben,

Featured products should appear twice in your admin area. Once under configuration, which allows you to enable/disable the contribution and some other options and once under Catalog, where you select the products you wish to feature.

If you are not seeing these admin options, then you have not run the SQL statement properly. Use phpmyadmin to run the statement under the SQL tab.


Chris

[BenjaminJ.Gremillion]

Ok. I had a configuration entry with an id of 18 already so I changed it to 31 and all that looks fine. It's in both places in the admin panel now.


EDIT: and the rest works! Thank you very much!

Edited by BenjaminJ.Gremillion, 12 February 2011, 19:53.

[DunWeb]

Ben,

Glad you got it working Ben.



Chris

Edited by DunWeb, 12 February 2011, 19:55.

[altoid]

Chris, I have this installed and it's working fine. Thank you for taking the time to modify this for 2.3.1.
SK

[DunWeb]

Good to hear Steve.



Chris

[ntracy]

Hi Chris,

I installed this. It showed Featured Products in Subcategories, but the products in each sub categories didn't show up, just the Feature Products show up.
Did I do something wrong here?

Thanks,

Tracy

[haxer]

I already set Display Sub Cat when displaying featured products. But it still in front page only display all the products without SUb Categories title in it.

I thought it will be

Sub Category Title 1 : Products1,
Products2, and so on

[gaynorti]

Installation worked well first time. Thank you so much.

[muraduk]

Hi i have just installed this contribution...

There is one instruction i cannot follow

==============================
Step 5:
Edit the file /catalog/admin/includes/boxes/catalog.php:

Find:

array(
'code' => FILENAME_SPECIALS,
'title' => BOX_CATALOG_SPECIALS,
'link' => tep_href_link(FILENAME_SPECIALS)
),

Add After:

// BOF: Featured Products
array(
'code' => FILENAME_FEATURED,
'title' => BOX_CATALOG_FEATURED_PRODUCTS,
'link' => tep_href_link(FILENAME_FEATURED)
),
// EOF: Featured Products
======================================

In my /catalog/admin/includes/boxes/catalog.php there is no

array(
'code' => FILENAME_SPECIALS,
'title' => BOX_CATALOG_SPECIALS,
'link' => tep_href_link(FILENAME_SPECIALS)

The page is displayed as

=====================================
<!-- catalog //-->
<tr>
<td>
<?php
$heading = array();
$contents = array();

$heading[] = array('text' => BOX_HEADING_CATALOG,
'link' => tep_href_link(FILENAME_CATEGORIES, 'selected_box=catalog'));

if ($selected_box == 'catalog') {
$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_CATEGORIES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_PRODUCTS_MULTI, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_CATEGORIES_PRODUCTS_MULTI . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_MANUFACTURERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_MANUFACTURERS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_REVIEWS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_REVIEWS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_SPECIALS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_SPECIALS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_FEATURED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_FEATURED_PRODUCTS . '</a><br>' .
'<a href="' . tep_href_link(FILENAME_PRODUCTS_EXPECTED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CATALOG_PRODUCTS_EXPECTED . '</a>');
}

$box = new box;
echo $box->menuBox($heading, $contents);
?>
</td>
</tr>
<!-- catalog_eof //-->
==================================================

Can anyone help.... and advise why i can't follow that step..

Many Thanks in advance...

[DunWeb]

You are not running a version 2.3.1 website, you downloaded the wrong featured products. You need this one:

http://addons.oscommerce.com/info/651/v,22


Chris

[beerbee]

Hi,
just installed, everything fine just one little thing regarding multilanguage support categoy names:

changed in catalog/includes/modules/featured.php
line 15 from:

  $cat_name_query = tep_db_query('SELECT `categories_name` FROM ' . TABLE_CATEGORIES_DESCRIPTION . " WHERE `categories_id` = '" . $featured_products_category_id . "' limit 1");

to:

 $cat_name_query = tep_db_query('SELECT `categories_name` FROM ' . TABLE_CATEGORIES_DESCRIPTION . " WHERE  `language_id` = '" . (int)$languages_id . "' AND `categories_id` = '" . $featured_products_category_id . "' limit 1");

best regards
beerbee

[birdrockdesigns]

Fantastic work!

Thanks for this Chris.

[birdrockdesigns]

Just a quick suggestion/question:

Is there a way to add a sort order to the featured products, if so, how?

Thanks

[coelroy]

Hi

I picked up that when a featured product is on special, then the special price is not listed.

Can somebody verify?

Regards

Elroy

[bksbeat]

Okay folks, I have just added this contribution and it is great. All is working - Special thank you to those that created and contributed to it - Great Job. To see mine it is www.nontando.com
There are 3 things that I would additionally like to do:

1. How can add my specials (at its special prices) to the featured products, and it displays the special prices. I just added 2 items that fall under that category and it displays the original price. I know there is an option for specials in config, but that only will allow me to display items on special (it still displays the original price)and not other featured items not on special?

2. I would like to beautify the featured products box a bit (similar to the way the new products worked), i.e. change font, perhaps a border/box, etc. How would I do this.

3. One of the main reasons I added this contr, is the ability to have featured products selected and displayed for specific holidays, etc. Hence, i would like to be able to change the heading that currently says "Featured Products" to the applicable occasion, e.g. "Gift Ideas for Fathers Day". I know I can probably hard code it in index.php - just wondering if was a way without changing this file.

Thank so much, Gary

[VenkeetechJones]

It's work....

Thanks Chris

[epwork]

I've installed Featured Products and want to use the Column Box but for some reason it's not picking up the style like the other boxes do automatically. (other Boxes not included in template work fine when I enable/disable.) see my site here

AND it's linking to /featured.php instead of /featured_products.php and goes no where? Or is that correct and it was missing in my download? I thought maybe changing Step 7 in instructions for Box to featured_products.php but that didn't work?

I am using a template and have added featured_products to the vars_map.php file, but that didn't seem to do anything either.

Any suggestions would be appreciated.

Thanks in advance

[epwork]

epwork, on 05 June 2011, 08:54, said:

I've installed Featured Products and want to use the Column Box but for some reason it's not picking up the style like the other boxes do automatically. (other Boxes not included in template work fine when I enable/disable.) see my site here

AND it's linking to /featured.php instead of /featured_products.php and goes no where? Or is that correct and it was missing in my download? I thought maybe changing Step 7 in instructions for Box to featured_products.php but that didn't work?

I am using a template and have added featured_products to the vars_map.php file, but that didn't seem to do anything either.

Well, I've made good progress (I think) ... I have changed/added the div class(s) in the includes/modules/boxes/bm_featured.php file and changed the tep_href_link(FILENAME_FEATURED) to tep_href_link(FILENAME_FEATURED_PRODUCTS) so it links correctly.

Haven't tried if the carousel rotating featured products will work yet but will give it a shot. If there is a more proper way to correct/modify would love to know, should I add other mod/boxes in the future.