Jump to content
Sign in to follow this  

Shifting All Customer Groups and Pricing to New Group Numbers

Recommended Posts

I want to add a new customer group called "Uncatagorized" which would be the new default (0). All the prices for this group would will be "$0.00".


So the way it is now:


Retail & Default (customer group 0)

Wholesale Level 1 (customer group 1)

Wholesale Level 2 (customer group 2)


Would end up like this:


Uncategorized (customer group 0)

Retail (customer group 1)

Wholesale Level 1 (customer group 2)

Wholesale Level 2 (customer group 3)


So what I need to do is shift all the customer groups and associated product pricing up one and insert the new group at the bottom without screwing up the current pricing table or the current customer groups that exist right now.


I realize this will take some kind of fancy SQL statement (or a series of them) but right now I can't get my head around the logic. If anyone has any suggestions, I'd appreciate it. Thanks.


Edit: I thought I was posting this in the SPPC thread but apparently I wasn't. So this question only pertains to SPPC.

Edited by 1Putts

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
Sign in to follow this