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
Structure of the sheet
Here is a list of every column in the sheet CustomerGroups.
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.