Description

Returns sales statistics for a single item, including sales quantities across three time periods and open order quantities. Identify the item using EANUPC or ItemNrInt — at least one must be provided. If both match different items, the item with the lowest item ID is used.

Request Parameters

#	Name	Type	Required	Example	Description
1	EANUPC	varchar(13)	0	2000000000091	Item barcode (EAN/UPC). At least one identification parameter must be provided.
2	ItemNrInt	varchar(50)	0	54e46dd1dc2c30a39.01766786	Item shop number. At least one identification parameter must be provided.

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:pipiGetItemSalesStats>
         <dem:EANUPC>2000000000091</dem:EANUPC>
         <dem:ItemNrInt></dem:ItemNrInt>
      </dem:pipiGetItemSalesStats>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Sales Statistics for Selected Item

#	Name	Type	Description
1	Open1SS	int	Number of open single-item orders containing this item in ANG status. These orders can potentially be shipped with a single barcode scan.
2	ABC	char	ABC classification tag assigned to the item by the system.
3	Sales30	int	Total quantity sold in the last 30 days.
4	Sales120	int	Total quantity sold in the last 120 days (includes the last 30 days).
5	Sales365	int	Total quantity sold in the last 365 days (includes the last 120 days).
6	OrderQtyANG	int	Total item quantity on open orders in ANG status placed within the last 365 days.
7	OrderQtyHAL	int	Total item quantity on open orders in HAL status placed within the last 365 days.

Additional Notes

Sales figures (Sales30, Sales120, Sales365) are cumulative — Sales120 includes the Sales30 period, and Sales365 includes both.

Cancelled (STO) and undeliverable (NLB) orderlines are excluded from all sales calculations.

OrderQtyANG and OrderQtyHAL reflect open, unfulfilled order quantities — they are not completed sales.

If neither EANUPC nor ItemNrInt matches an existing item, all result fields return NULL.