Status while getting order details.

DonyDony Member Posts: 12

Hi,

I am trying to get information for purchase order made lightspeed POS. I can get the order information using this url.

this url.,

"https://api.lightspeedapp.com/API/Account/110109/Order.json?load_relations=["OrderLines","Note","Vendor","Shop"]"

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.

5 comments

  • LucienVersendaalLucienVersendaal Moderator, Lightspeed Staff Posts: 299 moderator
    edited June 29

    Hi @Dony,

    Thank you for reaching out to us.

    Where in the UI have you found this status? Can you send me some screenshots?

  • gregaricangregarican Member Posts: 469 
    edited June 29

    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.



  • gregaricangregarican Member Posts: 469 

    Apparently this is a known gap in the Retail API, based on previous threads.


  • DonyDony Member Posts: 12

    Thank you for help.

  • LucienVersendaalLucienVersendaal Moderator, Lightspeed Staff Posts: 299 moderator

    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

Sign In or Register to comment.