pixiReportStockRange

Report items with long stock ranges...

Since pixi version: LOU Official - Update 46 (6.9.46.27927) Additional notes:

KPIs Reports Statistics

Request

POST https://apigateway.descartes.com/tms/pixi/pixiReportStockRange

Request body

Name	Type	Required	Description
SupplNr	string	false	Only one specific supplier Type: varchar(4) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927)
PriceMax	number	false	Maximum Price Type: money Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927)
PriceMin	number	false	Minimum Price Type: money Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927)
RowCount	integer	false	RowCount Type: int Default value: 100 Example: Available from: LOU Official - Update 46 (6.9.46.27927)
StartRow	integer	false	StartRow Type: int Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927)
StockMin	integer	false	Only show items with minimal stock of ... Type: int Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927)
DeductReturns	boolean	false	Deduct Returns Type: bit Default value: 0 Example: Available from: AVA 17.03 (8.4.27.29272)
MinStockRange	integer	false	Minimum stock range in days. Default = 100 Type: int Default value: 100 Example: Available from: LOU Official - Update 46 (6.9.46.27927)
SalesDaysBack	integer	false	Count sales for X days back from today on. Default: 360 Type: int Default value: 360 Example: Available from: LOU Official - Update 46 (6.9.46.27927)
LastStockIncDays	integer	false	Last time, stock was added for this item. Doesnt show items that where added recently, because there was maybe not enough time yet to sell them Type: int Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927)
ExcludeInhouseEAN	boolean	false	Exclude "non real" inhouse EANS starting with 2... Type: bit Default value: 0 Example: Available from: LOU Official - Update 46 (6.9.46.27927)

Request Example

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
  <Body xmlns="">
    <pixiReportStockRange>
      <RowCount>0</RowCount>
      <StartRow>0</StartRow>
      <MinStockRange>0</MinStockRange>
      <SalesDaysBack>0</SalesDaysBack>
      <LastStockIncDays>0</LastStockIncDays>
      <StockMin>0</StockMin>
      <PriceMin>0</PriceMin>
      <PriceMax>0</PriceMax>
      <SupplNr>string</SupplNr>
      <ExcludeInhouseEAN>true</ExcludeInhouseEAN>
      <DeductReturns>true</DeductReturns>
    </pixiReportStockRange>
  </Body>
</Envelope>

Response

1. Result set

Name	Type	Description
Row	string	Row Type: bigint Available from: / (25.7.0.59144)
Price	number	Price Type: money Available from: / (25.7.0.59144)
Sales	integer	Sold items in gives range of days (sold = invoiced, returned included) Type: int Available from: / (25.7.0.59144)
Stock	integer	Stock on given location Type: int Available from: / (25.7.0.59144)
EANUPC	string	EANUPC Type: varchar Available from: / (25.7.0.59144)
ItemKey	integer	ItemKey Type: int Available from: / (25.7.0.59144)
ItemName	string	ItemName Type: varchar Available from: / (25.7.0.59144)
ItemNrInt	string	ItemNrInt Type: varchar Available from: / (25.7.0.59144)
StockRange	number	StockRange Type: numeric Available from: / (25.7.0.59144)
SupplPrice	number	SupplPrice Type: money Available from: / (25.7.0.59144)
ItemNrSuppl	string	ItemNrSuppl Type: varchar Available from: / (25.7.0.59144)
SalesPerDay	number	SalesPerDay Type: numeric Available from: / (25.7.0.59144)
LastStockInc	integer	Last time put to stock in Days Type: int Available from: / (25.7.0.59144)

Response Example

<PixiReportStockRangePost200TextXmlResponse>
  <Row>string</Row>
  <ItemKey>0</ItemKey>
  <ItemName>string</ItemName>
  <Price>0</Price>
  <SupplPrice>0</SupplPrice>
  <EANUPC>string</EANUPC>
  <ItemNrSuppl>string</ItemNrSuppl>
  <ItemNrInt>string</ItemNrInt>
  <Stock>0</Stock>
  <Sales>0</Sales>
  <SalesPerDay>0</SalesPerDay>
  <LastStockInc>0</LastStockInc>
  <StockRange>0</StockRange>
</PixiReportStockRangePost200TextXmlResponse>

HTTP Example

POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
# echo -n '{{username}}:{{password}}' | base64 | pbcopy
Authorization: Basic {{token}}

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
                   xmlns:ns1="https://apigateway.descartes.com/tms/pixi/"
                   xmlns:xsd="http://www.w3.org/2001/XMLSchema"
                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <SOAP-ENV:Body>
        <ns1:pixiReportStockRange>
            <SupplNr xsi:type="xsd:string"></SupplNr>
            <PriceMax xsi:type="xsd:number"></PriceMax>
            <PriceMin xsi:type="xsd:number"></PriceMin>
            <RowCount xsi:type="xsd:integer"></RowCount>
            <StartRow xsi:type="xsd:integer"></StartRow>
            <StockMin xsi:type="xsd:integer"></StockMin>
            <DeductReturns xsi:type="xsd:boolean"></DeductReturns>
            <MinStockRange xsi:type="xsd:integer"></MinStockRange>
            <SalesDaysBack xsi:type="xsd:integer"></SalesDaysBack>
            <LastStockIncDays xsi:type="xsd:integer"></LastStockIncDays>
            <ExcludeInhouseEAN xsi:type="xsd:boolean"></ExcludeInhouseEAN>
        </ns1:pixiReportStockRange>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

PHP Example

<?php

getPixiSoapClientResponse('pixiReportStockRange', [
    'SupplNr' => '', // string
    'PriceMax' => '', // number
    'PriceMin' => '', // number
    'RowCount' => '', // integer
    'StartRow' => '', // integer
    'StockMin' => '', // integer
    'DeductReturns' => '', // boolean
    'MinStockRange' => '', // integer
    'SalesDaysBack' => '', // integer
    'LastStockIncDays' => '', // integer
    'ExcludeInhouseEAN' => '', // boolean
]);

function getPixiSoapClientResponse(string $method, array $arguments = [])
{
    $soapArguments = [];
    foreach ($arguments as $key => $value) {
        $soapArguments[] = new SoapVar($value, null, '', '', $key);
    }

    $soapClient = new SoapClient(null, [
        'login' => '...',
        'password' => '...',
        'uri' => 'https://apigateway.descartes.com/tms/pixi/',
        'location' => 'https://apigateway.descartes.com/tms/pixi/',
    ]);

    return $soapClient->__call($method, $soapArguments);
}

Unofficial Pixi-API-Documentation

by koempf24.de