CustomerGroups
Returns a list of customer groups.
Table Specific Information
Select
The driver uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:
- Id supports the = comparison.
- Name supports the = and LIKE comparisons.
- IsDefault supports the = comparison.
- IsGroupForGuests supports the = comparison.
- DateModified supports the =, <=, >=, <, and > comparisons.
The rest of the filter is executed client-side within the driver. For example, the following queries are processed server-side:
SELECT * FROM CustomerGroups WHERE Id = 1
SELECT * FROM CustomerGroups WHERE IsDefault = "true"
SELECT * FROM CustomerGroups WHERE IsGroupForGuests = "true"
SELECT * FROM CustomerGroups WHERE DateModified = '2024-12-27 01:20:31.0'
SELECT * FROM CustomerGroups WHERE DateModified <= '2024-12-27 01:20:31.0'
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Id of the customer group | |
| Name | String | Name of the group | |
| IsDefault | Boolean | Determines whether new customers are assigned to this group by default. | |
| CategoryAccessType | String | Type of the category access. | |
| CategoryAccessCategories | String | An array of category IDs. | |
| IsGroupForGuests | Boolean | Describes whether the group is for guests. There can only be one customer group for guests at a time. | |
| DateCreated | Datetime | Date on which the customer group was created. | |
| DateModified | Datetime | Date on which the customer group was last modified. | |
| DiscountRules | String | A collection of discount rules that are automatically applied to customers who are members of the group. |