Order Status Information

Order statuses are controlled by the table name ZnodeOmsOrderState in the database and the table has columns that tell Znode what they use for and what they trigger. You can add/remove items from these tables to match the statuses you need in your solution. These are the Yes/No flags and each status that indicates what Znode should allow.

  1. IsShowToCustomer - Is it visible to customers or used internally.

  2. IsAccountStatus - Is the status used for an account. 

  3. IsEdit - Indicates whether order/quotes should be editable by the user.

  4. IsSendEmail - Email to be triggered for this state.

  5. IsOrderState - Is the status used for orders.

  6. IsOrderLineItemState - Is the status used for order lines.

  7. IsQuoteState - Is the status used for quotes.

Notes -

  1. For manual advance orders through the system with its status, the external needs to provide status updates to Znode as there is no defined workflow and it accepts per the external system uses.

  2. The status to help know when can trigger the Electronic GCs is based on the need per ERP, as this could be a good approach. E.g if there is a status that you know means that you're ERP has accepted the gift card it makes sense to trigger the email and create a GC at that point. 

ZnodeOmsOrderState

Following are the default statuses out-of-box. As these are customizable your solution may have different values, please review the data in your database table to see the exact settings you have.

OmsOrderStateId

OrderStateName

IsShowToCustomer

IsAccountStatus

DisplayOrder

Description

IsEdit

IsSendEmail

IsOrderState

IsOrderLineItemState

IsQuoteState

10

SUBMITTED

1

0

99

Submitted

1

0

1

1

1

20

SHIPPED

1

0

99

Shipped

1

1

1

1

NULL

30

RETURNED

1

0

99

Returned

0

1

0

0

NULL

40

CANCELED

1

0

99

Canceled

0

1

1

0

1

50

PENDING APPROVAL

1

1

99

Pending Approval

1

0

1

1

NULL

60

APPROVED

1

1

99

Approved

1

0

0

0

1

70

REJECTED

1

1

99

Rejected

1

0

0

0

NULL

80

IN REVIEW

1

0

99

In Review

1

0

0

0

1

90

DRAFT

1

1

99

Draft

1

0

0

0

NULL

100

ORDERED

1

1

99

Ordered

1

0

0

0

NULL

110

PARTIAL REFUND

1

0

99

Partial Refund

1

1

0

0

NULL

120

SENDING

0

0

99

Sending

0

0

1

1

NULL

130

ORDER RECEIVED

0

0

99

Order Received

0

0

1

1

NULL

140

FAILED

0

0

99

Failed

1

0

1

1

NULL

150

IN PROGRESS

0

0

99

In Progress

0

0

1

1

NULL

160

IN PRODUCTION

0

0

99

In Production

0

0

1

1

NULL

170

WAITING TO SHIP

0

0

99

Waiting To Ship

0

0

1

1

NULL

180

INVOICED

0

0

99

Invoiced

0

0

1

1

NULL

190

PENDING PAYMENT

0

0

99

Pending Payment

0

0

1

1

NULL

200

EXPIRED

0

0

99

Expired

0

0

0

0

1

Did you find it helpful? Yes No

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