0

Im having some difficulties in understanding magento's sorting by NAME.
I have lots of products with names like the following and i dont understand why they appear like so :

Lorem ipsum #1 Alabama
Lorem ipsum #1 Cristiana
Lorem ipsum #10 Jack
Lorem ipsum #14 Connor
Lorem ipsum #2 Washington
Lorem ipsum #2 Kent
Lorem ipsum #1 Pall Mall
Lorem ipsum #1 Disease

Shouldn't all the products starting with Lorem ipsum #1 be displayed first?

Well,name sorting seems to have flaws since on my website they appear exactly like in the example from above where some products starting with Lorem ipsum #2 appear in front of other products that are starting with Lorem ipsum #1.

Can someone explain me why is this happenig and how to correct it?

Much appreciation.

DanCapitanDePlai
  • 457
  • 2
  • 6
  • 19

1 Answers1

1

Ideally the records would be retrieved from the DB using natural case sorting, but this is not possible in MySQL from what I know, outside of the curious case described in this SO post. To correct it you will need to change how the CatalogSearch module forms its queries.

Community
  • 1
  • 1
benmarks
  • 23,384
  • 1
  • 62
  • 84
  • Yesterday i got by this problem by paying more attention to getProductCollection's sorting. Thanks anyway. – DanCapitanDePlai Sep 06 '12 at 09:33
  • You should answer your question so others may benefit - I've seen this question before on Magento forums. – benmarks Sep 06 '12 at 12:01
  • Im the same user having the same problem. I asked the question in both sites in order to have more chances of getting an answer. I really dont remember what changes i did to make it work. – DanCapitanDePlai Sep 07 '12 at 14:49