Description
Report with an overview of orders with billing address information, totals and gross profit. Gross Profit is calculated from standard supplier price at the time of order - not comparable with other reports in pixi!
Request Parameters
| # |
Name |
Type |
Required |
Example |
Description |
| 1 |
OrderDateFrom |
string |
0 |
YYYY-MM-DD hh:mm:ss |
Filter order from orderdate. |
| 2 |
OrderDateTo |
string |
0 |
YYYY-MM-DD hh:mm:ss |
Filter order until orderdate. |
| 3 |
OrderNrStart |
integer |
0 |
123 |
Start Orders with OrderNr X or higher |
| 4 |
RowCount |
integer |
0 |
123 |
Nr of Rows to return |
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:pixiReportOrderOverview>
<dem:OrderDateFrom>YYYY-MM-DD hh:mm:ss</dem:OrderDateFrom>
<dem:OrderDateTo>YYYY-MM-DD hh:mm:ss</dem:OrderDateTo>
<dem:OrderNrStart>123</dem:OrderNrStart>
<dem:RowCount>123</dem:RowCount>
</dem:pixiReportOrderOverview>
</soapenv:Body>
</soapenv:Envelope>
Response
Body 1: Report Order Overview
| # |
Name |
Type |
Description |
| 1 |
OrderNR |
integer |
Order number in pixi* |
| 2 |
Anrede |
string |
Anrede |
| 3 |
Name |
string |
Name |
| 4 |
CareOf |
string |
Care Of |
| 5 |
Address |
string |
Address |
| 6 |
City |
string |
City |
| 7 |
ZIP |
string |
ZIP |
| 8 |
Country |
string |
Country |
| 9 |
eMail |
string |
E-Mail address |
| 10 |
Shop_Note |
string |
Shop Note |
| 11 |
GiftMessage |
string |
Gift Message |
| 12 |
Address_Remarks |
string |
Address Remarks |
| 13 |
PaymentCode |
string |
Payment Code |
| 14 |
OrderStatus |
string |
Order Status |
| 15 |
OrderLinesTotal |
number |
Order Lines Total |
| 16 |
OrderLinesDiscount |
number |
Order Lines Discount |
| 17 |
ShipCost |
number |
The total shipping costs of the whole order |
| 18 |
Discount |
number |
Discount |
| 19 |
OrderTotal |
number |
Order Total |
| 20 |
GrossProfit_Netto |
number |
Gross Profit Netto |
| 21 |
OrderDate |
string |
Order Date |
| 22 |
ShopID |
string |
Shop ID |
| 23 |
CurrencyCode |
string |
Currency code |
Additional Notes