Book Image

Deep Inside osCommerce: The Cookbook

By : Monika Mathe
Book Image

Deep Inside osCommerce: The Cookbook

By: Monika Mathe

Overview of this book

osCommerce has been around since March 2000. At present there are over 10,000 live, registered osCommerce sites, and about 100,000 registered community members. Apart from providing ready-made solutions to problems, as well as a huge repository of information, the osCommerce community is a living entity with which we can all interact. With the rising success and popularity of this remarkable piece of software, things can only get better.
Table of Contents (17 chapters)
Deep Inside osCommerce: The Cookbook
Credits
Foreword
About the Author
About the Reviewers
Introduction

63. Reset Date Added for Products


This recipe is perfect for you if you want to specify which products are showcased in the New Products box of your homepage and category pages. The New Products box uses the value of the products_date_added column of the products table for sorting, which makes a change in display fairly easy to achieve. You may want to be cheeky and reset items on purpose to get them up on the list, or you may use this feature after updating a product thoroughly, so it is basically a new product indeed. If you use this tool in the cheeky way a lot, consider renaming the box, as New Products will not fit any more.

Presentation

The following screenshot shows Administration | Catalog | Categories/Products with the DVD Movie Speed highlighted. Here you are about to have it reset as new:

As soon as the reset button is clicked, the products_date_added and products_last_modified columns in the products table are modified to hold the current date as shown here:

Let's skewer this...