1. User Guide: Shipping Table Rates Page 1Shipping Table RatesMagento ExtensionUser GuideCopyright 2012 amasty.comSupport: http://amasty.com/support.html

2. Table of contents:1. Enabling the extension .. 32. Where to create custom shipping methods ... 53. General method information .... 64. Select store view and customer groups ......... 75. Import CSV file with shipping rates ..... 86. View imported rates ... 97. Edit existing rates and add new ones ... 118. Example of csv file with rates ... 129. Shipping type . 1310. Example . 15Page 2Support: http://amasty.com/support.htmlCopyright 2012 amasty.comUser Guide: Shipping Table Rates 3. Page 3Support: http://amasty.com/support.html1. Enabling the extensionCopyright 2012 amasty.comUser Guide: Shipping Table RatesYou can make shipping availableboth for all countries and forspecific ones only. From the list ofcountries please choose those, forwhich you would like to createshipping methods with the module.To make the module workgo to Admin panel ->System -> Configuration ->Sales tab -> Shippingmethods.Set this option to Yesto enable the module.Put to Yes if to exclude freeshipping items from theshipping methods createdwith the module. 4. Page 4Support: http://amasty.com/support.htmlCopyright 2012 amasty.comUser Guide: Shipping Table RatesSet numeric zip to yes touse the intervals. Forexample, if you set up zipcode interval from 12346 to12349, the rate will apply tothe adresses, which includeany zip code from theinterval (12346, 12347,12348, 12349).When you set this option to Yes,price and quantity of virtual productswont be considered for calculation ofshipping rates for orders.You can indicate that a shippingrate should apply to price of theproduct after discount. Lets say aproduct costs $100. If after thediscount it becomes $70, shippingrate for 70-dollarproducts willapply to it.1. Enabling the extension 5. Page 5To create shipping methods pleasego to admin panel -> Sales ->Shipping Table RatesSupport: http://amasty.com/support.html2. Where to create custom shipping methodsCopyright 2012 amasty.comTo add a methodplease click AddMethod button.User Guide: Shipping Table Rates 6. Page 6At the General tab you can activate themethod, specify its name and priority.With the help of priority you can managethe order in which methods are displayedat the Shipping Methods step of checkout.Support: http://amasty.com/support.html3. General method informationCopyright 2012 amasty.comUser Guide: Shipping Table Rates 7. Page 7Support: http://amasty.com/support.html4. Select store view and customer groupsCopyright 2012 amasty.comUser Guide: Shipping Table RatesAt the Stores & Customer Groupstab you can choose at which storeview and for which customer groupsthe method should be available. 8. Page 8Support: http://amasty.com/support.html5. Import CSV file with shipping ratesCopyright 2012 amasty.comUser Guide: Shipping Table RatesAt the Import tab you can import csv file with the ratesinformation. You can find sample csv file at the specifiedurl and within the extension package. Please see the nextpages for explanation on csv structure.If you set Delete Existing Rates option to Yes, all ratespreviously imported for this method, will be deleted. 9. Page 9Support: http://amasty.com/support.htmlCopyright 2012 amasty.comUser Guide: Shipping Table RatesAt the Methods and Rates tab you can view the imported rates. You can see address, price, quantity, weight, shipping rate andshipping type data here.Rate column means base rate for the order which qualifies for the specified address, product price, weight and quantityparameters. In this case the flat rate of 12 will be applied to order shipped to Arkansas, with total product price between 33 and880, quantity between 2 and 2000, etc.PPP column percent per price. In this situation shipping will be calculated as 3% of total product price.FRPP column flat rate per product. Flat shipping rate of 7 will be added for each product within the order.FRPUW column flat rate for the unit of weight (kg or lb)Shipping type column.All the rates you defined in Rate, PPP,FRPP and FRPUW columns will apply only to the products of the shipping type youassign in Shipping type field. This way you can create unlimited number of rates for one or several products of specific types. Theprocess of assignment of products to shipping types will be described further in this user guide.6. View imported rates 10. Page 10Support: http://amasty.com/support.htmlCopyright 2012 amasty.comUser Guide: Shipping Table RatesRate, PPP, FRPP and FRPUW are added to each other, so in our situation shipping will be calculated as 50 per orderplus 3 percent of total product price plus flat rate of 7 plus 0,1 for the unit of weight for each product. If we have in cart 3products which cost 2000 and weigh 200 lb, with extra large shipping type, the price of shipping to Arkansas will be:151 = 50 (flat rate per order) + 60 (3% of product price) + 21 (7 per product) + 20 (0.1 for each lb of weight)For extra large products shipped to NY shipping rate is less in our setup. Also, shipping rate differs for the goods, locatedin CA storehouse when they are shipped to the other coast (NY), etc.6. View imported rates 11. Page 11Support: http://amasty.com/support.html7. Edit existing rates and add new onesCopyright 2012 amasty.comUser Guide: Shipping Table RatesTo edit a rate, pleaseclick on the record.To add a new raterecord, please clickAdd New Rate button. 12. Page 12Support: http://amasty.com/support.html8. Example of csv file with ratesCopyright 2012 amasty.comUser Guide: Shipping Table RatesIn the csv file please specify a value for each column of Methodsand Rates tab. You can find sample csv file within the extensionpackage or at http://amasty.com/examples/tablerates.csvIf you use * symbol for some column, it means that the rate willbe applied to all values of this parameter. For example if youspecify * for zip column, the rates will be applied to order withany zip code. 13. Page 13Support: http://amasty.com/support.html9. Shipping typeCopyright 2012 amasty.comUser Guide: Shipping Table RatesAs it was described before, you can use shipping type attribute for a product or agroup of products to make a shipping rate work only for this particular product orgroup of products.To create the options for shipping type attribute please go Catalog -> Attributes ->Manage attributes -> Edit Product Attribute "Shipping Type-> ManageLabel/Options.Create the optionsyou will use for theshipping rates. 14. Page 14Support: http://amasty.com/support.html9. Shipping typeCopyright 2012 amasty.comUser Guide: Shipping Table RatesAfter youvecreated the necessary options, they are availableforassignment to any product from your product list. Go to Catalog ->Manage Products and choose a product.You can assign any value of theattribute to the product. Then onceyou create a shipping rate for thisshipping type, the rate will apply onlyto the products with the shipping type. 15. Page 15Support: http://amasty.com/support.html10. ExampleCopyright 2012 amasty.comUser Guide: Shipping Table RatesShipping type for the refrigerator is extralarge. It is shipped to Arkansas. According toour rates table, the shipping costs $141.20 forextra large item of this weight and price. 16. Thank you!Your feedback is absolutely welcome!Page 16Support: http://amasty.com/support.htmlShould you have any questions or feature suggestions, please contact us at:http://amasty.com/support.htmlCopyright 2012 amasty.comUser Guide: Shipping Table Rates