Many DEAR customers use third-party logistics (3PL) for their distribution an fulfillment needs. Currently DEAR only provides native integration with one external fulfillment provider, Fulfillment by Amazon. However, other 3PL  and external fulfillment providers can connect with DEAR via our API ( if required.  

Alternatively, you can manually export a 3PL Shipment List from the Sales page to give to your 3PL provider. This downloads information required by 3PL providers in .csv format

The 3PL Shipment List is downloaded from the Sale → Sales screen. On this screen, select more than one sale in order to display the Bulk Actions toolbar. Select Export → Export 3PL Shipment List to export a .csv file with information for your 3PL supplier.

NOTE: Only orders where Ship has been authorised will be exported to the CSV file. Orders where only Pick or Pack has been authorised will not be exported. To save time, you can select all sales and only those with Ship status authorised will be exported to the shipment list. 

The 3PL Shipment List consists of the following fields exported from the DEAR sale:

  • Sale Order Number
  • Ship By Date
  • Product SKU
  • Product Description
  • Quantity
  • BSN (Batch/serial number)
  • Expiry date
  • Customer
  • Customer Contact
  • Customer Phone
  • Customer Email
  • Shipping Address Line 1
  • Shipping Address Line 2
  • Shipping City/Suburb
  • Shipping State/Province
  • Shipping Country
  • Shipping Postcode
  • Barcode
  • Notes (from sale document header)
  • Carrier
  • Invoice Memo
  • Ship to Company
  • Ship to Contact
  • Shipping Notes

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.