This manual describes the data exchange for orders if you wants to approve the proposed volume in their 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 shipped 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 cancelled. 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 your system in the "Draft" state.
2. Import of orders - you proces the order in your system and after its approval you sends to Quant the exact information what product for which order and in what quantity was ordered. Based on this information, Quant will change the order status to "Ordered" and count the approved volume as stock on the way.
3. Export of order properties - this is only a check export in case there was a communication error in the previous two data transfers. Within this export, we will send a list of QID orders that are open (draft status). If you find that there is an invalid order in this list, you can send a request to cancel it within the 4th import of order properties. Or, if the order has already been approved in your system, you can send us a list of approved products along with the approved volume in the 2nd order import.
4. Import of order properties - optionally you can use this import to cancel the whole order.

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 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. If a proposed product is not part of the import, Quant automatically assumes that the order was not placed, i.e. that zero volume was approved.

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 state flag, you can set this via Value Replacement in CSV Importable Order Properties Attribute Mapping settings.

Import orders properties