How to fix the errors while importing CSV with the shipping table rates?
If you are facing difficulties with importing a CSV file, it is necessary to check if the following conditions are met:
1. The country spelling in the CSV file is identical to the spelling of country names at Stores → Configuration → General → General → Country Options:
2. The state spelling in the CSV file is identical to the spelling of states in the dropdown via the following path - Sales → Shipping Table Rates → Shipping Method → Methods and Rates → Add New Rate:
3. Values in the Shipping Type column of your CSV file have been previously added to the values of the am_shipping_type attribute. The attribute is located at Stores → Attributes → Product Attributes:
4. There are no logic mistakes in the Price, Weight, and Qty columns. For example, the incorrect setup would be weight range specified from 100 kg to 50 kg:
5. Before importing the rates, make sure you've created a shipping method to which the import actions will be applied:
A new shipping method can be created at Sales → Shipping Table Rates → Add New:
If none of these recommendations help, please feel free to