Description

Returns the available stock quantity for all items. The quantity is calculated based on system configuration — taking bin-level stock, subtracting open order reservations where applicable, and applying location filters. Negative quantities are returned as zero.

Use ExcludeZeros = 1 to omit items with no available stock from the response.

Request Parameters

#	Name	Type	Required	Example	Description
1	ExcludeZeros	bit	0	0	0 or NULL (default) — returns all items including those with zero available quantity. 1 — excludes items with zero available quantity.

Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pipiGetStockForItems>
         <dem:ExcludeZeros>0</dem:ExcludeZeros>
      </dem:pipiGetStockForItems>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Item Stock Quantities

#	Name	Type	Description
1	ItemNrInt	varchar(50)	Item shop number.
2	AvailableQty	int	Available stock quantity for the item. Calculated based on system configuration — may reflect bin-level stock minus open orders or reservations. Never negative; minimum value is 0.

Additional Notes

AvailableQty is calculated based on system settings configured per pixi installation:
- The stock source (raw item quantity vs. bin-level aggregation)
- Which warehouse locations are included
- Whether open order lines and/or reservations are subtracted

Contact your pixi system administrator to confirm which calculation method is active for your installation.