n11.com api usage – Get orders

Posted by Abdullah in Marketplace Integration On August 20, 2020

In this article, I would like to show you how we can easily access order informations in n11.com api with using php code.

First of all, we need to n11 api key and password.

Getting your api key and password pair is easy enough.
Goto the n11 seller office home page and login to your account. For the purposes of this tutorial, we assume you are already an approved n11 seller. https://so.n11.com/

Click on the “Hesabım->API Hesapları” link at the top of the page. https://so.n11.com/selleroffice/integration/apiAccounts
Then click the button to “+ Yeni Hesap Oluştur”
Then your api key and password will be sent by e-mail.

For get orders our endpoint url : https://api.n11.com/ws/OrderService.wsdl

We can use to list orders in this service these methods

OrderListRequest
DetailedOrderListRequest

Sample OrderListRequest response:

<result>
	<status>success</status>
</result>
<pagingData>
	<currentPage>0</currentPage>
	<pageSize>100</pageSize>
	<totalCount>2</totalCount>
	<pageCount>1</pageCount>
</pagingData>
<orderList>
	<order>
		<citizenshipId>35314149022</citizenshipId>
		<createDate>20/08/2020 10:44</createDate>
		<id>247253473</id>
		<orderNumber>123456789</orderNumber>
		<paymentType>1</paymentType>
		<status>2</status>
	</order>
	<order>
		<citizenshipId>10495173202</citizenshipId>
		<createDate>20/08/2020 13:45</createDate>
		<id>247271092</id>
		<orderNumber>546546412</orderNumber>
		<paymentType>1</paymentType>
		<status>2</status>
	</order>
</orderList>

Sample DetailedOrderListRequest response:

<result>
	<status>success</status>
</result>
<pagingData>
	<currentPage>0</currentPage>
	<pageSize>100</pageSize>
	<totalCount>2</totalCount>
	<pageCount>1</pageCount>
</pagingData>
<orderList>
	<order>
		<citizenshipId>35314149022</citizenshipId>
		<createDate>20/08/2020 10:44</createDate>
		<id>247253473</id>
		<orderItemList>
			<orderItem>
				<approvedDate>20/08/2020</approvedDate>
				<attributes/>
				<commission>164.9</commission>
				<customTextOptionValues/>
				<deliveryFeeType>5</deliveryFeeType>
				<dueAmount>1649</dueAmount>
				<id>237034963</id>
				<installmentChargeWithVAT>0</installmentChargeWithVAT>
				<mallDiscount>0</mallDiscount>
				<price>1245</price>
				<productId>123456</productId>
				<productName>Urun Adi</productName>
				<productSellerCode>Urun Kodu</productSellerCode>
				<quantity>1</quantity>
				<sellerCouponDiscount>0</sellerCouponDiscount>
				<sellerDiscount>612</sellerDiscount>
				<sellerInvoiceAmount>1649</sellerInvoiceAmount>
				<shipmenCompanyCampaignNumber>1212121212122</shipmenCompanyCampaignNumber>
				<shipmentInfo>
					<campaignNumber>1212121212122</campaignNumber>
					<campaignNumberStatus>2</campaignNumberStatus>
					<shipmentCode>12312123</shipmentCode>
					<shipmentCompany>
						<id>345</id>
						<name>Aras</name>
						<shortName>ARAS</shortName>
					</shipmentCompany>
					<shipmentMethod>1</shipmentMethod>
				</shipmentInfo>
				<shippingDate></shippingDate>
				<sppApproved>true</sppApproved>
				<status>5</status>
				<totalMallDiscountPrice>0</totalMallDiscountPrice>
				<updatedDate>20/08/2020 11:09</updatedDate>
				<version>102</version>
			</orderItem>
		</orderItemList>
		<orderNumber>123456789</orderNumber>
		<paymentType>1</paymentType>
		<status>2</status>
		<totalAmount>1649</totalAmount>
		<totalDiscountAmount>612</totalDiscountAmount>
	</order>
	<order>
		<citizenshipId>10495173202</citizenshipId>
		<createDate>20/08/2020 13:45</createDate>
		<id>247271092</id>
		<orderItemList>
			<orderItem>
				<approvedDate>20/08/2020</approvedDate>
				<attributes/>
				<commission>197.2</commission>
				<customTextOptionValues/>
				<deliveryFeeType>3</deliveryFeeType>
				<dueAmount>1972</dueAmount>
				<id>465623</id>
				<installmentChargeWithVAT>0</installmentChargeWithVAT>
				<mallDiscount>0</mallDiscount>
				<price>2963</price>
				<productId>23465</productId>
				<productName>Urun Adi 2</productName>
				<productSellerCode>12354</productSellerCode>
				<quantity>1</quantity>
				<sellerCouponDiscount>0</sellerCouponDiscount>
				<sellerDiscount>991</sellerDiscount>
				<sellerInvoiceAmount>1972</sellerInvoiceAmount>
				<shipmenCompanyCampaignNumber>23132132123132</shipmenCompanyCampaignNumber>
				<shipmentInfo>
					<campaignNumber>23132132123132</campaignNumber>
					<campaignNumberStatus>2</campaignNumberStatus>
					<shipmentCode>12313246</shipmentCode>
					<shipmentCompany>
						<id>345</id>
						<name>Aras</name>
						<shortName>ARAS</shortName>
					</shipmentCompany>
					<shipmentMethod>1</shipmentMethod>
				</shipmentInfo>
				<shippingDate></shippingDate>
				<sppApproved>true</sppApproved>
				<status>5</status>
				<totalMallDiscountPrice>0</totalMallDiscountPrice>
				<updatedDate>20/08/2020 13:51</updatedDate>
				<version>67</version>
			</orderItem>
		</orderItemList>
		<orderNumber>546546412</orderNumber>
		<paymentType>1</paymentType>
		<status>2</status>
		<totalAmount>1972</totalAmount>
		<totalDiscountAmount>991</totalDiscountAmount>
	</order>
