Advance Rate Shipping for Magneto 2 - CedCommerce Products Documentation

3.1.Explanation to .csv Format
↑ Back to Top

On exporting the .csv file of shipping rates, admin will get all the details of shipping rates with different combination of Destination address, Weight, Quantity and Order Subtotal.

Fields in the Advance Rate .csv files are Country, Region/State, City, Zip/Postal Code, Weight From, Weight To, Order Subtotal From, Order Subtotal To, Quantity From, Quantity To, Shipping Price, Shipping Method.

All fields and rules related with the fields that should be kept in mind while importing the .csv file are described below:

Country

In this field, country name should be in ISO (alpha 2) or ISO (alpha 3) country code. The ISO country code are internationally recognised codes that designates for each country and most of the dependent areas 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 (Canada), DNK (Denmark), AUS (Australia).

In this fields ISO Country Codes will be saved. Otherwise, it will give error while importing.

Region / State

In this field, a valid region/state code should be entered. So, a valid Region/State code

should be given. Otherwise, it will give an error while importing.

For Example, New York will give error while saving uploaded file, it should be NY.

City

In this field, any city name can be provided. If no city is provided, then it means ALL

CITY (*) of that state and country.

Zip / Postal Code

In this field, postal code of the state or city is provided. Destination address of the customer will be matched with the fields of .csv file, shipping rates will be calculated according to the different destination address.

Weight From

This is the lower limit of weight range for which the Advance Shipping rate will be charged.

Weight To

This is the upper limit of weight range for which the Advance Shipping rate will be charged.

If the admin has set the condition “weight and destination”, then rates will be calculated if product’s weight comes in specified range and if destination address matches with the fields of destination address.

Price From

This is the lower limit of order price range for which the Advance Shipping rate will be charged.

Price To

This is the upper limit of order price range for which the Advance Shipping Rate will be charged. If the admin has set the condition “order subtotal and destination”, then rates will be calculated if order subtotal comes in specified range and if destination address matches with the fields of destination address.

Quantity From

This is the lower limit of Quantity for which the Advance Shipping Rate will be charged.

Quantity To

This is the upper limit of Quantity for which the Advance Shipping Rate will be charged.

If the admin has set the condition “Quantity and Destination”, then rates will be calculated if quantity comes in specified range and if destination address matches with the fields of destination address.