1

Is there any upper limit on the number of customer groups in Magento CE?

1 Answer 1

3

99999, if we follow the maximum index in the db. A large amount can influence performances as customer pages are most of the time not cached but else, I do not see any problem to set that amount.

Here is the creation script of the table. The customer_group_id is a smallint with a length of 5 so the maximum index is 99999.

CREATE TABLE IF NOT EXISTS `customer_group` (
`customer_group_id` smallint(5) unsigned NOT NULL COMMENT 'Customer Group Id',
`customer_group_code` varchar(32) NOT NULL COMMENT 'Customer Group Code',
`tax_class_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tax Class Id'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Customer Group' AUTO_INCREMENT=4 ;

ALTER TABLE `customer_group`
ADD PRIMARY KEY (`customer_group_id`);

ALTER TABLE `customer_group`
MODIFY `customer_group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT  COMMENT 'Customer Group Id',AUTO_INCREMENT=4;
2
  • Can you please tell me in which file this written
    – Amit Bera
    Nov 10, 2015 at 17:42
  • you can find it in the customer_group table in you db. I edit my answer to complete it. Nov 11, 2015 at 8:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.