Contributions
Customer Mismatched State & Zipcode Report v2.0
Customer Mismatched State & Zipcode Report v2.0
This will look through the database and report the names / id of customers whose zipcode does not match up with the State in their Address Book. It will search for both so either the zipcode is wrong or the State is wrong. If there are no incorrect entries found, nothing will be reported.
This way, you can notify the customer and let them know that they need to update their account info. It may be the shipping address or billing address
This is compatible with the Admin DHTML Menus contribution at http://www.oscommerce.com/community/contributions,1140
Support can be found at http://forums.oscommerce.com/index.php?showtopic=121478
Expand All / Collapse All
Added Armed Forces addresses (AE, AP, AA) and other US overseas territories (FM, MP, VI, PW, etc). Made sure all USPS states and territories are included and verified many zipcode ranges against USPS data.
This is the full package, just copy zipcode_validate.php over your existing one or follow installation instructions (copy 1 file and make 1 change to reports.php).
Added Armed Forces addresses (AE, AP, AA) and other US overseas territories (FM, MP, VI, PW, etc). Made sure all USPS states and territories are included and verified many zipcode ranges against USPS data.
This is the full package, just copy zipcode_validate.php over your existing one or follow installation instructions (copy 1 file and make 1 change to reports.php).
Here are a few more quick updates...
This is the full package, just copy zipcode_validate.php over your existing one.
##########################################################
HISTORY
##########################################################
Nov 16, 2004 - Dave (baddog)
Added Puerto Rico
Shortened the name so that it gets displayed on 1 line
Added the version number at the top
Nov 16, 2004 - John P. New (jnew)
User no longer has to modify database info in zipcode_validate.php.
If all states and zip codes match in the customer's database, report now returns a message stating such.
If no US addresses in the customer's database are found, report now returns a message stating such.
Hey, thanks DooD!
Nov 15, 2004 - Scott Moore (PopTheTop)
Updated for osC v2.2 MS2
Full re-write of original contribution to integrate with osC Admin section.
Added link in Admin / Reports to run this contribution.
Layout of report is now much nicer.
Made it compatible with the Admin DHTML Menus contribution.
Aug 31, 2004 - Doug Edmunds
Original contribution and code and idea by: Doug Edmunds.
http://www.oscommerce.com/community/contributions,2404
What a great start!
This will look through the US customer database and report the names / id of customers whose zip code don't match up with the state in their Address Book.
It will search for both so either the zip code or the state is wrong. If there are no incorrect entries found, or no US addresses found, a message will state this.
This way, you can notify the customer and let them know that they need to update their account info. It may be the shipping address or billing address.
Support can be found at http://forums.oscommerce.com/index.php?showtopic=121478
##########################################################
HISTORY
##########################################################
Nov 16, 2004 - John New (jnew)
User no longer has to modify database info in zipcode_validate.php.
If all states and zip codes match in the customer's database, report now returns a message stating such.
If no US addresses in the customer's database are found, report now returns a message stating such.
Hey, thanks DooD!
Nov 15, 2004 - Scott Moore (PopTheTop)
Updated for osC v2.2 MS2
Full re-write of original contribution to integrate with osC Admin section.
Added link in Admin / Reports to run this contribution.
Layout of report is now much nicer.
Made it compatible with the Admin DHTML Menus contribution.
Aug 31, 2004 - Doug Edmunds
Original contribution and code and idea by: Doug Edmunds.
http://www.oscommerce.com/community/contributions,2404
What a great start!
Customer Mismatched State & Zipcode Report v2.0
This will look through the database and report the names / id of customers whose zipcode does not match up with the State in their Address Book. It will search for both so either the zipcode is wrong or the State is wrong. If there are no incorrect entries found, nothing will be reported.
This way, you can notify the customer and let them know that they need to update their account info. It may be the shipping address or billing address
This is compatible with the Admin DHTML Menus contribution at http://www.oscommerce.com/community/contributions,1140
Support can be found at http://forums.oscommerce.com/index.php?showtopic=121478
Note: Contributions are used at own risk.
Customer Mismatched State & Zipcode Report v2.2.1
Customer Mismatched State & Zipcode Report v2.2