Description

API Call to get all information about an order

Request Parameters

#	Name	Type	Required	Example	Description
1	OrderNr	integer	0	123	pixi* order number (to retrieve a single order)
2	OrderNrXML	string	0	see aditional notes	XML of OrderNr and/or OrderNrExternal values
3	OrderNrExternal	string	0	Ext_1234	Order number external (to retrieve a single order)

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:pixiGetOrder>
         <dem:OrderNr>123</dem:OrderNr>
         <dem:OrderNrXML>see aditional notes</dem:OrderNrXML>
         <dem:OrderNrExternal>Ext_1234</dem:OrderNrExternal>
      </dem:pixiGetOrder>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Complette order information

#	Name	Type	Description
1	OrderNr	integer	Order number in pixi*
2	BillingAddress	string	Billing address details
3	ShippingAddress	string	Shipping address details
4	Customer	string	Customer details
5	OrderShippingVendor	string	Shipping vendo used for the order
6	GiftMessage	string	Gift Message
7	ShipInstruct	string	Transport remark
8	Discount	number	Order discount/voucher amount
9	CreateDate	string	Create date
10	CreateEmp	string	Creator of the recodr (pixi* user)
11	UpdateEmp	string	User who last updated the record
12	UpdateDate	string	Last update date of the record
13	CustRef	integer	ID of customer
14	AddrRef	integer	Billing address ID
15	ShipAdrRef	integer	Shipping address ID
16	OhSLocked	string	Order shipping lock flag
17	Address_Remarks	string	Address remark
18	Verfahren	string	Method
19	Product	string	Product
20	Extras	string	Tools
21	Shipdate	string	Ship this order at this date only! not before
22	Shop_Note	string	Shop note
23	ForceToPicklistIfNotFULL	boolean	Partial delivery is enabled
24	DFType	integer	Direct fullfilment type
25	OHMultiForceToPicklist	boolean	Ship remaining items after partial delivery shipout partially
26	OHCancelAfterForcedShipOut	boolean	Cancel not avaliable items after partial delivery shipout
27	SubShopLogo	string	Shop logo
28	SubShopName	string	Shop name
29	Referrer	string	Referrer
30	ChannelRef	integer	Shop channel ID
31	OrderNrExternal	string	External order number
32	OrderStatus	string	Order status
33	OrderLinesTotal	number	Sum of orderline totals
34	OrderLinesDiscount	number	Sum of orderline discounts
35	OrderTotal	number	Order total
36	Orderlines	string	Orderline details
37	BundleOrderlines	string	Bundleorderlines details
38	Invoices	string	Invoices details
39	CustomerAccount	string	Customer account details
40	OrderType	string	Order type (B2B, B2C)
41	OnPicklist	string	On picklist order status
42	ShipCost	number	Order ship costs
43	VoucherID	string	Voucher ID

Additional Notes

####**OrderNrXML** parameter sample:

	<OrderNrs>
		<OrderNr>137892</OrderNr>
		<OrderNrExternal>10003</OrderNrExternal>
	</OrderNrs>


----------

####**XML output samples**

**Billing address**:

	<row AddrKey="1109" AddrType="B">
		<AddrNr>C431</AddrNr>
		<CustomerNrExternal>sc....de</CustomerNrExternal>
		<ShopID>LEO</ShopID>
		<Name>Al..id</Name>
		<FirstName>A..er</FirstName>
		<LastName>S..d</LastName>
		<Address>S...tr. 2</Address>
		<Street>S...r.</Street>
		<HouseNr>2</HouseNr>
		<City>H...en</City>
		<ZIP>8..67</ZIP>
		<CountryCodePixi>D</CountryCodePixi>
		<CountryName>Deutschland</CountryName>
		<CountryNameEasylog>D</CountryNameEasylog>
		<CountryCodeISO2>DE</CountryCodeISO2>
		<CountryCodeISO3>DEU</CountryCodeISO3>
		<CountryCodeAfterbuy>D  </CountryCodeAfterbuy>
		<CountryCodePlenty>1</CountryCodePlenty>
		<eMail>s....net.de</eMail>
		<PaymentCode>B</PaymentCode>
		<NoChargeVAT>0</NoChargeVAT>
		<CreateDate>2011-07-18T10:02:59.910</CreateDate>
		<CreateEmp>LEO</CreateEmp>
		<Locked>N</Locked>
	</row>


