I have a list in NetSuite that I'm using for a fac...
# suitecommercea
ANHE
03/19/2021, 5:11 PMI have a list in NetSuite that I'm using for a facet in SCA. The customer recently added some new values to it. The list is configured to display alphabetically in NetSuite ERP, but in the web store the list values are displayed by internalid increasing. The result is that the list is mostly alphabetical because that's the order in which values were created... but then with the new values chunked onto the end of the list and out of alphabetical order.
Is there a configuration that I'm missing?
I'm looking at another SCA instance where list values were created in non-alphabetical order, the list is set to display alphabetically in NetSuite ERP... and in the web store the list is shown alphabetically. New values have been added since implementation, and they are slotting correctly alphabetically. The configuration is the same.
What's missing in the first instance?
ANHE
03/19/2021, 5:29 PMUpdate: Viewing the list on the item record, the values are also out of order. This field isn't a custom field... it's a custom segment.
ANHE
03/19/2021, 5:32 PMThe custom segment has list order preference set to "sublist" instead of "alphabetical".
Solved!
ANHE
03/19/2021, 7:10 PM2nd Update: Wasn't solved but is now. The root source of the problem is a mix of some values being all uppercase while others are sentence case. SCA evaluates uppercase values as higher priority than lowercase; even when the list was alphabeticised SCA was listing all the uppercase values for a letter first, with sentence case ones after. Solution was to transition all the 'new' values to be uppercase also to make it work.
👍🏻 1
👍 1
g
Greg
03/22/2022, 6:09 PMone year later and I just came here to look for this exact same issue i am experiencing. Thanks so much! @ANHE
3 Views