Extensions‎ > ‎Handling Fees Matrix‎ > ‎

Configuration



Installation



  • Extension installation instructions «HERE»

  • Display Shipping Settings in AdminSystemConfiguration.

  • Enable "Handling Fees Matrix"

Configuration


Handling Matrix is set up using a combination of a csv configuration file which is uploaded, and the configuration under system->configuration->shipping settings.
 
Within the csv file you have control over the handling rates depending on:
 
  • Destination
  • Weight
  • Price
  • Qty in cart
  • Product type (Shipping Group)
  • Delivery Type (As of zip version 5.2)
You can use the csv to create quite complex rules - e.g. Apply a $5 handling when Product X is in the cart and it's being shipped to Alaska and price > $100.
 
The Shipping Settings provide additional controls.
 
More information below.
 

 

Handling group attribute setup


Handling Fees Matrix creates a magento attribute called ' handling_id ' with the title Handling Group.
 
Handling groups are used to group together products that have the same handling price rules. 
 
See this section for further information on shipping groups and how to configure.
 
As an example I may be selling bikes & accessories, both of which have different handling price rules. A such I will create 2 handling groups - BIKES, ACCESSORIES.
 
 

Totaling Algorithm


There are the following choices:

  • Cumulative Totalling – Each handling rate found is totaled together to get a final rate that is added to the shipping cost.  So, for example if I had Product A with handling rate $4 per order, and Product B with handling rate of $5 per order the final handling rate would be $9

  • Highest Price Totalling – Handling rate is ascertained by the highest rate across the groups. So using above example handling rate would be $5

  • Per Unique Product Totalling - Handling rate is calculated per unique product in the cart. E.g. Product A (qty = 100) + Product B (qty=50) the extension would see the quantity as 2

  • Per Item Totalling - Handling rate calculated based on each item's individual price.  E.g. If I have 2*BIKES which have price of $50 each would match on a price filter rule of 0-80, but not on 80-120 as looking at each individual price ($50)


Apply Handling id “*” to all items in cart


The use of a * in handling id within the csv file can provide different results depending on the configuration of this field

The 2 options for the meaning of * are :

  1. Include all items that do not have a handling group assigned

  2. Include all items in the cart

So, lets say you want to give bulky products a handling rate of $20 per order, and all other products a handling rate of $5 per order. You would set this field to NO, and then in csv file create rows for where handling group is “*”.

If, though, you wanted to set a base rate of $5 per order for all products, then if it was bulky apply another $5 per item, this can be done by setting the field to YES.

 

Apply Handling on Zero Shipping Price

 
If the shipping price is zero this option allows you to prevent handling from being added, e.g. if you offer a pickup option you can use for this.

 

Table Configuration





Table columns at your disposal :



Name

Description

Country

Destination Country – use * for all

State

Destination State – use * for all

City

Destination City (generally not used) – use * for all

Zip from

Destination zipcode (e.g. BT% to match Northern Island or 14353 to match zip codes starting with this value). This extension does not support UK postcode filtering.

Zip to

Only used when wanting to match numerical zipcode ranges

Handling Group

Can be assigned to 1 or more products. Identifies the handling rates for those products. Can be set to * to either include all products, or include all products not in other handling groups (see configuration section below).

Price From

Minimum price above which this rate applies

Price To

Maximum price at which this rate applies

Qty From

Minimum no of items that must be greater than of combined products in cart with package id above

Qty To

Maximum number of combined products in cart with package id above

Price

The price that the customer will be charged assuming all

criteria in row is met

Algorithm

Can be set to either ITEM, ORDER, PRODUCT, PERCENTAGE_CART, PERCENTAGE_SHIP or WEIGHTINC=50.

When set to ITEM the handling price is multiplied by the #items of the handling group in the cart.

When set to ORDER the handling price is used as a flat rate for the order.

PRODUCT indicates will multiple by unique product qty in cart (e.g. 3* Product A and 2 * Product B would result in qty being 2). Only applicable if you have Per Unique Product Totalling.

When set to PERCENTAGE_CART the handling price is determined by the price column being used as a percentage multiplied by the sum of the items in the handling group (* for all items).

PERCENTAGE_SHIP allows you to increase/decrease the shipping price by a percentage. E.g. you can say reduce all shipping prices by 25% when order total is over $100

 Delivery Type

Enter the delivery type as shown on the front end. E.g 3 Day Select.  

(This is supported from zip version 5.2)