On exporting the CSV file of shipping rates, the vendor will get all the details of the destination addresses with the product’s SKU and price.
The Per Product Shipping Rates CSV file contains the fields such as Country, Region/State, City, Zipcode, SKU, and Price.
All related fields and rules that should be kept in mind while importing the CSV files are described below:-
In this field, the country name should be in ISO (alpha 2) or ISO (alpha 3) country code.
The ISO country codes are internationally recognized codes that designate each country and most of the dependent areas have a two letter combination or a three-letter combination, it’s like an acronym that stands for a country.
For example, ISO2 (two-letter) country codes are US (United States), FR (France)) and ISO3 (three-letter) country codes are CAN (for Canada), DNK (for Denmark), AUS (for Australia).
In this field, only ISO country codes will be saved. Otherwise, it will give an error while importing.
In this field, a valid region/state should be entered. Magento 2 has stored Region id on the basis of Region/state name in the database. For the state/region mentioned in the CSV file, the respective region id will be stored in the database. So, a valid Region/State with proper naming convention should be given, otherwise, it will give an error while importing.
For example, newyork State will give error while saving the uploaded file, it should be NewYork
In this field, any city name can be provided. If no city is provided, then it means ALL CITY (*) of that state and country.
In this field, the postal code of the state is provided. The destination address of the customer will be matched with the fields of the CSV file, shipping rates will be calculated according to the different destination address.
Now here comes the field on the basis of which shipping rates will be specified product-wise. Here the vendor will enter the SKU of the product. Shipping rates can be determined product-wise.
This is the field where the shipping price of different destination addresses and different products’ SKU is specified. Price provided here will be shown on the cart and checkout pages as a shipping cost of a particular destination address and particular product.