cancel
Showing results for 
Search instead for 
Did you mean: 

Is this working in M2?

Is this working in M2?

Hello,

 

In M2, I'm trying to figure out how to import or set the specific table rates. I enabled Table Rates in Configuration > Shipping, but I don't see a file upload button anywhere. 

 

Is this working in M2? 

 

Thanks.

2 REPLIES 2

Re: Is this working in M2?

Try changing the Store View from Default Config down to the website level. The import and export features should appear. It's the same in Magento 1.

Table Rates Store View.PNG

 

 

Hopefully, that will solve the issue for you.

 

Best of luck!

Re: Is this working in M2?

Hello @chgdf_cvbvc ,

 

Video tutorial: https://www.youtube.com/watch?v=0Wns49SCQp8

 

You set table rate shipping inside the System menu accessed via Magento’s backend.

While logged in as admin, navigate to System > Configuration and then, in the left menu under Sales, select Shipping Methods. https://www.screencast.com/t/NydqWD2jgbU

1407083233magento_shipping_methods.png

That should bring up the table rates menu in the window to the right. https://www.screencast.com/t/46Tt2WgJM

 

1407083235magento_table_rates_menu.png

The first thing to do is to enable table rates by selecting Yes in the drop-down menu for the Enabled option. This will turn off flat rate shipping and allow you to specify different rates based on your chosen criteria.

The next two options, Title and Method Name, allow you to create different table rate shipping policies that you can then select from. For this tutorial, we’ll leave the names as Standard Shipping and Standard.

The next option determines how you want to calculate the shipping. In our example, we’ll be using price vs. destination, so go ahead and select this in the drop-down options.

https://www.screencast.com/t/9SeyFQHE9d

1407083229magento_price_vs_destination.png

 

Now it’s time to start setting the table rates themselves. Save the current configuration and then, in the top left Current Configuration Scope menu, select Main Website.

https://www.screencast.com/t/w9ulHl1J

1407083228magento_current_configuration_scope.png

This will apply the current shipping policy to your main website.

The table rates menu to the right will now look something like this:
https://www.screencast.com/t/0TGGUmgU

1407083237magento_table_rates_menu_2.png

In particular, you’ll notice a new Export CSV and Import option. Magento requires a CSV file, so you’ll need to manually create the shipping rates you want in a spreadsheet, then import them into your website.

You’ll create the CSV from a template file. To download the template, click Export CSV. Here’s what the file looks like: https://www.screencast.com/t/HKqyjhMmm

1407083231magento_reimport_csv.png

The first column in the file selects the country where the specific shipping rate will apply. The second column allows you to set the region within that country for the rate and the third column selects specific postcodes. For this example, we’ll leave these two columns with an * value, which means we’ll charge everyone in the U.K. the same shipping rate.

The Order Subtotal (and above) and Shipping Price columns are where you determine the price for each shipping rate. These values will represent whatever currency you’ve set up for your webstore. In the above example the values represent the price in pounds sterling.

The price, or Order Subtotal (and above) column, essentially means that any customer spending £0 or above will be charged the corresponding shipping rate. In this case, the base shipping is £60, as shown in the last column. Conversely, any customer spending £50 or above, will be charged £50 for shipping, and so on.

You will manually set all these shipping rates depending on your own policy. Once this is completed, save the file and then import it back into Magento in the table rates section.

Your shipping rates are now set and will appear on the front-end as the customer goes through checkout.

 

Video tutorial: https://www.youtube.com/watch?v=0Wns49SCQp8

 

--
If my answer is useful, please Accept as Solution & give Kudos