Software to help you build a better store
SEARCH
June 22, 2007

Shipping Rate Provider Suite Freight Sample

This sample shows how to use the Shipping Rate Provider Suite for BVC5 to split an order between UPS and freight using the following rules:

  1. If the product has a custom property named "Pallets" (the number of pallets required to ship the product) and the value of the property is greater than 0, then the cost of shipping the item is the number of pallets × the number of that item in the order × 250.
  2. If the product weighs more than 150, then the shipping cost is the number of that item in the order × 200.
  3. If the product weighs more than 70, then the shipping cost is the number of that item in the order × 100.
  4. Otherwise, use UPS Ground and UPS Second Day Air to calculate the shipping cost for the item.

The list of shipping costs shown to the customer should look like this:

  • $x.xx - Standard
  • $x.xx - Express

Where Standard is UPS Ground combined with the freight costs and Express is UPS Second Dar Air combined with the freight costs.

Prerequisites

  • Shipping Rate Provider Suite 2.5
  • UPS Account

Steps

Watch the video

  1. Create a new shipping method called UPS Ground using the UPS provider.
    1. Select the Ground shipping type.
  2. Create a new shipping method called UPS Second Day Air using the UPS provider.
    1. Select the Second Day Air shipping type.
  3. Create a new shipping method called Standard using the Package Rules provider. Screen shot
    1. Create a new packaging rule called Pallets with the following criteria: Screen shot
      Item Custom Property "Pallets" > 0
      and Item Quantity = 1
    2. Create a new packaging rule called Weight > 150 with the following criteria: Screen shot
      Packaging Name = (blank) 
      and Item Weight > 150
    3. Create a new packaging rule called Weight > 70 with the following criteria: Screen shot
      Packaging Name = (blank)
      and Item Weight > 50
    4. Create a new shipping cost rule: Screen shot
      When Packaging Name = "Pallets", Cost = Item Custom Property "Number of pallets to ship" x 250.
    5. Create a new shipping cost rule: Screen shot
      When Packaging Name = "Weight > 150", Cost = Item Quantity x 200.
    6. Create a new shipping cost rule: Screen shot
      When Packaging Name = "Weight > 70", Cost = Item Quantity x 100.
    7. Edit the default shipping cost rule: Screen shot
      For all remaining packages, use rate from "UPS Ground" x 1.
  4. Create a new shipping method called Express using the Package Rules provider with all the same packaging and shipping cost rules (you can export the Standard packaging and shipping cost rules and then import them into Express). 
    1. Edit the default shipping cost rule:
      For all remaining packages, use rate from "UPS Second Day Air" x 1.

Adding the criteria Item Quantity = 1 will force each item into a separate "package". This is exactly the same as selecting Ships Separately in the catalog.
Adding the criteria Packaging Number = (blank) where (blank) is literally nothing (not the word "blank"), will ensure that items are not repackaged.

This site looks much better in a browser that supports current web standards, but it is accessible to any browser. Download one now This link is to a third party web site which will open in a new window

Some parts of this site will not work effectively on this older browser.
Please consider updating your browser This link is to a third party web site which will open in a new window

SSL