Articles in this section

See more

MyDeal Shipping Zones Table

  • Updated

The MyDeal Shipping Zones Table is a shipping rate table that allows you to specify a shipping charge for each of the MyDeal Shipping Zones:

  1. Australian Capital Territory

  2. NSW Border Cities

  3. NSW Regional

  4. Sydney Metropolitan

  5. NT Metropolitan

  6. NT Regional

  7. Brisbane and Gold Coast

  8. Central and Western Queensland

  9. Ipswich Toowoomba SW Queensland

  10. North Queensland

  11. Adelaide Metropolitan

  12. Regional SA and Broken Hill

  13. Tasmania Metropolitan

  14. Tasmania Regional

  15. Melbourne Metropolitan

  16. Victoria Regional

  17. Perth Metropolitan

  18. WA Northern Regional

  19. WA Southern and Central Regional

Click here to download the MyDeal Zones mapped per postcode

 

How to prepare the MyDeal Shipping Zones CSV file

Snapshot:

MDZone_Snapshot.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 all MyDeal Zones exactly as provided in the template
  • All prices must include GST (For sellers that are Direct Import, GST will be removed automatically when applicable)
  • Postcode Exclusions - If you are unable to ship to some postcodes within the MyDeal Zones you can also prepare a Postcode Exclusion CSV to attach with your rate table. See instructions here.

Steps:

1. Download the template here: MyDealZonesShippingTable_Template.csv

  • The file contains four columns. All columns except ‘State’ must be included in the final file.
 

Field

Example value

Description

 A

MyDealZone

Australian Capital Territory

Required - do not edit template.

 B

State

ACT

Optional  - do not edit.

State is for reference only. Any changes to this column will be ignored.

 C

ShippingCost

5.00

Required for all zones.

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

  • If shipping is free then input 0.
  • If you are unable to ship to the entire zone then input NA.
    • Note: When ShippingCost is NA any value in AdditionalChargePerItem will be ignored.

 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 the ‘ShippingCost’ values in column C beside each of the MyDeal Zones.

  • 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) 

Done!

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

If you require shipping to vary depending on product price or weight range per MyDeal Zone see the below options:

Related articles