Use Case:
When you need to generate a name for apparel to the Amazon standard.
Are using CRE. The same idea can be implemented for other POS systems, the field names will be different though.
CASE WHEN Inventory.IsMatrixItem = 1 THEN (
isnull(Inventory_AdditionalInfo.Brand, ‘’) + ’ ’ +
isnull((select name from nitrosell_webdepartment where id = nitroasl_pamtable.WebDepartmentID), ’ ') + ’ ’ +
isnull(nitroasl_pamtable.NSCBaseName, ‘’) + ’ ’ +
isnull(nitroasl_pamtable.NScSize, ‘’) + ’ ’ +
isnull(nitroasl_pamtable.NscColor, ‘’))
ELSE
dbo.ufn_InitCap(Inventory.ItemName)
END
Where
- Size is a NscPAM column
- Color is a NscPAM column