Shipping set-up for a single product that ships in 2 boxes

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
eileen
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 41
Joined: Sun Feb 11, 2007 10:59 pm
Location: Novato, CA
Contact:

Shipping set-up for a single product that ships in 2 boxes

Post by eileen » Thu Jul 24, 2014 3:03 pm

We have furniture products that ship in 2 boxes, e.g., Table top + table base; chair frame + chair cushions. Currently we enter the combined shipping weight and the larger box size, but the calculated shipping rates are too low. We tried setting up a hidden kit item for the 2nd box, with both the hidden kit item and the parent product set to calculate separately. Able combined the weights so the result was no different than our default method. How do others handle this situation?

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Shipping set-up for a single product that ships in 2 boxes

Post by Katie » Thu Jul 24, 2014 9:40 pm

Have you tried to disable the setting for Enable Package Breakup? I'm not sure which provider you are using, but this should be available from the configuration page. To be honest, I'm not sure what will happen when you try to get a rate request. If you go over the provider's maximum limit (without package breakup), then I would think that no rates would be returned, but I might be wrong. You'll just have to give it a quick test.

I spoke to someone last week who had integrated with "freightquote.com" because they sold large pieces of medical equipment that had to be put on pallets. They seemed very happy with the ability to get shipping estimates that were more in line with their requirements, but it would mean a custom integration.

Please keep us updated. I'm curious how the gateway will treat the oversized/overweight shipping request.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

eileen
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 41
Joined: Sun Feb 11, 2007 10:59 pm
Location: Novato, CA
Contact:

Re: Shipping set-up for a single product that ships in 2 boxes

Post by eileen » Fri Jul 25, 2014 6:51 am

Carrier is UPS. We get the same combined-weight rates whether "Enable Packaging" is enabled or disabled. UPS doesn't see that there are two separate boxes in the shipment.

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Shipping set-up for a single product that ships in 2 boxes

Post by Katie » Fri Jul 25, 2014 7:02 am

It might be helpful if you enable debug and post the XML request and response so we can look at the information and see what is going on. The log file will be generated in the app_data\logs\ folder and named UPS.log. We just need a single request/response entry please.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

eileen
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 41
Joined: Sun Feb 11, 2007 10:59 pm
Location: Novato, CA
Contact:

Re: Shipping set-up for a single product that ships in 2 boxes

Post by eileen » Fri Jul 25, 2014 12:19 pm

Code: Select all

Send: <?xml version="1.0"?><RatingServiceSelectionRequest xml:lang="en-US"><Request><TransactionReference><CustomerContext>Rating and Service</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><RequestAction>rate</RequestAction><RequestOption>shop</RequestOption></Request><PickupType><Code>01</Code></PickupType><CustomerClassification><Code>01</Code></CustomerClassification><Shipment><Shipper><Address><City>Vallejo</City><StateProvinceCode>CA</StateProvinceCode><PostalCode>94592</PostalCode><CountryCode>US</CountryCode></Address><ShipperNumber>A590F5</ShipperNumber></Shipper><ShipTo><Address><City></City><StateProvinceCode>NY</StateProvinceCode><PostalCode>10001</PostalCode><CountryCode>US</CountryCode><ResidentialAddressIndicator /></Address></ShipTo><ShipmentWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></ShipmentWeight><RateInformation><NegotiatedRatesIndicator></NegotiatedRatesIndicator></RateInformation><Package><PackagingType><Code>02</Code></PackagingType><Dimensions><UnitOfMeasurement><Code>IN</Code></UnitOfMeasurement><Length>24.00</Length><Width>24.00</Width><Height>11.00</Height></Dimensions><PackageWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></PackageWeight></Package></Shipment></RatingServiceSelectionRequest>

