This is the first time a client of us starts selling in the US, so we get to deal with US warehouses and US shipping carriers. My client has decided he wants to ship his packages using UPS.
All products are shipped from a US warehouse (Webgistix), we communicate to their systems via their API, that all goes well.
As you can imagine, Webgistix offers discounted shipping rates over the default UPS rates.
Since UPS offers a lot of methods with a lot of tiers we thought it would be a good idea to use the build-in UPS shipping method and configure it in such a way we can use the Webgistix shipping rates.
In the UPS module we have the ability to 'Enable Negotiated Rates', but we need to connect it with the rates of Webgistix.
The reason I though this might be possible is because I can enter a 'Shipper Number (Required for negotiated rates; 6-character UPS.)' in Magento. I though I'd enter my own API credentials and enter Webgistix Shipper Number to get their rates.
Of course we have already contacted webgistix about this, but they aren't too technical and they don't know how to set this up, they just provided a PDF with thousands of prices and expect us to manage that manually or something...
Is this even possible to use the UPS module? If not, is there another solution or should I enter everything manually.