List stock lots

get

https://api.mrpeasy.com/rest/v1/lots

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Query Params

code

string

A unique number to identify the stock lot.

lot_id

integer

Database ID of the stock lot.

article_id

integer

Database ID of the stock item.

If Matrix BOM is turned on, this is unique for each variation.

product_id

integer

Database product ID.

If Matrix BOM is turned on, product_id is the same at all variations of the stock item.

item_code

string

A unique number to identify the stock item.

item_title

string

Name of the stock item.

group_id

integer

ID of the product group.

group_code

string

A unique number to identify the product group.

group_title

string

Name of the product group.

status

array of objects

Status of stock lot.

5 - Requested
10 - Planned
15 - On hold
20 - Received
25 - Rejected
30 - Cancelled
100 - RMA Waiting for inspection
105 - RMA Waiting for repair
110 - RMA ready for shipment
115 - RMA returned

Arrays are supported, for example ?status[]=10&status[]=20.

status

source

integer

enum

Source type of the stock lot.

Allowed:

revision

string

Revision of the stock lot.

site_id

integer

ID of site where this stock lot is located.

pur_ord_id

integer

ID of purchase order if this stock lot was purchased.

purchase_order_code

string

Number of purchase order if this stock lot was purchased.

prod_ord_id

integer

ID of manufacturing order if this stock lot was produced. The response field is man_ord_id.

manufacturing_order_code

string

Number of manufacturing order if this stock lot was produced.

transfer_id

integer

ID of transfer order if this stock lot was transferred from one site to another.

transfer_order_code

string

Number of transfer order if this stock lot was transferred from one site to another.

rma_ord_id

integer

ID of RMA order if this stock lot was received through RMA.

rma_order_code

string

Number of RMA order if this stock lot was received through RMA.

quantity_min

string

Minimum initial quantity of stock lot.

quantity_max

string

Maximum initial quantity of stock lot.

available_min

string

Minimum quantity of stock items that are available for booking.

available_max

string

Maximum quantity of stock items that are available for booking.

booked_min

string

Minimum quantity of stock items that are booked.

booked_max

string

Maximum quantity of stock items that are booked.

item_cost_min

string

Minimum cost per one stock item.

item_cost_max

string

Maximum cost per one stock item.

total_cost_min

string

Minimum total cost of stock lot.

total_cost_max

string

Maximum total cost of stock lot.

created_min

integer

Minimum creation timestamp (Unix timestamp).

created_max

integer

Maximum creation timestamp (Unix timestamp).

available_from_min

integer

Minimum availability timestamp (Unix timestamp).

available_from_max

integer

Maximum availability timestamp (Unix timestamp).

expiry_min

integer

Minimum expiry date as Unix timestamp

expiry_max

integer

Maximum expiry date as Unix timestamp

Headers

Range

string

Pagination range (e.g., items=0-99, items=200-249)

Responses

429

Rate limited - another request is running

200List of lots

206Partial content

400Validation failed

401Authentication failed