Get all 3PL customers

I am trying to create an order for 3PL Customers using the API and it will be done for different users. I understand that we need to pass the customer_account_id value.
I can not find how can we get this customer account id for all our 3PL customers.

Hey saif_storage -

You should be able to get this from: https://app.shiphero.com/3pl
Not sure if you are able to get this thru the API - But at least there you will have it to put into your development :slight_smile:

2 Likes

Hi @saif_storage!

That is perfect, it should be at https://app.shiphero.com/3pl as mentioned by @Tommy_VikingC
You could also get them listed using this Query:

query {
  account {
    request_id
    complexity
    data {
      id
      legacy_id
      email
      customers {
        edges {
          node {
            id
            legacy_id
          }
        }
      }
    }
  }
} 

legacy_id should match the ones seen at https://app.shiphero.com/3pl and the id is the UUID

1 Like

Thanks this seems to do the work… is this mentioned in the documentation? and apart from the id and legacy_id what are the customer attributes that we can access? Thank you once again, it was really helpful

Thank you @Tommy_VikingC for the help. I actually had to do it with the API. @tomasw solution seems to working fine and this is what I was looking for

sure @saif_storage!
The fields available should be on the schema, but here is a list of ones that might help

query {
  account {
    request_id
    complexity
    data {
      id
      legacy_id
      email
      customers {
        edges {
          node {
            id
            legacy_id
            email
            username
            status
            dynamic_slotting
            is_multi_warehouse
            is_3pl
            cycle_count_enabled
            ship_backorders
          }
        }
      }
    }
  }
}

I’m currently working on a section for 3PL accounts useful tips on our Flows section, to bring some advice on managing 3PL accounts using the Public API, I will let you know as soon as it is published so if there is something I could add you can let me know

Thank you very much @tomasw

1 Like

From which field i’ll get the 3PL name ?

Hi @arpita.rath!

Are you registered to a Customer account or to a 3PL account?
If you are on a 3PL try this Query:

query {
  account {
    request_id
    complexity
    data {
      id
      legacy_id
      email
      username
      status
      dynamic_slotting
      is_multi_warehouse
      is_3pl
      cycle_count_enabled
      ship_backorders
      warehouses {
        id
        legacy_id
        account_id
        identifier
        dynamic_slotting
        invoice_email
        phone_number
        profile
      }
    }
  }
}

If you are on a Customer account, you won’t be able to Query for information on the 3PL.

Please let us know if that doesn’t help.
Thanks in advance!
Tom