Ecommerce Fulfillment
Menu
TOP

Parcel Send Report

For Australian Wineries Only
The .CSV export from the Parcel Send Report is specifically formatted for Parcel Send (Australian Post) to automatically update and add all addresses in an order.

Report Setup: Learn what steps to take before running the report. Learn More >

Running The Report: Learn where to find the report and how to run it. Learn More >

Parcel Send Orders CSV: Learn what columns are included in the Parcel Send Orders Report. Learn More >

Importing Parcel Send Order CSV: View Parcel Send resources to help you import the CSV file: Learn More >

Report Setup

To ensure the accuracy of all orders, we recommend taking additional setup steps for each of the following columns.

Product ID

Parcel Send requires the Product ID field to represent the shipping type for each order. We automatically take the Shipping Types "Code" from your Shipping Strategy and place it into the Product ID column for the report.

To ensure the data is correct before your report is run, we recommend double-checking that the corresponding Product ID from Parcel Send is correctly entered into your Shipping Strategy.

To update your list of Parcel Send Product IDs.

  1. Log into your Parcel Send Account.
  2. Go to Settings > CSV Import > Shipping Methods.
  3. After you've chosen the Product IDs you want to offer, log into your WineDirect Admin panel.
  4. Go to Shipping > Shipping Types > Code.
  5. Enter the codes you want your customers to use and click Save.

Weight

Take the time to make sure you've added weight as a detail on each of your products. Every time you create a new order, the report will calculate the total weight based on the weight you previously entered for each product. WineDirect automatically rounds up to the nearest half KG for final calculations.

If an order is placed for products that have no weight entered, the column will default to 0 which will error on upload to ParcelSend.  If you do not enter all your product weights, you will have an empty or incorrect weight listed for each product and you will need to manually update each order in the report before uploading.  We STRONGLY recommend you enter your product weights.

Page Top

Running The Report

  1. Go to Reports > Shipping > Parcel Send
  2. Select the date range (DD/MM/YYYY)
  3. Under Manage Filters, confirm that your report settings are accurate.
    1. You'll find All Types, as the default Order Type option, but can up updated to only include the Club Order Order Type if needed.
    2. Order Status will only pull Completed and Submitted orders
    3. Shipping status will only use Not Shipped and Sent to Fulfillment orders
  4. Under Manage Report Columns, select which optional columns to include or remove from your report.
    1. Learn more about the columns what data is output by default here.
  5. Preview your report with View, or click Export to download in a .CSV format

Page Top

Parcel Send CSV

Below is documentation for the columns available in the Parcel Send report and what data from WineDirect is used for each. (Definitions are only included for columns populated with WineDirect order information.)

Mandary rows are marked with a *

Column Name

Parcel Send Instructions

WineDirect Report

Row type *

Enter the letter S for primary shipments and the letter P for any subsidiary shipments going to the same address.

S is automatically hardcoded into the column for you.

The report will print off a single label per order. If you need multiple package labels (P), these must be manually adjusted.
Sender account

The 8 digit sender account number.

Australia Post customers with a single sender account may delete this column.

This column is left blank and the default AUS post account attached to Parcel Send will be used.  

If you have more than one account and would like to charge different orders to different accounts, you will need to populate the account numbers manually.
Recipient contact name *

Name of the recipient.
(Maximum 40 characters.)

 The First and Last Name from the shipping address is populated.
Recipient business name

Recipient’s business name. (Maximum 40 characters.)

 If there is one, the Company Name from the shipping address is populated. Otherwise, this column will be blank.
Recipient address line 1 *

First line of the address where the item will be sent.
(Maximum 40 characters.)

 The Shipping Address is populated.
Recipient address line 2

Second line of the address where the item will be sent.
(Maximum 40 characters.)

 The Shipping Address 2 is populated.
Recipient address line 3

Third line of the address where the item will be sent.
(Maximum 40 characters.)

 

 This column is left blank but can be filled manually if necessary.
Recipient suburb *

