helpwith.salesorder.com
  • Read me first
  • Start!
    • How to move forward
  • Video Index
  • Live in 5
    • Step 4: Solution Plan
      • Workflow Guides
    • Must read: Data Migration
      • Read First: ASIC and presets
      • Transaction Migration Primer
      • Migrate transactions
      • Migrate from Quickbooks
        • How to categorize Quickbooks 'Open' Purchase Orders
    • Step 5: Launch Sequence
      • T -6: System Settings
      • T -5: Baseline preparation
      • T -4: 'Open' transactions
      • T -3: Trial balance
      • T -2: Set Stock levels
      • T -1: User testing / Dry run
  • Customer references?
  • Common Actions
  • Company
    • Workers and Users
      • Add new User login
      • Owners
  • Organizer
    • Memo
    • Contacts
    • Calendar
    • Email
    • Attachments and Linking
  • Expenses/Timesheets
    • Expense Claims
      • Mileage Claims
    • Timesheets
  • Sales Forecasting
  • Sales
    • Leads
    • Prospects
    • Customers
      • Credit Controls
    • Jobs
    • Sales Quote
    • Sales Orders
      • Common Sales Tasks
        • Pre-Authorization/Pre-Payment with BASYS
      • Ordered Item History
      • Stock Allocation
      • Pick-Pack-Ship Process
      • Sales Order List
      • Drop Ship
      • Special Orders (Just in Time)
      • Discounts
      • Prepayment/Deposit
    • Cash Sales
    • Sales Invoices
    • Payments from Customers
      • Processing digital Payments
      • Apply Credit Automatically on Payments
    • Customer Credit Notes
    • Customer Refunds
    • Delivery Notes (a.k.a Packing List)
    • Customer Statements
    • Shipments
      • Pick List
    • RMA
    • Commission automation?
  • Purchasing
    • Suppliers
    • Purchase Quotes
    • Purchase Orders
    • Cash Purchases
    • Item Receipts
    • Bills (Purchase Invoices)
    • Payments to Suppliers
    • Supplier Credit Notes
    • Supplier Refunds
    • PO Generator by Item
    • PO Generator by Order
  • Inventory Forecasting
    • Inventoro
  • Products/Services
    • Items - which ones?
      • Preferred Suppliers
      • Stock Items (SKUs)
      • Stock Assemblies
      • Kits
      • Non Stock Items
      • Group Item
      • 'Calculation' Items
      • Service Item
      • Matrix Item
    • Sites
    • Stock Adjustment
    • Stock Manager
    • Stock Locations
    • Categories, Tags and Attributes
      • Categories
      • Tags
      • Attributes
    • Images on Items
    • Item Extra Info
    • Price Levels
    • Price Lists
    • Advanced Price Lists
  • Banking
    • Cashflow Forecast
    • Checks
    • Bank Reconciliation
    • Petty Cash Accounts
    • Credit Cards
    • Money In and Out
  • Accounting
    • Accounting Periods
    • Payment Terms
    • Tax
      • Sales Tax
        • US Tax Codes
      • Tax Authorities
        • Working with HMRC (UK Specific)
      • Tax Codes
      • Tax Groups
      • Item Tax Options
      • VAT Returns
    • Currencies
    • General Journals
    • Memorized Transactions
    • Reverse Transactions
  • WMS: Warehouse Management
    • Stock View
    • Goods In
    • Goods Out
    • RMA
    • Shipping
    • Pallets
    • Kits and Assemblies
    • Stock Actions
    • Stock Count
    • Locations
    • History
    • Admin
    • Config
    • Barcode Scanner App â›­
    • Multipacks
    • Overship Tolerance
    • Expiry Date
  • WMS Setup
  • Third-party logistics (3PL)?
  • Shipping
    • FedEx Manager Integration
    • UPS WorldShip Integration
  • Reports
    • Classifications
    • Report Mailer
    • Email Reports on Schedule
    • Accounting Periods
  • Setup
    • Roles
    • Email templates
    • Payment Processors
      • Basys: low fees, VIP service
      • Authorize.net
      • Cybersource
      • PayPal
      • USAePAy
      • Paragon (PAYA)
    • Configuration
      • Company â›­
      • Memo â›­
      • Ref # â›­
      • Leads â›­
      • Prospects â›­
      • Customers â›­
      • Credit Controlsâ›­
      • Jobs â›­
      • Sales Quote â›­
      • Sales Order â›­
      • Sales Invoice â›­
      • Customer Credit Note â›­
      • Cash Sale â›­
      • Statements â›­
      • Shipment â›­
      • Customer Refund â›­
      • Delivery Notes â›­
      • RMA â›­
      • Pick List â›­
      • Supplier â›­
      • Purchase Quote â›­
      • Purchase Order â›­
      • Item Receipt â›­
      • Cash Purchase â›­
      • Bills â›­
      • Payment to Suppliers â›­
      • Supplier Credit Notes â›­
      • Supplier Refunds â›­
      • 1099 Categories â›­
      • Kit â›­
      • Accounts â›­
      • Accounting Periods â›­
      • VAT â›­
      • Email Accounts â›­
        • OAuth for Outlook 365 â›­
      • Company Security â›­
        • Two Factor Authentication
      • Classifications â›­
      • Document Templates â›­
      • Shipping Carriers
      • Sales Invoice â›­
      • Payments from Customers â›­
      • Sales Opportunities â›­
    • EasyPost â›­
    • Shipstation â›­
    • Web to Lead
    • Import data templates
    • Exporting Data
    • Your Account
  • Shopping Carts b2c
    • âš  Live Shopping Carts
    • Shopping Cart controls
    • Shopify â›­
    • BigCommerce â›­
    • Magento â›­
    • Woocommerce â›­
    • Prestashop â›­
  • Trade Acceleration Portal 2.0
    • TAP Users
      • Customers
      • Sales Reps
      • Sales Teams
      • Administrators
        • Configure barcode order entry
        • Get your Inventory List from QuickBooks
    • TAP UX
      • Global Brand Style
      • Themes
      • Pages
      • Blocks
        • Group Start
        • Plain Text
        • Image
        • Hyperlink
        • Menu Matrix
        • Title
        • Custom HTML
        • Block Configurations
          • Pixels and Percentages
          • Flex Box Settings
            • Flex Wrap
            • Justify Content
            • Align Items
            • Column/Row Gap
            • Align Content
          • Background
          • Dimensions
          • Border
          • Slider & Carousel
          • Margin Padding
          • Overflow Settings
      • Content Management System (CMS)
  • Trade Acceleration Portal 1.0
    • Configure barcode order entry
    • Get your Inventory List from QuickBooks
  • Customization
  • Volume Automation
  • EDI
    • EDI integration via XML
  • REST API
  • Schema Documents
