Postcode & Weight Shipping Rate Table

If you find that MyDeal Zones do not align with the postcode ranges you require, you can create a Postcode & Weight Table which is a shipping rate table that allows you to specify shipping costs based on postcode and weight ranges that you define manually.

How to prepare the Postcode & Weight Table CSV file

Snapshot:

Important things to keep in mind:

• The file must be formatted as CSV UTF-8
• The first row of the CSV must contain the column headings exactly as provided in the template
• Column A must contain each MyDeal Zone at least once
• All prices must include GST
• Postcode and Weight Ranges:
  • Postcode and weight ranges values are inclusive, e.g. if a weight range is WeightFrom = 10 and WeightTo = 14.99, then any products with weights 10 to 14.99 inclusive will be charged the amount specified for this weight range
  • If you need individual postcodes to have specific shipping costs then you can input the same postcode in the PostcodeFrom and PostcodeTo fields (e.g. 3000 | 3000)
  • The weight range values must align with the same unit of measurement as your product weight data
  • Postcode ranges must cover all available delivery areas. 
    • Postcodes not included in the file will result in customers not being able to purchase products for delivery to those postcodes.
  • Weight ranges must cover all product weights in your catalog per zone and should be broad enough to cover possible future changes in product weights.
    • IMPORTANT: If a product weight is not covered in the rate table then that product will not be purchasable.
  • If a postcode or weight range overlaps then the system will choose from one of the applicable amounts detected in the rate table.
  • We can accept a maximum of 500 rows of data in the CSV
• Postcode Exclusions - If you are unable to ship to some postcodes within the your defined postcode ranges you can also prepare a Postcode Exclusion CSV to setup alongside your rate table. See instructions here.

• Combined Shipping Cost - If your can offer a combined shipping rate for purchases of multiple units of the same product, tick the Combined Shipping Cost box at the time of creating a freight scheme based on this rate table.

  This should remain unticked if your shipping arrangement does not support this.

  Note - To set up combined shipping across multiple products, please view the details HERE.

Steps

1. Download the template here:  PostcodeWeightShippingTable_Template.csv

• The template contains seven columns. All required columns must be included in the completed file.

 2.Fill in all required columns in the file (PostcodeFrom, PostcodeTo, WeightFrom, WeightTo and BaseCost).

• If applicable, you can also add values for Rate and MinimumCharge
• If you provide a ‘MinimumCharge’ value then ‘Rate’ cannot be blank for that row.

3. Save the file in CSV UTF-8 format.

4. Upload the file to your store via the Manage Freight Schemes feature in the seller portal.

     i. Click "Add New" or "View/Edit" of an exiting freight table

     ii. Select the Freight Scheme as "Shipping Rate Table"

     iii. Select the Option as "Postcode & Weight Shipping Rate Table"

     iv. Enter Description

     v. Under the "Rate Table" section, upload the .csv file you have created

     vi. Click "Save"

     NOTE:

• The file is in CSV UTF-8 format.
• If applicable, you have completed the Postcode Exclusion List CSV file (see instructions here).
• If applicable, you have ticked the Combined Shipping Cost box.

5. Once you have completed this process, please review this article to ensure your new freight scheme is applied to your products accordingly.