jayelkaake/enhancedgrid

Sorting of SKU is Weird

derikitz opened this issue · 2 comments

derikitz commented

How to fix the sorting issue for SKU's in the Enhance Grid?
below is the screenshot, how can I fix it? because it sorts it in a weird way like in the image sku100 the next should be sku101 instead its sku1000.
I need help so how to fix this?
screenshot from 2013-12-05 15 54 25

and another:
screenshot from 2013-12-05 15 56 19

DaveChild commented

This is pretty normal for sorting systems. SKUs are not numbers, they are mixtures of letters and numbers. SKU101 is "after" SKU1000 (the sorting compares each character in order, and all are the same until the sixth digit, which is "1" in the first SKU and "0" in the second SKU, so the second SKU comes first.

derikitz commented

thanks for clearing it out, but just to meet the clients need which part or which functionality of the extensions should I customize?..