No separate "parent product" entity — you encode attributes directly in the SKU
and reports group them by common prefix.
🔤
SKU with common prefix
Each size × color × material combination is an independent SKU:
SHIRT-COTV.M.WHT.COT, SHIRT-COTV.L.WHT.COT,
SHIRT-COTV.M.BLK.MIX. The common prefix SHIRT-COTV.*
groups all combinations of the same model in searches and reports.
Why it matters: separate stock per SKU (not aggregated),
price and discount configurable per SKU, and reports that automatically
aggregate by prefix — see which sizes / colors sell.
You define the naming convention at onboarding.
📥
Bulk import from Excel / CSV
When you receive a new collection, you prepare in Excel the columns
SKU, name, price, quantity (one line per combination
following your prefix convention), export CSV and import.
The system creates the missing SKUs, updates the stock of existing ones
and prepares the labels for printing.
🏷️
Barcode labels per SKU
Each SKU generates a unique barcode (EAN-13 or Code-128). Label templates
(name + size/color from SKU + price + barcode) for
Zebra / Godex / Argox printers.
Reprint when labels get damaged or when seasonal prices change.
📊
Reports grouped by prefix
"SHIRT-COTV.* sold 47 units this month. Detail:
M.WHT: 18, M.BLK: 12, L.WHT: 9, L.BLK: 5, S.WHT: 3."
You order from the supplier only the sizes / colors that move.
You reduce overstock on dead combinations.