Customer Groups: Sheet CustomerGroups

Before you begin

This section describes the XLSX stucture for importing customer groups.

Follow these guidelines to properly structure your customer group file. To follow along, feel free to download an example file.

Important
  • This sheet is required for Customer Group import.
  • All columns must be present in the order specified below.
  • Do not change/translate the names of the columns.
  • Allowed names for this sheet: CustomerGroups (one word, no space)
  • Maximum number of rows: 800. More info here

Spreadsheet structure

Here is a list of every column in the sheet Customer Groups.

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

Column Letter Column Name Extra Info Allowed Values Required
A Customer Group ID If you have an existing customer group in your store with this Customer Group ID, it will be overwritten. If left empty, the customer group will be imported as a new customer group. Integer number
Minimum: -2147483647
Maximum: 2147483647
(Conditional)*
B Customer Group Name Text Yes
C Description Text No
D Approve New Customers Any value different than "Enabled" will be regarded as "Disabled". Enabled / Disabled No
E Display Company No. Any value different than "Enabled" will be regarded as "Disabled". Enabled / Disabled No
F Company No. Required Any value different than "Enabled" will be regarded as "Disabled". Enabled / Disabled No
G Display Tax ID Any value different than "Enabled" will be regarded as "Disabled". Enabled / Disabled No
H Tax ID Required Any value different than "Enabled" will be regarded as "Disabled". Enabled / Disabled No
I Sort Order Integer number
Minimum: -2147483647
Maximum: 2147483647
No
Note* (Conditional) fields accept empty values for the purposes of an ExcelPort import. There are cases when you might need a value for this field. More information in column Extra Info.