I have set up a shipping table for "Local Delivery" based on nearby zip codes.  So when a customer's shipping zip code "Equals" one of the zip codes I entered into the shipping table, the shipping will be free ($0.00).  I have the "Enabled" check box checked and the sort order as "1".  I have a USPS Priority Mail table configured and set to sort order "0".  The only shipping option that is appearing even when one of the "Local Delivery" zip codes are used at checkout is the USPS Priority Mail option.  I am not seeing the free local delivery option appear.  I am not sure if I am missing something but I followed the tutorial and triple checked my configuration and everything looks to be fine. 

 

Any ideas as to why the local delivery option is not appearing during checkout?

Could you please show us how you define "Local Delivery"?

- Under Table Based Shipping, I added a shipping method that I named "Local Home Delivery".  

-The Shipping Basis is "Total Order Weight" and the Rate Unit is set to "Amount."

-Sort Order is "1"

 

-I then created a shipping region named "Irvine" which is the city my business is located

-In Shipping Region, under Shipping Region Definitions, I set the Property to "Zip Code", the Operator as "Equal", and the Value as the local zip code in Irvine.  I repeated this for all       the zip codes in Irvine that I want to offer local home delivery.

 

-Under the Shipping Rates, I entered "From" 0 "To" 12.50 ounces at a rate of "$2.00".  In other words, my packaged coffee is set to weight "11.5" in my shopping cart under the product    settings.  So, when a person only buys one bag, they will be charged a Local Home Delivery charge of $2.00.

-The second rate reads "From" 12.50 "To" UP with a rate set at $0.00 which is where the free local home delivery kicks in.  If someone buys (2) bags of coffee which will equal a              weight of 23 oz. (2 X 11.50), then they satisfy the (2) bag minimum for free local home delivery and the shipping rate is $0.00.

 

 

The problem is none of these Local Home Delivery options are coming up during check out even if the zip code I enter into shipping details "equals" one of the zip codes I configured in the table.

 

Thank you much and I hope this makes sense.

 

 

Don't repeat it for all the zip codes within one shipping region. All the conditions defined in one shipping region is "AND". Try create one shipping region for one zipcode.

Thanks Luke!  That did the trick.  Now time to go make a whole bunch of shipping regions for all my zip codes.  Any chance of adding an "OR" feature in a future release so that several zip codes can placed under one shipping region? 

 

Just a thought...

You can take a look at method private bool CheckConditions(List<Condition> conditions, ShippingPackage package) in Shipping\TableBasedShippingProvider.cs. But it would be fairly large task to implement "OR" condition.

 

Is it possible to use the realtime shipping rates instead? You just need to set up corrent weight at the product level.

 

Otherwise I would suggest you go with Bulk Import rount. Take a look at web\Admin\Store\TaxImport.aspx and TaxImport.aspx.cs. You can copy the same logic and apply to shiping rates.

 

In that case - we'll take a look at the bulk import. The problem with the realtime shipping rates is we need to have a separate shipping option for each individual school (plus all of our school deliveries are free). That way when a customer inputs their zip code they can select which of the schools, that is within a 5-10 mile radius their home, they want their items delivered to. Hopefully the bulk import will work for us. Thanks.

Now that we have access to our SQL server, we were thinking that maybe we could edit the shipping table directly. However, I can't find it on the server. Can you give me some direction?

It's stored in web\DSC.config. You cannot edit shipping table directly. It's encoded. I would suggest you take a look at TaxImport code and do the similar to shipping table.

Is DSC.config also where the shipping regions are stored?

 

Is there a limit to the size of DSC.config?