Jump to content

SQL query to correct wrong Customer Group ID's


Recommended Posts

Hi am upgrading from Prestahop 1.6 to 1.7 and have come across an issue I'd like to sort.  My customer group ID's currently are:

1. Customers

2. Visitor


These have been same since we started using Prestashop years ago. I believe at one point during an upgrade these should have changed to:

1. Vistor

2. Guest

3. Customer

I suspect these failed to update during one of the many 1 click updates I've done to the site over the years.

I want to get these right now. Can anyone suggest correct SQL query to re-assign to the now default ID's without mangling anything.



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More