There has been some discussion and mention of editing the table rates via csv file upload. This method is not working in version 1.3, and here is the solution to editing the database manually for the table rates to work.
SQL query:
INSERT INTO `shipping_tablerate` (`pk`, `website_id`, `dest_country_id`, `dest_region_id`, `dest_zip`, `condition_name`, `condition_value`, `price`, `cost`) VALUES
(1, 1, '0', 0, '', 'package_value', 0.0000, 4.9900, 4.9900),
(4, 1, '0', 0, '', 'package_value', 50.0000, 10.9900, 10.9900),
(5, 1, '0', 0, '', 'package_value', 150.0000, 0.0000, 0.0000);
This is telling Magento that website ID 1 (main website) for all Countries (0) and all regions (0) and all zips (0) calculate according to subtotal (package_value), if Subtotal is 0.00 then show the Customer 4.99 and charge them 4.99. Secondly, if Subtotal is $50 then show the Customer $10.99 and charge them $10.99. Thirdly, if Subtotal is $150 then show the Customer $0.00 and charge them $0.00.
I used table rates for package value here are the other 2 methods of table rates: Either ‘package_weight’ or ‘package_qty’.