This manual describes the data exchange for orders if you want to manage the delivery of orders in your internal system and use the FTP server for data exchange.

Order status

1. Draft - in this state, you can change the approved volume.
2. Ordered - the order is considered as sent and you cannot change the approved volume in this state. The approved volume is counted as stock on the way for the next order.
3. Delivered - the order is physically delivered to the store. The stock on the way is reduced by the approved volume in the respective order.
4. Canceled - the order has been completely canceled. The stock on the way is reduced by the approved volume in the respective order.

Data exchange scheme

1. Export Orders from Quant - Quant generates the order and exports it to FTP in the "Ordered" state after the confirmation time has passed.
2. Import of Orders (optional) - with this import you can edit the approved volume to the actual orderable volume (confirmed by the supplier). Quant will adjust the approved volume based on this information and count this volume as stock on the way for the next orders.
3. Export of Order Properties - this is only a check export in case an error occurs during data transfer. Within this export we send a list of QID orders that are open (status "Ordered").  If you find that there is an invalid order or an already delivered order in this list, send this information using the 4th Import of Order Properties.
4. Import of Order Properties - within this import you can send a request to cancel an order (status "Canceled"). Or, if the order has already been delivered, send information about its delivery (status "Delivered").

Export Orders 

Each line of the exported file represents one product in the order defined by the Primary product ID. Each order has its own unique order QID. You can specify which columns should be part of the export directly in the MinMax Ordering Confirmation automatic task settings. In the settings you can also optionally change the name of the exported column.

Export orders

Import Orders

The imported file must contain the Product ID, Order QID and Approved Volume. Import of Orders allows you to add a product to your order in addition to adjusting the approved volume. If, on the other hand, a product needs to be removed, then it needs to be sent with zero as approved volume (Approved Volume = 0).

Import orders

Export Orders Properties

Each line represents one unique order defined by the order QID. Using the status column, you can check if the order has already been processed or not. You can specify what other columns should be part of the export directly in the settings of the Export Order Properties automatic task.

Export order properties

Import Orders Properties

The imported file must contain the order QID and the order status to which the order is to be changed. Quant expects the following values: "Delivered" and "Canceled". If you are sending a different status term, you can set this via Value Replacement in CSV Importable Order Properties Attribute Mapping settings of the Import Orders Properties automatic task.

Import orders properties