MyDeal Shipping Zones Table – MyDeal Marketplace

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

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:

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

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: