---
title: "List products"
description: "List the variants on the store-wide Preorders > Products tab, with the offers each is linked to, paginated."
url: https://docs.stoqapp.com/v2-reference/preorders-products/list-products/
api: "API v2 reference"
method: GET
path: "/preorders/products"
---

# List products

`GET https://app.stoqapp.com/api/v2/external/preorders/products`

List the variants on the store-wide Preorders > Products tab, with the offers each is linked to, paginated.

**Note:** search matches product title, variant title and SKU, as the tab's search does. sort is one of created_asc, created_desc, title_asc, title_desc (default title_asc); created means the product's Shopify creation order. product_status keeps active, draft, archived, unlisted (comma-separated). With no offer filter the list holds only variants linked to an offer, as the tab does; offer_ids keeps variants in those offers and no_offer_linked=true adds the variants in no offer (the tab's 'No offer linked'). Variants deleted in Shopify are left out. per_page is 1-100 (default 20). Each row's offers carry that variant's own shipping_text and max_count (the values [`PATCH /preorders/products`](https://docs.stoqapp.com/v2-reference/preorders-products/update-a-product/) writes), quantity_limit (read-only: the limit that applies, which on a batch offer is the batches' total and not max_count; null is no limit), preorder_count and quantity_limit_reached. The top-level offers are every offer the tab can pick from, each with its current_status (live, scheduled or off, as [`GET /preorders/offers`](https://docs.stoqapp.com/v2-reference/preorders-offers/list-offers/) reports it: a dated offer is scheduled before its start and off after its end). include_inventory=true adds each row's live Shopify inventory_quantity and inventory_policy, and reads sku live, as the tab shows them.

## Query parameters

- `sort` (string) One of: `created_asc`, `created_desc`, `title_asc`, `title_desc`.
- `page` (string)
- `per_page` (string)
- `search` (string)
- `product_status` (string)
- `offer_ids` (array)
- `no_offer_linked` (string)
- `include_inventory` (string)

Rate limit: this call costs 1 point ([rate limits](https://docs.stoqapp.com/docs/rate-limits/)).

## Examples

### List products

```sh
curl "https://app.stoqapp.com/api/v2/external/preorders/products" \
  -H "X-Auth-Token: $STOQ_API_KEY"
```

### List products filtered by sort and offer_ids

```sh
curl "https://app.stoqapp.com/api/v2/external/preorders/products?sort=created_asc&offer_ids=string" \
  -H "X-Auth-Token: $STOQ_API_KEY"
```

## 200

Success: the requested resource.

## 401

Missing or invalid `X-Auth-Token`.

```json
{
  "errors": [
    "Invalid API key"
  ],
  "code": "auth_invalid",
  "details": [
    {
      "code": "auth_invalid",
      "message": "Invalid API key",
      "path": null,
      "value": null,
      "expected": null
    }
  ]
}
```

## 422

The request failed validation.

```json
{
  "errors": [
    "name is required"
  ],
  "code": "validation_failed",
  "details": [
    {
      "code": "validation_failed",
      "message": "name is required",
      "path": null,
      "value": null,
      "expected": null
    }
  ]
}
```

## 429

Rate limited: cost-weighted per token (read 1, write 2; 360 points / 60s). Check `Retry-After`.

```json
{
  "errors": [
    "Rate limit exceeded"
  ],
  "code": "rate_limited",
  "details": [
    {
      "code": "rate_limited",
      "message": "Rate limit exceeded",
      "path": null,
      "value": null,
      "expected": null
    }
  ]
}
```