Contributions

v1.3 - 10-14-2006
Fixed issue in the .sql file
Moved sql updates from .sql to install.txt
Updated to ms2-060817

With the release of osCommerce 2.2 Milestone 2 Update 051113, instances, according to update-20051113.html:
Problem:


When the customer updates their address in the My Account page, their country value is being stored in an incorrect variable that can cause an incorrect tax rate value being used in product prices.



Solution:


The following lines must be replaced in catalog/address_book_process.php:



Line 150, from:



$customer_country_id = $country_id;



to:



$customer_country_id = $country;



Line 171, from:



$customer_country_id = $country_id;



to:



$customer_country_id = $country;

Only 1 file updated (Address_Book_Process.php) - Full Package Included version 1.2

- New Address Book entries partially autopopulated by default values to save time

- Added Require Gender code
- Added Require DOB code
- Fixed Shipping & Payment address when changes or adds new address then goes to address_book and deletes them.

Fixed Shipping & Payment Bug where default shipping & payment address was undefined.

These modifications allow you to assign specific address book entries to a default shipping and a default billing address. In my circumstances, I import osc data into an accounting software package that allows for a statement address (customers_default_address_id), a billing address (customers_billto_address_id), and a shipto address (customers_shipto_address_id). Along with this, it would be easier for the customer to keep track of a "nickname" for that address id (also nicer in adrop-down listing for selection purposes when checking out! :)

There is an additional address line as well as a telephone & fax for each address book entry. Useful when selecting 2nd day air or overnight shipping options and the carrier requires a phone number for the delivery address.

Also, I modified the way osc handled updating customer account along with changing customer name upon selecting a different primary address. I don't see the need to do this. Why would the customer's name change if you wanted to use a different primary address? This particularly bothers me when using the address_book firstname & lastnamefor a contact or ATTN: field.