# Find catalog items with no associated location

**URL:** <https://developer.squareup.com/forums/t/find-catalog-items-with-no-associated-location/22593>\
**Category:** Questions\
**Tags:** catalog-api\
**Created:** [May 29, 2025, 3:55pm UTC](https://developer.squareup.com/forums/t/find-catalog-items-with-no-associated-location/22593 "2025-05-29T15:55:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![trolin](https://avatars.discourse-cdn.com/v4/letter/t/9de053/32.png) [@trolin](https://developer.squareup.com/forums/u/trolin)\
**Post date:** [May 29, 2025, 3:55pm UTC](https://developer.squareup.com/forums/t/find-catalog-items-with-no-associated-location/22593/1 "2025-05-29T15:55:05Z")

</div>

I’d like to identify any items in our item library that have no associated location. Since the dashboard does not appear to support that search, I’ve started playing with the developer API. I can find items _with_ a location ID, but I don’t see any way to find items with _no_ location ID. Is this doable? If so, what’s the query?

---

<div class="post-metadata">

**Author:** ![Square-Dev-AI](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/square-dev-ai/32/2513_2.png) [@Square-Dev-AI](https://developer.squareup.com/forums/u/Square-Dev-AI)\
**Post date:** [May 29, 2025, 3:55pm UTC](https://developer.squareup.com/forums/t/find-catalog-items-with-no-associated-location/22593/2 "2025-05-29T15:55:34Z")

</div>

👋 I’m Square Dev AI, here to help answer your question!  
Based on the information you’ve provided, the following documentation will help answer your question:

> **[Locations API](https://developer.squareup.com/docs/locations-api/how-it-works)**
>
> Learn how to use a Square API to update and retrieve location information for a Square seller.

> **[Locations API](https://developer.squareup.com/docs/locations-api)**
>
> Learn how to use a Square API to update and retrieve location information for a Square seller.

> **Additional Documentation**
>
> [Locations API](https://developer.squareup.com/docs/locations-api/cookbook/get-locations)  
> [Square Developer](https://developer.squareup.com/docs/app-marketplace/requirements/locations-api)  
> [Build and Manage a Simple Inventory](https://developer.squareup.com/docs/inventory-api/build-with-inventory)

If this documentation helped you find a solution, please check the box indicating that this reply solves the problem.  
Otherwise one of our Developer Advocates will provide additional assistance shortly.

---

<div class="post-metadata">

**Author:** ![Square-Dev-AI](https://sea1.discourse-cdn.com/square/forums/user_avatar/developer.squareup.com/square-dev-ai/32/2513_2.png) [@Square-Dev-AI](https://developer.squareup.com/forums/u/Square-Dev-AI)\
**Post date:** [May 29, 2025, 6:16pm UTC](https://developer.squareup.com/forums/t/find-catalog-items-with-no-associated-location/22593/3 "2025-05-29T18:16:45Z")

</div>

Yes, it is possible to find items with no associated location using the Catalog API. You can use the `ListCatalog` endpoint to retrieve all items in your catalog. This will return a list of all catalog objects, including items and item variations.

Each item variation object has a `present_at_all_locations` field. If this field is set to `false`, it means the item variation is not present at all locations. In this case, you can check the `present_at_location_ids` field to see the specific locations where the item variation is present. If this field is empty, it means the item variation is not associated with any location.

Please note that the `present_at_all_locations` and `present_at_location_ids` fields are only available for item variation objects, not for item objects. This is because in Square’s system, inventory is tracked at the item variation level, not at the item level. Therefore, you need to check these fields for each item variation under an item.

_This answer was reviewed by @Bryan-Square._

---

<div class="post-metadata">

**Author:** ![trolin](https://avatars.discourse-cdn.com/v4/letter/t/9de053/32.png) [@trolin](https://developer.squareup.com/forums/u/trolin)\
**Post date:** [May 30, 2025, 2:44pm UTC](https://developer.squareup.com/forums/t/find-catalog-items-with-no-associated-location/22593/4 "2025-05-30T14:44:31Z")

</div>

This will get me what I need. Thank you!