Excel contain product Id’s in 1st column and in column B1:H1 there are cities. Once I enter product Id in ecommerce site, gets product detail and map. In map need to search cities one by one. If any particular city available on map then confirm location button turned into blue otherwise it is grey color. If we get city in Map then in excel should update status as Yes else No. Can any one tell me how can we do that.
status should get updated as per below screenshot, If city is available on map then Yes else No as per product Id.
Is that to create a table that shows the available areas for shipment - in the service- ?
Then if you could explain the process step by step, it would be better to help you.