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!
Printable View
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!
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 ...
It is all customers in the table. When they sign up for a wholesale account they should be put into the 10% off group.Quote:
Originally Posted by Ajeh
I'm not sure exactly where to look for this ;)Quote:
Originally Posted by Ajeh
It's the GROUP ID - on the extreme left of the screen when you open Group Pricing (admin >>> customers >>> Group Pricing).Quote:
Originally Posted by townsend2009
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.
Oh okay, thanks!... It's group 1.
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:
It is always a good idea to backup your database before making changes like this ...Code:UPDATE customers SET customers_group_pricing = '1';
Thanks again for your help! Going to try this today :D