• From: UK
  • Registered: 10/11/2009
  • Posts: 50

Topic: Sorting Item List

Is there a way to make the drop down item list sort by item name rather than item code?

I have added many items now using the item import module but if I do not know the code it takes a while to find the item on the list as they tend to be mixed up.

I know you can enable the product search but I would prefer to just be able to scroll down the list to find what I am looking for.

Is there a place in the code I can make a change to adjust this sorting?

  • From: UK
  • Registered: 10/11/2009
  • Posts: 50

Re: Sorting Item List

I have been looking through the code and have changed line 689 in ui_lists.inc from:

'order' => array('c.description','stock_id')

To:

'order' => array('c.description','s.description')

and line 754 from:

'order' => array('c.description','i.item_code')

To

'order' => array('c.description','s.description')

Where c = stock_category and s = stock_master

This seems to have worked as now my drop down item lists on the items and inventory, sales and purchase pages have been ordered by item name.

I think an option in the setup to do this would be a really useful addition.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Sorting Item List

Yes, a good idea, kerrsmith. Will you put in on the Wiki to go for 2.3.

/Joe

  • From: UK
  • Registered: 10/11/2009
  • Posts: 50

Re: Sorting Item List

I have added this to the wiki on the following page:

Wishlist and future development directions for next major releases

  • Registered: 03/29/2010
  • Posts: 14

Re: Sorting Item List

Hi Kerrsmith, thanks to your note that I am able to sort the item description in the sale drop dropdown menu.

I have another question to ask, how do I print the sales documents with the item description sorted in alphabetical order?

Thanks.

peace, peter.

6 Reply by apmuthu (edited by apmuthu 11/24/2013 11:17:44 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Sorting Item List

Which is the wiki page?

* Wiki Page Item - Add an option to sort item lists by item name

// To Joe/Janusz
Should it not be part of the core FA by being a config flag to switch between them?

Post's attachments

SortItemListByNamePatch.zip 467 b, 11 downloads since 2013-11-24 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • Registered: 03/29/2010
  • Posts: 14

Re: Sorting Item List

Is it possible to view the sales documents like sales orders, delivery notes, invoices where the item description is sorted in an alphabetical order instead of item code?

Thanks.

peter.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: Sorting Item List

Take the report in Excel and sort inside the report!

apmuthu's Website

  • Registered: 03/29/2010
  • Posts: 14

Re: Sorting Item List

Got it. Thanks.