**Shipping address**:

	<row AddrKey="1110" AddrType="S">
		<AddrNr>C431</AddrNr>
		<CustomerNrExternal>sc....de</CustomerNrExternal>
		<ShopID>LEO</ShopID>
		<Name>Ale... Sch...</Name>
		<FirstName>Ale...</FirstName>
		<LastName>Sch...</LastName>
		<Address>Sch... 2</Address>
		<Street>Sch...</Street>
		<HouseNr>2</HouseNr>
		<City>Hoh...</City>
		<ZIP>*83*</ZIP>
		<CountryCodePixi>D</CountryCodePixi>
		<CountryName>Deutschland</CountryName>
		<CountryNameEasylog>D</CountryNameEasylog>
		<CountryCodeISO2>DE</CountryCodeISO2>
		<CountryCodeISO3>DEU</CountryCodeISO3>
		<CountryCodeAfterbuy>D  </CountryCodeAfterbuy>
		<CountryCodePlenty>1</CountryCodePlenty>
		<eMail>sch..........@ma...ses.net</eMail>
		<PaymentCode />
		<NoChargeVAT>0</NoChargeVAT>
		<CreateDate>2011-07-18T10:02:59.917</CreateDate>
		<CreateEmp>LEO</CreateEmp>
		<Locked>N</Locked>
		<CardHolderName />
		<BankName />
	</row>


**Customer**:

	<row CustKey="431">
		<LastBillingAddressKey>1109</LastBillingAddressKey>
		<LastShippingAddressKey>1110</LastShippingAddressKey>
		<Locked>N</Locked>
		<PaymentCode>B</PaymentCode>
		<ShopID>LEO</ShopID>
		<CreateDate>2011-07-18T10:02:59.913</CreateDate>
		<CreateEmp>LEO</CreateEmp>
		<UpdateDate>2011-07-18T10:02:59.923</UpdateDate>
		<CustomerNrExternal>sc...de</CustomerNrExternal>
		<TaxOnInvoice>Y</TaxOnInvoice>
		<POSCustomer>N</POSCustomer>
		<ReminderAction>PRINT</ReminderAction>
		<DatevAccountNr>102414</DatevAccountNr>
	</row>


**Orderlines**:

	<row OrderlineKey="3202">
		<OrderlineKey>3202</OrderlineKey>
		<SupplInfo>Seit</SupplInfo>
		<ArtNr>4032844900334</ArtNr>
		<ArtName>Fix für Bolognese, Seitz</ArtName>
		<Qty>1</Qty>
		<Price>30.9900</Price>
		<SupplPrice>0.4400</SupplPrice>
		<Status>EIN</Status>
		<OrderCurrency>EUR</OrderCurrency>
		<OrderDate>2011-07-16T19:43:08</OrderDate>
		<CreateDate>2011-07-18T10:02:59.923</CreateDate>
		<CreateEmp>LEO</CreateEmp>
		<UpdateDate>2017-11-06T09:52:13.420</UpdateDate>
		<UpdateEmp>p...v</UpdateEmp>
		<ItemRef>568</ItemRef>
		<Price_OrderCurr>30.9900</Price_OrderCurr>
		<ShipCost>3.9900</ShipCost>
		<ShipCost_OrderCurr>3.9900</ShipCost_OrderCurr>
		<LocationID>001</LocationID>
		<DiscountValue>0.0000</DiscountValue>
		<DiscountPerc>0.00</DiscountPerc>
		<FullPrice>30.9900</FullPrice>
		<DF_type>0</DF_type>
		<VATPercent>0.0700</VATPercent>
		<ItemNrInt>TA90_666111</ItemNrInt>
	</row>
	<row OrderlineKey="5650">
		<OrderlineKey>5650</OrderlineKey>
		<BundleOrderlineRef>390</BundleOrderlineRef>
		<SupplInfo>MGS</SupplInfo>
		<ArtNr>4027013172315</ArtNr>
		<ArtName>Riedenburger Bier glutenfrei, Riedenburger</ArtName>
		<Qty>1</Qty>
		<Price>1.6598</Price>
		<SupplPrice>0.8400</SupplPrice>
		<Status>EIN</Status>
		<OrderCurrency>EUR</OrderCurrency>
		<OrderDate>2017-11-06T09:52:09</OrderDate>
		<CreateDate>2017-11-06T09:52:09</CreateDate>
		<CreateEmp>pgodnov</CreateEmp>
		<UpdateDate>2017-11-06T09:52:13.420</UpdateDate>
		<UpdateEmp>p....v</UpdateEmp>
		<ItemRef>414</ItemRef>
		<Price_OrderCurr>1.6598</Price_OrderCurr>
		<ShipCost>3.9900</ShipCost>
		<ShipCost_OrderCurr>3.9900</ShipCost_OrderCurr>
		<LineItemIDShop>N</LineItemIDShop>
		<LocationID>001</LocationID>
		<DiscountValue>0.0000</DiscountValue>
		<DiscountPerc>0.00</DiscountPerc>
		<FullPrice>1.6598</FullPrice>
		<VATPercent>0.0700</VATPercent>
		<ItemNrInt>TA90_666111</ItemNrInt>
	</row>


