Would like new products to show up first,

[Guest lcools]

Hi,

I've been trying to fix this for awhile...When I add a product, it's added to the bottom of the list...I'd like it to go to the top of the list - for the customer ( although, it be nice in admin too)

Is this difficult, possible, in a mod?

I would appreciate any help.

Thanks!

Leila

[Guest Brivtech]

There's a nice free MOD over at www.cubecart.org that does this. Look for "Most Recent First" in the free admin utilities section.

I'll post an update there in a couple of days that allows it to work with products as well.

[Guest]

I made this mod a while ago and is very easy to install.

Just search in the free mods section for ''Latest Products to Show First'' ;)

[Guest lcools]

Hi Vrakas,

I found the mod but am unable to download-password problem.

Thanks so much,

Leila

I made this mod a while ago and is very easy to install.

Just search in the free mods section for ''Latest Products to Show First''

[Guest]

Try this link ;)

[Guest lcools]

First of all, thanks Brivtech. Got your mod for sorting admin products. Very cool. Thanks so much. One down, one to go!

I did update my viewCat.inc.php file with Estelle's mod, but i am getting a msql error.

I changed:

ORDER BY cat_name ASC

to

ORDER BY ".$glob['dbprefix']."CubeCart_cats_idx.productId DESC

but I am getting a msql error when I try to browse my shop products:

MySQL Error Occured

1054: Unknown column 'CubeCart_cats_idx.productId' in 'order clause'

QUERY = SELECT * FROM CubeCart_category WHERE cat_father_id = '9' ORDER BY CubeCart_cats_idx.productId DESC

I updated with your mod, Vrakas, and I also got a my sql error:

MySQL Error Occured

1054: Unknown column 'productid' in 'order clause'

QUERY = SELECT * FROM CubeCart_category WHERE cat_father_id = '9' ORDER BY productid DESC

I should say that my host recently updated to msql v5 and I'm still with 3.0.8

I am not sure what to do next.

If anyone has a clue....?

Thanks~

Leila

[Guest lcools]

I made some mysql5 changes, though I don't think that was the problem, then went back and redid Estelle's mod and it works fine now.

Thanks for all you helpful people.

Leila

[Guest]

You are welcome :D

[Guest Brivtech]

@ Vrakas - Hi Five!

:D