How to enable table rates in Magento 2 by uploading a CSV file?
Say, your warehouse is located in Los Angeles, California. It’s cheaper for you to ship to San Francisco, California, than to New York City.
So, you can use table rate to determine shipping costs basing on the following combinations:
- weight v. destination
- price v. destination
- number of items v. destination
So, how to configure table rates as a shipping method.
Table rates settings
To start using table rates, follow the steps:
- go to Stores → Settings → Configuration, then open the Sales tab and click on the Shipping Methods
- go to the Table Rates section and choose Yes in the Enable field
- enter the Title and Method Name that you want to display on the frontend
- choose the calculation method in the Condition filed
- if you want to add virtual products to the calculation, set Include Virtual Products in Price Calculation to Yes
- if needed, fill out the Calculate Handling Fee and Handling Fee fields
- enter the message that you want to show in case the method is unavailable in the Displayed Error Message field
- pick countries for which the shipping method will be available in the Ship to Applicable Countries field
- enter the Sort Order of the shipping method and save the changes
- to configure the CSV file, choose the needed Store View, and click on Export CSV
- download the shipping table rates file on your computer, open it, and fill in the table with the needed values (follow the official guide)
- once ready, save the file, and return to the Table Rates section
- double-check the Store View setting in the left corner. Next, find the Import field and click on Choose File
- import the needed file from your computer, and save the configurations
- go to the frontend and check the result
What are the Magento 2 shipping rates?
Magento 2 shipping rates are the amount of money you charge customers for shipping items. Say, your shipping rate depends on the cart subtotal and state. For states where you have warehouses, you have preferential rates. In this case, you will use the Price v. Destination condition.
In the table below, you can see how the shipping fee changes according to cart subtotal for all the orders with shipping region California (CA) and Utah (UT):
COUNTRY | REGION / STATE | ZIP / POSTAL CODE | ORDER SUBTOTAL (and above) | SHIPPING PRICE |
USA | CA | * | 100 | 5 |
USA | CA | * | 25 | 10 |
USA | CA | * | 0 | 15 |
USA | UT | * | 100 | 5 |
USA | UT | * | 25 | 10 |
USA | UT | * | 0 | 15 |
USA | * | * | 100 | 10 |
USA | * | * | 25 | 15 |
USA | * | * | 0 | 20 |
The shipping price is lower for these states than for the rest of the country and varies from $5 to $15. The symbol * represents all values i.e. if we put * in the Zip Code column, that means we want to use this rule for all the addresses of this region.
What is flat rate shipping in Magento?
Flat rate shipping Magento means that the shipping price is not related to the weight, shape, or size of the item being shipped. With flat-rate shipping, you can charge a flat rate for sending all orders to specific geographic areas, regardless of the number of items ordered.
Login and Registration Form