List products

Returns your products with their items, 50 at a time by default, in ascending ID order. Narrow the list with the filters below (including active) and page through it with the X-Next-Page header.

See Filtering, sorting and search for how the filters, ranges and sort work.

Required permission (any one of these):

GroupPermission
ProductsView item cost history
ProductsChange item costs (includes view)
ProductsList and view products
ProductsCreate, edit and delete products (includes view)
Query Params
integer
1 to 250
Defaults to 50

How many records to return per page. Defaults to 50, maximum 250.

string

Opaque paging cursor. Don't build this yourself: follow the path in the X-Next-Page or X-Prev-Page response header.

integer

Only return products with an ID greater than this one. Handy for picking up where you left off.

string

Comma-separated list of product IDs to fetch, e.g. 392056,392058.

string

Free-text search, for example on the product name.

string

Only records with any of these tags. Send one tag or a comma-separated list, up to 50.

string

Only return products of this type. See GET /products/types.json for the values.

string

Only return products from this vendor. See GET /products/vendors.json for the values.

date-time

Only return products created on or after this date/time (ISO 8601).

date-time

Only return products created on or before this date/time (ISO 8601).

string

Older way to choose the sort field, used with sort=asc or sort=desc. Still supported. Keys: id, name, style, type, vendor, created, updated.

string

Sort order. Use sort=key for ascending or sort=-key for descending, for example sort=-created. Keys: id, name, style, type, vendor, created, updated. The older sort_field=key&sort=asc|desc style still works.

string

Partial match on name.

string

Partial match on style.

date-time

Greater than (not including) the updated.

date-time

Less than (not including) the updated.

string

Exact match on vendor. Send one value or a comma-separated list.

string

Exact match on type. Send one value or a comma-separated list.

string

Exact match on style. Send one value or a comma-separated list.

string

Exact match on barcode. Send one value or a comma-separated list.

string

Exact match on sku. Send one value or a comma-separated list.

boolean

Filter on whether the product is active: true or false (1/0 work too). Leave it out to return both active and inactive products. Works with the other filters, sorting and cursor paging.

string

From this created. Accepts YYYY-MM-DD (a _to date covers the whole day) or a full timestamp (RFC 3339, converted to UTC). Inclusive.

string

Up to this created. Accepts YYYY-MM-DD (a _to date covers the whole day) or a full timestamp (RFC 3339, converted to UTC). Inclusive.

string

From this updated. Accepts YYYY-MM-DD (a _to date covers the whole day) or a full timestamp (RFC 3339, converted to UTC). Inclusive.

string

Up to this updated. Accepts YYYY-MM-DD (a _to date covers the whole day) or a full timestamp (RFC 3339, converted to UTC). Inclusive.

Responses

Language
Credentials
Header
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json