How to change telephone number to not being required on the admin side billing and shipping information?

Could this be done with some SQL query?

1 Answer 1


Here's the SQL query for setting the attribute telephone to not required.

UPDATE eav_attribute SET is_required = 0 WHERE attribute_code = 'telephone';

You might want this implemented in a setup script if you wish to package it in an extension.

This does not override any frontend code, which may still require the telephone.

  • you need also to edit app/code/core/Mage/Customer/Model/Address/Abstract.php comment out getTelephone() check.
    – LucScu
    Jun 18, 2018 at 10:47
  • @LucaS That's not necessary. Jun 19, 2018 at 11:56
  • It is necessary with magento and iwd checkout, if you don't edit app/code/core/Mage/Customer/Model/Address/Abstract.php it returns error "insert phone number". I don't try it with default checkout, but i think it returns error anyway because it checks phone number as required.
    – LucScu
    Jun 19, 2018 at 15:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.