How Can I Import Custom Carrier Rate?

Screen Path : WMS > Setup > Carrier Setup > Custom Carrier Rate

This screen is used to define constant rates base on the agreement between carrier and account owner. (Like UPS-MI)

All fields on the screen are also available on excel import pattern. Warehouse - Client - Carrier fields are mandatory and definition of your process. 

Package Type: If your shipping service got any special package type definition, you should also select that on this screen. On CarrierRateShopping process, system will automatically assign that package type for your order.

Weight - Carrier Rate: For most of these agreements, weight/zone information is the determinant and separator of rate. You will define that through that screen.

UPS MI Zone: This is a special field for UPS-MI service. These zones are provided by UPS or you can get that information from the following link. https://www.ups.com/us/es/shipping/zones-and-rates/48-contiguous-states.page

Valid Date: These agreements have validation date period. You will define that period to that fields. After the validation date is expired, the system will block that registration. 

On excel file, you have to pay attention some rules when filling them. 

Prefix: If your carrier has any defined prefix on carrier management screen, you must fill that field. Format should be like "Prefix-Carrier" format. As an example, if you have a UPS setup with marked with TEST prefix; you should fill that field as TEST-UPS.

Weight: Weight units are always ounces(OZ)

Valid Date: Please always use mm.dd.yyyy as date format.

 If you have several rates to define to the system, you can import custom carrier rates from excel rather than defining them one by one. First of all, if you do not have any excel template, you can "Download excel Template and save it, then you need to click "Import Custom Carrier Rate from Excel" button and  choose your excel. Relevant screen view is shown below:

Couldn’t Find What You Were Looking For?

Write to our support team: support@logiwa.com