# Vendor\_id and product\_id in purchase\_orders query results

**URL:** <https://community.shiphero.com/t/vendor-id-and-product-id-in-purchase-orders-query-results/1295>\
**Category:** GraphQL API\
**Created:** [April 28, 2021, 3:38pm UTC](https://community.shiphero.com/t/vendor-id-and-product-id-in-purchase-orders-query-results/1295 "2021-04-28T15:38:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bbarrett](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bbarrett](https://community.shiphero.com/u/bbarrett)\
**Post date:** [April 28, 2021, 3:38pm UTC](https://community.shiphero.com/t/vendor-id-and-product-id-in-purchase-orders-query-results/1295/1 "2021-04-28T15:38:25Z")

</div>

I am running this query:  
{purchase\_orders(created\_from:“2021-03-01”) {request\_id complexity data(sort:“created\_at” first:1 ){pageInfo{hasNextPage endCursor} edges{node{id po\_number created\_at date\_closed po\_date arrived\_at packing\_note fulfillment\_status po\_note partner\_order\_number shipping\_method tracking\_number line\_items(first:10 ){pageInfo{hasNextPage,endCursor} edges{node {product\_id id vendor\_id price quantity quantity\_received quantity\_rejected fulfillment\_status sku vendor\_sku product\_name note created\_at updated\_at}}}}}}}}

Here is a snapshot of the results:  
“node”: {  
“product\_id”: “349991821”,  
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjkxOTczMDE=”,  
“vendor\_id”: “387908”,  
“price”: “141.00”,  
“quantity”: 3,  
“quantity\_received”: 0,  
“quantity\_rejected”: 0,  
“fulfillment\_status”: “pending”,  
“sku”: “SMCBCK NATU 8”,  
“vendor\_sku”: “”,  
“product\_name”: “Oak Street Chromepak Slip Moc Natural / 8”,  
“note”: “”,  
“created\_at”: “2021-03-04T13:56:44”,  
“updated\_at”: null  
}

Why are the “prioduct\_id” and “vendor\_id” returned as integers? They used to be returned as strings like: UHJvZHVjdDozMTYyNjg3MjM=

When did this change? Is this a bug?

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [May 8, 2021, 2:57pm UTC](https://community.shiphero.com/t/vendor-id-and-product-id-in-purchase-orders-query-results/1295/3 "2021-05-08T14:57:12Z")

</div>

Hi @bbarrett !  
Our apologies for that! we made a change that might have impacted this.  
We are currently working on getting it to be a UUID again

At the moment is an INT, which is the Base64 decoded version of the UUID you saw before  
We will let you know once this is fixed.  
Thanks for the patience and we apologize for the inconvenience!  
Tom

---

<div class="post-metadata">

**Author:** ![tomasw](https://sea2.discourse-cdn.com/flex020/user_avatar/community.shiphero.com/tomasw/32/248_2.png) [@tomasw](https://community.shiphero.com/u/tomasw)\
**Post date:** [June 29, 2021, 11:53pm UTC](https://community.shiphero.com/t/vendor-id-and-product-id-in-purchase-orders-query-results/1295/4 "2021-06-29T23:53:58Z")

</div>

Hi @bbarrett!  
ID should be back to UUID by now.  
Thanks again for the patience while we reverted this!  
Tom