Creating Inventory Matrix Items

<< Click to Display Table of Contents >>

Navigation:  Inventory > Keeping it Simple >

Creating Inventory Matrix Items

Creating matrix items in your inventory to track size/color etc. can provide you with useful information about your inventory and also help you see more quickly "holes" in your inventory sizing runs.  However, inventory matrices can be complicated to create and you should take your time when determining whether you should use matrix items in your inventory.

 

A few questions to ask yourself before using matrices are:

 

1.Are you going to be carrying the full matrix (all sizes and colors) of items? If you are only going to be carrying one size or color, it might be easier to just create the one or two items you are going to carry rather than creating a matrix for all potential colors and or sizes.

 

2.Are the sized items you going to have many different price points? If you have items that are sized that have very different costs and prices,  you are going to have to spend some time adjusting costs and prices after creating the matrix items.  This will increase the amount of time that it takes to input the matrix items initially and on reorders.

 

3.Are you going to be using the UPC as your stock number or using the UPC labels on the items for scanning? If you are using a UPC as a stock number (instead of the UPC1 or UPC2 fields in the inventory), you can't use the matrix feature.  Also if you are using UPC fields to allow you use the UPC label on the items, then you are going to be spending extra time editing these items to enter the different codes with each item.

 

Listed below are some of the advantages and disadvantages of using matrices:

 

Advantages

 

Allows you to see inventory quantities for all items in a particular matrix quickly by pressing the Quantity tab on the Matrix Parent item.

 

You can more quickly add a group of items to a purchase order or receiving by entering quantities on a matrix (size/color) grid.

You can use the matrix parents in packages and create packages that allow you to select different size sizes for items at the time of sale.

 

You can print barcode labels for matrix parents.  This may save time when physically tagging items as you only have one label to tag all sizes and color items.  Items tagged with matrix parent tags will prompt the sales person to select the proper size and color item.

 

Disadvantages

 

Does not work well for items with dissimilar costs and prices.

 

Can conflict with Vendor styles.  Some vendors might track colors but you don't care about tracking colors

 

Can create large number of inventory items that you will never have in your inventory.

 

Does not work if you are using a UPC for the item's stock number.