The MyDeal Shipping Zones & Price Table is a shipping rate table that allows you to specify a shipping charge per product price range for each of the MyDeal 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 Zones & Price 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
- Price Ranges:
- IMPORTANT: If a product price is not covered in the rate table then that product will not be purchasable.
- PriceFrom and PriceTo values are inclusive, e.g. if a price range is PriceFrom = 50 and PriceTo = 99.99, then any products with a sell price of $50 to $99.99 inclusive will be charged the ShippingCost specified for this price range
- The price ranges must cover all product prices in your catalog per zone and should be broad enough to cover possible future changes in product price.
- If a price range overlaps then the system will choose one of the applicable ShippingCost amounts detected in the rate table.
- For variant deals, the freight is calculated based on the price of the first option in the feed.
- Postcode Exclusions - If you are unable to ship to some postcodes within the MyDeal Zones you can also prepare a Postcode Exclusion CSV to setup alongside your rate table. See instructions here.
Steps:
1. Download the template here: MyDealZonePriceShippingTable_Template.csv
- NOTE: this template has been filled with common price ranges as an example, you can edit or remove rows if these ranges do not apply to you.
- The template contains five columns. All required columns must be included in the completed file. Details below:
Field |
Example value |
Description |
|
A |
MyDealZone |
Melbourne Metropolitan |
Required. Each MyDeal Zone must be included at least once formatted exactly as per the template. MyDeal Zones can be repeated over different rows for each weight range. |
B |
PriceFrom |
0 |
Required. Must be numeric. Prices will be rounded to two decimal points. *See important things to keep in mind section for details. |
C |
PriceTo |
49.99 |
Required. Must be numeric. Prices will be rounded to two decimal points. *See important things to keep in mind section for details. |
D |
ShippingCost |
10 |
Required for all zones. 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 in the file (PriceFrom, PriceTo and ShippingCost)
- 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 & Price 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.