Any thoughts on retail apparel matrix item setup? ...
# inventory
b
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
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)
Then use a parent item to group them all together in reporting
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
So you know that you have 10 Cardinal Red and 10 Heather Red shirts vs 20 RED shirts
b
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
Yes I ended up using systematic color codes like Pantone or NRF as part of the item sku syntax