Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

krdito

Members
  • Posts

    112
  • Joined

  • Last visited

  • Days Won

    1

Reputation Activity

  1. Like
    krdito got a reaction from wkdwich in USPS Rate V4, Intl Rate V2 (official support thread)   
    I have been away from this thread for a couple of days (thanks to resolving my shipping issue!), but someone asked about setting up the zone rates. It's very simple! First, check in your admin panel to see if you have a zone module. If so, you are in good shape. If not, you will need to find the contribution to add it. We already had it, so we didn't have to go looking for it.
     
    The instructions in the module (includes->modules->shipping->zones) tells you how to increase the number of zones within one zone module (I needed 3 zones, one for the US, one for Canada, and one for the rest of the world). Once you have the correct number of zones, go back to your Admin panel and set them up using the instructions for entering the country code and price based on weight. Please note that one zone module is only good for one USPS service! So, once we had Priority Mail set up, we had to duplicate the zone module to create 2 more zone modules to use for Standard Post and Express Mail. We named them z2 and z3. Don't use the word "zone" in the new module name because it does mess up the system. You then have to go into your new module and replace "zone" with "z2" (or whatever you have named your new zone module) for both lower case and upper case. We then did the same thing for z3. We dug up an old thread here that had instructions for duplicating a table module and used the same principles for duplicating a zone module. This thread is: http://www.oscommerce.com/forums/topic/137263-shipping-duplicating-table-rate/
     
    You will also need to duplicate the language file for the new zones in includes->languages->english->modules->shipping using the same search and replace as you did with the actual zone modules.
     
    Once you have duplicated the zone module and language file (which is the hardest step), you can then set up the new zone modules with the country codes and shipping costs by pound. We looked up prices on the USPS website and used zip code 90026 for US prices, Canada obviously for Canada, and Australia for the rest of the international countries to which we ship. We renamed the zones in the includes->languages->modules-> language files to be Standard Post<sup>®</sup></b> - estimated delivery is 2-9 business days after shipment:, Priority Mail<sup>®</sup></b> - estimated delivery is 2-3 business days after shipment to US addresses and 6-10 business days after shipment to international addresses:, and Express Mail™</b> - estimated delivery is 1-2 business days after shipment to US addresses and 3-5 business days after shipment to international addresses:, so this is what the customer sees during checkout and includes the estimated delivery (not the new "official" estimate from the USPS, but the same basic estimates that have always been in place.
     
    Here is what we have for Priority Mail:
    Enable Zones Method
    True
     
    Tax Class
    --none--
     
    Sort Order
    2
     
    Zone 1 Countries
    US
     
    Zone 1 Shipping Table
    2:10.25,3:12.90,4:16.45,5:18.90,6:21.20,7:23.85,8:26.30,9:41.05,10:41.05,12:41.05,14:41.05,16:67.85,20:81.95,24:81.95,28:81.95,32:81.95
     
    Zone 1 Handling Fee
    1.00
     
    Zone 2 Countries
    CA
     
    Zone 2 Shipping Table
    2:30.60,3:32.95,4:35.30,5:37.65,6:40.00,7:42.35,8:44.70,9:47.05,10:49.40,12:54.50,14:59.60,16:64.70,20:74.90,24:85.10,28:95.30,32:105.50
     
    Zone 2 Handling Fee
    1.00
     
    Zone 3 Countries
    AD,AQ,AS,AT,AU,AW,BE,BR,BS,CH,CL,CN,CZ,DE,DK,ES,FI,FK,FR,FX,GB,GL,GR,GU,HK,HU,IE,IL,IS,IT,JP,KY,LI,LU,MC,MX,NL,NO,NZ,PL,PR,PT,SE,SG,TR,TW,UA,VE,VG,VI,ZA
     
    Zone 3 Shipping Table
    2:44.10,3:48.25,4:52.40,5:56.55,6:60.90,7:65.25,8:69.60,9:73.95,10:78.30,12:87.20,14:96.10,16:137.10,20:159.70,24:182.30,28:204.90,32:227.50
     
    Zone 3 Handling Fee
    1.00
     
     
     
    For Standard Post:
    Enable Z2 Method
    True
     
    Tax Class
    --none--
     
    Sort Order
    1
     
    Zone 1 Countries
    US
     
    Zone 1 Shipping Table
    2:8.92,3:10.81,4:12.07,5:12.66,6:14.20,7:15.98,8:17.62,9:19.06,10:20.97,12:25.02,14:27.50,16:30.21,20:30.21,24:30.74,28:31.39,32:32.10
     
    Zone 1 Handling Fee
    1.00
     
     
     
    and for Express Mail:
    Enable Z3 Method
    True
     
    Tax Class
    --none--
     
    Sort Order
    3
     
    Zone 1 Countries
    US
     
    Zone 1 Shipping Table
    2:38.10,3:43.90,4:49.45,5:55.00,6:60.45,7:66.05,8:71.70,9:77.25,10:81.20,9:77.25,10:81.20,12:88.95,14:96.50,16:104.70,20:120.25,24:137.35,28:152.55,32:170.70
     
    Zone 1 Handling Fee
    1.00
     
    Zone 2 Countries
    CA
     
    Zone 2 Shipping Table
    2:41.40,3:45.45,4:49.50,5:53.55,6:57.85,7:62.15,8:66.45,9:70.75,10:75.05,12:83.55,14:92.05,16:204.20,20:244.95,24:244.95,28:244.95,32:244.95
     
    Zone 2 Handling Fee
    1.00
     
    Zone 3 Countries
    AD,AQ,AS,AT,AU,AW,BE,BR,BS,CH,CL,CN,CZ,DE,DK,ES,FI,FK,FR,FX,GB,GL,GR,GU,HK,HU,IE,IL,IS,IT,JP,KY,LI,LU,MC,MX,NL,NO,NZ,PL,PR,PT,SE,SG,TR,TW,UA,VE,VG,VI,ZA
     
    Zone 3 Shipping Table
    2:59.50,3:64.65,4:69.80,5:74.95,6:80.60,7:86.25,8:91.90,9:97.55,10:103.20,12:114.50,14:125.80,16:294.70,20:359.05,28:359.05,32:359.05
     
    Zone 3 Handling Fee
    1.00
     
    Our largest weight is 32 pounds, but you can go higher if needed, based on what you sell. We don't use First Class, but if you do, you would need a separate zone module for that class. We set the sort order so the zones would show up in order of cheapest to most expensive.
     
    If USPS rates go up in the future (of course they will!), we can either figure out the new rates on the USPS site or bump up the handling fee to cover the increase.
     
    Using these zone modules, we are no longer have to connect to the USPS for service and price quotes. If they ever change service names, it's a simple name change to our current language file.
     
    The only downside of the zone modules is we used a Califoria zip code for calculating costs for US shipping. Customers living closer will pay more than they should have, but the different is usually just a few dollars, so we didn't sweat it. It was more important to us to have a module that worked, over which we have complete control, than risk losing more sales waiting on a fix for the current mess we found ourselves in on July 28th...and last Januar with those USPS updates.
     
    I can tell you I have slept so much better since we implemented our zone modules. No worries ever again about changes by the UPSPS that bring our sales to a grinding halt!
     
    Anyone with questions is more than welcome to message me. I am happy to help! My husband, avec, is a regular poster here and did the zone module duplication when I had the idea that duplicating and using zone modules could be a good fix for us...and it was!
  2. Like
    krdito got a reaction from altoid in USPS Rate V4, Intl Rate V2 (official support thread)   
    My husband, who is very knowledgable about PHP and posts here often, and I have spent countless hours since Sunday trying to fix this mess. We have never gotten the service names to show up (despite using the USPS naming nomenclature from their July 2013 web tools release document), have not gotten international or Standard Post to work at all, and can't get the handling charge to work. So, we set up 3 modules for zone rates, one for Standard Post, one for Priority Mail (both domestic and international in one module), and one for Express Mail (again, both domestic and international in one module). It took about an hour to define the prices by weight for each service/zone, but it's all loaded, working fine, each zone has our handling fee, and BEST OF ALL, we do not have to connect to the USPS for it to work! No matter what the USPS does in the future, our zone modules will be unaffected (although we will have to manually increase prices if there is a price increase, but is less than an hour's work and could be covered by upping the handling fee). I remember the USPS website was down for almost 2 weeks several years ago around the holidays, and then their January 2013 changes caused us problem for almost a week, and now this 6 months later.
     
    Zone shipping works great and will NEVER be affected by a silly name change by the USPS or any other useless change they implement to make their services less user-friendly.
  3. Like
    krdito reacted to kepa in USPS Rate V4, Intl Rate V2 (official support thread)   
    I couldn't get this one to work for me so for the sake of helping others that are having difficultly, USPS Methods 6, while not as good looking as this one seems to be, at least works for me. I finally got it to work, Service error gone... (It seems because I didn't run the included the sql files as it isn't mentioned in the Install instructions and I forgot about seeing them in the root folder -- so take note of that too). It is better than nothing, pretty good actually and thankfully sales can happen normally again.
×
×
  • Create New...