File details: order-status.csv

Edit on GitHub

This document describes the order-status.csv file to configure the update of the regular order status information in your Spryker shop.

To import the file, run:

order-oms:status-import order-status

Import file parameters

The file must have the following parameters:

Order_reference Must be unique. Identifier of the order in the system.
order_item_reference String Must be unique. Identifier of the item in the order.
order_item_event_oms String OMS events depend on the state machine configured. Desired order item state. Only this parameter is updated in the database

Import file dependencies

The file has no dependencies.

Additional information

When the order item status is updated by importing the CSV file, the corresponding events in a state machine are triggered, and the state gets updated. As an order may contain several order items, the CSV file can have several rows of items for the same order.

Order_item_reference can repeat and have different states in the file—for example, in one case, packed and then shipped. This lets you update the item through different state machine statuses —for example, packed and shipped—and avoid errors. If the order item doesn’t follow the existing sequence (the statuses flow in the state machine), the state is not updated, and you get an error.

Import template file and content example

The following table contains the template and an example of the file:

template_order-status.csv Import file template with headers only.
order-status.csv Example of the import file with Demo Shop data.