Announcement

Collapse
No announcement yet.

Displaying USPS Postal Zone on Merchant Confirmation E-mails

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Displaying USPS Postal Zone on Merchant Confirmation E-mails

    Hi,

    Is there a way I can display the USPS Postal Zone on our Merchant Confirmation E-mails?

    Since we always ship from the same zip code I wasn't sure if there is a way we can do that by either creating a table from the Postal Zone charts found here:
    http://postcalc.usps.gov/Zonecharts/default.aspx

    Or if there is a module already out there that can do this and all we need to do is display the token?

    Having the Postal Zone displayed on our end will help our shipping department determine which USPS service we will use as well as what USPS box to pack the order in.

    Thanks,
    Mike

    #2
    Re: Displaying USPS Postal Zone on Merchant Confirmation E-mails

    I'm not aware of a module that does this. Some order processing systems might, but that might be overkill if you aren't already using one.
    Best,
    Pamela

    Consultant / Developer / Trainer
    Contributing Editor to Practical Ecommerce
    Author of the Official Guides for Miva Merchant
    pamelahazelton.com

    Comment


      #3
      Re: Displaying USPS Postal Zone on Merchant Confirmation E-mails

      Thanks Pamela, I'm wondering instead of that maybe I can write a conditional from that data on the usps website to display the zone.

      Just not sure if that is a cumbersome way of doing it since there will be about 150 possibilities. Last thing I want to do is slow down the checkout process.

      Regards,
      Mike

      Comment


        #4
        Re: Displaying USPS Postal Zone on Merchant Confirmation E-mails

        Originally posted by mstella1 View Post
        Thanks Pamela, I'm wondering instead of that maybe I can write a conditional from that data on the usps website to display the zone.

        Just not sure if that is a cumbersome way of doing it since there will be about 150 possibilities. Last thing I want to do is slow down the checkout process.

        Regards,
        Mike
        Yeah, that would be a big cycle. I wonder if there's a third-party service you can connect to simply by passing the zip code and then displaying the data.

        Are you using any order processing system? Or just Miva Merchant? Because if this only needs to display internally, a custom back-end mod may be ideal.
        Best,
        Pamela

        Consultant / Developer / Trainer
        Contributing Editor to Practical Ecommerce
        Author of the Official Guides for Miva Merchant
        pamelahazelton.com

        Comment


          #5
          Re: Displaying USPS Postal Zone on Merchant Confirmation E-mails

          Just Miva Merchant for processing orders.

          Nothing against any of the subscription services out there but we can't add any more subscription based services to our overhead here. Not to mention we essentially dropped UPS to go with the USPS so keeping our costs down is the reasoning for the postal zone.

          I have a call with USPS today in regards to their API's so I may ask to see if they have anything that can do that for us.

          Thanks for the input.

          Mike

          Comment


            #6
            Re: Displaying USPS Postal Zone on Merchant Confirmation E-mails

            Use your USPS zone table to build this:
            MYSQL zonetable: lowcode/hicode/zone. 150+- rows ordered asc on lowcode. Index lowcode. Select from zonetable where dest zip(3) >= lowcode and destzip(3) <= hicode.
            execute this from merchant email template. Module returns zone.
            Last edited by wajake41; 06-02-15, 10:07 AM.
            Larry
            Luce Kanun Web Design
            www.facebook.com/wajake41
            www.plus.google.com/116415026668025242914/posts?hl=en


            Comment


              #7
              Re: Displaying USPS Postal Zone on Merchant Confirmation E-mails

              Mike: I'd recommend that you contact Kent Multer and get a bid on a module to do this. He's done good work for us and I highly recommend him. This shouldn't be a subscription but just a one time cost. And I think Kent could do this for a reasonable cost.
              Ask for a quote and see what he says.
              Cheers, Larry
              Larry
              Luce Kanun Web Design
              www.facebook.com/wajake41
              www.plus.google.com/116415026668025242914/posts?hl=en


              Comment

              Working...
              X