Suburb where the item will be sent.
(Maximum 30 characters.)

The suburb will be validated against the state and postcode.

 

 The Shipping City is populated.

Recipient state *

State code for where the item will be sent.

Valid values are ACT, NSW, NT, QLD, SA, TAS, VIC, WA.

The state will be validated against the suburb and postcode.

 

 The Shipping State is populated.
Recipient postcode *

4-digit postcode for where the item must be sent.

The postcode will be validated against the suburb and state.

 

 The Shipping Post Code is populated.
Send tracking email to recipient

Either YES or NO.

Enter YES to send tracking emails to the recipient.

Recipient email address must be entered if YES is entered.

If left blank, the default is NO.

 YES is automatically populated if a billing email is present.
Recipient email address

Recipient’s email address.

Even if tracking emails aren’t requested, entering the recipient’s email address helps Australia Post match parcels to recipients in the MyPost app.

(Maximum 50 characters.)

Optional – unless “Send tracking email to recipient” is YES

The Billing Email is populated.
Recipient phone number

Recipient’s phone number.

 

 The Shipping Phone Number is populated.
Delivery/special instruction 1

Space for additional instructions or information that will show on the parcel's label. 

(Maximum 128 characters.)

 

 The Order Notes are populated.
Sender reference 1

Space for additional information that will show on the parcel's label. 

 

 The Order Number is populated.
Sender reference 2

More space for additional information that will show on the parcel's label. 

 

 This column is left blank but can be filled manually if necessary.
Product ID *

The 3-4 character Product ID code which corresponds to the required shipping method.

Examples are 3P85, EXP, 7C53.

A unique list of product codes for your account is available in Parcel Send under Settings – CSV import.

 

The Shipping Type Code / Carrier Code from the shipping method is populated.

Please see "Report Setup" for more information.
Authority to leave

Either YES or NO.

Enter YES to allow authority to leave (ATL) for the item.

If the field is left blank, the default is dependent on the chosen product.

 

 NO is automatically populated but this can be updated manually if necessary.

Safe drop

Either YES or NO.

Enter YES to allow safe drop for the item if it is requested by the recipient.

If the field is left blank, the default is dependent on the chosen product.

 NO is automatically populated but this can be updated manually if necessary.
Quantity

A number between 1 and 99. The number of identical parcels.

If left blank, the default is 1. A quantity can be specified for rows with a type of either S (Shipment) or P (Parcel). 

 This column is left blank which defaults to 1 but can be filled manually if necessary.
Weight *

The item weight in kilograms, up to 3 decimal places, up to 32KG.

 

This column is calculated for you based on the weights you have entered for each product in the order and then rounded up to the nearest half KG.

If you have not entered any weights for your products, a default of 4KG (6 bottles) has been entered and you will need to adjust each line manually.

If your package weight is over 32KG, you will need to split up the package manually into more than one parcel.
Length

Length of the item in centimetres, up to 1 decimal place.

Optional for Australia Post customers using cubic weight pricing.

 This column is left blank but can be filled manually if necessary.
Width

Width of the item in centimetres, up to 1 decimal place.

Optional for Australia Post customers using cubic weight pricing.

 This column is left blank but can be filled manually if necessary.
Height

Height of the item in centimetres, up to 1 decimal place.

Optional for Australia Post customers using cubic weight pricing.

 This column is left blank but can be filled manually if necessary.

Parcel contents

Description of the item.

(Maximum 50 characters.)

 

 WINE is automatically populated but this can be updated manually if necessary.
Transit cover value

Enter the dollar amount of transit cover required, up to 2 decimal places. Don’t include the $ symbol.

Note, transit cover may not be applicable for all products.

 

The total before discount has been calculated in this column.

If you do not want to include transit cover for your shipments, remove this column.

Page Top

Importing Parcel Send Order Report

  1. Login to your account on the Parcel Send Website.
  2. Follow the setup steps outlined in the Parcel Send Import Guide.

Page Top