Portal | Homepage | Blog

Creating Amazon Apparel Names using NscSync


#1

Amazon Index

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

Amazon 501. Frequently Asked Questions (FAQ)