DM3PL Mode - Bulk Update of Order Status
Order Prefix & Suffix Reference
- Traveller Orders:
HC<YYMMDD0000>DM-XXXX-A(e.g.HC2004146005DM-1000-A) - Non-Traveller Orders:
NC<YYMMDD0000>DM-XXXX-A(e.g.NC2011120002DM-1000-A)
⚠️ For HCXXXXXXXXDM-XXXX and HSXXXXXXXXDM-XXXX orders, ensure delivery only after the Flight Date/Time.
Order Statuses
Open: A new order that has not been processed yet. 💡Partial or full order cancellations can only be done at this stage.
Ready to Ship: The order has been processed and is ready to be shipped.
Shipping in Progress: The order is out for delivery.
Delivered to Customer: The order has been delivered to the customer.
How to process the order
- Go to All Orders ➡️ Open Orders

- Click on a checkbox to select an order. Once an order has been selected, the Bulk Update button will appear on the top right hand corner. ➡️ Click on Bulk Update

- Click on Export File

- 📝Note: Order status = Open
Please fill up the following information below:
– Original Quantity:The quantity in the order.
– Quantity: The quantity that can be fulfilled for the order.
– Cancellation Reason:Select the cancellation reason in the dropdown if the quantity was adjusted.
– Courier: Select the carrier in the dropdown.
– Tracking Number: Input the courier tracking number.
– Tracking URL: Input the courier tracking URL.

If the tracking information has been included and the file has been uploaded successfully, the order status will change from Open ➡️ Shipping in Progress.If the tracking information was not included and the file was uploaded successfully, the order status will change from Open ➡️ Ready To Ship.📝Note: Order status = Ready To Ship.
Please fill up the following information below:
– Courier: Select the carrier in the dropdown.
– Tracking Number: Input the courier tracking number.
– Tracking URL: Input the courier tracking URL.

Once the file has been uploaded successfully, the status will change to Shipping in Progress. - Once done, save the file. In TREX, click on the Upload Excel File button to upload the template. It will take about 5 minutes. Once the upload is completed, please check the status of the file and download the Error Report if needed.

