If you find that MyDeal Zones do not align with the postcode ranges you require, you can create a Postcode & Weight Table which is a shipping rate table that allows you to specify shipping costs based on postcode and weight ranges that you define manually.
How to prepare the Postcode & Weight 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 and Weight Ranges:
- Postcode and weight ranges values are inclusive, e.g. if a weight range is WeightFrom = 10 and WeightTo = 14.99, then any products with weights 10 to 14.99 inclusive will be charged the amount specified for this weight 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)
- The weight range values must align with the same unit of measurement as your product weight data
- Postcode ranges must cover all available delivery areas.
- Postcodes not included in the file will result in customers not being able to purchase products for delivery to those postcodes.
- Weight ranges must cover all product weights in your catalog per zone and should be broad enough to cover possible future changes in product weights.
- IMPORTANT: If a product weight is not covered in the rate table then that product will not be purchasable.
- If a postcode or weight range overlaps then the system will choose from one of the applicable amounts 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 your defined postcode ranges you can also prepare a Postcode Exclusion CSV to setup alongside your rate table. See instructions here.
-
Combined Shipping Cost - If your can offer a combined shipping rate for purchases of multiple units of the same product, tick the Combined Shipping Cost box at the time of creating a freight scheme based on this rate table.
This should remain unticked if your shipping arrangement does not support this.
Note - To set up combined shipping across multiple products, please view the details HERE.
Steps
1. Download the template here: PostcodeWeightShippingTable_Template.csv
- The template contains seven 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 |
WeightFrom |
0 |
Required.
Must be numeric. *See Important things to keep in mind section for more details. |
D |
WeightTo |
5.99 |
Required.
Must be numeric. *See Important things to keep in mind section for more details. |
E |
BaseCost |
10 |
Required. Must be numeric. Prices will be rounded to two decimal points.
|
F |
Rate |
1.5 |
Optional. Must be numeric. Input a value when you want to charge an additional amount per weight unit on top of the BaseCost. Formula: [Final Shipping Cost] = [BaseCost] + ([Weight] x [Rate]) |
G |
MinimumCharge |
15 |
Optional. Must be numeric. If the final shipping cost is less than the MinimumCharge amount then the final shipping cost will be updated to be the MinimumCharge amount. I.e. IF [Final Shipping Cost] < [MinimumCharge] THEN [Final Shipping Cost] = [MinimumCharge] |
2.Fill in all required columns in the file (PostcodeFrom, PostcodeTo, WeightFrom, WeightTo and BaseCost).
- If applicable, you can also add values for Rate and MinimumCharge
- If you provide a ‘MinimumCharge’ value then ‘Rate’ cannot be blank for that row.
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 "Postcode & Weight Shipping Rate 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).
- If applicable, you have ticked the Combined Shipping Cost box.
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.