Items: Customer Upsells

Returns a list of potential upsell items and item categories for a specific customer.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-upsell-items-by-customer/
SELECT
	BUILTIN.DF( UpsellItem.PurchasedItem ) AS ItemPurchased,
	BUILTIN.DF( UpsellItem.Item ) AS UpsellItem,
	( UpsellItem.CorrrelationFld * 100 ) AS Corrrelation,
	UpsellItem.CountFld AS Count,
	( 
		SELECT 
			 COALESCE( MAX( Price ), 0 )
		FROM 
			ItemPrice 
		WHERE 
			( Item = UpsellItem.Item ) 
			AND ( PriceLevelName = 'VIP Customer' ) 
			AND ( IsInactive = 'F' ) 
	) AS UnitPrice
FROM
	UpsellItem
WHERE
	UpsellItem.Customer = 237
ORDER BY
	Corrrelation DESC,
	Count DESC,
	ItemPurchased

Click here to return to the list of available queries.