title | slug | date |
---|---|---|
OpenCart: Bulk Update Customer Group via phpmyadmin |
opencart bulk-update-customer-group-opencart-mysql-phpmyadmin |
2017-05-21 |
Because you can not delete a group if it has customers in it. And there is no easy way to move all customers to another group via the admin.
Warning: This customer group cannot be deleted as it is currently assigned to 2170 customers!
You can find the customer_group_id
from the Admin URL, or by checking the oc_customer_group_description
table
SELECT * FROM `oc_customer` WHERE `customer_group_id`=1
UPDATE `oc_customer` SET `customer_group_id`=3 WHERE `customer_group_id`=1