---
title: "Lot list (expiry date)"
method: GET
path: "/shops/{SHOP_ID}/lots"
tags: ["Lot"]
---

# Lot list (expiry date)

`GET /shops/{SHOP_ID}/lots`

## Request

- Base URL: `https://pos.pages.fm/api/v1`
- URL: `https://pos.pages.fm/api/v1/shops/{SHOP_ID}/lots`
- Auth: API key in query parameter `api_key`

Get the list of expiry-date lots of products (products with type `LOT`). Each lot has a lot code (`custom_id`), manufacturing date and expiry date, and is linked to one or more variations of the product via `lot_variations`.

Datetime values (`expire_date`, `manufacturing_date`, ...) are in UTC.

## Path parameters

- `SHOP_ID` integer, required

## Query parameters

- `page` integer
- `page_size` integer
- `search` string
- `warehouse_ids[]` string[]
- `remain_quantity` string
- `actual_remain_quantity` string
- `min_retail_price` integer
- `max_retail_price` integer
- `expiry_date` string
- `range` string
- `sort_field` string

## Response `200`

Success

- object
  - `data` LotProduct[]: List of lots
    - `id` string: Lot ID
    - `custom_id` string: Lot code
    - `expire_date` string, date-time: Expiry date (UTC)
    - `manufacturing_date` string, date-time: Manufacturing date (UTC)
    - `inserted_at` string, date-time: Created at
    - `updated_at` string, date-time: Updated at
    - `product` LotProductInfo: Product of the lot (variations are not included)
      - `id` string: Product ID
      - `name` string: Product name
      - `type` string: Product type, always `LOT` for expiry-date products
      - `custom_id` string, nullable: Product custom ID
      - `display_id` integer: Product display ID
      - `image` string, nullable: Product image URL
      - `is_published` boolean, nullable: Store cake status
      - `is_sell_negative` boolean, nullable: Allow selling with negative stock
      - `note` string, nullable: Internal note
      - `note_product` string: Product note (HTML)
      - `measure_group_id` integer, nullable: Measure group ID
      - `brand_id` string, nullable: Brand ID
      - `creator_id` string, nullable: Creator ID
      - `inserted_at` string, date-time: Created at
      - `categories` object[]: Product categories
        - `id` integer: Category ID
        - `name` string: Category name
      - `tags` object[]: Product tags
        - `id` integer: Tag ID
        - `note` string: Tag name
      - `materials` integer[]: Material IDs
      - `supplier_product_ids` integer[]: Supplier IDs
      - `manipulation_warehouses` string[]: Warehouse IDs the product is operated in
      - `product_attributes` object[]: Product attributes
        - `id` string: Attribute ID
        - `name` string: Attribute name
        - `values` string[]: Attribute values
        - `keyword` object[]: Keyword of each attribute value
          - `keyValue` string: Keyword
          - `value` string: Attribute value
      - `bonus_products` object[]: Bonus products
        - `variation_id` string: Variation ID of the bonus product
        - `quantity` union: Bonus quantity
          - string
          - number
        - `price_original` union: Original price of the bonus product
          - string
          - number
        - `variation_info` object: Variation information of the bonus product
      - `limit_quantity_to_warn` integer, nullable: Low-stock warning threshold
      - `limit_quantity_to_warn_by_warehouse` object, nullable: Low-stock warning threshold per warehouse (key is warehouse ID)
      - `warning_by_variation` boolean, nullable: Low-stock warning is applied per variation
    - `lot_variations` object[]: Variations of the product linked to this lot
      - `id` string: Lot-variation ID
      - `variation_id` string: Variation ID
      - `inserted_at` string, date-time: Created at
      - `updated_at` string, date-time: Updated at
  - `page_number` integer: Page number
  - `page_size` integer: Page size
  - `success` boolean: Success status
  - `total_entries` integer: Total entries
  - `total_pages` integer: Total pages

## Changes

- **2026-10-13** `e8241b8d7791`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/pancake/apis/pancake-pos-open-api/changes/shops/:SHOP_ID/lots/get.md)

---

[API](https://skmtc.dev/pancake/apis/pancake-pos-open-api.md) - [All operations](https://skmtc.dev/pancake/apis/pancake-pos-open-api/llms.txt) - [OpenAPI document](https://skmtc.dev/pancake/apis/pancake-pos-open-api/revisions/3df28d1fb5dc?raw)