# Get 3PL Customer name for Sku/Inventory Adjustments?
**URL:** https://community.shiphero.com/t/get-3pl-customer-name-for-sku-inventory-adjustments/2110
**Category:** GraphQL API
**Created:** [July 29, 2022, 8:39pm UTC](https://community.shiphero.com/t/get-3pl-customer-name-for-sku-inventory-adjustments/2110 "2022-07-29T20:39:28Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Raj](https://community.shiphero.com/u/Raj)
#### Post date: [July 29, 2022, 8:39pm UTC](https://community.shiphero.com/t/get-3pl-customer-name-for-sku-inventory-adjustments/2110/1 "2022-07-29T20:39:28Z")
HI,
I’m pulling inventory\_changes results using warehouse and time filters. I need the 3PL Customer name associated with each sku in result - how can I extract that?
In case the above query has no way of giving that info, a product(sku) query run on each result would work? (it’s a much longer alternative, but I’m willing to use this if the first approach won’t help)
Could you pls post a sample query with your answer?
Many thanks!
Raj
---
### Author:  [@tomasfd](https://community.shiphero.com/u/tomasfd)
#### Post date: [July 29, 2022, 9:38pm UTC](https://community.shiphero.com/t/get-3pl-customer-name-for-sku-inventory-adjustments/2110/2 "2022-07-29T21:38:38Z")
Hello @Raj!
If you are connected as a 3PL and want to use that filter to get `inventory_changes` for specific customer accounts, you could add the filter `customer_account_id` and get the updates for each of them separately.
To get the `customer_account_id`s, you can use the following query:
```auto
query{
account{
data{
customers{
edges{
node{
id
legacy_id
email
}
}
}
}
}
}
```
Currently, `inventory_changes` is returning the `account_id` of the 3PL, but the filter works correctly. I already forwarded that issue to our EN team, and they are working on it.
The account name is not returned in either of those queries. We use the email used to register it for reference. You can get that in the query I shared.
Please let me know if this helps you.
Kind regards,
TomasFD
---
### Author:  [@Raj](https://community.shiphero.com/u/Raj)
#### Post date: [August 1, 2022, 2:36pm UTC](https://community.shiphero.com/t/get-3pl-customer-name-for-sku-inventory-adjustments/2110/3 "2022-08-01T14:36:45Z")
Thank you @tomasfd , you da man!!
The filter worked beautifully, and I love that it accepts legacy\_id as I already keep record of it for the clients I’m using this for 😃
---
### Author:  [@tomasfd](https://community.shiphero.com/u/tomasfd)
#### Post date: [August 1, 2022, 4:20pm UTC](https://community.shiphero.com/t/get-3pl-customer-name-for-sku-inventory-adjustments/2110/4 "2022-08-01T16:20:44Z")
Hello @Raj!
Always happy to help!
FYI, all id filters should work with `id` just as `legacy_id`. Have you come across one that doesn’t?
Best,
TomasFD
---
### Author:  [@Raj](https://community.shiphero.com/u/Raj)
#### Post date: [August 1, 2022, 4:39pm UTC](https://community.shiphero.com/t/get-3pl-customer-name-for-sku-inventory-adjustments/2110/5 "2022-08-01T16:39:42Z")
Oh okay, thanks @tomasfd … No I don’t recall coming across any such case. I guess I was just happy I wouldn’t have to deal with another type of id per account haha