Skip to content

Instantly share code, notes, and snippets.

@trabulium
Created July 6, 2018 00:10
Show Gist options
  • Save trabulium/f18b1db5e75b25f46873afb06f43feae to your computer and use it in GitHub Desktop.
Save trabulium/f18b1db5e75b25f46873afb06f43feae to your computer and use it in GitHub Desktop.
Magento 1 - Remove Fax #'s and remove email address and Alphanumeric from Phone Field on customer accounts
Attribute IDs 32, 178 for Fax
Attribute IDs 31, 175 for Phone
update customer_address_entity_varchar set value = '' where attribute_id in (32,178) and value != '';
update customer_address_entity_varchar set value = '' where attribute_id in (31,175) and (value REGEXP '^[A-Za-z]+$' OR value like ('%@%'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment