write a suiteql query to get all product categories by hierarchy level

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can use SuiteQL to get all product categories by hierarchy level. However, the exact query would depend on how your product categories are structured in your NetSuite instance. Here is a general example of how you might structure this query:

sql
SELECT id, name, parent 
FROM item 
WHERE recordtype = 'category' 
ORDER BY parent, id

This query selects the

id

,

name

, and

parent

fields from the

item

table where the

recordtype

is 'category'. The results are ordered by the

parent

field first, then by

id

, which should give you a list of product categories by hierarchy level. Please note that this is a general example and may need to be adjusted based on your specific NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******