Order Enumerations


"Value" column values are stored as strings, not integers.

OrderCheckoutStatus

NameValueDescription
NotVisited (default)0Checkout is open.
Completed1Checkout is closed.
Visited2Checkout is open.
Disabled4Checkout is closed.
CompletedAndVisited3Checkout is closed.
CompletedOffline8Checkout is closed.
OnHold16Checkout is open.

OrderPaymentStatus

NameValueDescription
NotYetSubmitted (default)0Payment is unfinished.
Cleared1Payment is finished.
Submitted2Payment is unfinished.
Failed4Payment is finished.
Deposited8Payment is unfinished.

OrderShippingStatus

NameValueDescription
Unshipped (default)0Fulfillment is incomplete.
Shipped1Fulfillment is complete.
PartiallyShipped2Fulfillment is incomplete.
PendingShipment4Fulfillment is incomplete.
Canceled8Fulfillment is complete.
ThirdPartyManaged16Fulfillment is complete.

OrderTaxType

NameValueDescription
NoTax (default)0
Standard1Tax is not included in costs.
ExclusiveVat2Tax is not included in costs.
InclusiveVat3Tax is included in costs.

FlagType

NameValue
NotSpecified-9999
ItemCopied-2
ExclamationPoint-1
NoFlag0
RedFlag1
QuestionMark2
NotAvailable3
Price4
YellowFlag5
GreenFlag6
BlueFlag7

AdjustmentReason

Some sites have Marketplace-Specific AdjustmentReason values. Those that do not will have the values on the table below applied.

NameValue
GeneralAdjustment (default)100
ItemNotAvailable101
CustomerReturnedItem102
CouldNotShip103
AlternateItemProvided104
BuyerCancelled105
CustomerExchange106
MerchandiseNotReceived107
ShippingAddressUndeliverable108

AdjustmentType

NameValueDescription
Refund (default)0Generally applied after fulfillment.
Cancellation1Generally applied before fulfillment.
Dispute2Applied when an item is in dispute (used for eBay buyer-requested cancel/refunds)

AdjustmentRequestStatus and RestockStatusAsyncStatus

NameValueDescription
Error-1The operation failed
SubmittedNotProcessed0Queued for processing
NewRma1New buyer-initiated return awaiting the seller's approval or rejection
PendingApproval2Queued for approval communication with the marketplace
ProcessingApproval3Approval communication is in progress
ReadyForReturn4Approval complete; awaiting the seller's approval or rejection of the return shipment
PendingReturn5Queued for return approval communication with the marketplace
ProcessingReturn6Return approval communication is in progress
PendingRejection7Queued for rejection communication with the marketplace
ProcessingRejection8Rejection communication is in progress
ProcessedNotAcknowledged10Initial processing is complete; waiting for response
PendingReturnRejection11Queued for return rejection communication with the marketplace
ProcessingReturnRejection12Return rejection communication is in progress
AcknowledgedPostProcessingNotComplete20Response received; completing final processing
PostProcessingComplete30Successful and complete
RejectionCompleted31Successfully completed rejection processing.  No refund occurred.
InformationOnly32The buyer-initiated return was imported for information purposes but was not processed
NoChange-999Incomplete

FulfillmentType

NameValueDescription
Ship1Items are shipped to the recipient.
Pickup2Items are picked up from a physical location by the recipient.
ShipToStore3Items are shipped to a physical location then picked up by the recipient.
Courier4Items are delivered to the recipient by an intermediary.

FulfillmentDeliveryStatus

NameValueDescription
NoChange1The fulfillment is unshipped. Making a request with this value will set a fulfillment or order to unshipped.
InTransit2The fulfillment is in transit to a location where the recipient may pick it up. This status is used for eBay In-Store-Pickup orders only.
ReadyForPickup4The fulfillment has arrived at the pickup location and is ready for the recipient to pickup. This status is intended to be used for eBay In-Store-Pickup orders only.
Complete8The fulfillment is complete and/or fully shipped.
Canceled13The items on this fulfillment have been canceled and will not be fulfilled.
ThirdPartyManaged26The fulfillment is handled outside ChannelAdvisor. Integrations where orders are imported into ChannelAdvisor but the retailer does not want ChannelAdvisor to manage any aspects of the order's fulfillment will have this status.

ExternalFulfillmentStatus

NameValueDescriptionFinal State
Held-10Fulfillment is held in ChannelAdvisorYes
Failed-1Communication failed to external partnerYes
New0Communication not initiated to external partnerNo
Pending10Routed to internal Distribution Center, not yet communicated to external partnerNo
Sent15Communication delivered to external partnerNo
Processing20External partner is working on the fulfillmentNo
Complete30Fulfillment is in a completed stateYes

DistributionCenterTypeRollup

NameDescription
SellerManagedThe Distribution Center associated with products in the order is managed by the seller.
ExternallyManagedThe Distribution Center associated with products in the order is managed by another party.
MixedThe Distribution Centers associated with products in the order are both seller managed and externally managed.

LabelFormat

NameValueDescription
PDF2 PDF file format
ZPL8 ZPL file format

MeasurementUnit

NameValueDescription
Centimer0
Inch1

WeightUnit

NameValueDescription
Gram0
Pound1

DeliveryConfirmation

NameValueDescription
Default0 The default confirmation determined by the shipping carrier.
SignatureRequired 1 Signature required for package delivery.
AdultSignatureRequired 2 Adult signature required for package delivery.
NoDeliveryConfirmation 34 No delivery confirmation requested.