**BundleOrderlines**:

	<row BundleOrderlineKey="390">
		<BundleOrderlineKey>390</BundleOrderlineKey>
		<OriginalOrderlineKey>1</OriginalOrderlineKey>
		<SupplInfo>MGS</SupplInfo>
		<ArtNr>2000060000000</ArtNr>
		<ArtName>Bier Testpaket</ArtName>
		<Qty>1</Qty>
		<Price>5.9900</Price>
		<SupplPrice>3.6800</SupplPrice>
		<Status>ANG</Status>
		<OrderCurrency>EUR</OrderCurrency>
		<OrderDate>2017-11-06T09:52:09</OrderDate>
		<CreateDate>2017-11-06T09:52:09</CreateDate>
		<CreateEmp>p....v</CreateEmp>
		<UpdateDate>2017-11-06T09:52:09</UpdateDate>
		<UpdateEmp>p....v</UpdateEmp>
		<ItemRef>928</ItemRef>
		<Price_OrderCurr>5.9900</Price_OrderCurr>
		<ShipCost>3.9900</ShipCost>
		<ShipCost_OrderCurr>3.9900</ShipCost_OrderCurr>
		<LineItemIDShop>N</LineItemIDShop>
		<LocationID>001</LocationID>
		<DiscountValue>0.0000</DiscountValue>
		<DiscountPerc>0.00</DiscountPerc>
		<FullPrice>5.9900</FullPrice>
		<VATPercent>0.0700</VATPercent>
		<ItemNrInt>TA90_666111</ItemNrInt>
	</row>


