Geographical filtering based on radius Kilometers distance from a postal code

[hmfa]

Hi @russellkouadio .

Aditionaly take a look at this thread

Geo, Distance Radius Calculations - Please Help

Hello - PLEASE HELP ;( I have been breaking my head over this for days. I need to do a store-level inventory analysis on a retail chain. The API allows me to query either: SKU+ZIP+100 mile radius - returns all stores and their respective inventory level Sku+StoreID - returns just that stores inventory level There are about 2278 SKUs and 1473 Stores. Right now I am using a cross-join to create API Calls: ?storeId=X&skuId=Y which gives me 3.3 Mil API calls which is too much! There must be …

Br