HomeHome Product Discus... Product Discus...SmithCartSmithCartShipping Calculation from Postal Code Issues Cart 4.50Shipping Calculation from Postal Code Issues Cart 4.50
Previous
 
Next
New Post
8/9/2011 3:03 PM
 
Ismet Dumlupinar
No Ranking


Joined: 7/10/2011
Posts: 38

DNN Version: 5.6.3

Cart Version: 4.50 Trial

Country: Canada

Under Store Admin Menu > Shipping > By Postal Code

I imported postal codes with 3 chars (eg. H4N) for Canada (CA) from a PDF file that has postal codes and shipping rates for different zones.

Under Manage Cart Settings > Shipping and Handling Setup > Custom Ship Methods By Zip Code is checked.

The problem is, since i used only first 3 chars of postal code for shipping calculation, if user inputs his full postal code, shipping calculator cannot calculate the shipping rate. How can one fix this issue?

Or am i doing things with inproper way?

 
 
New Post
8/9/2011 4:10 PM
 
Ismet Dumlupinar
No Ranking


Joined: 7/10/2011
Posts: 38
The problem is the pdf file i received has unique shipping rates for different zones in each city. So, I'm trying to solve a puzzle...
 
New Post
8/9/2011 5:14 PM
 
Ismet Dumlupinar
No Ranking


Joined: 7/10/2011
Posts: 38
Guys it is kinda urgent, can't we make a wildcard validation rule?
 
New Post
8/9/2011 6:05 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Ismet,

The issue most likely lies in the pdf file you imported which probably contains formatting or other special characters. To import tax tables, data must be in CSV format. The following is the correct CSV import format:

City
County
State
Zip
TaxRate

Step1: Click the Choose File button and choose the CSV file to upload.

Step2: Click the Import Tax table button to upload the Tax Table.
Clicking Delete Tax Table deletes all Tax Tables previously imported.

Thanks,
 
New Post
8/9/2011 6:19 PM
 
Ismet Dumlupinar
No Ranking


Joined: 7/10/2011
Posts: 38
Kevin i my question on this url has nothing to do with Tax table. I'm asking about shipping calculation. I didn't import PDF file actually, i created entries manually for shipping as pdf file contains only a screenshot.
 
New Post
8/9/2011 6:21 PM
 
Ismet Dumlupinar
No Ranking


Joined: 7/10/2011
Posts: 38
What i want is, if users zipCode has same first three characters with ZoneCodes, then display that ZoneCode's shipping rate. Instead of displaying a "please enter a valid zip code or country" message.
 
New Post
8/9/2011 6:45 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0

Hi Ismet,

Sounds like you will need to use the Custom Ship Methods by Zip Code feature located in the Shipping and Handling Setup section in the Cart Settings. When selected the cart will charge shipping based on the customers ship to zip code. If you select this option you will need to configure ship methods by zip code. To configure Custom Ship Methods by Zip Code do the following:

  • Navigate to the “Store Admin Menu” and click the “Shipping” button
  • Click the “By Zip Code” button at the top of the screen
  • Add shipping methods, zip code and shipping cost.

Thanks,
 
New Post
8/9/2011 6:59 PM
 
Ismet Dumlupinar
No Ranking


Joined: 7/10/2011
Posts: 38

Hi Kevin, i already followed your suggestions by reading module user manual.
I have shipping method, zip code and shipping cost already setup. The problem is:

I added values in format of postal codes Smith_ShippingByZipCode table
http://en.wikipedia.org/wiki/List_of_H_postal_codes_of_Canada (e.g H3C,H4N etc...)

But buyers postal code consist of 6 chars or 7.
eg. (H4N 1F6) or (H4N1F6)

Since i cannot find all postal codes and import them to my database, only comparing against first three chars of buyer's zipcode within ZipCode value under Smith_ShippingByZipCode will be enough to match and display shipping rate for buyer, right?

But module currently does not accept zipcodes entered other than included items in Smith_ShippingByZipCode.

Thats, why i am asking. Is this expected by design, or a bug, needs to get resolved?
 
New Post
8/9/2011 11:01 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Ismet,

If I understand you correctly, you wish for the Cart to search for a match of zip codes using only the first 3 characters of the code correct? If this is so, the Cat has not been programmed to match partial zip codes so the code behind the logic that matches the zip code would have to be changed to do a search for the corresponding shipping zone. If you would like a quote for us to make the change please send an email to sales@smith-consulting.com with a link to this post. We quote all features enhancements below cost since it is enhancing the module.

Thanks,
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartShipping Calculation from Postal Code Issues Cart 4.50Shipping Calculation from Postal Code Issues Cart 4.50




Questions? Contact us for answers!

Contact Us!