Customers: Sheet Meta


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

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

The Meta sheet is useful for two primary purposes:

  • Data Validation: This is where Excel pulls the available values when validating your data. More information on data validation here.
  • User reference: For finding the appropriate customer groups.

Structure of the sheet

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

Column Letter Column Name Extra Info
A Statuses Enabled / Disabled
B Customer Groups All available Customer Group Names are listed here.
C,D Stores All Store IDs and their corresponding Store Names.