Returns
A comprehensive list of the return resource's fields and attributes
Last updated
A comprehensive list of the return resource's fields and attributes
Last updated
are linked to one specific order. Commerce Layer Metrics API lets you perform different types queries on the /returns/{{query_type}}
endpoint to gather stats and information about your organization return history:
The results of each query can be filtered based on specific fields and operators:
You can easily see it in action by checking these simple examples:
Please reference to this list for a comprehensive view of all the return resource's fields and attributes, accessible through the Metrics API:
customer
fieldid
String
The ID of the customer.
email
String
The email address of the customer.
group_name
String
The name of the customer group the customer belongs to (if any).
destination_address
fieldbusiness
Boolean
Indicates if the address is a business or a personal one.
city
String
The city specified in the address.
country_code
String
geocoded
Boolean
Indicates if the address has been successfully geocoded.
localized
Boolean
Indicates if the latitude and longitude of the address are present, either geocoded or manually updated.
state_code
String
The state, province or region code specified in the address.
zip_code
String
The ZIP or postal code specified in the address.
origin_address
fieldbusiness
Boolean
Indicates if the address is a business or a personal one.
city
String
The city specified in the address.
country_code
String
geocoded
Boolean
Indicates if the address has been successfully geocoded.
localized
Boolean
Indicates if the latitude and longitude of the address are present, either geocoded or manually updated.
state_code
String
The state, province or region code specified in the address.
zip_code
String
The ZIP or postal code specified in the address.
market
fieldid
String
The ID of the market.
name
String
The name of the market.
number
Integer
The numeric unique identifier for the market.
return
fielddate_from
String
date_to
String
date_field
String
The date field (e.g. requested_at
, rejected_at
, etc.) where to apply the date and time range filter.
approved_at
String
archived_at
String
archived
Boolean
Indicates if the return has been archived.
cancelled_at
String
created_at
String
number
String
The numeric unique identifier for the return.
received_at
String
reference
String
Any external identifier that might be useful to link the return resource to other systems through the Commerce Layer core API.
reference_origin
String
Any identifier of the 3rd-party system that defines the reference code.
rejected_at
String
shipped_at
String
status
String
The return status. One of draft
, requested
, approved
, cancelled
, shipped
, rejected
or received
.
updated_at
String
current_date
String
id
String
The ID of the return.
order_id
String
The ID of the order associated with the return.
skus_count
Integer
The total number of SKUs in the return's line items.
return_line_items
fieldcreated_at
String
quantity
Integer
The return line item quantity.
restocked_at
String
updated_at
String
line_item_id
String
The ID of the return line item.
line_item_code
String
The code of the associated SKU or bundle.
line_item_item_type
String
The type of the associated item. One of sku
, or bundle
.
line_item_total_amount
Number
The total amount of the return line item (float).
line_item_tax_amount
Number
The collected tax amount for the return line item (float).
line_item_tax_rate
Number
The tax rate for the return line item (if calculated).
line_item_updated_at
String
stock_location
fieldid
String
The ID of the stock location.
name
String
The name of the stock location.
reference
String
Any external identifier that might be useful to link the stock location resource to other systems through the Commerce Layer core API.
reference_origin
String
tags
fieldid
String
The tag ID.
name
String
The tag name.
The international 2-letter country code (as defined by the standard) specified in the address.
The international 2-letter country code (as defined by the standard) specified in the address.
The lower limit of the date and time range used to filter the collected returns (complete date plus hours, minutes and seconds — according to the standard).
The upper limit of the date and time range used to filter the collected returns (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return was approved (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return was archived (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return was cancelled (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return was created (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return was received (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return was rejected (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return was shipped (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return was last updated (complete date plus hours, minutes and seconds — according to the standard).
The date and time of the return's latest status change, regardless of the return's status (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return line item was created (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return line item was restocked (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return line item was last updated (complete date plus hours, minutes and seconds — according to the standard).
The date and time at which the return line item was last updated (complete date plus hours, minutes and seconds — according to the standard).