Magento – csv file format for setting table rate in magento 2

csvmagento2shippingtable-rates

I need to set special shipping cost for 1-3 business days(first 5 kg) for the states Dubai & Sharjah in UAE, but I don't know how to write it in the csv file. Do anyone know the format?

Thanks.

Best Answer

Go to Store >> Configuration >> Sales >> Shipping Methods >> Table Rates

enter image description here

Export sample file that is already entered in Table Rates from export button.

After exporting you can see rules something like below and you can enter as per your requirement.

enter image description here

1-3 business days(first 5kg) for this condition you have to write promotion rules

enter image description here

Read this blogs:

  1. Cart Price Rules
  2. Cart Price Rules