System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
Determine characteristics for your item. In this example we will use colour, size and gender. Determine Top level part number to represent the main part number. This will be better understood after reading this example.
For example, we have a style of shirt we will name SHIRT001. This style of shirt comes in 3 colours – Red, Green and Blue. The shirt also has 3 sizes – Small, Medium, Large. The gender for the shirt can be Male or Female.
Part numbers can only be 20 characters long in System Five so we will abbreviate the above characters. The abbreviations are as follows:
Red = RED Green = GRN Blue = BLU
Small = S Medium = M Large = L
Male = M Female = F
We will assign these attributes to identifiers we will call Size 1, Size 2 and Size 3. These Sizes do not mean actual sizes, they are only placeholders for other information. A name for the entire group of characteristics will be called MATRIX STYLE which will be set to SHIRT001.
It follows that: MATRIX STYLE = SHIRT001 Size 1 = RED, GRN, BLU Size 2 = S, M, L Size 3 = M, F
Now we need to determine the Part Number that represents a specific shirt. The part number will be in the format MATRIX STYLE-Size1-Size2-Size3. The entire part number included hyphens cannot exceed 20 characters long.
The resulting part number for a ladies, small and green shirt will be: SHIRT001-GRN-S-F
Each of these part numbers will need to be written into an Excel spreadsheet. In our example we will have the main MATRIX STYLE number with 18 sequences of the part number for a total of 19 part numbers.
The Excel file should be saved as a CSV file format. Do not open the CSV file in Excel after saving it. The resulting CSV file will be dataloaded into System Five.
The Excel file will look like the following image.
Data loading matrix items video
How the Clothing Matrix works Matrix Data Load - Companion article