I created a new customer attribute (Drop Down) and added it to the registration form.
Attribute details found in
Everything work as expected, attribute is added to the customer when new account is registered or an existing account was edited and the attribute was added. I can find that in the table
Now, I have about 90,000 customers and I need to set a value of this attribute.
How can I update all the customers custom drop down attribute with the above value? Any method would suit me, PHP or SQL.