eParcel Orders Export

The eParcel Orders Export is only applicable to our Australian clients. It is a . CSV format file that is formatted for eParcel (Australian Post). The export can then be imported into eParcel manually, saving wineries from typing out all the addresses for every order.

Running The Export

1. Go to Settings > Import/Export > eParcel Orders Export

2. Enter the date range you wish to report on [To & From Date]. Dates should be DD/MM/YYYY in Australia.

3. By default, the Order Type is set to pull All Types. Typically you do not need to adjust this setting. However, you can adapt this to remove orders with a specific order type, such as ClubOrder.

4. By default Order Status is set to pull only Completed. Typically you do not need to adjust this setting. However, you can adapt this to remove orders with a specific payment status, such as Submitted.

5. By Default, Shipping Status will be set to All Statuses, meaning that both ship and pickup orders will be included in your export. Statuses include:

• All Statuses
• No Statuses
• Sent to Fulfillment
• Shipped
• Picked Up
• Handled Externally
• No Shipping Required
• Pending Carrier Pickup
• Not Shipped
• Not Picked Up

6. Enter your Post Account number to populate the appropriate column in the Report. (If this is left blank, the CSV file will still generate but not include your Post Account number).

7. Enter your Charge Account number, which will populate the appropriate column in the Report. (If this is left blank, the CSV file will still generate but not include your Post Account number).

8. The Signature Required checkbox will be checked by default, as most packages contain wine. You can uncheck this value if you do not require a signature for all the orders you are exporting,

9. Enter the Package Weight for all orders you export. Note: Only one value can be entered. If this field is blank, the CSV file will still generate and export, and package weights can be manually added.

10. Enter a short Package Description that will be added to all the orders you are exporting. The default value is set to WINE. If this field is blank, the CSV file will still generate and export, and package descriptions can be manually added.

11. If the orders require insurance, check the Insurance Required box and enter the dollar amount for insurance in the Insurance Amount field.

12. Click Export as CSV to generate your Report, and click Download when the progress bar completes.

eParcel Consignment Orders CSV

Below are the columns that are in the default eParcel Consignment Orders report.

*Only the columns populated with information from your order in WineDirect will include definitions.

** The secondary line of headers outlines eParcels required fields for import which the eParcel importer tools should ignore.

Importing eParcel Order Report

1. log in to your account on the eParcel Website.

2. Follow the setup steps outlined in the eParcel Consignment Import Guide V5.05.