I supplier ships to customers based on their zip code and weight. They use a table like this for zip code:
*ZIP Code Prefix* *Zone* *ZIP Code Prefix* *Zone* *ZIP Code Prefix* *Zone* *ZIP Code Prefix* *Zone* 005 4 349 6 496..497 3 716..722 5 006..009 8 350..352 4 498..509 4 723..725 4 010..013 4 354 5 510..513 5 726..731 5 014..034 5 355..359 4 514 4 733 6 035..037 4 360..361 5 515..516 5 734..741 5 Etc... And their shipping rates/pound look like this: Weight Postal Zone (lbs) 1 2 3 4 5 6 7 8 1 $5.65 $5.65 $5.65 $5.65 $5.65 $5.65 $5.65 $5.65 2 $5.65 $5.65 $5.90 $6.55 $8.05 $8.40 $8.75 $9.30 3 $6.25 $6.25 $7.10 $8.10 $9.40 $10.15 $10.65 $11.40 4 $6.95 $6.95 $8.10 $9.10 $10.55 $11.55 $12.25 $13.30 5 $7.80 $7.80 $9.30 $10.35 $11.55 $12.40 $13.05 $14.20 Etc... I wanted to see if I could setup shipping rules to accurately emulate the above in OFBiz, but I was unable to figure out where I could place "ranges" of zip codes in ofbiz. I first thought that it would be possible to use something like this: <QuantityBreak quantityBreakId="90001" quantityBreakTypeId="SHIP_WEIGHT" fromQuantity="0.00" thruQuantity="1.0"/> <QuantityBreak quantityBreakId="90102" quantityBreakTypeId="SHIP_WEIGHT" fromQuantity="1.01" thruQuantity="2.0"/> <ShipmentCostEstimate shipmentCostEstimateId="USPS_STA10001" carrierPartyId="USPS" carrierRoleTypeId="CARRIER" productStoreId="9000" "productStoreShipMethId="9004" orderFlatPrice="5.65" orderPricePercent="0.0" geoIdFrom="00500" geoIdTo="00599" shipmentMethodTypeId="STANDARD" weightBreakId="90001"/> <ShipmentCostEstimate shipmentCostEstimateId="USPS_STA10002" carrierPartyId="USPS" carrierRoleTypeId="CARRIER" productStoreId="9000" productStoreShipMethId="9004" orderFlatPrice="6.55" orderPricePercent="0.0" geoIdFrom="00500" geoIdTo="00599" shipmentMethodTypeId="STANDARD" weightBreakId="90102"/> But then I soon learned that "geoIdFrom" and "geoIdTo" were actual, exact FROM/TO zip codes, and not RANGES, which I initially tried. So I ask: Is it possible to setup shipping rules based on RANGES of ZIP codes? How would you do it? I already know that I can use USPS to lookups, but I wanted to EXACTLY duplicate the shipping rates that the supplier uses, then add my own markup as I see fit. Thanks Mike
