download the template.
We recommend using a spreadsheet programme to manipulate the rules such as Calc.
Note: A CSV should be delimited by commas, strings enclosed by quotes. So please maintain the CSV format when you save.
Write your rules in pseudo code and try to break them down to the simplest form.
We will go through a running example demonstrating different features of Shipping Override and how to implement different scenarios.
Note: any columns omitted are either empty or unimportant to the example shown, you will still need to have all columns present in your CSV file.
The scenario we have here is a store using UPS live rates using Ground, Next Day Air, and Worldwide Express delivery types.
Here we want to exclude international shipping from certain products. Our reason could be that they are only sold within the provider's country. This may also be used to exclude pickup only items, freight items, or for any other reason.
We have defined an attribute under the special_shipping_group as `NO INTERNATIONAL` (case sensitive) to apply to any products we are excluding from Worldwide Express. To do this we set the shipping price to `-1`. Under the product listing each product this applies to now needs to be assigned this attribute under the `shipping` tab. The behaviour of this rule will exclude `Worldwide Express` from showing in the quote whenever any product in the attribute set is in the cart.
We want to provide free shipping on `Ground` when a certain product is in the cart. The shipping price set will be the replacement quote for `Ground`.
We want to charge table based rates for shipments to Alaska and Hawaii. This is done using the ORDER algorithm, using AK, HI states as the destination filters.
Once the cart total is > $100 then no longer show Ground shipping.
Appending the custom freight rate for products selected as shipping by freight and removing Next Day Air from the rate.
Offering 25% off Ground shipping on selected products.
To see the final CSV used in this tutorial - download the example and see above
Have a look at our examples for more demonstrations of Shipping Override including scenarios not shown here.
Change the Configuration Scope to Main Website in Shipping Settings of System > Configuration
Choose File > Browse to your CSV and Save Config to upload.