The Shipping charges are calculated based on a table which has the following data as combinational conditions
1.Weight v. Destination
2.Price v. Destination
3.Number of Items v. Destination
Backend Configuration:
Stores >> Configuration >> Sales >> Shipping Methods >> Table Rate
Steps :
1.The Status of the Table Rate has to be enabled
2.The title and the Method Name to be updated.
3.Select the condition in the dropdown
4.Weight v. Destination
- Price v. Destination
- Number of Items v. Destination
- Include Virtual Products in Price Calculation If any virtual product is available, need to set the status as YES.
- Calculate Handling Fee
5.The handling fee is optional and appears as an additional charge that is added to the shipping cost.
Fixed
-
- Percent
The handling fee is based on a percentage of the order, enter the amount as a percentage.
- Percent
6. Displayed Error Message
If this delivery method becomes unavailable, the updated error message will display.
7. Ship to Countries
Customers from all countries or custom locations specified in your store configuration can use this delivery method.
8. Sort Order
The sequence in which Flat Rate Shipping appears when listed with other delivery methods during checkout.
Prepare the Table Rate Excel
- In the store view, set the Store View to Main Website.
- Update the required condition
- On clicking on Export CSV, a excel file will be downloaded based on the condition
4. Conditions
1.Weight Vs Destination – If the weight is 30 kg, the shipping charges is 30$ , the if items weight exceeds 30 kg, the shipping charges will be updated as 30$i
| Country | Region/State | Zip/Postal Code | Weight (and above) | Shipping Price |
2. Price Vs Destination — If the Order subtotal is $200 ,the shipping charges is 30$ , the if items subtotal exceeds $200, the shipping charges will be updated as 30$.
- Price Vs Destination — If the Order subtotal is $200 ,the shipping charges is 30$ , the if items subtotal exceeds $200, the shipping charges will be updated as 30$.
| Country | Region/State | Zip/Postal Code | Order Subtotal (and above) | Shipping Price |
| USA | AK | * | 100 | 10 |
- Number of items Vs Destination – If the number of items is 10 ,the shipping charges is 30$ , if number of items exceeds 10, the shipping charges will be updated as 30$.
| Country | Region/State | Zip/Postal Code | # of Items (and above) | Shipping Price |