Managing Shipping Methods & Shipping Costs

Overview

This article reviews concepts and set-up instructions for shipping methods as part of the base platform. Additional features are available in several of the addon bundles – Optional Software Bundles Overview.

The base platform allows for the creation of shipping methods that users can select from and the selected method can be passed onto the order in the ERP system.

Options include:

1. Setting up internal rate structures for a fixed amount or percentage based on product cost, weight, or count. This can include just setting a fixed shipping cost for a given method.
2. Making an external call to your Fedex or UPS account to return rates based on a fixed ship from location, the shipping address on the order, and the weight of the product. For the external calls to UPS and Fedex to work  the products must have a weight. More information on product weight can be found later in the article. These external calls are for parcel shipping only. Freight shipping external pricing calls requires the additional software bundle – Advanced Shipping Price Calculations [L]
3. A call out to USPS can be added to the site but requires a small amount of additional set-up. If this is something you need on your site please enter an extranet support ticket to request pro-services assistance setting up USPS shipping.
4. Different shipping methods can be set to display/not display based on:
   1. Order product weight total
   2. Order Price total
   3. Ship to location
5. A shipping method can be set up to collect the customer’s shipper account information. This will be covered in a separate article – Shipper Accounts
6. Shipping methods can be set to display a message instead of cost. This is typically something like TBD where you will add actual freight costs at time of invoicing.
7. Add multipliers to external rates to increase or decrease the rate present to customers based on the value returned for the carrier.

Note: You will never be able to set up the website so that you will always get an exact match from UPS or FedEx on the actual costs they will charge. Packaging weight, how items are packaged together, rate changes, and other factors will likely cause difference in the cost calculated. You can expect the cost calculated to be close, but there are likely to be some differences.

Prior to setting up shipping methods you will want to make sure you understand how you want to offer shipping on the site. Do you need to charge shipping on the site or can you just add it to the invoice after the item ships? Are you using shipping as a profit center? Is shipping built into the cost of the product? Do you need to offer expedited shipping methods? All of these should be considered before crating shipping methods on the site.

What A Customer Site User Sees

Users should be able to see shipping methods at checkout (Figure 1) along with the calculated shipping cost for each method. The cart total will reflect the cost of the selected shipping method. The shipping method display name can be a user friendly name and does not have to match the ship via set up in the ERP.

Users can also see the the shipping methods and cost in the shipping estimator (Figure 2) in the cart and cart pop-up if feature for this enabled.

Currently available configuration options will be reviewed in the Features section of this article.

 

What a CRM Worker Sees

A CRM worker will not see anything additional and will see what a user sees when impersonating.

What an Admin Worker Sees

Admin workers are the ones who will be setting up the shipping for the customer site(s). The basic set-up process would be:

1. Set up any 3rd party integrations (UPS, FEDEX,…) with your account credentials and ship from information
2. Set up the desired shipping methods
3. Test to ensure desired shipping methods display and rates are what are expected.

Setting up 3rd party integrations.

Third party integrations are associated with the application as a whole and are not specific to a user or customer site. There are some additional software bundles that have features to associate different aspects of a 3rd party integration with a specific warehouse. See the additional software bundles for more information.

To set up 3rd party credentials go to Setting Workspace > System-Wide Settings > Application Settings and choose the Features > Shipping tab.

1. General Settings
   1. Ship From State – The State of the location from where packages are shipped
   2. Ship From Postal Code – The Zip Code of the location from where packages are shipped
   3. Max Weight Per Box – The system uses this to determine how many packages to break the order into. If an order has items that total 66 pounds and this is set to 40, the system will send this for rating as two packages of 33 pounds. If the order totals 39 pounds then it will be rated based on one package of 39 pounds. This is independent of how many items are on the order.
   4. Default Warehouse – Enter the default warehouse code from where packages are shipped. The address on this warehouse should match the address information entered above.
