Our UPS shipping rates (actual vs estimate) are off.

Ground is low. 2nd day is WAY high.

Normally, I'd get the XML that's sent to UPS and troubleshoot with them. I've turned on diagnostics mode, but it doesn't share the XML data.

1. How can I get the raw XML sent to UPS.

2.Does Hotcakes send the account number in the XML to UPS? I know that was an issue that NopCommerce had.

Thanks!
Jason

The UPS account number is definitely used and sent as part of the API/integration request. Perhaps the store address and shipping address aren't the same? The store address is used as the "ship from" address by default.

https://hotcakescommerce...Settings-Store-s-Address 

If you want the store address and shipping origin address to be different, I'd suggest adding your warehouse/fulfillment center as a vendor and update your products to use that setting. You'd effectively be your own drop-shipper (ship mode).

https://hotcakescommerce...ticles/210265263-Vendors 

---

Thanks, Will. The address is correct in the Store Address. No need for different addresses.

For us to troubleshoot, we need to get/send the XML that HotCakes sends to UPS. How can I get that? I didn't see it in the logs.

The UPS account number is definitely used and sent as part of the API/integration request. Perhaps the store address and shipping address aren't the same? The store address is used as the "ship from" address by default.

https://hotcakescommerce...Settings-Store-s-Address 

If you want the store address and shipping origin address to be different, I'd suggest adding your warehouse/fulfillment center as a vendor and update your products to use that setting. You'd effectively be your own drop-shipper (ship mode).

https://hotcakescommerce...ticles/210265263-Vendors 

Hello Jason:

Diagnostics Mode
If you are having issues with your shipping rates and need to troubleshoot them for any reason, check this setting. You shouldn't leave this checked for long term on any site. When checked, the Event Viewer in the Admin menu will be populated with information sent to and returned from UPS. This could easily fill up your event log over time, which could end up slowing down your website.

That's an excerpt from the documentation. Do you have diagnostics mode enabled? If you do, are you not seeing the response in the Event Viewer? What about the Log4Net log files?

https://hotcakescommerce...0196-Shipping-Method-UPS 

Also, it may be worth double-checking the client's rate and rate code.

---

I sent the diagnostics info I got from the Admin log, but UPS states it needs the original XML that was pushed to them.

#sigh#

Here's what the diagnostics say. The last message is a bit concerning, if not cryptic.
I am passing the account # and it is registered.

Thoughts?


Service Id: XXXX
Display Name: UPS Ground Service
Codes:03 Estimated Cost:10.45 ||

Service Id: XXXX
Display Name: UPS Second Day Air
Service Codes:02
Estimated Cost:22.74 ||

End of Rates ||
If this is all that you see, then you're not yet registered with UPS, there were no rates returned from UPS, the address was missing/invalid, or none of the returned rates match the shipping details of the line items in your order.

You aren't able to see the raw XML request and response in diagnostics mode. You're only able to see the parsed version of it at this time. I've added an issue in GitHub to change this in the future.

https://github.com/Hotca...Commerce/core/issues/154 

In the meantime, you can still do this by setting up a local instance of Hotcakes (if you haven't already done so), and debugging it. Set a breakpoint at the respective lines of code to see the raw request and response.

https://github.com/Hotca...g.Ups/UPSService.cs#L210 

https://github.com/Hotca...g.Ups/UPSService.cs#L219 

---

Thanks, Will. That gave me what I needed to write the XML to the Event log.

Jason

When I compared the XML with what UPS was expecting for negotiated rates*, there were elements missing (in red below).

Also, with this request, HotCakes needs to use the NegotiatedRates in the response. Is that happening?


<?xml version="1.0" encoding="UTF-8"?>
<RatingServiceSelectionRequest xml:lang="en-US">
<Request>
<TransactionReference>
<CustomerContext>Bare Bones Rate Request</CustomerContext>
<XpciVersion>1.0001</XpciVersion>
</TransactionReference>
<RequestAction>Rate</RequestAction>
<RequestOption>Shop</RequestOption>
</Request>
<PickupType>
<Code>06</Code>
</PickupType>
<CustomerClassification>
<Code>01</Code> WAS SET TO 4
</CustomerClassification>
<Shipment>
<Shipper>
<Address>
<StateProvinceCode>TX</StateProvinceCode>
<PostalCode>76107</PostalCode>
<CountryCode>US</CountryCode>
</Address>
<ShipperNumber>XXX</ShipperNumber>
</Shipper>
<ShipTo>
<Address>
<ResidentialAddressIndicator/>
<StateProvinceCode>TX</StateProvinceCode>
<PostalCode>77093</PostalCode>
<CountryCode>US</CountryCode>
</Address>
</ShipTo>
<ShipFrom>
<Address>
<StateProvinceCode>TX</StateProvinceCode>
<PostalCode>76107</PostalCode>
<CountryCode>US</CountryCode>
</Address>
</ShipFrom>
<Service>
<Code>03</Code>
</Service>
<Package>
<PackagingType>
<Code>02</Code>
</PackagingType>
<Dimensions>
<Length>5</Length>
<Width>5</Width>
<Height>6</Height>
</Dimensions>
<PackageWeight>
<Weight>3</Weight>
</PackageWeight>
</Package>
<RateInformation>
<NegotiatedRatesIndicator/>
</RateInformation>
</Shipment>
</RatingServiceSelectionRequest>

Our testing hasn't revealed anything missing in the past. I'm wondering if the requirements have updated on UPS's end and we haven't found out about it yet... This is especially interesting since most stores use UPS.

Could you please provide more details about each of the items you see missing?

---

The items in bold above are missing, but needed.

The ShipTo StateProvinceCode is from the customer Shipping address
The ShipFrom StateProvinceCode is from the store's Shipping address

Our testing hasn't revealed anything missing in the past. I'm wondering if the requirements have updated on UPS's end and we haven't found out about it yet... This is especially interesting since most stores use UPS.

Could you please provide more details about each of the items you see missing?

https://github.com/Hotca...commerce-core/issues/158 

---

Thanks for adding it to the issues list.

Jason

https://github.com/HotcakesCommerce/hotcakes-commerce-core/issues/158

It's also slated for us to hopefully include in the next release. 🙂

---

This has been resolved in the latest release:

https://upendoventures.c...d-support-driven-updates 

---

Thanks, Will!

This has been resolved in the latest release:

https://upendoventures.c...d-support-driven-updates 

We just finished cooking up a fresh batch of Hotcakes for you. Enjoy! ;)

https://dnncommunity.org...-Marks-a-Major-Milestone 

---