The Integration Engineer
When it just has to work.

I recently had to setup a tiered shipping table for a client on Magento.  I did find some instructions, but there were a few missing steps.  So here is a more comprehensive set of step by step instructions.

This is something that you will need to do if you are spreading and averaging the cost of multiple drop shipping vendors, and shielding your customers from getting unique shipping costs for each product.  You want to make sure that you aren’t gouging your customers, as they will notice and go elsewhere.  And it isn’t nice.  But you also want to make sure that you are not eating into your margins too much.

If you are starting a new store, you will probably be needing to evaluate and adjust your shipping table every week as you get data on the average cost and charge.

If you want to check out the wiki page about this on Magento Commerce, go here. http://www.magentocommerce.com/knowledge-base/entry/how-do-i-set-up-table-rate-shipping.  But all of the information is also in this post.

Step 1: “Enabling Table Rates”

Login to Admin and go to System>Configuration

On the Left side navigation click on Shipping Methods in the Sales group.

Expand the Table Rate in the main window and set enabled to “YES”

We are calling this “Standard Shipping” so if this is a new install, change the Title to this.  (This is what is displayed to the web site user and on their emails)

Make sure to  set condition to “Price vs. Destination”

Calculate should be fixed, and handling should be “0″ if you have no handling charge.

Now save the Config before you move on or your changes will be lost.

Step 2.  “Creating or Modifying the Rates Table”

Now again on the left side navigation, find the “Current Configuration Scope” and select your “Main Website”.

For clarity it should look like this exactly:

Thanks Clockman

(If you need to, navigate back to the Table Rate.  Sometimes it seems to know you need to be there, other times you are at the root of the configuration settings after selecting the Main Website.)

Now you have an “Export CSV” button, and an “Import” file selection Menu

If you need to get the format, click on the export button and save the current table to your desktop.

When you are ready to upload, click the “Browse” button off of the “Import” option, and select the file with the table you are ready to upload.

Remember. Uploading this table will replace the current table. This does not just add the new rows or rules.

Then save the config to upload the new table.  (for some reason there is no “import” button)

Now you have just updated the table rate shipping.

Tomorrow I will list the instructions for getting and creating a shipping table including international shipping.

Subscribe to "The Integration Engineer" by Email
Find out about the tools and services available at The Integration Engineer's Consulting site.

This entry was posted on Thursday, January 12th, 2012 at 5:21 pm and is filed under Magento. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.