No results found :(
How to set up shipping in Magento using XLS
- From Magento Admin panel to System→Configuration
- Under Sales, choose Shipping methods
- Under Shipping Methods choose "Table Rates"
- Add shipping information
- Change Configuration scope
- Click on Export CSV orange button, Fill in the sheet/Upload
- Click on "Save Config" button
It’s time to see how to set up shipping rates for our products that will be visible to our customers on front end.
You should log in to your Admin Panel and navigate to System and choose Configuration menu item.
See the screenshot below:
Next, from the left hand side menu choose Shipping Methods and click. You will then, see a screen that will allow you to configure your shipping methods. Then, navigate to Table Rates. You can now start determining the prerequisites for your shipping.
Make sure you enable it by marking Yes, add proper title and name the Method. Next, from the dropdown menu choose a Condition.
We chose that our shipping cost will be conditioned by weight of the product and the destination that we are sending our product to. Take a look:
Next, we chose to leave Displayed Error Message as it is, and moved on to determining the countries that we will be able to send our products to.
For the purpose of this tutorial we chose to mark All Allowed Countries from the dropdown menu next to Ship to Applicable Countries field.
At this point you should pay close attention, since what you need to do next is to scroll up and choose Configuration Scope for our settings.
See the screenshot below:
We chose to mark Main Website.
Note that you could do this in the very beginning, but we opted to set up everything first and then show what changes will Configuration Scope bring.
We have a new field now, so what we need to do is click on the orange button named Export CSV to download the sheet automatically.
Open Table Rates sheet and you will see that you need to fill it with following information: Country, Region/State, Zip/Postal Code, Weight and Shipping Price. (see the screenshot)
Go ahead and enter all the information.
As you can see, first column will determine to which country this particular shipping rate applies, second column will determine the region within the country that was chosen, then you have to enter zip or postal code, weight and then finally determine and write down the shipping price.
Note that if you have added one price for one country and you want it to apply no matter what is the region you are shipping to, just enter the name of the country and region and enter star [*] into zip column.
Once you’re done, click Choose file button and upload the document from your computer.
And you’re almost done!
Click Save Config button in the upper right part of the screen to save all of your settings.
You’re all set!