VG008
Senior Member
Hi Guys
Our company issues MasterCard branded cards to certain clients. Now, these clients are free to transact wherever but we have seen a trend where by they transact at PNP & Shoprite mostly.
For phase 1, I would like to group these transactions by Province (Gauteng/KZN). For phase 2 I would like to plot these transactions on a map (google maps for instance) so I would need the GPS co-ordinates of these stores.
For Phase 1 Shoprite has the province embedded in the store name (Data Element 43 on the ISO message from MasterCard), however for Pick 'n Pay, they don't. They just send 'Pick 'n Pay Family Douglasdale ZAF' for instance.
So, my question is how can I get the provinces for each PNP store? Or maybe a list of PNP stores?
Thanks for the help!
Our company issues MasterCard branded cards to certain clients. Now, these clients are free to transact wherever but we have seen a trend where by they transact at PNP & Shoprite mostly.
For phase 1, I would like to group these transactions by Province (Gauteng/KZN). For phase 2 I would like to plot these transactions on a map (google maps for instance) so I would need the GPS co-ordinates of these stores.
For Phase 1 Shoprite has the province embedded in the store name (Data Element 43 on the ISO message from MasterCard), however for Pick 'n Pay, they don't. They just send 'Pick 'n Pay Family Douglasdale ZAF' for instance.
So, my question is how can I get the provinces for each PNP store? Or maybe a list of PNP stores?
Thanks for the help!