Customer API cannot filter by ZIP code

Highlighted
Shopify Expert
2 0 1

I'm having a problem with API, if I filter by country or city I get the expected JSON encoded list of customers as specified here: https://help.shopify.com/en/api/reference/customers/customer#search

For example:

https://storename.myshopify.com/admin/customers/search.json?query=city:Berlin

https://storename.myshopify.com/admin/customers/search.json?query=country:United%20Kingdom

 

But if I filter by ZIP code I just don't get any results, even though I can see the exact ZIP code in the previous methods results:

https://storename.myshopify.com/admin/customers/search.json?query=zip:53715

 

Anyone else had this problem? Is there no feature to filter by ZIP code? It's in the returned fields so I just assumed it would be - same with the city, which isn't mentioned in the docs but works.

 

Thanks!

1 Like
Highlighted
Shopify Staff
Shopify Staff
4 0 1

Hi there!

John from Shopify's Technical Support team here. I actualy did look into this issue in the last couple days and you are correct, we don't currently have the zip/postal code field available to be searched by this call.

I wish I had a good work around for you, but I currently haven't been able to find a suitable one, as this is a pretty specific call you're making, and nothing quite covers a zip code in the same way.

That said, I have broached this with our developers and while I haven't been able to find any reason for it's omission (it could have been a simple oversight, or there may have been some other deeper reason I am as of yet unaware of), I have raised it a feature request / point of frustration for us to look at and possibly address.

I can't make any promises as to when or even if this will changed without a proper formal discussion taking place but I will update this thread if and when I find out anything concrete to go by, but that may be awhile (literally no timeframe at the moment).

So, probably not the answer you were hoping for, but a totally valid point to raise, and at least you know one way or the other for now.

John

1 Like
Highlighted
Shopify Expert
2 0 1

Hi John,

Thanks for your reply. It is indeed good to know that is something out of my control. I believe I have come up with a solution to our problem that doesn't involve using the customer search API, but it's not an ellegant one and means the admin user has to take more steps then I'd like. So I'd very much apprciate if it you would update the thread should any changes occur. :-)

 

Thanks,

Andrew

 

0 Likes
Highlighted
Shopify Partner
8 0 2

I also really need this feature.

Odd that you can search by zip/post code in orders but not in customers.

0 Likes
Highlighted
New Member
5 0 0

This still seems to not be a feature, is there a reason you cant search customer by zip? we are having to export customers each time into excel.


@Jamie_D wrote:

I also really need this feature.

Odd that you can search by zip/post code in orders but not in customers.


 

0 Likes