When checking out on a Magento shop you will find that on the Billing screen ‘Ship to different address’ is selected as the default option. It is more likely you will want ‘Ship to this address’ to be the default option. This is how you do it.
When making a checkout Magento checks a database field to see if it should ship to the same address, this database field’s default value is set to no. To change it do the following:
- Log into the Magento database
- Open the table sales_flat_quote_address
- Find the field same_as_billing and choose to modify it’s structure
- Change the default value for same_as_billing default from 0 to 1Now any new customers or guests will have ‘Ship to this address’ as the default option. To update any existing users simply set the same_as_billing field to 1 on all the records in this table.
ALTER TABLE `sales_flat_quote_address` CHANGE `same_as_billing` `same_as_billing` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1'