</orderList>

Benim işime daha detaylı sonuç veren DetailedOrderListRequest isteğini kullanmak geliyor. Satılan ürünü görebiliyorum vs. Fakat bu detaylı istekte zaman sınırı bulunuyor. İki DetailedOrderListRequest isteği arasında 5 saniye beklemek gerekiyor.

Zaman sınırından bize ne demiyoruz. Çünkü tek sorgu ile işi çözemiyoruz. Şöyle açıklayalım. Bu isteği yaparken gönderdiğimiz parametrelerden biri sipariş durumu(status). Bu durumlar da şunlar oluyor:

“New”: Yeni siparişler
“Approved”: Onaylanmış Siparişler
“Rejected”: İptal Edilmiş Siparişler
“Shipped”: Kargolanmış Siparişler
“Delivered”: Teslim Edilen Siparişler
“Completed”: Tamamlanmış Siparişler
“Claimed”: İptal/İade/Değişim Durumundaki Siparişler
“LATE_SHIPMENT” Kargolanması Geciken Siparişler

Normal akış düzeninde (müşterilerin sipariş verip bizim bunları onaylayıp hazırlayıp kargoya verdiğimiz düzen) bizim görmemiz gereken aktif siparişler New(Yeni Siparişler), Approved(Onaylanmış Siparişler) ve LATE_SHIPMENT(Kargolanması Geciken Siparişler). Bu 3 durumdaki siparişleri tek sorgu ile çekemiyoruz. -Yada ben fark edemedim.- Bu 3 durumdaki aktif olan siparişlerin hepsini çekmek için sıra ile 3 sorgu çalıştırmamız gerekiyor.

Ben burada zaman sınırına en az takılmak için yeni ve geciken siparişleri OrderListRequest ile onaylanmış siparişleri DetailedOrderListRequest ile çekiyorum. Yeni ve geciken sipariş sorgularından gelen cevaplarda sipariş adedini gösteren totalCount alandaki değeri kontrol ediyorum. 0‘sa 3 sorgu 1 saniye içerisinde tamamlanmış oluyor. totalCount alanları 0 değilse 6 saniye arayla bekleyip 0 olmayan yeni yada geciken siparişleri DetailedOrderListRequest ile çekiyorum.

Nasıl çekiyorum derseniz. Multi_curl kullandığım php kodum şu şekilde.

$app_key = "fd79f0ba-5ead-49c9-b058-2dea4287797b";
$app_secret = "ypwgJwJ4nVaO0Qe2";
$ct = array();
////////////////////////////////////////////////////
$status = "New";
$post = "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/' xmlns:sch='http://www.n11.com/ws/schemas'>
	<soapenv:Header/>
	<soapenv:Body>
		<sch:OrderListRequest>
			<auth>
				<appKey>$app_key</appKey>
				<appSecret>$app_secret</appSecret>
			</auth>
			<searchData>
				<status>$status</status>
			</searchData>
		</sch:OrderListRequest>
	</soapenv:Body>
