Lightspeed R Series | Importing Matrix items

Lightspeed R Series | Importing Matrix items

Importing matrix items

To import inventory items via our Retail Imports team, please refer to this article.

 In Lightspeed Retail (R Series), a Matrix item is used to manage products that come in different variations, such as size, color, or material. Instead of creating separate products for each variation, you can create a single Matrix parent item and associate all variations under it.

To save time, especially when dealing with large inventories, you can import Matrix items in bulk using a spreadsheet. This article will guide you through the process.

The Item Import tool handles matrix items differently from normal singles and non-inventory items. Here is a full outline on how the Item Import tool handles matrix items upon creating and updating them.




Best Practices

  • Always test with a small batch import before uploading a large file.

  • Save a backup of your import file for future reference.

  • Keep attribute names short and descriptive (e.g., "Size" instead of "Shirt Size").

  • Ensure SKUs are unique across your catalog.

Considerations upon creating matrix items

  • Matrix items with new Attributes (1-3) can be created through an import.

Considerations upon updating matrix items

  • Matrix Description cannot be updated.
  • The following fields can be updated on matrix items. Changing these fields will update every variant in the matrix:
    • Brand
    • Category
    • Subcategory 1-9
    • Tax Class
    • Vendor
    • Item Type (Single/Non-Inventory/Assembly/Box)
    • Serialized (true/false)
  • The following fields can be updated on a matrix item. Changing these fields will update the individualvariant in the matrix:
    • UPC
    • EAN
    • Custom SKU
    • Manufacturer SKU
    • Price
    • MSRP
    • Online Price
    • Default Cost
    • Reorder Point
    • Reorder Level
    • Vendor ID
    • Publish to eCom
    • Tags (Clear Existing/Add)
    • Image 
  • Matrix Attribute Set cannot be updated (for example: changing Color to Color/Size)
  • Attributes (1-3) cannot be updated or removed.
  • Matrix items can be archived, but archiving variants will not archive the matrix itself.
  • Matrix items cannot be updated to be removed from a matrix.
  • The quantity on hand and unit cost of your matrix items can only be imported upon their creation. They can't be updated.

Importing Matrix items in the Lightspeed R Series streamlines inventory setup, ensures accurate product variations, and saves valuable time. With a well-prepared import file, you can easily manage products with multiple variations and keep your inventory organized.