Shipments average time in picking

How to use the Metrics API to get the average time your shipments stay in picking status before being packed

The problem

You want to get the average time your order shipments remain in the picking status before being moved to packing, over a selected date and time range.

The solution


You need to perform a stats query setting the required query keys as follows and adding the optional ones based on your needs:







Make sure to set the desired date and time range using the date_from and date_to keys in the filter.

As shown in the example below, use placed_at as the date_field in the date filter if you want the results to count all the orders that were placed in the selected date and time range (read more about this).


The following request uses the Metrics API to get the average time shipments stay in picking:

curl -g -X POST \
  'https://{{your_domain}}' \
  -H 'Accept: application/vnd.api.v1+json' \
  -H 'Content-Type: application/vnd.api+json' \
  -H 'Authorization: Bearer {{your_access_token}}' \
  -d '{
    "stats": {
      "field": "shipments.seconds_in_picking",
      "operator": "avg"
    "filter": {
      "order": {
        "date_from": "2021-01-01T00:00:00Z",
        "date_to": "2021-12-31T23:59:00Z",
        "date_field": "placed_at"

Similar cases

Just changing a couple of query keys and/or filter parameters you can address lots of very similar use cases, such as:

Last updated