I want to sort the products by sku, is this possible? sku ascending

Comments

mogtofu33’s picture

Component: Miscellaneous » Code
Assigned: Unassigned » mogtofu33
Priority: Critical » Normal
Status: Active » Postponed

Currently sku sort is not supported, if more people need this feature and i get some time i will add this option.

Regards.
Mog.

mogtofu33’s picture

I try to add sku filter but unfortunatly SQL order is not natural, if your sku is numeric, order will be on first digit. i.e:
1
10
2
3
If you still need this feature, wait to download next dev release (probably 10-05-2011) and uncomment this lines:

uc_advanced_catalog.filters.inc: line 211, uncomment block from line 267 to 278
uc_advanced_catalog.pages.inc: line 163

But i'll give no support for natural ordering, you need to adjust your skus.

If someone got a solution (i don't want php function to make natural sort, it degrade performance)

Regards.
Mog.

thaistore’s picture

can you set the sku sort by default, and thank you for doing this. I will try.

Also I had to create a new view and sort them by SKU by default, but I lost all the good things that come with advanced catalog like selecting the posts per page....

I like this functionality, number of products per page. Is that something it can be added to default view?

I would like to customize the catalog view, is is possible in the future to make a catalog view under views?

thaistore’s picture

Priority: Normal » Critical

YES THAT IS CORRECT order

If I sort by sku in view, it is already correct, I have mixed numeric letter SKU

I downloaded your latest dev today, and the function is not there to sort by SKU, are you sure you added it?

thaistore’s picture

Status: Postponed » Active

any news about sorting by SKU, you said that you will add this feature in next release, but i cant see it

mogtofu33’s picture

See post #2 you need to edit files to get SKU filter.

mogtofu33’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.