2. Use UPS Integration? – Enables UPS rate calculations. You will need to sign up for a UPS API account and enter the credentials they provide. Important: Do not use the test credentials that may have been provided to you by CIMcloud for production usage, otherwise the rates may be incorrect or become unavailable.
   1. Integration – Choose Standard (Rest API) to use the UPS OAuth connection.
      1. Important:  The Legacy integration is no longer supported by UPS as of June 2024. CIMcloud Version 2023.09 (internal version 4.7) added the UPS OAuth connection. – Details on the change are in this article
   2. Client ID – Enter the OAuth information provided to you in the UPS Developer Portal
   3. Client Secret – Enter the OAuth information provided to you in the UPS Developer Portal
   4. Shipper Number – Enter the shipper number associated with the account for the desired rates. Appropriate values are:
      1. For Negotiated rates enter the Account Shipper Number
      2. For Retail Rates leave this field blank
   5. Rating Type – Select the appropriate rating type for your situation
3. Use FedEx Integration? – Enables FedEx rate calculations. You will need to sign up for a UPS API account and enter the credentials they provide. Important: Do not use the test credentials that may have been provided to you by CIMcloud for production usage, otherwise the rates may be incorrect or become unavailable.
   1. NOTE: As of 08/22/2016, FedEx provides 3 levels of service: Standard, Advanced w/o Shipping Label, and Advanced with Shipping Labels. The customer should request Advanced w/o Shipping Labels to avoid receiving “FedEx Error 1000 – Authentication Failed”
   2. Integration – Choose Standard (Rest API) to use the FedEx OAuth connection.
      1. Important: The Legacy integration is no longer supported by FedEx – Details on the change are in this article
   3. Client ID – Enter the OAuth information provided to you in the FedEx Developer Portal
   4. Client Secret – Enter the OAuth information provided to you in the FedEx Developer Portal
   5. Account Number – Enter your FedEx Account Number
   6. Rate Type
      1. Account – Your Negotiated rates
      2. List – Standard rates that apply to non-account holders
      3. Preferred – This is a legacy setting and sets the rates the same as List
4. Use USPS Integration? – Enables USPS rate calculations. You will need to sign up for a USPS API account and enter the credentials they provide. Important: Do not use the test credentials that may have been provided to you by CIMcloud for production usage, otherwise the rates may be incorrect or become unavailable.
   1. Client ID – Enter the Consumer Key provided to you in the USPS Portal
   2. Client Secret – Enter the Consumer Secret provided to you in the USPS Portal

Setting Up Shipping Methods

Go to Settings Workspace > Shipping > Shipping Methods to manage shipping methods.

General Information/Software Tracking Code/Price Calculation

1. Display Status – Enabled Shipping Methods are available to display. Disabled methods will never display.
2. Reference ID – This is a unique identifier for the record and cannot exist on two different shipping methods and is not shown to end users. Avoid using spaces and special characters.
3. Name – This does not need to be unique and is what end users see on the customer site(s)
4. Alias Name – Field available to populate for internal (Worker Portal) to assist in identifying the method and its use case.
5. Description – This can just be an internal note or optionally shown end users during checkout. Turn on the Quotes / Ordering > Shipping Settings >  Show the Shipping Method Description on the payment page feature setting to show this to end users.
6. Eligible For Free Shipping – This field is associated with features enabled in software bundle – Advanced Shipping Price Calculations. Outside of this bundle this setting does not impact how the shipping method returns information.
7. Sort Order Position – You can use this to control the display order of the shipping methods shown to the user at checkout. This only works if the Shipping Settings feature setting is set to either Position Ascending or Position Descending.
8. Sales Order Code – This is the value passed into the ERP order (Sage100 – Ship Via) when the method is selected for the order. If blank this field is blank on the order.
9. Calculate Price – If you are wanting the method to return a value based on the additional set-up to follow then select Yes. If you are just wanting users to be able to select a shipping method and are not presenting a cost for the particular method then select No.

Rate (External)

If want to return rates from UPS or FedEx the select the External Lookup button and the following options will allow you to select the specific external method from the carrier to call.

