Items: Item Information

Returns detailed information about items that have been created or updated in the past 7 days. Item information includes the preferred vendor. Used in project involving development of a custom Product Information Manager (PIM).

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Source: https://timdietrich.me/blog/netsuite-suiteql-product-information-manager-sync/
SELECT
	Item.ID,
	Item.ItemID,
	Item.Parent,
	Item.ExternalID,
	Item.IsInactive,
	Item.IsOnline,
	Item.ItemType,
	Item.CreatedDate,
	Item.LastModifiedDate,	
	Item.PurchaseDescription,
	Item.QuantityOnHand,
	Item.QuantityBackordered,
	Item.ReorderPoint,
	Item.Cost,
	Item.LeadTime,
	ItemVendor.Vendor AS PreferredVendorID,
	Vendor.Companyname AS PreferredVendorName,
	Vendor.Externalid AS VendorExternalID
FROM
	Item
	LEFT OUTER JOIN ItemVendor
		ON ( ( ItemVendor.item = Item.id ) AND ( ItemVendor.preferredvendor = 'T' ) )
	LEFT OUTER JOIN Vendor
		ON ( Vendor.id = ItemVendor.vendor )
WHERE
	( Item.CreatedDate >= ( CURRENT_DATE - 7 ) )
	OR ( Item.LastModifiedDate >= ( CURRENT_DATE - 7 ) )

Click here to return to the list of available queries.