Meaning of Status in Order Line Export file

[rainfogd]

Hello

In this file - normally exported as bba.txt order lines usually have the status of F or N. But we're getting some with status C eg#

5689,13664,"C","WKK3B","Safe Haven extra mounting kit","",1,0,1,0,1702,0,0,0,0,"","","",1702,298,0,0,1702,0,0,0,0,"Customer couldn't wait any longer!","101=1750=0=VAT=","0=0=0==","101=1750=0=VAT=","0=0=0==",0,-1,0,0,"101","000",0,0,0,"",""

Anybody have any idea what C means?

Gareth

Gearshift / Orbit Cycles

[Jan]

The clue is in the message in that order line, 'C' = cancelled.

Regards,

[Jan]

Actually I have just found another status as well which is "S" for shipped.

So the values for the status field in the order table are

'N' pending/just arrived
'S' shipped
'C' cancelled
'F' complete

... and you also have to check bOrderIsDeleted, -1 means that it is deleted, 0 means it is not.

Regards,

[rainfogd]

Jan

Thanks for that - but it doesn't seem to square with what we've found comparing the export file with what really happens -

F followed by C=SHIPPED,
F followed by N=SHIPPED,
F=SHIPPED,
C followed by C=CANCELLED.
C followed by N=CANCELLED
F cannot be followed by another F (as this denotes next product, not a component or attribute)

So, for instance,
Order sequence 5751 status F Endura Cairn T-shirt
Order sequence 5751 status C - Size: Medium (WENB2M)

is shipped.

whilst
Order sequence 5689 status C Safe Haven extra mounting kit

is cancelled.

and

Order sequence 5908 status C Endura Women's Tactel Shirt
Order sequence 5908 status C - Size: Size 12 (WENJ6M)

is cancelled

as is

Order sequence 6235 status C Orbit Gel Mitts
Order sequence 6235 status N - Size: Medium (WCM3)

But

Order sequence 6118 status F Markill? Peak Illuminator
Order sequence 6118 status F Peak Illuminator Spares
Order sequence 6118 status N I would like - this spare: Spare Mantles (WATCL1M)

is entirely despatched (two products)

so C does not always seem to represent a cancelled order?

Thanks

Gareth

[Jan]

There are two parts to an order, the order and the order details, the latter has one line for each item ordered and each component or attribute included.

The status I posted are correct for the order lines.
I think that the status for the order detail lines should be taken from the main line rather than the component (there is a flag that tells you whether it is a component) I will check and let you know.

Regards,