NetSuite: Use SuiteQL to Get Item Types and Counts

Published on October 30, 2024.

Here's a very simple SuiteQL query that returns the types of items that are setup in a NetSuite instance, and the count for each item type.

SELECT
   ItemType,
   COUNT(*) AS ItemCount
FROM
   Item
GROUP BY
   ItemType
ORDER BY
   ItemType
About Me

Hello, I'm Tim Dietrich. I develop custom software for businesses that are running on NetSuite, including mobile apps, Web portals, Web APIs, and more.

I'm the developer of several popular NetSuite open source solutions, including the SuiteQL Query Tool, SuiteAPI, and more.

I founded SuiteStep, a NetSuite development studio, to provide custom software and AI solutions - and continue pushing the boundaries of what's possible on the NetSuite platform.

Copyright © 2025 Tim Dietrich.