How to Fix MyPost Business CSV Import Errors

Missing or incorrect CSV headers

A store export normally uses customer-facing columns, while a MyPost Business import expects shipping-specific columns. Renaming only one or two headers is rarely enough because sender, recipient, package, service and compliance fields also need to be placed in the correct columns.

Start from the intended target template, keep a single header row, and avoid adding notes above it. ShipFormat's built-in preset exports the current MyPost-oriented header set in a fixed order.

Phone number formatting

Spaces, punctuation, +61, 0061 and a missing leading zero can all produce inconsistent values. The ShipFormat converter removes non-digits and attempts to normalise Australian mobile numbers into local 04xxxxxxxx form. A number that still does not match that form is flagged for review instead of being silently treated as valid.

Blank required fields

Recipient name, phone, address line 1, suburb, state and postcode are critical in the current built-in workflow. If one is missing, the row is marked not exportable. Fixed parcel and service values cannot rescue an otherwise empty source row, so blank spreadsheet rows are filtered instead of becoming false shipments.

Address, suburb, state and postcode mismatches

Do not place the entire address into Address Line 1 or Address Line 2. Keep the street in Address Line 1, use Address Line 2 only for a real unit, level, building or care-of detail, and keep suburb, state and postcode in their dedicated fields.

ShipFormat recognises Australian state names and abbreviations, looks for a four-digit postcode, and uses the address tail to infer suburb. Every delivery address line must be 40 characters or less. Ambiguous or repeated locality text can remain exportable but is marked for review; missing or unsafe fields are blocked.

Parcel weight and dimension fields

Weight and dimensions must be positive numeric values. The current built-in rule uses a 30 cm length, stacks up to three items vertically, increases width for additional stacks, and calculates 0.3 kg per item. For example, quantity 6 becomes 30 × 20 × 15 cm and 1.8 kg.

This is a configured product rule, not a general measurement service. Confirm that it matches the goods being shipped before using the output.

Spreadsheet software changing data formats

Spreadsheet applications may remove leading zeros from phone numbers or postcodes, convert long values to scientific notation, or save a CSV with a different delimiter or character encoding. Format identifier columns as text before saving, keep one shipment per row, and reopen the final CSV to confirm that values such as 0400000000 and four-digit postcodes remain intact.

MyPost Business CSV checklist

• Use the required target headers with no extra title rows.
• Confirm sender name, phone and address details.
• Check recipient name, mobile, street, suburb, state and postcode.
• Keep each delivery address line at 40 characters or less.
• Verify packaging type, delivery service, description and dangerous goods flag.
• Confirm parcel length, width, height and weight are numeric and appropriate.
• Review every flagged row and inspect the exported CSV before upload.