TAKU Retail
Request SupportEmail UsTerms & Policies
  • What is TAKU Retail?
  • What is TAKU Pay?
  • Watch how TAKU Retail Works
  • How to Sell on Every Channel with TAKU
  • Pricing Plans
  • How to Get Started
    • ✅Onboarding Checklist
    • ⚙️General Settings
      • Business Details
        • SKU & Account ID Formats
        • Financial Settings
        • Inventory Options Settings
      • Inventory Settings
        • Inventory Doc Formats
        • Units of Measure
        • Inventory Categories
        • Inventory Brands
      • Account Settings
        • Account Groups
        • Privacy Consent Capture
      • Money Settings
        • Currency Denominations
        • Cash Rounding
        • Tender Types
          • Creating / Editing Tender Types
          • Store Credits
      • Taxes
        • How Taxes Work in TAKU
        • Creating Sales Taxes
        • Creating Tax Rules
        • Creating Tax Categories
        • Tax Exceptions
      • Privacy Consent Capture
    • 🗺️Zones Settings (Multi-Store)
      • Adding / Managing Zones
      • Stock Allocations
      • Shippers
      • Inventory Doc Formats
      • Recurring Order Setup
    • 📍Store Settings
      • Salesscreen Settings
        • Sales Doc Formats
        • Sales Doc Settings
        • Store Policies
      • Setting up Picture Gallery
      • Return Settings
      • Store Payment Settings
      • Cashout Settings
      • Receipts
        • Receipt Builders
        • Email Receipts
      • Adding / Managing Stores
    • 🖥️Stations
      • Adding / Managing Stations
    • 🖨️Hardware Setup
    • 🔖Discount Controls
      • Restricting Discounts by Product
    • 👥Users & Access Rights
      • User Roles
      • Access Rights by Role
    • 📤Importing Data
      • 🏷️Importing Inventory
        • Matrix Product Import
      • 🙂Personal Accounts Import
      • 🏢Commercial Accounts Import
      • 📇Commercial Contacts Import
    • 🔁Transaction Recovery
  • Selling In Store (POS)
    • 🛒Sales & Returns
      • How to Make a Sale
        • Selling with Picture Gallery
        • Viewing & Selecting Line Items
        • Deleting a Line Item during a Sale
        • Clearing the Salesscreen
        • How to Park or Suspend a Transaction
        • Re-opening a Suspended or Parked Transaction
        • Creating Accounts during a Sale
        • Creating Products during a Sale
        • Price Editing during a Sale
        • Setting a Future Pickup Date
      • How to Return in the Return Screen
        • How to Return or Exchange in the Salesscreen
        • Offering Store Credit for Returns
      • Creating Pre-Orders (Prepaid)
      • Creating Pre-Orders (Unpaid)
      • Commitments (Recurring Orders)
        • Selling Repeat Products during POS Checkout
        • Managing Commitments
          • Generating Recurring Orders from Commitments
          • Skipping, Pausing or Voiding Commitments
        • Processing Recurring Orders
    • 🎯Discounts & Promotions
      • Manual Discounts
        • Applying Line Discounts
        • How to Apply Bulk Line Discounts
        • Applying Sub-Total Discounts
      • Automated Promotions
        • Price Levels
        • Category Promotions
    • 📦Inventory
      • Adding Inventory Items
      • Editing Inventory Items
      • Editing Inventory Prices
      • Receiving Reordered Inventory
      • Creating Matrix Products (Variants)
      • Editing Matrix Items
      • Creating Usage Detail
      • Printing Barcode Labels
    • 👤Accounts & CRM
      • Adding Personal Accounts (Customers)
      • Editing Personal Accounts (Customers)
      • Adding Commercial Accounts (B2B)
    • 💵Cash Management
      • How to Handle Cash
      • Opening the Till
      • Closing the Till
  • Selling Online
    • 🌐Start Selling Online
      • Online Products
        • Publishing Products Online
        • Re-Sorting Online Products
        • Creating Categories for your TAKU eCommerce store
      • Taxes & Payments
        • Online Taxes
        • Setting up Payments
          • Setting Up Online Payment Options
          • Setting Up Manual (Offline) Payments
          • Sorting Payment Options
          • Setting Your Payment Currency
          • Disabling A Payment Option
          • Mapping All Payments for Reporting
      • Pickup, Delivery & Shipping
        • Store Pickup
        • Scheduled Store Pickup
        • Local Delivery
        • Offering Free Shipping
        • Setting Up Shipper Options
      • Designing your Storefront
        • Designing your Online Store
        • Designing your New-gen Instant Site
        • Adding the "About Us"
        • Adding your Business Number
        • Adding a Logo to your Invoices
        • Adding "Shipping & Payment" Policies
        • Adding a "Return Policy"
        • Adding "Terms & Conditions"'
        • Getting Consent at Checkout
        • Adding a "Privacy Policy"
        • Enable/Disable Your Instant Site
    • 🧾Handling Online Orders
      • Fulfilling Online Orders
      • Buy Online Pickup In Store
      • Buy Online Return or Exchange In Store
      • Buy Online Pay In Store
      • Online Storefront Only
        • Signing into TAKU eCommerce (External)
        • Resetting your Password for TAKU eCommerce (External)
    • 📱Facebook / Instagram Shop
      • Facebook Shop
      • Instagram Shop
  • Marketing
    • 🔎Be Found Online Locally
      • Google My Business
      • Google Product Listings
    • 💬Live Chat
      • Facebook Messenger Live Chat
    • 📈Tracking Online Traffic
      • Facebook Pixel
      • Google Analytics
  • Apps
    • 💳Payments
      • In-Person Payments
        • 👑TAKU Pay
          • Business Verification
          • TAKU Pay Accounts
          • TAKU Pay Locations
          • Pairing TAKU Terminals
          • Unpairing TAKU Terminals
          • Terminal Payments
          • Card-Not-Present
        • Ⓜ️Moneris
      • Online Payments