**Invoices**:

	<row>
		<InvoiceNr>LEO0000014</InvoiceNr>
		<InvoiceKey>541</InvoiceKey>
		<InvDate>2017-11-06T09:52:01.463</InvDate>
		<VATBaseHigh>5.5981</VATBaseHigh>
		<VATBaseLow>30.2341</VATBaseLow>
		<Total>40.9700</Total>
		<PaymentCode>B</PaymentCode>
		<PaidDate>2017-11-06T09:52:01.463</PaidDate>
		<PaidAmount>0.0000</PaidAmount>
		<CreateDate>2017-11-06T09:52:12.040</CreateDate>
		<CreateEmp>p....v</CreateEmp>
		<Total_OrderCurr>40.9700</Total_OrderCurr>
		<Total_ShipCost>3.9900</Total_ShipCost>
		<Total_ShipCost_OrderCurr>3.9900</Total_ShipCost_OrderCurr>
		<OrderCurrency>EUR</OrderCurrency>
		<VATBaseHigh_OrderCurr>5.5981</VATBaseHigh_OrderCurr>
		<VATBaseLow_OrderCurr>30.2341</VATBaseLow_OrderCurr>
		<VATBaseHigh_ShipCost>0.6039</VATBaseHigh_ShipCost>
		<VATBaseLow_ShipCost>3.2813</VATBaseLow_ShipCost>
		<VATBaseHigh_ShipCost_OrderCurr>0.6039</VATBaseHigh_ShipCost_OrderCurr>
		<VATBaseLow_ShipCost_OrderCurr>3.2813</VATBaseLow_ShipCost_OrderCurr>
		<VATHigh>0.3919</VATHigh>
		<VATHighPerc>7.0000</VATHighPerc>
		<VATLow>0.7559</VATLow>
		<VATLowPerc>1.9000</VATLowPerc>
		<VATHText>7.00</VATHText>
		<VATLText>1.90</VATLText>
		<AddrRef>1109</AddrRef>
		<ShipAdrRef>1110</ShipAdrRef>
		<InvLocationID>001</InvLocationID>
		<PackageGrossWeight>1.360000000000000e+000</PackageGrossWeight>
		<Locked>N</Locked>
		<VoucherSum_OrderCurr>0.0000</VoucherSum_OrderCurr>
		<VATinShipCost>Y</VATinShipCost>
		<DueDate>2017-11-20T09:52:01.463</DueDate>
		<Is1SS>0</Is1SS>
		<InvoiceLines>
			<row InvoiceLineKey="2605">
				<InvoiceLineKey>2605</InvoiceLineKey>
				<OrderLineRef>5652</OrderLineRef>
				<ItemNr>4012852001698</ItemNr>
				<ItemQty>1</ItemQty>
				<OrderQty>1</OrderQty>
				<ItemText>Lammsbräu Glutenfrei, Neumarkter Lammsbräu</ItemText>
				<ItemPrice>1.1034</ItemPrice>
				<ItemPrice_OrderCurr>1.1034</ItemPrice_OrderCurr>
				<ItemDiscount>0</ItemDiscount>
				<ItemVAT>H</ItemVAT>
				<CreateDate>2017-11-06T09:52:12.700</CreateDate>
				<CreateEmp>E...19</CreateEmp>
				<ShipCost>3.9900</ShipCost>
				<ShipCost_OrderCurr>3.9900</ShipCost_OrderCurr>
				<ItemRef>927</ItemRef>
				<FullPrice>1.1034</FullPrice>
				<DiscountValue>0.0000</DiscountValue>
				<DiscountPerc>0.00</DiscountPerc>
			</row>
			<row InvoiceLineKey="2606">
				<InvoiceLineKey>2606</InvoiceLineKey>
				<OrderLineRef>5653</OrderLineRef>
				<ItemNr>4260108510085</ItemNr>
				<ItemQty>1</ItemQty>
				<OrderQty>1</OrderQty>
				<ItemText>Schnitzer Bräu Hirse Lemon, Schnitzer Bräu</ItemText>
				<ItemPrice>1.5670</ItemPrice>
				<ItemPrice_OrderCurr>1.5670</ItemPrice_OrderCurr>
				<ItemDiscount>0</ItemDiscount>
				<ItemVAT>H</ItemVAT>
				<CreateDate>2017-11-06T09:52:12.700</CreateDate>
				<CreateEmp>E....19</CreateEmp>
				<ShipCost>3.9900</ShipCost>
				<ShipCost_OrderCurr>3.9900</ShipCost_OrderCurr>
				<ItemRef>469</ItemRef>
				<FullPrice>1.5670</FullPrice>
				<DiscountValue>0.0000</DiscountValue>
				<DiscountPerc>0.00</DiscountPerc>
			</row>
		</InvoiceLines>
	</row>


**Customer account**:

	<row>
		<CustomerAccountKey>848</CustomerAccountKey>
		<EventID>INV</EventID>
		<EventDate>2017-11-06T09:52:01.463</EventDate>
		<Reference>138288</Reference>
		<InvoiceRef>541</InvoiceRef>
		<Amount>-40.9700</Amount>
		<Matched>0.0000</Matched>
		<DoNotRefund>0</DoNotRefund>
		<CreateEmp>p....v</CreateEmp>
		<CreateDate>2017-11-06T09:52:13.997</CreateDate>
		<UpdateEmp>p....v</UpdateEmp>
		<UpdateDate>2017-11-06T09:52:13.997</UpdateDate>
	</row>