Jump to content

How to make new product listed first?


Guest mcservice2005
 Share

Recommended Posts

Guest mcservice2005

Hi Everyone:

I am wondering how can we make the new added product listed at the beginning at its category? The current setting of cubecart is that the newest added item is listed at the very last on its category.

Many many thanks, my friend.

Sincerely,

M

Link to comment
Share on other sites

includes/boxes/category.inc.php

SEARCH FOR

$results = $db->select("SELECT cat_name, cat_id FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_father_id = 0");

REPLACE WITH

$results = $db->select("SELECT cat_name, cat_id FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_father_id = 0 ORDER BY cat_id DESC");

Note red marked is the trick.

Link to comment
Share on other sites

Guest mcservice2005

Dear, thank you but that is not what I mean.

My concern is, not to re arrange the category but to rearrange the items listed under each category - as from the newest added items listed on the first page, rathen then on the last page.

Thank you very much ,my friend.

M

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...