Order API endpoint is returning NULL supplier_id

Description

Calling the Order API endpoint for my dev account with this: “https://apiverson.ordoro.com/order/1-1050”. The supplier_id column for some products returns as NULL, but when I check the Product API for the SKU there IS a supplier entered.

When I did:

https://apiverson.ordoro.com/order/1-1050

I expected:

I expect that if a product has an associated supplier, the supplier ID would be populated

What actually happened:

supplier_id is NULL

Request Details

https://apiverson.ordoro.com/order/1-1050

if there is a relevant payload to attach, do that here too (just remember to obfuscate any private information like passwords or ids).

{
GET /order/1-1050 HTTP/1.1
Host: apiverson.ordoro.com
Authorization: Basic xxx
Cache-Control: no-cache
Postman-Token: xxx

}

Response Details

Body

{
 "lines": [
        {
            "link": "/order/1-1050/line/32879446",
            "quantity": 1,
            "item_price": #,
            "total_price": #,
            "supplier_price": null,
            "sku": "KTI-78070",
            "product_name": "abc",
            "order_line_product_name": "cbd",
            "product_link": "/product/KTI-78070/",
            "product_category": "Cable Ties",
            "shippability": {
                "shippability": "shippable",
                "supplier_id": null,
                "is_dropship": false
            },
            "details": ""
        },
        {
            "link": "/order/1-1050/line/32879447",
            "quantity": 1,
            "item_price": #,
            "total_price": #,
            "supplier_price": null,
            "sku": "KTI-78140",
            "product_name": "abc",
            "order_line_product_name": "cbcb",
            "product_link": "/product/KTI-78140/",
            "product_category": "Cable Ties",
            "shippability": {
                "shippability": "shippable",
                "supplier_id": null,
                "is_dropship": false
            },
            "details": ""
        },
        {
            "link": "/order/1-1050/line/32879448",
            "quantity": 1,
            "item_price": #,
            "total_price": #,
            "supplier_price": null,
            "sku": "BAUGI5000",
            "product_name": "cbcbc",
            "order_line_product_name": "cbcbc",
            "product_link": "/product/BAUGI5000/",
            "product_category": "Cable Binder",
            "shippability": {
                "shippability": "shippable",
                "supplier_id": 35180,
                "is_dropship": true
            },
            "details": ""
        }
    ]

Request ID

this can be found in the X-ORDORO-REQUEST-ID header and will help us trace the request through our logs

X-API-REQUEST-ID →414d7d5a-97a3-4315-858d-e8f7a9d6ab0a
X-APIVERSON-REQUEST-ID →e8976a5f-ded8-460e-b767-27fded945019
X-ORDORO-API-SERVER →i-071fe1adaa46f6e5e 1.497.0
X-ORDORO-HANDLED-BY →ip-172-31-31-186

Hi,

If is_dropship = true, then we will include the supplier_id, this is currently used for drop shipping only, so if the product is set to be supplied in-house, even if the product has a default supplier, we will not include this information in the response.

If you need to know the suppliers for a product, you’ll have to make a request to get the product information on a line by line basis.

1 Like

Where do I change a product to set dropship = true ?

You can use this endpoint /product/sku/default_dropshipper/supplier_id/ doc link.

Reminder, for products, the api base is api.ordoro.com.