</soapenv:Envelope>";
$ct[0] = curl_init();
curl_setopt($ct[0], CURLOPT_URL,"https://api.n11.com/ws/OrderService.wsdl");
curl_setopt($ct[0], CURLOPT_POST, 1);
curl_setopt($ct[0], CURLOPT_TIMEOUT, 10);
curl_setopt($ct[0], CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ct[0], CURLOPT_POSTFIELDS, $post);
curl_setopt($ct[0], CURLOPT_HTTPHEADER, array("Content-Type: text/xml; charset=utf-8"));
curl_setopt($ct[0], CURLOPT_RETURNTRANSFER, true);
////////////////////////////////////////////////////
$status = "LATE_SHIPMENT";
$post = "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/' xmlns:sch='http://www.n11.com/ws/schemas'>
	<soapenv:Header/>
	<soapenv:Body>
		<sch:OrderListRequest>
			<auth>
				<appKey>$app_key</appKey>
				<appSecret>$app_secret</appSecret>
			</auth>
			<searchData>
				<status>$status</status>
			</searchData>
		</sch:OrderListRequest>
	</soapenv:Body>
</soapenv:Envelope>";
$ct[1] = curl_init();
curl_setopt($ct[1], CURLOPT_URL,"https://api.n11.com/ws/OrderService.wsdl");
curl_setopt($ct[1], CURLOPT_POST, 1);
curl_setopt($ct[1], CURLOPT_TIMEOUT, 10);
curl_setopt($ct[1], CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ct[1], CURLOPT_POSTFIELDS, $post);
curl_setopt($ct[1], CURLOPT_HTTPHEADER, array("Content-Type: text/xml; charset=utf-8"));
curl_setopt($ct[1], CURLOPT_RETURNTRANSFER, true);
////////////////////////////////////////////////////
$status = "Approved";
$post = "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/' xmlns:sch='http://www.n11.com/ws/schemas'>
	<soapenv:Header/>
	<soapenv:Body>
		<sch:DetailedOrderListRequest>
			<auth>
				<appKey>$app_key</appKey>
				<appSecret>$app_secret</appSecret>
			</auth>
			<searchData>
				<status>$status</status>
			</searchData>
		</sch:DetailedOrderListRequest>
	</soapenv:Body>
</soapenv:Envelope>";
$ct[2] = curl_init();
curl_setopt($ct[2], CURLOPT_URL,"https://api.n11.com/ws/OrderService.wsdl");
curl_setopt($ct[2], CURLOPT_POST, 1);
curl_setopt($ct[2], CURLOPT_TIMEOUT, 10);
curl_setopt($ct[2], CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ct[2], CURLOPT_POSTFIELDS, $post);
curl_setopt($ct[2], CURLOPT_HTTPHEADER, array("Content-Type: text/xml; charset=utf-8"));
curl_setopt($ct[2], CURLOPT_RETURNTRANSFER, true);
////////////////////////////////////////////////////
$cct = curl_multi_init();
for ($j=0;$j<count($ct);$j++) {
	curl_multi_add_handle($cct,$ct[$j]);
}
$running=null;
do { curl_multi_exec($cct,$running);
} while ($running > 0);

$new_veri = xml_to_array(curl_multi_getcontent($ct[0]));
$late_veri = xml_to_array(curl_multi_getcontent($ct[1]));
$appr_veri = xml_to_array(curl_multi_getcontent($ct[2]));

Ben bu gelen verileri nedense okuyamıyorum. Bunları diziye çevirmek için şöyle bir fonksiyonum var. Son satırlarda bunu kullandım.

function xml_to_array($veri) {
	$xml = simplexml_load_string($veri);
	foreach($xml->xpath('//env:Body') as $path) {
		$orderList = $path->xpath('//orderList');
		$pagingData = $path->xpath('//pagingData');
		return array($pagingData[0],$orderList[0]);
	}
}

Kodu çalıştırıp bu dizilerin birinin print_r halini de buraya koyarsak yazı tamamdır.

Buradan istediğiniz dataya erişin kullanın kopyalayın. Örneğin;

Sipariş adedi için $appr_veri[0]->totalCount;
Tek tek siparişleri işlemek for döngüsü

foreach ($appr_veri[1]->order as $satis) {
	echo $satis->id;
}

BLOG

n11.com api usage – Get orders

About Author

Abdullah

Leave a Reply Cancel reply