Powered by GitBook

© TAKU Canada Ltd.

On this page
  • Examples
  • Product with One Option
  • Product with Multiple Options

Was this helpful?

  1. How to Get Started
  2. Importing Data
  3. Importing Inventory

Matrix Product Import

This article will guide you on how to successfully import matrix products

PreviousImporting InventoryNextPersonal Accounts Import

Last updated 1 year ago

Was this helpful?

If you will be importing matrix products, refer to the below article on how to properly add matrix products to the import file.

Refer to this article to setup inventory options:

When importing matrix products, special care needs to be taken when creating the import file.

  1. Download the inventory template by going to Settings > Import > Inventory List, and then selecting Create New Records Only, you will then be able to select Download Inventory Template

  1. Add the parent product to the import file

  2. Enter Parent into the Product Type column

  3. Fill out the Option Name(s) that this matrix will have (ie. Colour, Size) use Option Name 2, Option Name 3, and Option Name 4 if you will have more than 1 option.

  4. Directly under the parent product, add new rows for each of the product options available for this product

  5. For each product option, enter Child into the Product Type column

  6. Fill out the Option Name(s) and the Option Value(s) for each product option

Examples

Note that other mandatory columns were hidden so content would fit in this image

Product with One Option

In this example 9999007 is the parent product, it appears as the first product in this matrix import, the product type is set as Parent, and the option name has been entered but no value is required for the parent.

Each of the product options appear directly underneath the parent, the product type is set as Child, and Option Names and Option Values are fully filled.

Product with Multiple Options

This example uses multiple options Comic Series and Condition

Important Notes

  • The parent product and each product option should have it’s own unique SKU

  • All product options belonging to a parent must be in the rows directly under the parent, if a product option is separated from the parent it may result in errors when trying to import, or the product option will appear under the wrong parent

  • Inventory options that appear in import file must be setup before import otherwise it will result in import errors

  • There is a limit of 4 possible different options for each product

📤
🏷️
Inventory Options Settings