Vendors account_id is not unique

GraphQL API
1

Hi,
I am working on pulling orders and mapping them to a vendor. However, I have discovered that the Vendor account id is not unique but the node and legacy id for the vendor is unique. I have an instance where one account id has four duplicates. On the order schema I do not see a way to get the unique vendor id (since the only field that I can see relates to vendor id is the account id). How can I uniquely map and order to a vendor?

Thank you!

2

Hi @jb001! Welcome to our community, glad to have you here!
Can you share an example of how you pull data and where it shows this case? I’d like to review it internally.
Have a nice day!

3

Hi @tomasfd! Thank you for having me! I am pulling data using the following graphql query:

query Vendors {
    vendors {
        request_id
        complexity
        data {
            edges {
                cursor
                node {
                    id
                    legacy_id
                    account_id
                    created_at
                }
            }
        }
    }
}

For orders I am using:

{
        order(id: "<ID>") {
            data {
                id
                line_items {
                    edges {
                        node {
                            id
                            sku
                            quantity
                            product_name
                            quantity_allocated
                            quantity_pending_fulfillment
                            quantity_shipped
                            warehouse
                            barcode
                            product {
                                id
                                name
                                sku
                                barcode
                                dimensions {
                                    weight
                                    height
                                    width
                                    length
                                }
                                thumbnail
                                large_thumbnail
                                images {
                                    position
                                    src
                                }
                            }
                            product_id
                            backorder_quantity
                            warehouse_id
                            order_id
                            serial_numbers {
                                id
                                legacy_id
                                line_item_id
                                serial_number
                                scanned
                                created_at
                                updated_at
                            }
                        }
                        cursor
                    }
                    pageInfo {
                        hasNextPage
                        hasPreviousPage
                        startCursor
                        endCursor
                    }
                    total_count
                }
                order_date
                shop_name
                partner_order_id
                order_number
                account_id
            }
            complexity
        }
      }
}

To get an example would it be possible to get your email? I am nervous about sharing client information on a public forum.

Thank you!

4

Hi @jb001, I forgot to mention it. Feel free to send whatever you need in a private message in this platform if you’re more comfortable that way. Please reference the thread.
Have a great day!

5

Hi @tomasfd I am still looking for how to send a private message, but once I do you will receive the data.

6

Hi @tomasfd have you had a chance to see my list of customer ids? I sent it yesterday to the moderator team because I did not have permission to send you a direct message.

Thank you!