Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

[Contribution] Featured Products for v2.3.x


64 replies to this topic

#1 DunWeb

  • Community Sponsor
  • 10,464 posts
  • Real Name:Chris Dunn
  • Gender:Male
  • Location:Tecumseh, Ontario, Canada N8N 1X8

Posted 09 February 2011, 07:55

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.

:|: Was this post helpful ? Click the LIKE THIS button :|:

:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:

:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:

#2 BenjaminJ.Gremillion

  • Community Member
  • 14 posts
  • Real Name:Benjamin J. Gremillion
  • Gender:Male
  • Location:Baton Rouge, LA

Posted 12 February 2011, 19:15

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?

#3 DunWeb

  • Community Sponsor
  • 10,464 posts
  • Real Name:Chris Dunn
  • Gender:Male
  • Location:Tecumseh, Ontario, Canada N8N 1X8

Posted 12 February 2011, 19:21

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
:|: Was this post helpful ? Click the LIKE THIS button :|:

:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:

:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:

#4 BenjaminJ.Gremillion

  • Community Member
  • 14 posts
  • Real Name:Benjamin J. Gremillion
  • Gender:Male
  • Location:Baton Rouge, LA

Posted 12 February 2011, 19:44

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.


#5 DunWeb

  • Community Sponsor
  • 10,464 posts
  • Real Name:Chris Dunn
  • Gender:Male
  • Location:Tecumseh, Ontario, Canada N8N 1X8

Posted 12 February 2011, 19:55

Ben,

Glad you got it working Ben.



Chris

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

:|: Was this post helpful ? Click the LIKE THIS button :|:

:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:

:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:

#6 altoid

  • Community Member
  • 536 posts
  • Real Name:Steve
  • Gender:Male
  • Location:Pennsylvania

Posted 16 February 2011, 23:46

Chris, I have this installed and it's working fine. Thank you for taking the time to modify this for 2.3.1.
SK
I am not a professional webmaster or PHP coder by background or training but I will try to help as best I can.
I remember what it was like when I first started with osC. It can be overwhelming.
However, I strongly recommend considering hiring a professional for extensive site modifications, site cleaning, etc.
There are several good pros here on osCommerce. Look around, you'll figure out who they are.

#7 DunWeb

  • Community Sponsor
  • 10,464 posts
  • Real Name:Chris Dunn
  • Gender:Male
  • Location:Tecumseh, Ontario, Canada N8N 1X8

Posted 16 February 2011, 23:55

Good to hear Steve.



Chris
:|: Was this post helpful ? Click the LIKE THIS button :|:

:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:

:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:

#8 ntracy

  • Community Member
  • 27 posts
  • Real Name:Tracy

Posted 19 February 2011, 07:37

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

#9 haxer

  • Community Member
  • 28 posts
  • Real Name:Haxer

Posted 20 February 2011, 02:40

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

#10 gaynorti

  • Community Member
  • 9 posts
  • Real Name:Gaynor Tilley
  • Gender:Female

Posted 06 March 2011, 16:37

Installation worked well first time. Thank you so much.

#11 muraduk

  • Community Member
  • 189 posts
  • Real Name:Muradali Esmail

Posted 14 March 2011, 23:38

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...

#12 DunWeb

  • Community Sponsor
  • 10,464 posts
  • Real Name:Chris Dunn
  • Gender:Male
  • Location:Tecumseh, Ontario, Canada N8N 1X8

Posted 15 March 2011, 00:30

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
:|: Was this post helpful ? Click the LIKE THIS button :|:

:|: Click Here to learn how I can help you with custom coding, add ons, security and templates :|:

:|: Need an Area Calculator, Pre-Paid Account, Virtual Pin, Auction or Layaway Add on ? Click Here :|:

#13 beerbee

  • Community Member
  • 11 posts
  • Real Name:Christoph
  • Gender:Male
  • Location:Berlin Germany

Posted 28 April 2011, 10:36

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

#14 birdrockdesigns

  • Community Member
  • 77 posts
  • Real Name:Dave

Posted 11 May 2011, 20:21

Fantastic work!

Thanks for this Chris.

#15 birdrockdesigns

  • Community Member
  • 77 posts
  • Real Name:Dave

Posted 11 May 2011, 23:18

Just a quick suggestion/question:

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

Thanks

#16 coelroy

  • Community Member
  • 44 posts
  • Real Name:Elroy
  • Gender:Male
  • Location:Cape Town, South Africa

Posted 30 May 2011, 15:55

Hi

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

Can somebody verify?

Regards

Elroy

#17 bksbeat

  • Community Member
  • 138 posts
  • Real Name:Gary

Posted 30 May 2011, 21:35

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

#18 VenkeetechJones

  • Community Member
  • 1 posts

Posted 02 June 2011, 14:31

It's work....

Thanks Chris

#19 epwork

  • Community Member
  • 22 posts
  • Real Name:Tiffany
  • Gender:Female
  • Location:Los Angeles

Posted 05 June 2011, 08:54

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

#20 epwork

  • Community Member
  • 22 posts
  • Real Name:Tiffany
  • Gender:Female
  • Location:Los Angeles

Posted 05 June 2011, 20:30

View Postepwork, 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.