How to import shipping rates
The Shipping Table Rates module offers functionality for importing already existing tables with shipping rates through a CSV file. Get acquainted with the format of this file by exporting shipping rates from your store or module's demo.
In order to import shipping rates from the CSV file, you need to create methods according to store views and customer groups.
Upload the CSV file with shipping rates to your server into folder var/import/table_rates.csv. The file has to be named as table_rates.csv.
Navigate to the shipping rate page configuration by going through Stores > Configuration > Shipping Table Rates and pressing Import button.
Note
Important: If you want to add new rates to the existing rates with import, keep in mind that import will delete the rates that have the same shipping method as rates from the import file. This is done so that you don't have to delete rates manually if you don't need them. If you need to keep the existing rates, you have to export your existing rates, add new ones to the exported file, and then import the updated file.
Example
For example, if you have 10 rates for shipping method A, and in your import file, you have 3 rates for shipping method A, then import will delete these 10 rates and add 3 new rates from the import file.