I hereby nominate categories and tabs as the most neglected stepchild record in all of NetSuite history. In the last 12 or so years that I've been using NetSuite, I can think of one update that affected website categories - about 5 years ago, we finally got the privilege of being able to search them. The searching is terribly lacking, Only giving us access to 7 of the dozens of fields as columns or filters.
Here is a small list of the things that are unnecessarily painful when dealing with site builder categories:
[LIST=1]
[*]The only way to access most of the data in the record with a script is using nlapiloadrecord, the slowest and worst function available.
[*]trying to access the website or parent category (or 90% of the data fields) using nlapilookupfield completely fails
[*]Adding columns like web site, parent category, etc in a scripted search also fails
[*]The preferred category is returned as full text when called from a scripted search. the only way to get the actual preferred category ID is to once again use nlapiloadrecord to load the item record, wait forever for it to load, then extract the ID.
[*]Apparently website tabs are not categories at all. using nlapiloadrecord on a tab ID creates an ' unexpected error' within a script. There is no workaround, and no way to access the tab record via script.
[*]Categories are listed in the record browser only as a sublist under the inventory item record - they do not exist as their own record, nor are they listed in the scriptable records. Ridiculous.
[*]It's impossible to add a custom field to the category record
[*]Only one category can be chosen as the preferred category on the item record, even if that item lives in 3 different websites. It's generous to call the multiple websites feature an afterthought.
[/LIST]
Like every other aspect of the site builder platform, categories have been completely ignored for 10 years. Never mind that the vast majority of NetSuite customers still run their website on the zombie platform. I get that NetSuite wants to sell everyone on a large, expensive upgrade to SCA, but what about everyone else in the meantime? Having a 10-year-old website platform is aiken to driving a 60-year-old car. What would you think of Chevy if they were still selling a '55 station wagon in dealerships without a single upgrade?
NetSuite - Either admit to everyone that site builder is a zombie platform that will never get any improvements or bug fixes, or do something to address the many holes.
Consultants like me are the reason people are able to stay with NetSuite. It would otherwise be an unwieldy platform that is simply too much to master for the vast majority of NetSuite's customers. NetSuite doesn't seem to care what we think, or about fixing all the massive pain points that make dealing with the system unnecessarily miserable.Talented people who have options will simply choose to work on other platforms that aren't so bad.