Articles in this section

See more

Postcode Shipping Rate Table

  • Updated

If you find that the MyDeal Zones are not suitable for your needs, 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.

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. Email the CSV file to your Account Manager or am@mydeal.com.au for processing. Make sure to:

  • Attach the completed rate table CSV file
  • Specify which products the rate table should be applied to
  • If applicable, also attach 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.

Related articles