About Club osCommerce

Showcasing osCommerce - the good, the bad and the ugly!

StumbleUpon It! DIGG It!

Just a few products? Dump the categories…

Written By Gary on Apr 03 2008 ·

Years back I had a client who had only a few products in his store. Rather than use the category infoBox I rewrote it to simply give a direct link to each product.

It's funny that I was looking at that store the other day (it's on the Hot 100 list), and today someone in the osCommerce Forum asked for exactly the same thing.

Rather than try to find the file I used on that old site, I just rewrote the script. 2 minutes later, and here we are;

PLAIN TEXT
PHP:
  1. <?php
  2. /*
  3.   $Id: categories.php
  5.   osCommerce, Open Source E-Commerce Solutions
  6.   http://www.oscommerce.com
  8.   Copyright (c) 2003 osCommerce
  10.   Released under the GNU General Public License
  11.  
  12.   Copyright (c) www.clubosc.com
  13. */
  14. $products_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by pd.products_name ");
  15. ?>
  16. <!-- categories //-->
  17.           <tr>
  18.             <td>
  19. <?php
  20.     $info_box_contents = array();
  21.     $info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES);
  22.  
  23.     new infoBoxHeading($info_box_contents, false, false);
  24.  
  25.     $products_list = '<ul>';
  26.     while ($products = tep_db_fetch_array($products_query)) {
  27.       $products_list .= '<li><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">' . $products['products_name'] . '</a></li>';
  28.     }
  29.     $products_list .= '</ul>';
  30.  
  31.     $info_box_contents = array();
  32.     $info_box_contents[] = array('text' => $products_list);
  33.  
  34.     new infoBox($info_box_contents);
  35. ?>
  36.             </td>
  37.           </tr>
  38. <!-- categories_eof //-->

What this script will do is simply list all your products in a long list, instead of the category box. Easy as 123, eh?

Obviously if you use this script, you will need to set a style on the <ul and maybe the <li - depends upon what you want the list to look like ;)


Buy Gary A Beer?
Buying me a "beer" helps me to keep my contributions updated and keep this blog alive. Cheers!


3 Comments

  1. Hi Gary,I have a potential client that only offers 1 product to sell. This looks like it could work for this situation. Thanks for the tip!

    Ron

    ps - I like this blog…lots of good info here.

    Comment by Ronaldinho53 — June 26, 2008 @ 1:05 pm


  2. Ron - should work just fine - let me know?

    Comment by Gary — June 26, 2008 @ 1:19 pm


  3. Thanks. I am meeting with him next week so I will keep you posted.

    Comment by Ronaldinho53 — June 27, 2008 @ 6:18 pm


Leave a comment

RSS feed for comments on this post · TrackBack URL

Hot 100 osCommerce Shops

View the osCommerce HOT 100These are the best looking, most exceptional osCommerce Stores as voted for by you.

New to osCommerce - get inspiration from these beautiful shops. Reckon your site has what it takes to become a member of the HOT 100? Submit it!