Status while getting order details.
in Development
Hi,
I am trying to get information for purchase order made lightspeed POS. I can get the order information using this url.
this url.,
this Url is giving me allmost all information which I need, the only this which I could able to get was Status.
there is something called orderstatus in UI, which is not coming into API.
I am not sure if I am checking correct or not.
Thank you for advance help.
Tags:
5 comments
Hi @Dony,
Thank you for reaching out to us.
Where in the UI have you found this status? Can you send me some screenshots?
Out of curiostity I ran the following GET request:
https://api.merchantos.com/API/Account/{accountId}/Order/{orderId}.json?load_relations=all
And sure enough, I didn't see the order status in the API response.
{
"@attributes":{
"count":"1"
},
"Order":{
"orderID":"11",
"orderedDate":"2018-04-18T04:00:00+00:00",
"shipInstructions":"",
"stockInstructions":"",
"shipCost":"0",
"otherCost":"0",
"complete":"false",
"archived":"false",
"discount":"0",
"totalDiscount":"0",
"totalQuantity":"1",
"timeStamp":"2018-04-18T22:19:50+00:00",
"refNum":"",
"vendorID":"199",
"noteID":"379",
"shopID":"2",
"createdByEmployeeID":"0",
"Vendor":{
"vendorID":"199",
"name":"",
"archived":"true",
"accountNumber":"",
"integrationName":"",
"integrationLogin":"",
"integrationPassword":"",
"integrationAccount":"",
"integrationEnabled":"0",
"priceLevel":"",
"updatePrice":"false",
"updateCost":"false",
"updateDescription":"false",
"shareSellThrough":"false",
"timeStamp":"2018-05-25T15:33:30+00:00",
"contactID":"0",
"noteID":"0"
},
"Note":{
"noteID":"379",
"note":"",
"isPublic":"false",
"timeStamp":"2018-04-18T22:19:50+00:00"
},
"Shop":{
"shopID":"2",
"name":"Sawmill Boutique",
"serviceRate":"0",
"timeZone":"America\/New_York",
"taxLabor":"true",
"labelTitle":"No Title",
"labelMsrp":"false",
"archived":"false",
"timeStamp":"2018-07-13T17:26:53+00:00",
"companyRegistrationNumber":"",
"vatNumber":"",
"zebraBrowserPrint":"true",
"contactID":"3",
"taxCategoryID":"1",
"receiptSetupID":"2",
"vendorID":"0",
"ccGatewayID":"0",
"gatewayConfigID":"b46272dc-f14d-43f0-8f26-577febf8baa7",
"priceLevelID":"1"
},
"OrderLines":{
"OrderLine":{
"orderLineID":"13",
"quantity":"1",
"price":"0",
"originalPrice":"0",
"checkedIn":"0",
"numReceived":"0",
"timeStamp":"2018-04-18T22:20:44+00:00",
"total":"0",
"orderID":"11",
"itemID":"340"
}
}
}
}
Here are screen shots where it's plainly accessible in the UI.
Apparently this is a known gap in the Retail API, based on previous threads.
Thank you for help.
Hi guys,
You can only infer the status of a PO based on these fields:
"archived"
"checkedIn"
"numReceived"
"total"
For example, if checkedIn and numreceived is 0 and total has a value > 0 it's in Ordered status...is checkedIn has a value greater > O then the PO is in check in status. If numReceived = or < total it's fully received. There's also the field "complete". I'm assuming it means the PO is in finished status.
I hope this helps