Articles in this section

See more

Postcode Shipping Rate Table

  • Updated

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

How to prepare the Postcode Table CSV file

Snapshot:

Screen_Shot_2020-03-13_at_3.25.53_pm.png

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 Ranges:
    • Postcodes not included in the file will result in customers not being able to purchase products for delivery to those postcodes.
    • PostcodeFrom and PostcodeTo values are inclusive, e.g. a postcode range of PostcodeFrom = 3000 to 3006 means that any customers inputting postcodes from 3000-3006 inclusive will be charged the ShippingCost specified for that 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)
    • Postcode ranges must cover all available delivery areas. 
    • If a postcode range overlaps then the system will choose from one of the applicable ShippingCosts 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 postcode ranges you can also prepare a Postcode Exclusion CSV to setup alongside your rate table. See instructions here.
  • Please ensure that all postcodes across Australia are covered either by the shipping rate table or postcode exclusion list. This way customers can check whether delivery is available to their postcode directly on the product page, without needing to submit an enquiry to the seller.

Steps

1. Download the template here: MyDealPostcodeShippingTable_Template.csv

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

Field

Example value

Description

 A

PostcodeFrom

3000

Required.

Must be number in text form. Must be from 0200 to 9729.

*See Important things to keep in mind section for more details.

 B

PostcodeTo

3999

Required.

Must be number in text form. Must be from 0200 to 9729.

*See Important things to keep in mind section for more details.

 C

ShippingCost

5.00

Required for postcode ranges.

Must be numeric. Prices will be rounded to two decimal points.

  • If shipping is free then input 0.

 D

AdditionalChargePerItem

2.00

Optional.

Must be numeric and less than or equal to ShippingCost. Prices will be rounded to two decimal points.

  • If you require the ShippingCost amount to be charged per item then leave this field blank. Example:
    • Shipping Cost: $10.00
    • Additional Charge Per Item: [blank]
    • Qty purchased: 2
    • Total shipping cost: $20.00
  • If you require the ShippingCost amount to be charged as a flat amount regardless of the quantity of the items ordered then input 0. Example:
    • Shipping Cost: $5.00
    • Additional Charge Per Item: 0
    • Qty purchased: 4
    • Total shipping cost: $5.00
  • If you require an additional charge per item on top of the ShippingCost then input a value. Example:
    • Shipping Cost: $20
    • Additional shipping cost per item: $5
    • Qty purchased: 3 
    • Total shipping cost: ($20+$5+$5) = $30

2. Fill in all required columns.

  • If applicable, also fill in the ‘AdditionalChargePerItem’ value in column D. This is optional and can be added to any row or left blank when not applicable.

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 Shipping Rate Table"

     iv. Enter Description

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

     vi. Click "Save"

mceclip0.png

NOTE:

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

Sample File: Click here to download an example of a completed CSV file for your reference.

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

 

Related articles