Magento Commerce – Fix Shipping/Billing Address Fiasco

Recently, we have run into an issue with some Magento E-Commerce carts with regard to their shipping and billing addresses. The cart defaults to prompting the customer to enter a billing address and a shipping address. However, under most circumstances, the addresses match. I have updated my clients cart to default the shipping address to match the billing address. If a customer would like to separate the two, they have that option; although, most don’t utilize it. In this article, I explain the simple solution.

Here are the simple instructions to update your Magento Commerce website to default the shipping address to match the billing address:

1. Log into your database. This may involve using an interface such as Navicat or PHPMyAdmin.
2. Open the table: “sales_flat_quote_address”
3. Locate the column: “same_as_billing” and modify the structure of this field
4. Change the “same_as_billing” default value to 1. (It should have been set to 0 upon installation.)

This should resolve your billing/shipping issues and should remain in tact through upgrades. Good luck on sales and check out http://www.bellafragrance.com, our newly released Fragrance Discount Superstore!

Tags: billing address, database, ecommerce, instructions, Magento, navicat, phpmyadmin, shipping address, tutorial, updates

This entry was posted on November 18, 2009 at November 18, 2009 and is filed under Code Help, Olebox Websites, Tutorials, php. You can follow any responses to this entry through the RSS 2.0 feed.