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?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
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.