We need to add 3 more column in the customer group table.

How to add it using script?

closed as unclear what you're asking by Jai, Piyush, sv3n, liyakat, 7ochem Jun 12 '18 at 12:50

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


Try this code

$installer = $this; 

$installer->getConnection()->addColumn($installer->getTable('customer_group'), 'my_custom_field1', 'varchar(100)');
$installer->getConnection()->addColumn($installer->getTable('customer_group'), 'my_custom_field2', 'varchar(100)');

  • Need to: 1st => With Decimal with price formate, 2nd => with Int – Ashish Kacha Jun 12 '18 at 11:09
  • 1
    "varchar(100)" replace to "DECIMAL(12,4)" and try – user68116 Jun 12 '18 at 11:13
  • What about For Int ? – Ashish Kacha Jun 12 '18 at 11:16
  • 1
    "varchar(100)" replace to "INT(11)" and try – user68116 Jun 12 '18 at 11:23

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