Free shipping when the amount of purchases reached

Hi guys ,

Would like to know how to configure the shipping method to provide Free Shipping when a the purchase amount reaches the threshold e.g $20 else charge them a fixed shipping fee.



Regards

Hi,

I think that the best solution would be to :
- Set the weight of all of your product to 1Kg
- Create your new FREE manual shipping and set the "Minimum weight" option to 20Kg
- And set the "Maximum weight" option of the other manual shipping methods to 20KG.

Hope this will help you a little.

which means , I need two manual shipping methods.
one set the price for minimum n maximum to 20 kg and set the price to $0
one set the price for default pricing for the shipping price to $10

If i want to change the shipping items to 10 , i set the kg limit to 10.
I already have created quite a number of products , i need to manually set them 1 by 1 ? Any other simpler way?

The other way would be to :
1. Using an SQL request through your phpmyadmin

2. Exporting your products trough a CSV file, editing this file and importing it.

Mind pointing out the tables and which columns needed for the SQL query. thx