Logo ExcelPort
  • All Products
Logo ExcelPort
Menu
  • Welcome
  • Features
  • Demo Page
  • Software Requirements
  • Installation & Update
    • OpenCart 1.x
    • OpenCart 2.x
    • OpenCart 3.x
  • Licensing
  • User Interface
    • Export
    • Export Filters
    • Import
    • Settings
  • Excel Spreadsheets
    • Example Files
    • Products: Bulk
      • Sheet Products
      • Sheet Attribute
      • Sheet Option
      • Sheet Recurring
      • Sheet Discount
      • Sheet Special
      • Sheet Image
      • Sheet Reward Points
      • Sheet Design
      • Sheet Meta
    • Products: Basic
      • Sheet Products
      • Sheet Meta
    • Categories
      • Sheet Categories
      • Sheet Meta
    • Options
      • Sheet Options
      • Sheet Meta
    • Attributes & Attribute Groups
      • Sheet Attributes
      • Sheet Attribute Groups
    • Customers
      • Sheet Customers
      • Sheet Addresses
      • Sheet Meta
    • Customer Groups
      • Sheet CustomerGroups
      • Sheet Meta
    • Orders
      • Sheet Orders
      • Sheet Products
      • Sheet Options
      • Sheet Downloads
      • Sheet Totals
      • Sheet Histories
      • Sheet Vouchers
      • Sheet Meta
    • Manufacturers
      • Sheet Manufacturers
      • Sheet Meta
    • Coupons
      • Sheet Coupons
      • Sheet History
      • Sheet Meta
    • Vouchers
      • Sheet Vouchers
      • Sheet History
      • Sheet Meta
  • Uninstallation
    • OpenCart 1.5.x
    • OpenCart 2.x
    • OpenCart 3.x
  • FAQ
  • Welcome
  • Features
  • Demo Page
  • Software Requirements
  • Installation & Update
    • OpenCart 1.x
    • OpenCart 2.x
    • OpenCart 3.x
  • Licensing
  • User Interface
    • Export
    • Export Filters
    • Import
    • Settings
  • Excel Spreadsheets
    • Example Files
    • Products: Bulk
      • Sheet Products
      • Sheet Attribute
      • Sheet Option
      • Sheet Recurring
      • Sheet Discount
      • Sheet Special
      • Sheet Image
      • Sheet Reward Points
      • Sheet Design
      • Sheet Meta
    • Products: Basic
      • Sheet Products
      • Sheet Meta
    • Categories
      • Sheet Categories
      • Sheet Meta
    • Options
      • Sheet Options
      • Sheet Meta
    • Attributes & Attribute Groups
      • Sheet Attributes
      • Sheet Attribute Groups
    • Customers
      • Sheet Customers
      • Sheet Addresses
      • Sheet Meta
    • Customer Groups
      • Sheet CustomerGroups
      • Sheet Meta
    • Orders
      • Sheet Orders
      • Sheet Products
      • Sheet Options
      • Sheet Downloads
      • Sheet Totals
      • Sheet Histories
      • Sheet Vouchers
      • Sheet Meta
    • Manufacturers
      • Sheet Manufacturers
      • Sheet Meta
    • Coupons
      • Sheet Coupons
      • Sheet History
      • Sheet Meta
    • Vouchers
      • Sheet Vouchers
      • Sheet History
      • Sheet Meta
  • Uninstallation
    • OpenCart 1.5.x
    • OpenCart 2.x
    • OpenCart 3.x
  • FAQ

Customer Groups: Sheet Meta

Important

Using this sheet is not obligatory. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Customer Groups.

This sheet is not regarded during import. Deleting this will not impact the import process in any way.

The Meta sheet is useful for Data Validation. This is where Excel pulls the available values when validating your data. More information on data validation here.


Structure of the sheet

To follow along, feel free to download an example file.

Column Letter Column Name Extra Info
A Statuses Enabled / Disabled
  • PRODUCTS
  • Products By Sector
  • OpenCart Extensions
  • OpenCart Themes
  • Dedicated Support
  • RESOURCES
  • Support
  • Videos
  • Blogs
  • Books
  • CONTACT
  • USA:   +1 617 600 6661
  • Europe:   +359 2 417 89 83
  • sales@isenselabs.com
All rights reserved. © 2025 iSenseLabs