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. 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 "MyDeal Shipping Zones 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).
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.
--------------------------------------------------------------------------------------------------------------------
If you require shipping to vary depending on product price or weight range per MyDeal Zone see the below options: