Has anyone been able to get BC to look up the shipping postcode to determine which shipping option to offer the customer?
We have flat shipping options per area.
E.g Sydney is $10 but NSW Country is $15 and currently customers have to choose their own shipping option - problem with this is that customer not in Sydney will select Sydney and then we loose out of freight and have to call each customer to get the extra amount = very time consuming!
As we charge based on flat rates regardless of invoice total, we need BC to lookup the postcode.
Does anyone have a website that has got this to work?
That's not possible on BC. You can integrate with AustPost and that will give you a postcode field where the customers can enter the postcode and the AustPost will return the rates for it.
Otherwise, simply create user defined options, one for Sydney for $10 and another for elsewhere in NSW for $15. Customers will almost always shoose the correct option.
In a round about way we have got this to work! We have an externally hosted table that lists the postcodes and each identifies the shipping table entry that applies to it in BC. You simply enter your postcode and if it is nthe external table then it will match to a shipping zone entry and come back with a price. If the postcode i not in the external table we tell the shopper they can't use shipping and must raise a quote - we disable the CHECK OUT button.
Take a look at http://quickbrownbox.com.au - purchase any product and try the checkout page - suggest yu choose postcodes around SE Qld to get a result and something in WA to se what happens for a postcode not in the ext table
That's right Mario and you will notice the red message beneath the postode entry field which says "Postcode not found, please request a shipping quote".
In your case the order can't be riased and the user is required to post a Quote instead. I forgot that the client had disabled all but local postcodes but if yu now enter 4346 you will see the result below. The postcode lookup tables is held as an SQL file ona 3rd party server.
Silly me! Not sure why I thought the postcode for Brisbane was 7000. Cool. Nice implementation. I think you may want to capture that JS alert and suppress it if your lookup is returning "postcode not found". Other than that, this is a great effort. You should make it into a web app, integrate with Toll, which is something people are asking about all the time and sell it to other BC users