To import inventory items via our Retail Imports team, please refer to this article.
Matrices are essentially a way to group similar items together by the attributes that they share. These similar items are referred to as "variants" and the attributes that they share are determined by their matrix attribute sets. Matrix attribute sets can have up to three attributes and Lightspeed Retail POS has three built-in matrix attribute sets:
- Color
- Size
- Color/Size
You can also create your own custom matrix attribute sets under Inventory > Matrix Attribute Sets.
Formatting to create matrix variants
To import new items as matrix variants, you need to format them in a specific way in your item import file. To help you understand how to format them, let's pretend you're trying to import a plain t-shirt that comes in three colors (red, blue and yellow). To import each variation of the t-shirt as a matrix variant, you would need to enter the following in your import file for each variant:
- Leave the Description column empty. Matrix variant names are created based on the Matrix Description + Attribute 1 + Attribute 2 + Attribute 3 columns.
- In the Matrix Description, enter "Plain T-Shirt".
- In the Matrix Attribute Set column, enter "Color".
- In the Attribute 1 column, enter the color of the variant (e.g. "Red").
- Format the rest of the columns as you would for any item you're importing.
By doing so, you would create a matrix called "Plain T-Shirt" under Inventory > Matrix and each variant within the matrix would be called:
- Plain T-Shirt Red
- Plain T-Shirt Blue
- Plain T-Shirt Yellow
Now, let's pretend you're trying to import a plain t-shirt that comes in three colors (red, blue and yellow), three sizes (small, medium and large) and 2 materials (cotton and tri-blend). You wanted to use a custom matrix attribute set for these t-shirts. To import each variation of the t-shirt as a matrix variant, you would first need to create the custom attribute set. You would call it "Color/Size/Material" and it would have three attributes (color, size and material). Then, you would need to enter the following in your import file for each variant:
- Leave the Description column empty. Matrix variant names are created based on the Matrix Description + Attribute 1 + Attribute 2 + Attribute 3 columns.
- In the Matrix Description, enter "Plain T-Shirt".
- In the Matrix Attribute Set column, enter "Color/Size/Material".
- In the Attribute 1 column, enter the color of the variant (e.g. "Red").
- In the Attribute 2 column, enter the size of the variant (e.g. "Small").
- In the Attribute 3 column, enter the material of the variant (e.g. "Cotton").
- Format the rest of the columns as you would for any item you're importing.
By doing so, you would create a matrix called "Plain T-Shirt" under Inventory > Matrix and each variant within the matrix would be called:
- Plain T-Shirt Red Small Cotton
- Plain T-Shirt Red Small Tri-Blend
- Plain T-Shirt Red Medium Cotton
- Plain T-Shirt Red Medium Tri-Blend
- Plain T-Shirt Red Large Cotton
- Plain T-Shirt Red Large Tri-Blend
- Plain T-Shirt Blue Small Cotton
- Plain T-Shirt Blue Small Tri-Blend
- Plain T-Shirt Blue Medium Cotton
- Plain T-Shirt Blue Medium Tri-Blend
- Plain T-Shirt Blue Large Cotton
- Plain T-Shirt Blue Large Tri-Blend
- Plain T-Shirt Yellow Small Cotton
- Plain T-Shirt Yellow Small Tri-Blend
- Plain T-Shirt Yellow Medium Cotton
- Plain T-Shirt Yellow Medium Tri-Blend
- Plain T-Shirt Yellow Large Cotton
- Plain T-Shirt Yellow Large Tri-Blend
Format to update matrix variants
When formatting matrix variants in your item import file, it's important to understand which columns will update every variant in the matrix and which will only update the individual variant. It's also important to note that matrix variants cannot be removed from a matrix through an import and that some columns cannot be updated.
Entering inventory data in these columns will update every variant in the matrix:
- Brand
- Category
- Subcategory 1-9
- Tax Class
- Vendor
- Item Type
- Serialized
Entering inventory data in these columns will update the individual variants in the matrix:
- UPC
- EAN
- Custom SKU
- Manufacturer SKU
- Price
- MSRP
- Online Price
- Default Cost
- Reorder Point
- Reorder Level
- Vendor ID
- Publish to eCom
- Clear Existing Tags
- Add Tags
- Image
- Archived
The following columns cannot be updated:
Column | |
Matrix Attribute Set |
|
Attribute 1-3 |
|
Archived |
|
Shop Quantity on Hand |
|
Shop Unit Cost |
|