---
title: "List catalog variances"
method: GET
path: "/catalog/variances"
tags: ["catalog"]
---

# List catalog variances

`GET /catalog/variances`

Returns catalog entries with price variance information from invoice items. By default, returns all items that had purchases in the specified period, including items with zero variance. Use variance_only=true to return only entries with non-zero variance. Use expand=invoice_items to include all invoice items inline (otherwise only the most recent invoice item is returned).

## Query parameters

- `ottimate_company_id` integer, required
- `variance_only` boolean
- `expand` string
- `invoice_start_date` string, date
- `invoice_end_date` string, date
- `erp_vendor_ids` string
- `ottimate_location_ids` string
- `exception_type` 'underbilling' | 'overbilling'
- `page` integer
- `limit` integer

## Headers

- `Authorization` string, required
- `X-Api-Key` string, required
- `X-API-Version` string

## Response `200`

Successful response with paginated variance list

- VarianceListResponse
  - `count` integer, required
  - `results` VarianceListResponseResultsItems[], required
    - `id` string, required — Catalog entry ID
    - `item_name` string, required
    - `sku` string
    - `upc` string
    - `pack_size` string
    - `erp_vendor_id` string — ERP Vendor id from ERP/accounting system
    - `last_invoice_item` VarianceListResponseResultsItemsLastInvoiceItem
      - `id` integer, required
      - `price` number, double, required
      - `invoice_date` string, date, required
      - `price_variance` number, double
      - `effective_price` number, double

## Other responses

- `400` — Bad request - Invalid parameters or request format

---

[API](https://skmtc.net/ottimate/apis/api-reference.md) · [All operations](https://skmtc.net/ottimate/apis/api-reference/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/ottimate/api-reference/versions/3b3756010473/schema)