Any thoughts on retail apparel matrix item setup? With thousands of vendor colors as options, obviously we don’t want these setup as matrix options. Would it be best to use basic colors (Red, Blue, Black, etc..) and sizes (XL, L, M) and then capture the vendor color in custom non-matrix fields? Anyone using NRF Color codes/sizes as matrix options?
m
MGBC
05/16/2025, 6:49 PM
The trick here is properly accounting for inventory and picking/shipping orders.
In most cases when it comes to apparel, I've setup each combination of color/size/gender as unique items with a specific item numbering syntax
(ie 1234-M-RED-XL)
MGBC
05/16/2025, 6:49 PM
Then use a parent item to group them all together in reporting
MGBC
05/16/2025, 6:50 PM
Usually the problem is that the vendor has Cardinal Red and Heather Red as colors, but you can't combine these as just RED in netsuite, so you have to break them out into separate item records
MGBC
05/16/2025, 6:50 PM
So you know that you have 10 Cardinal Red and 10 Heather Red shirts vs 20 RED shirts
b
Brian
05/19/2025, 6:09 PM
Thanks for the reply. Thats what I am running into. Obviously using Matrix items will group them by parent, but the matrix options are where I am struggling. Obviously a never ending list of vendor colors like tacoma sunset and copper orange would not be very user-friendly, but you can't have two colors (orange) for the same matrix item unless they are unique somehow. This is why I am considering using NRF color codes for Matrix Options..
m
MGBC
05/19/2025, 6:31 PM
Yes I ended up using systematic color codes like Pantone or NRF as part of the item sku syntax