peterp Posted July 16, 2018 Share Posted July 16, 2018 Hi All, I have just changed the sorting sequence of the storefront using the store settings in admin to sort via a product code, unfortunately in one instance that I have found is that the sorting process has put the product code 'ACC-140' in front of 'ACC-81'. It seems that after some further investigation only one other product is seemingly out of sequence. Should I be looking somewhere else to make sure all products are sorted into the right sequence within there apropriate category Any help will be appreciated Best Regards, Peterp Link to comment Share on other sites More sharing options...
Claudia M Posted July 16, 2018 Share Posted July 16, 2018 I think that ACC-81 has to be ACC-081 and all product codes have to have the same amount of characters. Link to comment Share on other sites More sharing options...
bsmither Posted July 16, 2018 Share Posted July 16, 2018 MySQL does not do "natural sorting". There are hacks to get the same result, but it is a hassle to implement them in already written code. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.