You can look clicshopping_v2 maybit can help you
https://github.com/ClicShoppingOfficialModulesV3/apps_tools_import_data/blob/7f8c544a8e1742d26a1f549ca946665ad0200d3e/includes/Module/Hooks/ClicShoppingAdmin/ImportDatabase/ClicShoppingV2.php
line around 548
In my sense it's better to make an update via Customer/Customer group and add other groups after.
customers_group_id int not_null auto_increment
customers_group_name varchar(32) not_null
customers_group_discount decimal(11,2) default(0.00) not_null
color_bar varchar(8) default('#FFFFFF') not_null
group_order_taxe tinyint(1) default(0) not_null
group_payment_unallowed varchar(255) default('cc')
group_shipping_unallowed varchar(255)
group_tax varchar(5) default('false') not_null
customers_group_quantity_default int(4) default(0) not_null
--
primary customers_group_id
idx_customers_group_name customers_group_name
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci
Maybe your problem is the primary.
Hello,
I take your update and make little modification, I tested on osCommerce and phoenix, works fine. I try with oscMax, but there is a problem on the db importation.
Let me know if you have a problem.
Thank you for your contribution.
https://github.com/ClicShoppingOfficialModulesV3/apps_tools_import_data