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