Skip to main content
Stock order status data file specification

How to format the stock order status data file for the Advanced CSV connector

S
Written by Sara Jaffer
Updated over 2 weeks ago

The Advanced CSV connector is in Early Access. If you're interested, you can click here to apply to our Early Adopter Program.

Note: The Advanced CSV connector is only available to Premium subscribers. Contact Inventory Planner Support to learn more about upgrading to Premium.

Inventory Planner has a set of default statuses for stock orders. If you use statuses outside of that default set, you can manage them using the stock order status file.

The default set is OPEN, DRAFT, PARTIALLY RECEIVED, CLOSED and CANCELLED. Note that they can’t be edited or deleted.

Stock order status data columns

Column name

Required

Column type

Comments

NAME

VARCHAR(256)

The status name

STATUS_TYPE

VARCHAR(256)

Must be one of “draft”, “active”, “closed” and “cancelled”

REMOVED

BOOLEAN

Soft remove the status by setting to “true”

UPDATED_AT

TIMESTAMP_NTZ

Row last updated timestamp

Did this answer your question?