How to fix the errors while importing CSV with the shipping table rates?

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 contact us.

      • Related Articles

      • How to import Shipping Table Rates?

        Due to the functionality that relies on Magento Import component, it is possible to seamlessly import huge data volumes via a CSV file in a few clicks. Our Shipping Table Rates module allows importing rates to the methods created in the instance. ...

      • Shipping Table Rates API

        The methods listed below are not implemented by our module but are part of Magento itself. Our Shipping Table Rates module does not introduce its own API methods for the exclusive managing of rates created by the extension. However, all the Magento ...

      • I have configured several shipping rates, but only one of them is shown on the storefront. How to fix that?

        Such behavior is expected - according to the logic of the Shipping Table Rates extension, only one rate from the method is displayed on the storefront. It means that, if you have one Shipping Table Rates method with multiple rates inside, a single ...

      • How do I exclude postcodes while setting up shipping table rates?

        Out of the box, the Shipping Table Rates module does not allow excluding postcode ranges. However, this feature is presented in our Shipping Rules and Shipping Restrictions extensions. With the help of the Shipping Areas submodule that comes in a ...

      • The shipping method doesn't show up on the frontend. How do I fix it?

        If the shipping methods created with Shipping Table Rates are missing on the frontend, it is necessary to make sure that: 1. The extension is enabled at Stores → Configuration → Sales → Delivery Methods for the right store(s), and the required ...