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 |
How to prepare the MyDeal Shipping Zones 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 all MyDeal Zones exactly as provided in the template
- All prices must include GST
- 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.
|
D |
AdditionalChargePerItem |
2.00 |
Optional. Must be numeric and less than or equal to ShippingCost. Prices will be rounded to two decimal points.
|
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: