Latest carts with a specific product from a specific market
How to use the Metrics API to get the most recently created carts containing a specific SKU, from a specific market
Last updated
How to use the Metrics API to get the most recently created carts containing a specific SKU, from a specific market
Last updated
You want to get the last ten created carts that contain a specific product and are associated with a specific market, over a selected date and time range, chronologically ordered by date of creation.
You need to perform a search query setting the required query keys as follows and adding the optional ones based on your needs:
limit
10
sort_by
order.created_at
Set the desired date and time range using the date_from
and date_to
keys and add an additional filter on the line items field to restrict the related search on carts that contain the desired SKU only:
codes
"in": [ "TSHIRT0001" ]
Then add an additional filter on the market field to restrict the related search on the carts associated with the selected market only:
names
"in": [ "North America" ]
In the example below, since the date_field
isn't specified in the , the default value current_date
will be used, meaning that the results will count all the orders that changed their status within the selected date and time range ( about this).
The following request uses the Metrics API to get the latest carts containing a specific SKU and associated with a specific market:
Just changing a couple of query keys and/or filter parameters you can address lots of very similar use cases, such as: