Problem getting vendor on purchase order

Please look at request_id: 6218e5a2eb93af10c10dcd80

Why is it returning 0 for the “vendor_id”. The PO and items in the shiphero web app are displayed with a vendor (Polo Ralph Lauren). But I cannot get this value “Polo Ralph Lauren” for the PO nor the PO LineItems. How do I get the vendor assigned on this PO? It is currently “Polo Ralph Lauren” but it is not returned anywhere in the API.

Query:

{purchase_order(po_number:“100031972” ){request_id complexity data{id vendor_id vendor{name} legacy_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{name} vendor_id price quantity quantity_received quantity_rejected fulfillment_status sku vendor_sku product_name note created_at updated_at}}}}}}

Result:

{
“data”: {
“purchase_order”: {
“request_id”: “6218e5a2eb93af10c10dcd80”,
“complexity”: 11,
“data”: {
“id”: “UHVyY2hhc2VPcmRlcjo5NTc0NTQ=”,
“vendor_id”: “0”,
“vendor”: null,
“legacy_id”: 957454,
“po_number”: “100031972”,
“created_at”: “2022-01-28T21:53:30”,
“date_closed”: null,
“po_date”: “2022-02-20T00:00:00”,
“arrived_at”: null,
“packing_note”: null,
“fulfillment_status”: “Pending”,
“po_note”: “”,
“partner_order_number”: null,
“shipping_method”: null,
“tracking_number”: null,
“line_items”: {
“pageInfo”: {
“hasNextPage”: true,
“endCursor”: “YXJyYXljb25uZWN0aW9uOjk=”
},
“edges”: [
{
“node”: {
“product_id”: “368324300”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTM1”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 3,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 STON 50 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Stone / 50” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:31”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “368324293”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTI4”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 4,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 STON 36 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Stone / 36” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:30”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “368324289”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTQ2”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 2,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 COBA 50 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Cobalt / 50” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:32”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “367785291”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTQw”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 6,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 COBA 38 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Cobalt / 38” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:32”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “368324294”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTI5”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 7,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 STON 38 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Stone / 38” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:30”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “368324297”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTMy”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 6,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 STON 44 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Stone / 44” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:31”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “367785289”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTM5”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 4,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 COBA 36 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Cobalt / 36” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:32”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “368324301”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTM2”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 3,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 STON 52 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Stone / 52” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:31”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “368324302”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTM3”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 2,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 STON 54 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Stone / 54” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:31”,
“updated_at”: null
}
},
{
“node”: {
“product_id”: “368324286”,
“id”: “UHVyY2hhc2VPcmRlckxpbmVJdGVtOjEyNTQyMTQz”,
“vendor”: null,
“vendor_id”: “0”,
“price”: “75.0000”,
“quantity”: 5,
“quantity_received”: 0,
“quantity_rejected”: 0,
“fulfillment_status”: “pending”,
“sku”: "41062 COBA 44 38 “,
“vendor_sku”: null,
“product_name”: “Weathered Canvas Pant Cobalt / 44” / 38"”,
“note”: null,
“created_at”: “2022-01-28T21:53:32”,
“updated_at”: null
}
}
]
}
}
}
}
}

Hello @bbarrett!

Thank you for reaching out.

That purchase order was created with a vendor that belongs to another child account, which also doesn’t exist within the line items added. In that PO, the vendor I see is “Ballin”, not “Polo Ralph Lauren”.

I checked other POs, and those that have as vendor Polo Ralph Lauren return the same, as that vendor doesn’t exist for that child account.

Please let me know if you need further help.
Kind regards,
TomasFD

Is there anyway using the API to get the Vendor value shown in the app: “Polo Ralph Lauren” ?

Hello @bbarrett,

Not in this case as the vendor does not exist in the child account.

You should create the vendor, add it to products and recreate de PO.

Kind regards,
TomasFD

This is very frustrating. You are all avoiding answering my question. I
completely understand what you are saying. You have said it twice. Yet I
have responded twice asking something quite specific which you are not
answering. Lets try again…

Yes, I understand that if we had chosen to reference a vendor that existed
in your vendor list, it probably would return the vendor as expected.

BUT! In this case we did not. Your system allowed us to enter a string
for the vendor that did not exist in your list “Polo Ralph Lauren”. It
obviously saved this string somewhere! Its getting displayed.

Here is my question: When we specify a vendor that does not exist in the
vendor list how do we get the text that ShipHero is storing and displaying
as the vendor?

I am suspicious you can’t. I just want you to confirm.

Lastly, assuming you confirm the above I will then suggest you consider
this a bug and provide a way to get this non-vendor text that IS stored
someplace in your database. OR prevent the creation of a PO with an
invalid vendor.

Hello @bbarrett

My apologies for the late answer.

Yes, it is as you assume, you won’t be able to get that value.

As for your suggestion, yes you are right, I already treated this as a bug and the matter has already been sent to our engineers.

Kind regards,
TomasFD