1. Rate Type – For external Rates select External Lookup
2. External Lookup – This is where you select UPS or FedEx
3. UPS/FedEx External Method – The dropdown will have the available options for that carrier. It should be noted that for FedEx there are two separate methods for standard ground shipping based on if the address entered is flagged as residential or not. An address flagged as residential will not return FedEx Ground and an address not flagged as residential will not return FedEx Ground Home Delivery. Typically we recommend customers set up a method for both of these an call them both FedEx Ground as only one of these will return for a given shipment.
4. Multiplier – This allows you to adjust the rate returned by a multiplier. If you want to just use the rates returned then enter 1. If you want to increase by 10% then the multiplier would be 1.1. If you want the rates to be a fraction of the returned rates then the multiplier would be less than 1.

Rate (Internal)

This allows you to set up up an internal rate structure versus making a call out to UPS or Fedex.

1. 1. Rate Type – To set up an internal rate structure set this to Internal Rae Table. An internal rate structure allows you to set up rates without making external calls to UPS or FedEx. The following fields show the available options for for setting up this structure.
   2. Internal Rate Table Threshold – This is what the rate table is based on and what the values entered in the next field, Threshold, apply to. The possible values are:
      1. Weight (the total weight of the items in the particular shipment/order. The weight pulls from the standard weight field on the product which is typically synced from the ERP)
      2. Product Total ( The total product price on the order/shipment)
      3. Product Qty (the total quantity of items for the order/shipment)

The following 3 fields (3, 4, and 5 above) can be used to create multiple entries. After entering the three values click on the small plus sign above the Configured Columns section (Marked as 6 in the image above). The plus is one of the options to the right. This allows you to build out a table with different structures based on the particular value for the Internal rate table Threshold.

1. 3. Threshold – this is the starting value of the chosen Internal Rate Table Threshold selected. The first entry is typically going to be 0 and subsequent entries will be the starting value for the next line in the rate table being created. So if you chose Weight in 2 above, the value here would be the starting value for the order/shipment weight and will apply up to the next entry in the table. If you just create one entry starting at 0 then the subsequent values will apply to any order.
   4. Type – this is how the shipping cost/value is calculated. The options are:
      3. 1. % of Product Total – Choose this if you are wanting to calculate the shipping cost based as a percentage of the Internal Rate Table Threshold value. This is typically used mainly with the Product Total Option. This would allow you to set the particular shipping costs as a percentage of the order/shipment total price.
         2. Fixed Price/Amount – This allows you to set a fixed cost for the particular table tier.
   5. Amount – This is the particular value based on the Type selection. If Percentage was selected then a 10 entered here would be 10% and if Fixed was selected before a value of 10 would mean a fixed value of $10 would be applied as shipping cost for this table tier.
   6. Configured Columns – This will show the list of values set up using the three previous options noted. You can use the icons to the right to Edit, Copy, Add, or Delete options.
   7. Multiplier – This allows you to apply a multiplier globally to the value returned in from the rate table.

Filters and Shipper Account Collection

This section allows you to enter criteria to filter the entire shipping method by. If the order does not meet the order criteria it will not display to users as an option at checkout. The available filter options are Weight, Price, and Geographic Location of the Shipping Address on the order.

1. Filter By Weight Total – All Weights means this method will display no matter what the weight on the order. If you only want this particular method to display for a specific weight range then select Only Within Weight Range and enter the weight range values.
2. Filter by Product Price Total – All Product Price Totals means this method will return no matter what the total shipment value. If you only want the method returning for a specific range of shipment price totals then select Only Within Price Total Range and enter the desired range.
3. Filter By Ship To Address on Order – This allows you to filter the specific shipping method based on the shipping address selected. If you want the method to show for all orders select All Countries otherwise select the specific options that match the desired restrictions for this shipping method. You can filter by Country, State (in the USA), and Zip Code.
4. Filter By Product Warehouse – This allows you to either include or exclude the shipping method based on product warehouse.

Use Shipping Method to Collect End Customers Shipping Account

This final section allows you to set up the shipping method to collect the Carrier/account information from the end customer to use their shipping account with the carrier to bill them directly. The particular set-up for doing this is in a separate article – Shipper Accounts