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:
- 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.
- If the product weighs more than 150, then the shipping cost is the number of that item in the order × 200.
- If the product weighs more than 70, then the shipping cost is the number of that item in the order × 100.
- 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
- Create a new shipping method called UPS Ground using the UPS provider.
- Select the Ground shipping type.
- Create a new shipping method called UPS Second Day Air using the UPS provider.
- Select the Second Day Air shipping type.
- Create a new shipping method called Standard using the Package Rules provider.
- Create a new packaging rule called Pallets with the following criteria†:

Item Custom Property "Pallets" > 0
and Item Quantity = 1
- Create a new packaging rule called Weight > 150 with the following criteria‡:

Packaging Name = (blank)
and Item Weight > 150
- Create a new packaging rule called Weight > 70 with the following criteria:

Packaging Name = (blank)
and Item Weight > 50
- Create a new shipping cost rule:

When Packaging Name = "Pallets", Cost = Item Custom Property "Number of pallets to ship" x 250.
- Create a new shipping cost rule:

When Packaging Name = "Weight > 150", Cost = Item Quantity x 200.
- Create a new shipping cost rule:

When Packaging Name = "Weight > 70", Cost = Item Quantity x 100.
- Edit the default shipping cost rule:

For all remaining packages, use rate from "UPS Ground" x 1.
- 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).
- 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
Some parts of this site will not work effectively on this older browser.
Please consider
updating your browser