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


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'

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;
  • Can you please tell me in which file this written – Amit Bera Nov 10 '15 at 17:42
  • you can find it in the customer_group table in you db. I edit my answer to complete it. – Christophe Ferreboeuf Nov 11 '15 at 8:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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