CSV Import / Export - Premium Tablerates [M2] - Magento 2

  • > 
  • CSV Import / Export - Premium Tablerates [M2] - Magento 2

Premium Tablerates extension uses CSV(comma separtated values) files for creating and importing rates to your Magento store. A CSV file is best opened in a spreadsheet application such as OpenOffice and saved with UTF-8 encoding.

Import/Export CSV

Go to Stores > Configuration > Sales > Shipping Methods.

  • Switch the scope of the configuration to the website level, using the Store View dropdown available at the top left side of the configuration section as shown in the image. Your website name might differ from what is shown in the image, please select the scope on the same level as Main Website in the image.
  • You may have a multiple websites, in which case select the website for which you would like to import the rates.

Once you have switched the configuration scope, you should see an export button and a file upload field.

  • Export: Click on the Export CSV button to export the rates in the database to a downloadable CSV file.
  • Import: Click on the Browse button and select the CSV file to be imported. Click on the save button to import rates into the database.
  • Shipping rates are setup per website, and if you want same rates to be applied to different websites, you need to upload the same CSV for each of the websites by switching the configuration scope to the respective website as mentioned above.
  

CSV Definition

Country Region/State City Zip From Zip To Weight >= Weight < Price >= Price < Qty >= Qty < Shipping Price Algorithm Shipping Method Sort Order
USA * * * * * * * * * * 15 * UPS Ground *
 
CSV column
 Description Default Value
Country
 ISO 3 (USA, GBR, etc) or ISO 2 (US, GB, etc.) country codes are allowed. Multiple countries can be specified in one line by separting the values using a comma and wrapping them inside quotes (Example: "USA,GBR"). *
Region/State
 State name or Region code defined in Magento. *
City
 City name *
Zip From
 The value here depends on the configuration. If you have selected numeric postcodes, use numeric values. For pattern matching, define the pattern. *
Zip To
 This value is used only for numeric postcodes. Specify the upper limit for the postcode range. *
Weight >
 The total weight of the products in cart should be greater than this value. *
Weight <=
 The total weight of the product in cart should be less than this value. *
Price >
 The total price of the products in cart should be greater than this value. *
Price <=
 The total price of the products in cart should be less than this value. *
Qty >
 The total number of items in cart should be greater than this value. *
Qty <=
 The total number of items in cart should be less than this value. *
Shipping Price
 Specify the shipping price. This is a required field and must be defined.
Algorithm
 Define the algorthim you wish to apply for calculating the shipping price. *
Shipping Method
 Shipping method label to be displayed in the frontend. Example: UPS Ground, Next Day Delivery, Flat Rate, etc. This is a required field and must be defined.
Sort Order
 You can specify the order in which the premium tablerate methods are displayed in the frontend. *

* - Apply to all.

 

NOTE:

  • CSV headers are not used for anything but describing the values in the columns.
  • Do not change the order of the columns.
  • CSV should be delimited by commas and any column value that contains a comma within it should wrap the values inside quotes. For example: Multiple countries should be wrapped inside quote like "USA, GBR".
  • If the data in the CSV is correct and the file still gives an error when uploading, make sure the file is in Windows format. It is best to use OpenOffice for editing and saving the file.
  • Option to import / export the CSV file is shown only when the scope of the configuration is at the website level.
Company
Magento 2 Extensions
Magento Extensions
Live chat: cookie consent required

Copyright © Hungersoft 2019

· Terms & Conditions · Privacy policy