Receive: <?xml version="1.0"?>
<RatingServiceSelectionResponse><Response><TransactionReference><CustomerContext>Rating and Service</CustomerContext><XpciVersion>1.0001</XpciVersion></TransactionReference><ResponseStatusCode>1</ResponseStatusCode><ResponseStatusDescription>Success</ResponseStatusDescription></Response><RatedShipment><Service><Code>03</Code></Service><RatedShipmentWarning>User Id and Shipper Number combination is not qualified to receive negotiated rates.</RatedShipmentWarning><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>60.87</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>60.87</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery/><ScheduledDeliveryTime/><RatedPackage><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>60.87</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>60.87</MonetaryValue></TotalCharges><Weight>63.0</Weight><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight></RatedPackage></RatedShipment><RatedShipment><Service><Code>12</Code></Service><RatedShipmentWarning>User Id and Shipper Number combination is not qualified to receive negotiated rates.</RatedShipmentWarning><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>200.34</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>200.34</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery>3</GuaranteedDaysToDelivery><ScheduledDeliveryTime/><RatedPackage><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>200.34</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>200.34</MonetaryValue></TotalCharges><Weight>63.0</Weight><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight></RatedPackage></RatedShipment><RatedShipment><Service><Code>02</Code></Service><RatedShipmentWarning>User Id and Shipper Number combination is not qualified to receive negotiated rates.</RatedShipmentWarning><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>297.74</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>297.74</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery>2</GuaranteedDaysToDelivery><ScheduledDeliveryTime/><RatedPackage><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>297.74</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>297.74</MonetaryValue></TotalCharges><Weight>63.0</Weight><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight></RatedPackage></RatedShipment><RatedShipment><Service><Code>13</Code></Service><RatedShipmentWarning>User Id and Shipper Number combination is not qualified to receive negotiated rates.</RatedShipmentWarning><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>395.20</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>395.20</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery>1</GuaranteedDaysToDelivery><ScheduledDeliveryTime/><RatedPackage><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>395.20</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>395.20</MonetaryValue></TotalCharges><Weight>63.0</Weight><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight></RatedPackage></RatedShipment><RatedShipment><Service><Code>14</Code></Service><RatedShipmentWarning>User Id and Shipper Number combination is not qualified to receive negotiated rates.</RatedShipmentWarning><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>437.30</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>437.30</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery>1</GuaranteedDaysToDelivery><ScheduledDeliveryTime>8:00 A.M.</ScheduledDeliveryTime><RatedPackage><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>437.30</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>437.30</MonetaryValue></TotalCharges><Weight>63.0</Weight><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight></RatedPackage></RatedShipment><RatedShipment><Service><Code>01</Code></Service><RatedShipmentWarning>User Id and Shipper Number combination is not qualified to receive negotiated rates.</RatedShipmentWarning><RatedShipmentWarning>Your invoice may vary from the displayed reference rates</RatedShipmentWarning><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>404.15</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>404.15</MonetaryValue></TotalCharges><GuaranteedDaysToDelivery>1</GuaranteedDaysToDelivery><ScheduledDeliveryTime>10:30 A.M.</ScheduledDeliveryTime><RatedPackage><TransportationCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>404.15</MonetaryValue></TransportationCharges><ServiceOptionsCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>0.00</MonetaryValue></ServiceOptionsCharges><TotalCharges><CurrencyCode>USD</CurrencyCode><MonetaryValue>404.15</MonetaryValue></TotalCharges><Weight>63.0</Weight><BillingWeight><UnitOfMeasurement><Code>LBS</Code></UnitOfMeasurement><Weight>63.0</Weight></BillingWeight></RatedPackage></RatedShipment></RatingServiceSelectionResponse>


User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Shipping set-up for a single product that ships in 2 boxes

Post by Katie » Sat Jul 26, 2014 7:29 am

You show that the shipment weight is 63 lbs, and that is the billable weight as well. This is not over their limits, so the enable package breakup setting doesn't come into play.

Can you give the dimensions and weight for EACH separate box to be shipped?
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

eileen
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 41
Joined: Sun Feb 11, 2007 10:59 pm
Location: Novato, CA
Contact:

Re: Shipping set-up for a single product that ships in 2 boxes

Post by eileen » Tue Jul 29, 2014 5:50 pm

Following are weights / dimensions for some of our products that ship in 2 boxes:
DESKTOP PODIUM
- Box #1: 12# 19" x 16" x 13"
- Box #2: 17# 28" x 28" x 2"
HI-BACK OFFICE CHAIR
- Box #1: 50# 27" x 27" x 21"
- Box #2: 23# 43" x 17" x 6"
ADJUSTABLE DESK
- Box #1: 50# 61” x 34” x 3”
- Box #2: 58# 38” x 28” x 8”
SADDLE SEAT
- Box #1: 33# 18” x 18” x 36
- Box #2: 13# 28” X 28” X 6”
The fake item I was testing earlier was 2 boxes each about 30#. These are representative examples. Actual weights may change with the configuration of the item (e.g., chair with or without arms, etc.).

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Shipping set-up for a single product that ships in 2 boxes

Post by Katie » Thu Jul 31, 2014 1:54 pm

This is how I setup the products for shipping. I created a kit which included the Box 1 and Box 2 of the Desktop podium. Each of the kit products uses the dimensions and weight you have entered above. The shipping setting is 'Calculate Separately'. This is in case the dimensions that are entered make billable weight more than the actual weight. In the case of the Desktop Podium, the actual weight is used.

In AbleCommerce, I setup 3 UPS services: Ground, 2nd day, and Next day. When I put the kit into my basket and went to the checkout page, here are the shipping rates that were returned:

Ground = 69.98
2nd Day = 269.85
Next Day = 399.51

So then I went to UPS's website and entered each package using the same weights and dimensions, same ship from and ship to locations, and no extra services. Here are those results:

12# box - Ground = 31.48
12# box - 2nd day = 152.55
12# box - next day = 216.19

17# box - Ground = 38.50
17# box - 2nd day = 117.30
17# box next day = 183.32

If you do the math and add both 12# and 17# together, here is what you get -

Ground = 69.98
2nd Day = 269.85
Next Day = 399.51

So, then I did another test using the Desk. I setup the kit product in the same way as the desktop. Box 1 of the desk has a billable weight of 90 lb. because of the dimensions. In Able, I just entered the dimensions and weight as you have them listed.

AC calculated = 259.88 for ground and UPS calculated 169.53 for box 1 and 90.35 for box two, totaling 259.88.

In both cases, the UPS rates match AbleCommere to the penny. So, I suggest that you follow the same steps I have done and do a comparison of your AC rate and UPS rates. I would also suggest using the Calculate Separately option so dimensions will be considered for the rate calculation.

Hope this helps,
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Post Reply