Matrix - Unlock the Potential of Master Product Identification

Matrix Overview

The SapphireOne Matrix is commonly referred to as a colour-style matrix in the manufacturing industry. Typically, fashion apparel utilises a size-colour-style matrix for all their inventory, which also includes footwear. Manufacturers and retailers often employ a master product to identify inventory and then arrange a multidimensional grid that aligns size, colour, and style with the master inventory item. Once a size-colour-style matrix is established in SapphireOne, the Master ID, also known as the Parent ID, serves as the header, with the various sizes, colours, and styles listed beneath it. Each inventory item remains distinct.

The power of the SapphireOne size-colour-style matrix lies in its simplicity. By entering the Master ID and pressing the Tab key, it automatically brings up a matrix similar to a spreadsheet. You can then tab or click on the desired item and enter quantities into the corresponding grid. Alternatively, you can tab through each cell to add quantities or use a barcode scanner to scan the barcodes, which populates the quantity at the end of the grid.

Once the Order Client Invoice (OCI) or Order Vendor Invoice (OVI) is generated, the finished product is received by the client or vendor in the form of a Matrix Invoice. This invoice displays only one master line, which lists the various quantities, colours, and styles for a Vendor or Client Invoice. The advantage for the recipient is that the master item appears as a single line, which then shows the different sizes, quantities, and styles within that line. This method creates a condensed and simplified invoicing process for both customers and vendors. The Matrix also allows for the establishment of Items of Column Name and Row Name as a template and category for the Table Matrix.

A fashion matrix, or ‘Colour – Size Matrix,’ refers to the system by which fashion, footwear, and/or apparel retailers track product variants in a grid format. These manufacturers, distributors, and retailers manage their product variants by creating a multidimensional grid. This process involves aligning the colours of a stock line against the sizes. A matrix is an efficient tool not only for entering stock by size and colour but also for assessing variants for re-ordering and transfer purposes.

Matrix Inquiry

This Matrix Inquiry is directly linked to the creation of Table Items on the Controls Page within an Inventory Inquiry. The necessary Row and Column headings must be established here prior to creating table items in a Base Inventory Inquiry.

Selecting New , Modify or Look allows the user to add or Modify an individual Table entry.

The SapphireOne Matrix Data Entry initially presents you with a standard sales purchase Data Entry screen, where you add your inventory Matrix ID. We always select the Parent ID Inventory item for the Matrix, which is invariably a non-diminishing inventory item.

After selecting the inventory ID, Master ID, or the Parent ID – which is the non-diminishing ID – you enter a quantity and press the Tab key. You will then see the screen shown below. This screen enables you to adjust sizes and colours within the Matrix if necessary.

After you have selected the process, the screenshot below will be displayed. Depending on the number of sizes and colours you have set up, it will automatically align to a grid. This grid provides a vertical column on the left and horizontal rows across the top, creating various matrices. In the example screenshot below, the item is organised by colour on the left-hand side in the vertical column, while the varying stock amounts—such as size and quantity—are arranged from left to right along the horizontal row.

As a user, you have the option to click your mouse in each cell and enter a quantity. However, it is much simpler and faster to use the Tab key to navigate through each cell. By repeatedly pressing Tab, the system will highlight the corresponding size and colour, and then you can enter the quantity. Press Tab again, and it will move you to the next cell for a different size and colour. After entering all the sizes and colours, you simply hit the “process” button, which will consolidate all the entries into a single line, whether it’s for a sale or a purchase.


You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Was this helpful?

Previous Article

Bill of Materials

Next Article

Open to Buy