Changing "All Products" Order on Main Page

[redturbo917]

Hello all,

 

I have a site where the older products are displayed at the bottom of the "All Products" section. I am looking for an easy way to control the order of products on this section of the main page.

 

I guess I could delete products, then relist them. I just wonder if there is a better way. :)

 

Thanks!

 

Mike

[♥geoffreywalton]

You can either "edit" the date added to manipulate which products are displayed first or you can change the order defined in the sql that gets the products to display

[kitka]

I have this problem too... can you explain how to edit the 'date added'? Is that via PHP MyAdmin, and if so what table would it be in?

 

Thanks for any help in advance!

 

Kitka

[♥geoffreywalton]

Personally I use the Contribution Easy Populate and a csv file like this

 

v_products_model,v_date_added,EOREOR

19LS4D,18-Apr-2008,EOREOR

22LS4D,18-Apr-2008,EOREOR

KDL20B4050U,18-Apr-2008,EOREOR

KDL20S3020U,18-Apr-2008,EOREOR

KDL20S3030U,18-Apr-2008,EOREOR

KDL20S3000U,18-Apr-2008,EOREOR

KDL23B4050U,18-Apr-2008,EOREOR

KDL26U3000U,18-Apr-2008,EOREOR

KDL26T3000U,18-Apr-2008,EOREOR

KDL40U3000U,18-Apr-2008,EOREOR

19W330DB,18-Apr-2008,EOREOR

L42VP01,18-Apr-2008,EOREOR

 

If you are doing it using phpmyadmin just browse all the product related files and I am sure you will find it.