Description

Exports stock quantities for all items for use in external system synchronisation. Returns only items with a stock quantity greater than zero. Stock is calculated based on system configuration — taking bin-level stock and subtracting reservations or open orders where applicable.

Use the Location parameter to filter stock to a specific warehouse location. Pass ALL (default) to include all locations.

Request Parameters

#	Name	Type	Required	Example	Description
1	Location	varchar(3)	0	ALL	Location to include in the stock calculation. Use ALL (default) to include all locations, or provide a specific location ID to restrict results to that location.

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:pipiExportItemStock>
         <dem:Location>ALL</dem:Location>
      </dem:pipiExportItemStock>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Item Stock Export

#	Name	Type	Description
1	ItemNrSuppl	varchar(50)	Supplier item number.
2	EANUPC	varchar(13)	Item barcode (EAN/UPC).
3	ItemName	varchar(120)	Item name.
4	ItemNrInt	varchar(50)	Item shop number.
5	Stock	int	Available stock quantity. Always greater than 0 (items with zero stock are excluded).
6	Manufacturer	varchar(100)	Manufacturer name.
7	Price	decimal(10,2)	Selling price (including VAT).
8	SupplPrice	decimal(10,2)	Supplier purchase price.
9	Category	varchar(50)	Item category description.

Additional Notes

Only items with Stock > 0 are returned. Items with zero available stock are excluded from the response.

Stock is calculated based on system settings configured per pixi installation — the calculation may include or exclude reservations, specific locations, or open order deductions. Contact your pixi system administrator to confirm the active calculation method.