Powered by GitBook
On this page

Was this helpful?

  1. Products/Services
  2. Items - which ones?

Matrix Item

PreviousService ItemNextSites

Last updated 7 months ago

Was this helpful?

Media

In certain cases, a particular product may have a number of different variants, each of which is represented by a distinct Item. For example, if you sell shirts the same basic shirt may come in three different sizes (small, medium, and large), and three different colors (red, green, and blue). A convenient way to represent this set of related Items is to use a Matrix Item.

A Matrix Item allows you to create and group together all the related Matrix Combinations (i.e. separate Items). This makes the creation and editing of the different combinations easier than if the associated Items were created one by one.

Note: Any Item can be designated a Matrix Item when it is created i.e. a Matrix Item is not a distinct Item in its own right. So for example, you can have Matrix Stock and Service Items, and you can even have Matrix Discount/Mark up Items.

How to Create a Matrix Item

Let's go through a simple example to show how Matrix Items work. We will use shirts as the basic product.

Step 1: Creating the required Attributes

First set up two attributes called Color and Size. The Color attribute can have values Red, Blue and Green. The Size attribute can have values Small, Medium and Large. For more information on Item Attributes see

Step 2: Create the Matrix Master Item

Create a Stock Item (or Non-Stock if you prefer) with an appropriate Item Code and a Description. Before saving, make sure that the Matrix Item checkbox is ticked. This indicates that the item is a Matrix Item. Enter the remaining details and save the Item.

After saving the Item, you will notice two things:

  1. The Matrix Parent Field indicates this is the Matrix Master.

  2. A Matrix Tab has appeared, showing the different Items corresponding to combinations in this Matrix. Initially, there is only one Item combination, which is the Master itself.

Additionally, you will now see a field called Item Code Alias. This field can be added only for the matrix parent item, but it is not a mandatory field. Any value entered here will appear for all Parent and Child Matrix items in the TAP list.

Step 3: Add Matrix Combinations

Now you have created the Matrix Master, you can add Item combinations based on different Attribute values. Click on Edit and go to the Matrix Tab.

Adding Matrix combinations is easy. Simply enter the new Item Code (remember the combination is a new Item), select the required Attribute values and click on Add Combination. The new Item will automatically appear in the Matrix Combination Table.

Note: The new Item will inherit all the values from the Item it is created from (including account mappings etc). If you want to change these values simply change them in the Item before clicking Add Combination.

You can edit any of the combinations by clicking the corresponding Edit button. Moreover, you do not have to use the Matrix Master to create more combinations. You can do this from any of the Matrix combinations as well.

Matrix Items
Attributes