Bulk Edit Customers discount-group membership setting

[townsend2009]

I would like to change all the customers in my wholesale area to be in the group "members" but can I do it all at once somewhere instead of one by one?

TIA!

[Ajeh]

Define all customers ... is this "every single customer" in your customers table or "some customers" in the customers table?

Also, look up what the customers_group_pricing is ... this will be the same as if you were to edit the Group Pricing and looked at the gID in the URL ...

[townsend2009]

Define all customers ... is this "every single customer" in your customers table or "some customers" in the customers table?

It is all customers in the table. When they sign up for a wholesale account they should be put into the 10% off group.

Also, look up what the customers_group_pricing is ... this will be the same as if you were to edit the Group Pricing and looked at the gID in the URL ...

I'm not sure exactly where to look for this ;)

[schoolboy]

I'm not sure exactly where to look for this ;)

It's the GROUP ID - on the extreme left of the screen when you open Group Pricing (admin >>> customers >>> Group Pricing).

If you have not yet set up a group, do so, then note the ID.

What Linda is about to tell you is a bit of SQL that will mass-update the customer data... but she needs this info first.

[townsend2009]

Oh okay, thanks!... It's group 1.

[Ajeh]

You can use, to change every single customer in your customers table to this customers_group_pricing value of, for example when the customers_group_pricing is 1, by using:

UPDATE customers SET customers_group_pricing = '1';

It is always a good idea to backup your database before making changes like this ...

[townsend2009]

Thanks again for your help! Going to try this today