Limit date range of items in Whats New page?

[modal]

Hi,

 

Is there any "quick" way to limit say, the date range on the number of items in the "Whats New" page?

 

I know you can set the number of items to display on the page in OS admin, however my understanding is that this setting is literally just that - ie. a display setting - and doesn't seem to prevent the page from counting every item in the store, however long ago it was added.

 

My client only wants to limit this page to the last 12 items they've loaded onto the store and not all 300+....

 

 

Is it a case of going and hacking the code...? :'(

 

Any tips or pointers gratefully received.

 

Regards

 

MarkW

[♥Monika in Germany]

Hi,

 

Is there any "quick" way to limit say, the date range on the number of items in the "Whats New" page?

 

I know you can set the number of items to display on the page in OS admin, however my understanding is that this setting is literally just that - ie. a display setting - and doesn't seem to prevent the page from counting every item in the store, however long ago it was added.

 

My client only wants to limit this page to the last 12 items they've loaded onto the store and not all 300+....

Is it a case of going and hacking the code...?  :'(

 

Any tips or pointers gratefully received.

 

Regards

 

MarkW

<{POST_SNAPBACK}>

 

that is what it already does by default. Set it to 12 in admin. The query selects all items, sorts by date added (newest first, then takes as many as you have specified in admin, starting from the top:

order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

[modal]

Monika, thank you for your reply. Sorry its taken me so long to acknowledge... swamped with work... :-(

 

I'm an OSCommerce first-timer so if I appear a little green then thats my excuse why. I will check this out further.

 

Mark

 

Ps. As is often the case, the client wants it all done by yesterday and is the type of person who is more impressed by spinning Flash logos... sigh... so I rarely seem to get time to really get into any serious coding...