What command line determines order of featured products

[musicmaestro]

Guys

 

Hopefully an easy one for the experts.

 

What determines which product is shown first in the featured products on my home page?

 

I notice that everytime you add an item to the catolog it moves it done one in the featured list. Ideally I would like the SQL statement to perhaps show them by product_id order so first, second third items etc always show.

 

Thank you

[Guest]

If I'm looking at this right it should be in the includes/modules/new_products.php file. In the beginning there will be 2 sql statements that will search either by a category, or by everything. In each of these, you'll see the statement

order by p.products_date_added desc

All that you will have to do is change that to

order by p.products_id desc

And that should fix what you are looking to do.

[musicmaestro]

If I'm looking at this right it should be in the includes/modules/new_products.php file. In the beginning there will be 2 sql statements that will search either by a category, or by everything. In each of these, you'll see the statement

order by p.products_date_added desc

All that you will have to do is change that to

order by p.products_id desc

And that should fix what you are looking to do.

 

Yes, that was what I meant. I've changed the SQL statement and added an item to our store but it shifted the item to the right and the new one inserted itself as the first item.

 

I've checked the product_id number in phpmyadmin and the new item had a product_id number > the existing one.

 

Any other suggestions would be appreciated

 

BeauCowan: Thanks for your quick response.