Understanding matrix items

A matrix item is a product that has the same basic properties but is sold with multiple variations. For example, a store that sells clothing might create a matrix item for t-shirts that vary in size, color, and collar style. Similarly, a grocery store that sells "bake at home" pizzas might create a matrix item for pizzas that vary in size, crust, and toppings.

You can define up to three dimensions for a matrix item. Within each dimension you can define several attributes. For t-shirts, you might define dimensions like size, color, and collar style. For the size dimension, you might define size attributes such as extra large, large, medium, small, and extra small. Similarly, for the color dimension, you might set up color attributes such as white, black, gray, red, and blue, and for the collar style dimension, you might set up collar style attributes such as crew neck, v-neck, scoop neck, and polo neck.

Dimension: Size Color Collar Style

Attribute:

Extra Large

White

Crew Neck

Attribute:

Large

Black

V-Neck

Attribute:

Medium

Gray

Scoop Neck

Attribute:

Small

Red

Polo Neck

Attribute:

Extra Small

Blue

 

RMH automatically creates multiple component items based on the dimensions and attributes you define for the matrix item. For example, RMH would create 100 component items based on the t-shirt dimensions and attributes defined in the table above, e.g. Extra Large White Crew Neck, Extra Large White V-Neck, Extra Large White Scoop Neck, Extra Large White Polo Neck, etc.

You can save dimensions and attributes and reuse them in different matrix items. For example, a store that sells clothing might save the size dimension and attributes and reuse them for other types of clothing that use the same dimension and attributes, such as dress shirts or jackets. Each saved dimension (and attributes) is known as a dimension set.

Each attribute must be assigned a code. For example, for the size dimension, the attributes extra large, large, medium, small, and extra small would typically be assigned the codes XL, LG, MED, SM, and XS. The matrix lookup code is combined with the attribute codes to create the item lookup codes of the component items. You have the option to use a separator character, such as a dash, between the matrix lookup code and the attribute codes to make the item lookup codes easier to read, e.g., TSHIRT-XL-WHT-CRW. Item lookup codes can contain a maximum of 25 characters. You should ensure that the matrix lookup code, optional separator character, and attribute codes total 25 characters or less. Longer item lookup codes will be truncated.

When you create a matrix item, you can select a department, category, item tax, supplier, and barcode type. These matrix item properties are automatically assigned to the component items when they are created. If you want to change these properties in the component items, the best practice is to update the matrix item. When you save the matrix item, you have the option to update the properties of the component items to match the matrix item.

You can also enter a price and cost for the matrix item. The matrix item price and cost are automatically assigned to the component items when they are created. If you want to change the price or cost for all component items, the best practice is to update the matrix item. When you save the matrix item, you have the option to update the price or cost of the component items to match the matrix item. However, if you only want to change the price or cost of specific component items, you will need to make the change directly to the relevant component items. For example, if a store creates a matrix item for t-shirts and enters $15.99 as the matrix item price, this price is automatically assigned to all component items. However, the store might want to charge $16.99 for extra large t-shirts and $14.99 for extra small t-shirts. They would need to change the prices of those specific component items manually, or use Task 110: Change Item Prices in the Advanced Item Wizard to change the prices.