EDI Status Updates

If you require a feed of line level status updates, we can easily set this up to come back to you via csv file. You can then pick up this file and processes it as you wish.

Here are the available fields we can use on the tracking csv file (note all of these are visible on the GetOrderStatus API call if you are using that).

Field NameDescriptionSample Value
TrackingIdUnique line level id (either provided or panther generated it not)1023200000012
ConsignmentNoOrder numberorder123
StatusIdSingle digit character for statusB
StatusNameDescriptive name for statusBooked
DateBookedForCustomer Delivery/Return Collection Date
ExceptionBoolean (either yes or no depending on status) e.g. Damaged status would be true.1
DateCreatedDatetime stamp of the status update2014-08-06 13:55
DateDeliveredDelivery date is successful2014-08-12 00:00
SupplierNameSupplier collection nameBluehouse Imports
SupplierCollectionDateSupplier collection date2014-08-11
DepotPanther Depot that will serve this order (based on postcode/area)Leeds
FailureCodeFailure status code (if an unsuccessful delivery/collection attempt has been made)n
FailureDescriptionFailure status descriptionCustomer Not In
ScanInStatusIdThree letter code for scan IN statusRWG
ScanInStatusNameDescriptive name for statusReceived in Warehouse – Good
ScanOutStatusIdThree letter code for scan OUT statusODA
ScanOutStatusNameDescriptive name for statusOut for Delivery (All)
NoOfItemsQty of items for the order line2
ProductCodeSKU for the order linesku123
MinBookDaysIf Pather book orders, this would be a client provided value to control first date offered7
AdditionalOrderTypeCustom field available for sending additional order classification if requiredSX
Client_Line_NumberCustom field available for sending additional unique line number1234

Here is an example of a typical tracking csv file, we can adapt the columns visible and their display order very easily so please let us know your requirements.

Example Tracking CSV File

Below is a breakdown of our status codes:

Standard line level status codes:

StatusIdDescription
ASAwaiting Stock
BBooked
CCancelled
COCollected
DDelivered
DMDamaged
EEdited
FFulfilled
HOn Hold
LTLost In Transit
NCNot Collected
NRNot Received from Supplier
OOpen
ODOut for Delivery
PPartial
PDPart-Delivered
QQuarantined
RRefused
RDReDelivery
RHReceived in Hub
RTSReturned to Supplier
SOCShipped to 3rd Party
TTRASHED
UDUnDelivered

Barcode scanning statuses (not shown on tracking csv files  by default):

StatusIdDescription
OAGOpen (Awaiting Goods)
ODAOut for Delivery (All)
ODPOut for Delivery (Partial)
OPDReceived in Warehouse (Damaged)
OPGReceived in Warehouse (Partial)
ORBReceived in Warehouse (Complete)
RWDReceived in Warehouse – Damaged
RWGReceived in Warehouse – Good

Reason Codes

REASON CODEDESCRIPTIONAPPLIES TO STATUS
BIAIncorrect Address rebookB
BRBRegular bookingB
CLBClient RebookedB
RAUAuto RebookedB
CACAbusive CustomerC
CARAlready RoutedC
CCCClient CancelledC
CDFIncorrect Customer Data / FraudC
CDMDamagedC
CDODuplicate OrderC
CHPHolding PolicyC
CNSNo StockC
CRCCustomer CancelledC
NTFNot To Be FulfilledC
H1Awaiting Cust CallbackH
H2Awaiting Client Call BackH
H3Awaiting ScansH
Q1Incorrect Phone No.Q
Q2Incorrect AddressQ
Q3Unable To ContactQ
Q4Awaiting CollectionQ H
Q5Awaiting DeliveryQ H
Q7Material ShortageQ
Q8Missing Customs DetailsQ
Q9Incorrect Weight DimsQ
adCannot Find AddressUD NC
agAgent ErrorUD NC
bmVehicle Capacity Issue – Manually RoutedUD
caCancelled Late (Client)UD NC
ccCancelled Late (Customer)UD NC
cdCustomer Did Not OrderUD
crCustomer RebookB
dDamaged on delivery vehicleUD
daDamaged in Warehouse/TrunkUD
dpDamaged on unpackingUD
drDelivery ErrorUD
fCancelled within SLAUD NC
gLoading errorUD
hTraffic congestion/Adverse WeatherUD NC
iVehicle breakdownUD NC
itData ErrorUD NC
jIT issueUD NC
kInsufficient driving timeUD NC
lIncorrect customer dataUD NC
lhProduct Too Large/HeavyUD NC
lwLoaded onto wrong pallet/trunkUD
mWrong item sentUD NC
mcManually routed (VCI)NC
mpMispickUD
nCustomer not inUD NC
ncNot Collected (VCI)NC
pCannot access addressUD NC
ppPostponed out of SLAUD NC
ptPostponed within SLANC UD
qRefused- Packaging DamagedUD
rCustomer not ready to acceptUD NC
sNot despatched from supplierUD
scService CompletedUD NC
sfSuspected FraudUD
tVehicle Capacity Issue – FailureUD
tiTransport IssueUD
uReceived damage from ClientUD
urUnable to RepairUD NC
vMisroute/MissortUD
vcIncorrect Weights & DimsUD
zNothing To CollectNC