Update DealersLive set StoreID=1 WHERE DealerNAme= 'Airport Supa Quick'
Update DealersLive set StoreID=3 WHERE DealerNAme= 'Alberton Supa Quick'
Update DealersLive set StoreID=124 WHERE DealerNAme= 'Alexandra Laan Supa Quick'
Update DealersLive set StoreID=172 WHERE DealerNAme= 'Amalinda Supa Quick'
Update DealersLive set StoreID=55 WHERE DealerNAme= 'Amanzimtoti Supa Quick'
Update DealersLive set StoreID=497 WHERE DealerNAme= 'Armadale Supa Quick'
Update DealersLive set StoreID=5 WHERE DealerNAme= 'Athlone Supa Quick'
Update DealersLive set StoreID=503 WHERE DealerNAme= 'Ballito Supa Quick'
Update DealersLive set StoreID=10 WHERE DealerNAme= 'Barden Tyres Supa Quick'
Update DealersLive set StoreID=516 WHERE DealerNAme= 'Beaufort-Wes Supa Quick'
Update DealersLive set StoreID=152 WHERE DealerNAme= 'Benoni Supa Quick'
Update DealersLive set StoreID=649 WHERE DealerNAme= 'Bergville Supa Quick'
Update DealersLive set StoreID=335 WHERE DealerNAme= 'Bethal Supa Quick'
Update DealersLive set StoreID=287 WHERE DealerNAme= 'Birchleigh Supa Quick'
Update DealersLive set StoreID=271 WHERE DealerNAme= 'Bloemhof Supa Quick'
Update DealersLive set StoreID=252 WHERE DealerNAme= 'Blue Route Supa Quick'
Update DealersLive set StoreID=656 WHERE DealerNAme= 'Bonaero Park Supa Quick'
Update DealersLive set StoreID=17 WHERE DealerNAme= 'Braamfontein Supa Quick'
Update DealersLive set StoreID=18 WHERE DealerNAme= 'Brackenfell Supa Quick'
Update DealersLive set StoreID=269 WHERE DealerNAme= 'Brentwoodpark Supa Quick'
Update DealersLive set StoreID=21 WHERE DealerNAme= 'Brits Supa Quick'
Update DealersLive set StoreID=22 WHERE DealerNAme= 'Bronkhorstspruit Supa Quick'
Update DealersLive set StoreID=377 WHERE DealerNAme= 'Bryanston Supa Quick'
Update DealersLive set StoreID=420 WHERE DealerNAme= 'Buffalo Supa Quick'
Update DealersLive set StoreID=23 WHERE DealerNAme= 'Bultfontein Supa Quick'
Update DealersLive set StoreID=260 WHERE DealerNAme= 'Burgersfort Supa Quick'
Update DealersLive set StoreID=24 WHERE DealerNAme= 'Caledon Retreaders'
Update DealersLive set StoreID=25 WHERE DealerNAme= 'Calvinia Supa Quick'
Update DealersLive set StoreID=9 WHERE DealerNAme= 'Cape Town Supa Quick'
Update DealersLive set StoreID=286 WHERE DealerNAme= 'Carletonville Supa Quick'
Update DealersLive set StoreID=27 WHERE DealerNAme= 'Carolina Supa Quick'
Update DealersLive set StoreID=28 WHERE DealerNAme= 'Centurion Supa Quick'
Update DealersLive set StoreID=623 WHERE DealerNAme= 'Century City Supa Quick'
Update DealersLive set StoreID=29 WHERE DealerNAme= 'Ceres Supa Quick'
Update DealersLive set StoreID=284 WHERE DealerNAme= 'Claremont Supa Quick'
Update DealersLive set StoreID=35 WHERE DealerNAme= 'Commercial Road Supa Quick'
Update DealersLive set StoreID=333 WHERE DealerNAme= 'Constantia Supa Quick'
Update DealersLive set StoreID=642 WHERE DealerNAme= 'Cresta Supa Quick'
Update DealersLive set StoreID=37 WHERE DealerNAme= 'Dalton Supa Quick'
Update DealersLive set StoreID=38 WHERE DealerNAme= 'Delareyville Supa Quick'
Update DealersLive set StoreID=459 WHERE DealerNAme= 'Delmas Supa Quick'
Update DealersLive set StoreID=39 WHERE DealerNAme= 'Dendron Auto Centre'
Update DealersLive set StoreID=296 WHERE DealerNAme= 'Diep River Supa Quick'
Update DealersLive set StoreID=334 WHERE DealerNAme= 'Douglas Supa Quick'
Update DealersLive set StoreID=40 WHERE DealerNAme= 'Du Toits Bande Louis Trichardt'
Update DealersLive set StoreID=41 WHERE DealerNAme= 'Du Toits Bande Messina'
Update DealersLive set StoreID=42 WHERE DealerNAme= 'Duivelskloof Bande'
Update DealersLive set StoreID=43 WHERE DealerNAme= 'Dundee Supa Quick'
Update DealersLive set StoreID=45 WHERE DealerNAme= 'Durban North Supa Quick'
Update DealersLive set StoreID=46 WHERE DealerNAme= 'Durbanville Supa Quick'
Update DealersLive set StoreID=16 WHERE DealerNAme= 'East Rand Mall Supa Quick'
Update DealersLive set StoreID=281 WHERE DealerNAme= 'Eastgate Supa Quick'
Update DealersLive set StoreID=518 WHERE DealerNAme= 'Elliot Supa Quick'
Update DealersLive set StoreID=441 WHERE DealerNAme= 'Elsies River Supa Quick'
Update DealersLive set StoreID=626 WHERE DealerNAme= 'Empangeni Supa Quick'
Update DealersLive set StoreID=50 WHERE DealerNAme= 'Empire Supa Quick'
Update DealersLive set StoreID=498 WHERE DealerNAme= 'Ermelo Supa Quick'
Update DealersLive set StoreID=52 WHERE DealerNAme= 'Errols Tyres Supa Quick'
Update DealersLive set StoreID=630 WHERE DealerNAme= 'Eshowe Supa Quick'
Update DealersLive set StoreID=54 WHERE DealerNAme= 'Exhaust & Tyre Services'
Update DealersLive set StoreID=496 WHERE DealerNAme= 'Festival Mall Supa Quick'
Update DealersLive set StoreID=56 WHERE DealerNAme= 'Ficksburg Supa Quick'
Update DealersLive set StoreID=366 WHERE DealerNAme= 'Fischers Hill Supa Quick'
Update DealersLive set StoreID=273 WHERE DealerNAme= 'Fish Hoek Supa Quick'
Update DealersLive set StoreID=58 WHERE DealerNAme= 'Fordsburg Supa Quick'
Update DealersLive set StoreID=639 WHERE DealerNAme= 'Fourways Supa Quick'
Update DealersLive set StoreID=60 WHERE DealerNAme= 'Gallo Manor Supa Quick'
Update DealersLive set StoreID=495 WHERE DealerNAme= 'Gansbaai Supa Quick'
Update DealersLive set StoreID=290 WHERE DealerNAme= 'Gateway Supa Quick'
Update DealersLive set StoreID=61 WHERE DealerNAme= 'Gelderblom Bande Supa Quick'
Update DealersLive set StoreID=446 WHERE DealerNAme= 'Germiston Supa Quick'
Update DealersLive set StoreID=185 WHERE DealerNAme= 'Gezina Supa Quick'
Update DealersLive set StoreID=63 WHERE DealerNAme= 'Graaff Reinet Supa Quick'
Update DealersLive set StoreID=423 WHERE DealerNAme= 'Grabouw Supa Quick'
Update DealersLive set StoreID=64 WHERE DealerNAme= 'Greenacres Supa Quick'
Update DealersLive set StoreID=629 WHERE DealerNAme= 'Greenstone Supa Quick'
Update DealersLive set StoreID=525 WHERE DealerNAme= 'Greytown Supa Quick'
Update DealersLive set StoreID=183 WHERE DealerNAme= 'Groblersdal Supa Quick'
Update DealersLive set StoreID=65 WHERE DealerNAme= 'Hammanskraal Supa Quick'
Update DealersLive set StoreID=66 WHERE DealerNAme= 'Harding Supa Quick'
Update DealersLive set StoreID=67 WHERE DealerNAme= 'Hartswater Supa Quick'
Update DealersLive set StoreID=68 WHERE DealerNAme= 'Harvest Tyre'
Update DealersLive set StoreID=128 WHERE DealerNAme= 'Hazyview Supa Quick'
Update DealersLive set StoreID=618 WHERE DealerNAme= 'Helderberg Supa Quick'
Update DealersLive set StoreID=70 WHERE DealerNAme= 'Hermanus Supa Quick'
Update DealersLive set StoreID=71 WHERE DealerNAme= 'Hillcrest Supa Quick'
Update DealersLive set StoreID=263 WHERE DealerNAme= 'Hluhluwe Supa Quick'
Update DealersLive set StoreID=72 WHERE DealerNAme= 'Hoedspruit Supa Quick'
Update DealersLive set StoreID=190 WHERE DealerNAme= 'Hoopstad Supa Quick'
Update DealersLive set StoreID=73 WHERE DealerNAme= 'Howick Supa Quick'
Update DealersLive set StoreID=74 WHERE DealerNAme= 'Humansdorp Supa Quick'
Update DealersLive set StoreID=442 WHERE DealerNAme= 'Isando Supa Quick'
Update DealersLive set StoreID=77 WHERE DealerNAme= 'Isipingo Supa Quick'
Update DealersLive set StoreID=251 WHERE DealerNAme= 'Ixopo Supa Quick'
Update DealersLive set StoreID=526 WHERE DealerNAme= 'Jane Furse Supa Quick'
Update DealersLive set StoreID=657 WHERE DealerNAme= 'JBay Supa Quick'
Update DealersLive set StoreID=79 WHERE DealerNAme= 'JL Tyres & Exhausts'
Update DealersLive set StoreID=292 WHERE DealerNAme= 'Johnny''s Supa Quick'
Update DealersLive set StoreID=81 WHERE DealerNAme= 'Jules Street Supa Quick'
Update DealersLive set StoreID=517 WHERE DealerNAme= 'Kameeldrift East Supa Quick'
Update DealersLive set StoreID=82 WHERE DealerNAme= 'Karroo Banddienste'
Update DealersLive set StoreID=633 WHERE DealerNAme= 'Katlehong Supa Quick'
Update DealersLive set StoreID=84 WHERE DealerNAme= 'Kempton Supa Quick'
Update DealersLive set StoreID=85 WHERE DealerNAme= 'Kimberley Supa Quick'
Update DealersLive set StoreID=86 WHERE DealerNAme= 'Kinross Retreaders'
Update DealersLive set StoreID=484 WHERE DealerNAme= 'Kleinmond Supa Quick'
Update DealersLive set StoreID=531 WHERE DealerNAme= 'Kloof Supa Quick'
Update DealersLive set StoreID=89 WHERE DealerNAme= 'Knysna Supa Quick'
Update DealersLive set StoreID=379 WHERE DealerNAme= 'Kokstad Supa Quick'
Update DealersLive set StoreID=433 WHERE DealerNAme= 'Komatipoort Supa Quick'
Update DealersLive set StoreID=632 WHERE DealerNAme= 'Kroonstad Supa Quick'
Update DealersLive set StoreID=30 WHERE DealerNAme= 'Krugersdorp Supa Quick'
Update DealersLive set StoreID=92 WHERE DealerNAme= 'KT Tyres'
Update DealersLive set StoreID=93 WHERE DealerNAme= 'Kuils River Supa Quick'
Update DealersLive set StoreID=254 WHERE DealerNAme= 'Kuruman Supa Quick'
Update DealersLive set StoreID=361 WHERE DealerNAme= 'Kyalami Supa Quick'
Update DealersLive set StoreID=504 WHERE DealerNAme= 'Ladybrand Supa Quick'
Update DealersLive set StoreID=511 WHERE DealerNAme= 'Ladysmith Supa Quick'
Update DealersLive set StoreID=631 WHERE DealerNAme= 'Lambton Supa Quick'
Update DealersLive set StoreID=445 WHERE DealerNAme= 'Latgro Supa Quick'
Update DealersLive set StoreID=267 WHERE DealerNAme= 'Lenasia Supa Quick'
Update DealersLive set StoreID=97 WHERE DealerNAme= 'Lichtenburg Supa Quick'
Update DealersLive set StoreID=75 WHERE DealerNAme= 'Linton Grange Supa Quick'
Update DealersLive set StoreID=98 WHERE DealerNAme= 'Loerie Supa Quick'
Update DealersLive set StoreID=99 WHERE DealerNAme= 'Lombard Tyres Supa Quick'
Update DealersLive set StoreID=100 WHERE DealerNAme= 'Lydenburg Supa Quick'
Update DealersLive set StoreID=523 WHERE DealerNAme= 'Mabopane Supa Quick'
Update DealersLive set StoreID=101 WHERE DealerNAme= 'Mafikeng Supa Quick'
Update DealersLive set StoreID=282 WHERE DealerNAme= 'Magaliesburg Supa Quick'
Update DealersLive set StoreID=272 WHERE DealerNAme= 'Malelane Supa Quick'
Update DealersLive set StoreID=102 WHERE DealerNAme= 'Malmesbury Supa Quick'
Update DealersLive set StoreID=103 WHERE DealerNAme= 'Margate Supa Quick'
Update DealersLive set StoreID=105 WHERE DealerNAme= 'Matatiele Supa Quick'
Update DealersLive set StoreID=106 WHERE DealerNAme= 'Matsapha Supa Quick'
Update DealersLive set StoreID=556 WHERE DealerNAme= 'Maxiprest Tyres Regional Office'
Update DealersLive set StoreID=107 WHERE DealerNAme= 'Menlyn Supa Quick'
Update DealersLive set StoreID=108 WHERE DealerNAme= 'Middestad Supa Quick'
Update DealersLive set StoreID=109 WHERE DealerNAme= 'Midrand Supa Quick'
Update DealersLive set StoreID=454 WHERE DealerNAme= 'Mitchells Plain Supa Quick'
Update DealersLive set StoreID=110 WHERE DealerNAme= 'Mobeni Supa Quick'
Update DealersLive set StoreID=111 WHERE DealerNAme= 'Montagu Supa Quick'
Update DealersLive set StoreID=204 WHERE DealerNAme= 'Mooi River Supa Quick'
Update DealersLive set StoreID=173 WHERE DealerNAme= 'Mooreesburg Supa Quick'
Update DealersLive set StoreID=113 WHERE DealerNAme= 'Morester Bande'
Update DealersLive set StoreID=114 WHERE DealerNAme= 'Mosselbay Supa Quick'
Update DealersLive set StoreID=115 WHERE DealerNAme= 'Motyre Supa Quick'
Update DealersLive set StoreID=116 WHERE DealerNAme= 'Mtuba Supa Quick'
Update DealersLive set StoreID=440 WHERE DealerNAme= 'Namibia Tyres Supa Quick'
Update DealersLive set StoreID=118 WHERE DealerNAme= 'Nelspruit Supa Quick'
Update DealersLive set StoreID=120 WHERE DealerNAme= 'Newcastle Supa Quick'
Update DealersLive set StoreID=371 WHERE DealerNAme= 'Newton Park Supa Quick'
Update DealersLive set StoreID=121 WHERE DealerNAme= 'Nongoma Supa Quick'
Update DealersLive set StoreID=186 WHERE DealerNAme= 'North Coast Road Supa Quick'
Update DealersLive set StoreID=438 WHERE DealerNAme= 'Norwood Supa Quick'
Update DealersLive set StoreID=122 WHERE DealerNAme= 'Nylstroom Supa Quick'
Update DealersLive set StoreID=614 WHERE DealerNAme= 'Observatory Supa Quick'
Update DealersLive set StoreID=123 WHERE DealerNAme= 'Oliver Cradock Supa Quick'
Update DealersLive set StoreID=253 WHERE DealerNAme= 'Online Innovations'
Update DealersLive set StoreID=421 WHERE DealerNAme= 'Ormonde Supa Quick'
Update DealersLive set StoreID=126 WHERE DealerNAme= 'Oudtshoorn Supa Quick'
Update DealersLive set StoreID=654 WHERE DealerNAme= 'Overport Supa Quick'
Update DealersLive set StoreID=443 WHERE DealerNAme= 'Paarden Eiland Supa Quick'
Update DealersLive set StoreID=127 WHERE DealerNAme= 'Paarl Supa Quick'
Update DealersLive set StoreID=419 WHERE DealerNAme= 'Parow Supa Quick'
Update DealersLive set StoreID=69 WHERE DealerNAme= 'Parys Supa Quick'
Update DealersLive set StoreID=528 WHERE DealerNAme= 'Phalaborwa Supa Quick'
Update DealersLive set StoreID=462 WHERE DealerNAme= 'Piet Retief Supa Quick'
Update DealersLive set StoreID=130 WHERE DealerNAme= 'Pinetown Supa Quick'
Update DealersLive set StoreID=131 WHERE DealerNAme= 'PMBurg Supa Quick'
Update DealersLive set StoreID=132 WHERE DealerNAme= 'Pongola Supa Quick'
Update DealersLive set StoreID=133 WHERE DealerNAme= 'Port Shepstone Supa Quick'
Update DealersLive set StoreID=134 WHERE DealerNAme= 'Potchefstroom Supa Quick'
Update DealersLive set StoreID=136 WHERE DealerNAme= 'Potgietersrus Supa Quick'
Update DealersLive set StoreID=279 WHERE DealerNAme= 'Pretorius Street Supa Quick'
Update DealersLive set StoreID=360 WHERE DealerNAme= 'Prieska Supa Quick'
Update DealersLive set StoreID=8 WHERE DealerNAme= 'Prospecton Supa Quick'
Update DealersLive set StoreID=137 WHERE DealerNAme= 'Queensburgh Supa Quick'
Update DealersLive set StoreID=36 WHERE DealerNAme= 'Queenstown Supa Quick'
Update DealersLive set StoreID=261 WHERE DealerNAme= 'Randfontein Supa Quick'
Update DealersLive set StoreID=139 WHERE DealerNAme= 'Randparkridge Supa Quick'
Update DealersLive set StoreID=615 WHERE DealerNAme= 'Rayton Supa Quick'
Update DealersLive set StoreID=140 WHERE DealerNAme= 'Retyre Supa Quick'
Update DealersLive set StoreID=141 WHERE DealerNAme= 'Richards Bay Supa Quick'
Update DealersLive set StoreID=510 WHERE DealerNAme= 'Richmond Supa Quick'
Update DealersLive set StoreID=142 WHERE DealerNAme= 'Ritz Bande'
Update DealersLive set StoreID=357 WHERE DealerNAme= 'Robertsham Supa Quick'
Update DealersLive set StoreID=143 WHERE DealerNAme= 'Roodepoort Supa Quick'
Update DealersLive set StoreID=266 WHERE DealerNAme= 'Rosettenville Supa Quick'
Update DealersLive set StoreID=353 WHERE DealerNAme= 'Rossburgh Supa Quick'
Update DealersLive set StoreID=144 WHERE DealerNAme= 'RSM Bande'
Update DealersLive set StoreID=529 WHERE DealerNAme= 'Ruimsig Supa Quick'
Update DealersLive set StoreID=264 WHERE DealerNAme= 'Sabie Supa Quick'
Update DealersLive set StoreID=145 WHERE DealerNAme= 'Safeway Tyres'
Update DealersLive set StoreID=146 WHERE DealerNAme= 'Salisbury Street Supa Quick'
Update DealersLive set StoreID=200 WHERE DealerNAme= 'Sandhurst Supa Quick'
Update DealersLive set StoreID=315 WHERE DealerNAme= 'Sandown Supa Quick'
Update DealersLive set StoreID=147 WHERE DealerNAme= 'Sandton Tyre & Exhaust'
Update DealersLive set StoreID=277 WHERE DealerNAme= 'Sasolburg Supa Quick'
Update DealersLive set StoreID=655 WHERE DealerNAme= 'Schweizer Reneke Supa Quick'
Update DealersLive set StoreID=149 WHERE DealerNAme= 'Scottburgh Supa Quick'
Update DealersLive set StoreID=150 WHERE DealerNAme= 'Sea Point Service Centre'
Update DealersLive set StoreID=180 WHERE DealerNAme= 'Selby Supa Quick'
Update DealersLive set StoreID=151 WHERE DealerNAme= 'Shariffs Exhaust & Tyre Centre'
Update DealersLive set StoreID=153 WHERE DealerNAme= 'Shariffs Tyre Centre'
Update DealersLive set StoreID=154 WHERE DealerNAme= 'Sharwoods Berrys Corner'
Update DealersLive set StoreID=155 WHERE DealerNAme= 'Sharwoods North End'
Update DealersLive set StoreID=341 WHERE DealerNAme= 'Shelly Beach Supa Quick'
Update DealersLive set StoreID=156 WHERE DealerNAme= 'Silverton Supa Quick'
Update DealersLive set StoreID=157 WHERE DealerNAme= 'Socrates Bande'
Update DealersLive set StoreID=522 WHERE DealerNAme= 'Southgate Supa Quick'
Update DealersLive set StoreID=403 WHERE DealerNAme= 'Springbok Supa Quick'
Update DealersLive set StoreID=159 WHERE DealerNAme= 'Springs Supa Quick'
Update DealersLive set StoreID=163 WHERE DealerNAme= 'Steeledale Supa Quick'
Update DealersLive set StoreID=164 WHERE DealerNAme= 'Steelpoort Supa Quick'
Update DealersLive set StoreID=635 WHERE DealerNAme= 'Stellenbosch Supa Quick'
Update DealersLive set StoreID=617 WHERE DealerNAme= 'Strand Supa Quick'
Update DealersLive set StoreID=325 WHERE DealerNAme= 'Strydompark Supa Quick'
Update DealersLive set StoreID=168 WHERE DealerNAme= 'Sunward Park Supa Quick'
Update DealersLive set StoreID=169 WHERE DealerNAme= 'Supa Quick Regional Office (CapeTown)'
Update DealersLive set StoreID=170 WHERE DealerNAme= 'Supa Quick Regional Office (Durban)'
Update DealersLive set StoreID=620 WHERE DealerNAme= 'Supa Quick Regional Office (PE)'
Update DealersLive set StoreID=174 WHERE DealerNAme= 'Swellendam Supa Quick'
Update DealersLive set StoreID=175 WHERE DealerNAme= 'Tall Tree Supa Quick'
Update DealersLive set StoreID=176 WHERE DealerNAme= 'Techni Tyre Supa Quick'
Update DealersLive set StoreID=533 WHERE DealerNAme= 'Thabazimbi Supa Quick'
Update DealersLive set StoreID=644 WHERE DealerNAme= 'The Glen Supa Quick'
Update DealersLive set StoreID=177 WHERE DealerNAme= 'Thomas Tyre Centre'
Update DealersLive set StoreID=95 WHERE DealerNAme= 'Thomas Tyres Supa Quick'
Update DealersLive set StoreID=388 WHERE DealerNAme= 'Thomas Tyres, Ontdekkers Road'
Update DealersLive set StoreID=178 WHERE DealerNAme= 'TJ Tyres'
Update DealersLive set StoreID=179 WHERE DealerNAme= 'Trichardt Supa Quick'
Update DealersLive set StoreID=181 WHERE DealerNAme= 'Tyre & Exhaust Centre'
Update DealersLive set StoreID=182 WHERE DealerNAme= 'Tyre & Silencer Clinic'
Update DealersLive set StoreID=637 WHERE DealerNAme= 'Tzaneen Supa Quick'
Update DealersLive set StoreID=350 WHERE DealerNAme= 'Uitenhage Supa Quick'
Update DealersLive set StoreID=370 WHERE DealerNAme= 'Ulundi Supa Quick'
Update DealersLive set StoreID=506 WHERE DealerNAme= 'Umgeni Supa Quick'
Update DealersLive set StoreID=188 WHERE DealerNAme= 'Underberg Supa Quick'
Update DealersLive set StoreID=189 WHERE DealerNAme= 'Upington Supa Quick'
Update DealersLive set StoreID=265 WHERE DealerNAme= 'Van Der Hoff Supa Quick'
Update DealersLive set StoreID=192 WHERE DealerNAme= 'Volksrust Supa Quick'
Update DealersLive set StoreID=395 WHERE DealerNAme= 'Voortrekker Road Supa Quick'
Update DealersLive set StoreID=364 WHERE DealerNAme= 'Vosloorus Supa Quick'
Update DealersLive set StoreID=193 WHERE DealerNAme= 'Vredenburg Supa Quick'
Update DealersLive set StoreID=262 WHERE DealerNAme= 'Vredendal Supa Quick'
Update DealersLive set StoreID=194 WHERE DealerNAme= 'Vryburg Supa Quick'
Update DealersLive set StoreID=195 WHERE DealerNAme= 'Vryheid Supa Quick'
Update DealersLive set StoreID=652 WHERE DealerNAme= 'Walmer Supa Quick'
Update DealersLive set StoreID=650 WHERE DealerNAme= 'Waterfall Mall Supa Quick'
Update DealersLive set StoreID=196 WHERE DealerNAme= 'Welkom Supa Quick'
Update DealersLive set StoreID=198 WHERE DealerNAme= 'Wesselsbron Supa Quick'
Update DealersLive set StoreID=199 WHERE DealerNAme= 'Wheel Inn Supa Quick'
Update DealersLive set StoreID=648 WHERE DealerNAme= 'Wierda Park Supa Quick'
Update DealersLive set StoreID=158 WHERE DealerNAme= 'Windhoek Supa Quick'
Update DealersLive set StoreID=202 WHERE DealerNAme= 'Witbank Supa Quick'
Update DealersLive set StoreID=203 WHERE DealerNAme= 'Witkoppen Road Supa Quick'
Update DealersLive set StoreID=426 WHERE DealerNAme= 'Wolmaransstad Supa Quick'
Update DealersLive set StoreID=205 WHERE DealerNAme= 'Worcester Supa Quick'
Update DealersLive set StoreID=396 WHERE DealerNAme= 'Yorkstraat Supa Quick'
Update DealersLive set StoreID=167 WHERE DealerNAme= 'Zambesi Supa Quick'
Update DealersLive set StoreID=206 WHERE DealerNAme= 'Zastron Bande Supa Quick'
Update DealersLive set StoreID=638 WHERE DealerNAme= 'Zeerust Supa Quick'