Mixed stats about returns that contain more than one product

POST https://{{subdomain}}.commercelayer.io/metrics/returns/stats

The problem

Among the ones containing more that one products, you want to get some common statistics about the number of SKUs present in the returns requested from your orders, over a selected date and time range. Specifically:

The solution

Query

You need to perform a stats query setting the required query keys as follows:

Make sure to set the desired date and time range using the date_from and date_to keys or as your environment variables and add an additional filter on the return field to restrict the related search on returns containing more than one SKU only:

In this example, since we use created_at as the date_field, you'll get in the response all the returns that were created within the selected date and time range ([read more] this).

Request Body

{"stats"=>{"field"=>"return.skus_count", "operator"=>"stats"}, "filter"=>{"return"=>{"date_from"=>"{{date_from}}", "date_to"=>"{{date_to}}", "date_field"=>"created_at", "skus_count"=>{"gt"=>1}}}}

HEADERS