Specials & Products_new sort category & sub-category dropdown menu

-------------------------------
Products_new / What will it do?
-------------------------------

(Example) Currently if you had 1000 items in your site and a customer clicked on your Products_new.php page,
they would get a list of your hole site, pretty much of 1000 items 50 items in Specials.

They are shown in the order they
have been inserted, just in (reverse) latest first. You guys know what I mean.

So, if a customer wanted to see your latest products in a particular category / sub-category
they will probably have to browse through 20 or 30 pages. That would NOT be me! So, chances
are that you will lose a potencial sale with me.

Products_new dropdown menu mod is the solution to this issue.

1). Once a Customer clicks on Products_new.php your page will still display your 1000 items by pages.
+ a dropdown menu on the top of your page that will allow you to sort your 1000 items by categories.

2). That said,(Example) customer selects category (DVD Movies), page will refresh and show all product
in DVD Movies category in the order they have been inserted, just in (reverse) latest first.

3). Here's where it gets better! Now the customer is viewing all your DVDs in said category. The dropdown
menu will now allow the customer to sort the DVDs by Sub-categories in the order they have been inserted,
just in (reverse) latest first.


-------------------------------
Specials / What will it do?
-------------------------------

It is basicly the same as Products_new. (Example) Currently if you had 50 items in Specials and a
customer clicked on your specials.php page, they would get a list of all 50 items in Specials.

So, if a customer wanted to see your specials in a particular category / sub-category
they will probably have to browse more than they need to. So, chances are that you can lose a potencial
sale in the long run.

Again, Specials dropdown menu mod is the solution to this issue.

1). Once a Customer clicks on specials.php your page will still display 50 Special items.
+ a dropdown menu on the top of your page that will allow you to sort those 50 Special items by categories.

2). That said,(Example) customer selects category (DVD Movies), page will refresh and show all DVDs
with specials in DVD Movies category.

3). Here's where it gets better! Now the customer is viewing all your DVDs with specials in said category.
The dropdown menu will now allow the customer to sort the DVDs with specials by Sub-categories.

----------------------------------------------------------------------
----------------------------------------------------------------------


Awsome Script!!!! I had it costome made for my site couple years ago.

It will work for older versions Oscommerce, see it in action in the test site listed below.
For some reason it will not work for the latest versions of Oscommerce.

Someone with the knowledge & skills can fix this with eys closed.

By next month I will finish a keyword coded advance search result page w/ dropdown menu
to do the same as specials & products_new

www.youregiftbasket.com/specials.php
www.youregiftbasket.com/products_new.php


Guys, feel free to add on to these scrips. ENJOY!!!!!!!!!!!!!!!!!!!

This is a no brainner install, 1 cut & paste -- and -- 1 piece of script replaced

SIMPLE but allways, BACKUP!!!BACKUP!!!BACKUP!!!BACKUP!!! your files before!!!

It works for me, see test site

More...