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:
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.
|
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 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. |