Description

Returns items whose stock was recalculated since a specified date and time. Use this call to synchronise stock levels incrementally by polling for items changed since the last successful sync.

Since is required. Results are paginated using Start and Rowcount — increment Start by Rowcount to retrieve subsequent pages.

Request Parameters

#	Name	Type	Required	Example	Description
1	Since	datetime	1	2024-01-01 00:00:00	Returns items with a stock recalculation date on or after this value.
2	Rowcount	int	0	1000	Maximum number of rows to return per call. Defaults to 1000.
3	Start	int	0	0	Row offset for pagination. Use 0 to start from the beginning. To get the next page, increment by Rowcount (e.g. Start = 0, then Start = 1000, then Start = 2000).

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:pipiGetChangedItemStockSince>
         <dem:Since>2024-01-01 00:00:00</dem:Since>
         <dem:Rowcount>1000</dem:Rowcount>
         <dem:Start>0</dem:Start>
      </dem:pipiGetChangedItemStockSince>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Items with Changed Stock

#	Name	Type	Description
1	RowNr	int	Row number in this result set. Used with Start parameter for pagination.
2	ItemKey	int	Item ID.
3	ItemNrInt	varchar(50)	Item shop number.
4	EANUPC	varchar(13)	Item barcode (EAN/UPC).
5	ItemNrSuppl	varchar(50)	Item supplier number.
6	PhysicalStock	int	Total physical stock quantity across all locations.
7	AvailableStock	int	Available stock quantity for export. Calculated based on system reservation and stock export settings — may differ from PhysicalStock when reservations are enabled.
8	EstimatedDelivery	datetime	Estimated delivery date for the item. NULL if no delivery is scheduled.
9	MinStockQty	int	Minimum stock quantity configured for the item.
10	Enabled	bit	Indicates whether the item is enabled (1 = enabled, 0 = disabled).
11	OpenSupplierOrderQTY	int	Always 0. This field is obsolete and retained for backwards compatibility.
12	UpdateDate	datetime	Date and time the stock was last recalculated for this item.
13	BundleItem	bit	Indicates whether the item is a bundle (1 = bundle, 0 = regular item).
14	OpenSupplOrdersQty	int	Total quantity on open supplier order lines (statuses NEW, BES, CON) minus already delivered and undelivered quantities. NULL if no open orders exist.

Additional Notes

Pagination using Start and Rowcount:
  Call 1: Start = 0,    Rowcount = 1000  → rows 1–1000
  Call 2: Start = 1000, Rowcount = 1000  → rows 1001–2000
  Continue until fewer rows than Rowcount are returned.

Important: results are ordered by stock recalculation date then item ID. If an item's stock is recalculated while you are paginating, it is moved to the end of the list and may appear in multiple pages. Account for duplicates when processing results.

AvailableStock reflects the quantity exported to connected channels and is influenced by system reservation settings. Use PhysicalStock for the raw warehouse quantity.