BV Commerce Forum
»
BV Commerce Support
»
General Support
»
Incorrect Zip Code & $0.00 - Contact Store for Details
Rank: Member
Joined: 10/11/2006(UTC) Posts: 162
Thanks: 1 times
|
We launched our new store about two weeks ago, and we've already had about three orders where the customer did not enter a correct zip code (either with too few numbers, or adding in a comma or other character). When they do this, the shipping comes up as "$0.00 - To Be Determined. Contact Store for Details."
I've made sure zip code validation is enabled, which brings up the red asterisk momentarily, but then goes away and still allows them to place an order. Is there any way to stop the order from going through until they correct the zip code?
Thanks!
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC) Posts: 1,113
|
If you are using carrier rates, then without a zip code you won't get rates from some carriers, others you will still get a rate based on the state (such as FedEx Ground). |
|
|
|
|
Rank: Member
Joined: 10/11/2006(UTC) Posts: 162
Thanks: 1 times
|
Hi Birdsafe -
I understand what you are saying, however, that is a bit different than what I'm running into. Users are entering incorrect or incomplete zip codes and then placing the order, and since FedEx can't calculate a cost for a 4 digit zip code the shipping cost is unchanged at $0.00. It seems that selecting the 'Enable zip code validation' would cause the cart to throw an error to the user and have them correct their mistake...
: Greg
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC) Posts: 1,113
|
It clearly tells them to enter the zip code for rates, so there should'nt be a problem for you to say to them we're going to have to charge you for the shipping rates. I doubt that many would put it through like that -- I do about 25 orders a day and simply don't see that happening. |
|
|
|
|
Rank: Member
Joined: 10/11/2006(UTC) Posts: 162
Thanks: 1 times
|
Agreed, it doesn't happen often but enough to make it a hassle. I would've thought the zip code validation would catch incorrectly formatted zip codes and have the user correct prior to submission.
: Greg
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC) Posts: 1,737
|
Zip validation has come up before. I think the combinations of numbers and alph can be daunting if you ship to say, Canada and S. America, Europe... and continually change so an on-site look-up table may be possible but unlikely. Fed Ex Ground spits out mismatches (zip/city). Throw in Google and Paypal checkout complications and..... well, let's not go there.
I think there is a service available for this for the states.... Andy may know more about this.
If you capture later and see a $0.00 shipping fee, you can call the shopper, get a proper zip and edit the cart. |
Optimists invent airplanes, Pessimists buy parachutes. |
|
|
|
Rank: Member
Joined: 1/17/2007(UTC) Posts: 69
|
We're having the same problem. This seems like a basic edit test to require a 5 digit zip code - maybe the entry will be random numbers, but at least it would result in a non-zero shipping cost.
Next question is how to add some basic edit test in Javascript or something - VB code? Not being a programmer, I have no clue what to do on this, but just want to simply add a test for a 5 digit zip entry on that field. Help please!
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC) Posts: 310
|
This is the perfect case for performing address validation using USPS AVS. I did write about this a few weeks back on one of my threads. Send me an email if you are interested in performing address validation using USPS AVS. However, it will only work for US based addresses. |
Thanks, Satya support @ bayquel.net Work: +1 803 883 3226 |
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
Over a year ago I asked USPS if I could use their address web service for my ecommerce site, and if I could use their web service for other ecommerce sites not my own (as part of my Shipping Rate Rule Providers). They answer was "no" to both. In the first case, because I do not exclusively use USPS for shipping (i.e. the web service might be called for an order that was not ultimately shipped via USPS). In the second case, it was "no" because I could not guarantee that the other sites would use USPS exclusively.
I decided to include a US postal code database with my Shipping Rate Rule Providers. I use it to calculate delivery distance, although it can also be used to determine if a zip code is valid and what city it is in.
Has the USPS policy changed? |
|
|
|
|
Rank: Member
Joined: 1/17/2007(UTC) Posts: 69
|
I need to handle US and Canada zip codes. Can anybody give me help on a javascript snippet to force at least 5 digits (Canada would be six but I'm willing to live with that small issue).
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
Service Pack 4 includes a new field called "Postal Code Validation Regex" on the BV Admin > Options > Site Settings > Countries > Edit Country page. The code for Single Page Checkout\Checkout.aspx seems to apply the regular expression to the postal code field. The default regular expression for United States is "^\d{5}$" which should require 5 digits.
As of today, Service Pack 4 (SP4) is still pre-release (although a release candidate is available, and you can sign up to test it). |
|
|
|
|
Rank: Member
Joined: 8/1/2007(UTC) Posts: 310
|
The regular expression validator in BV for postal cdes does validation for the number of digits only. Not if they are valid in the true sense in the real world. USPS has a AVS system. More information can be found here: http://www.usps.com/webtools/address.htm. I dont know about their previous policy. But they do allow address verification now of course. I have already done this. |
Thanks, Satya support @ bayquel.net Work: +1 803 883 3226 |
|
|
|
Rank: Member
Joined: 1/17/2007(UTC) Posts: 69
|
how about a hot fix in the meantime? Given we are entering the holiday season, we are not going to be able to test and load a service pack until January, but a hot fix we can do.
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
What service package do you have installed? Please attach the Checkout.aspx page you are using (from the BVModules\Checkouts\[Checkout] directory, where [Checkout] is the checkout style you are using. |
|
|
|
|
Rank: Member
Joined: 1/17/2007(UTC) Posts: 69
|
we're running the latest service pack with all hot fixes added. File Attachment(s): Checkout.aspx (23kb) downloaded 132 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
I didn't realize BVC5 SP3 also includes postal code validation. Make sure BV Admin > Options > Site Settings > Countries > Enable Postal Code Validation is checked. |
|
|
|
|
Rank: Member
Joined: 1/17/2007(UTC) Posts: 69
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC) Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
On my demo store, I checked it (and I verified that United States has the pattern "^\d{5}$"). Then I added an item to the cart and started checkout. I enter a 4 digit zip code (1234) and then click on the Place Order button. The message "Postal code is invalid" appeared and I was not able to complete the order.
Perhaps your modified theme has done something to disable the postal code validation. Try switching your theme to an unmodified single page checkout to test. |
|
|
|
|
Rank: Member
Joined: 1/17/2007(UTC) Posts: 69
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC) Posts: 1,737
|
I also have "Enable Postal Code Validation" checked. A 4 digit zip isn't stopping an order. The Regex is blank. Is this the problem? MitchA attached the following image(s): country zip code.jpg (24kb) downloaded 46 time(s).You cannot view/download attachments. Try to login or register. |
Optimists invent airplanes, Pessimists buy parachutes. |
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.