Dumping sql to check for overlap. If this block produces any records, be careful! - Total records: 510

SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` > 9999 and `merchant_id` < 10500;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 270;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 223;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1093;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 980;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1238;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1254;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1256;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1281;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1253;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1255;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1240;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1243;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1239;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1237;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 522;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1079;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1007;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 942;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 512;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1126;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 513;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 226;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 227;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 753;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 514;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1225;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1212;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1276;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 940;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 516;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 518;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 519;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 955;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 228;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 902;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 805;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 523;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1251;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 524;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1252;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 964;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 968;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 525;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 755;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 827;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 526;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 231;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 793;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1136;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 468;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 232;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 530;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 531;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 532;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1125;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 535;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1080;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 884;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 756;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1099;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 757;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 203;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 536;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 537;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 538;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 792;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1046;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 539;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 540;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1081;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1160;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 398;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1220;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 932;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 544;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1043;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 545;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1066;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 546;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1247;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1264;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 548;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1071;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 549;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 758;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1044;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 806;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1115;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 550;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 551;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 235;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 552;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 554;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1141;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 236;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1098;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1078;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 556;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1067;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 557;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 558;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 559;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1224;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1195;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1143;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 563;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1076;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1096;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1039;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1258;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 813;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1100;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 566;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 814;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 568;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1037;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1048;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1166;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1196;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 569;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 570;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 571;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 572;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 575;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1142;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 573;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 903;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1127;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 943;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 574;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 576;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 577;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1101;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1082;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 578;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 579;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1075;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 580;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 581;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1151;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 313;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1036;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1054;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 949;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 582;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 205;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 196;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 997;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1058;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 584;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 830;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 585;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 276;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 587;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 588;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 589;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 817;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1211;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1047;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 592;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 818;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1269;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 560;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1176;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 207;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 594;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1084;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 831;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1083;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1045;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1279;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 400;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 595;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 596;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 832;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1163;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 761;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1250;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1102;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1140;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 598;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1062;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1103;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1257;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1119;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1273;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1171;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1085;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1215;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 602;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 833;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1161;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 911;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1275;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 802;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 603;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 948;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1113;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1271;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 762;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 240;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 378;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 605;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 217;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1197;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1209;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 241;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 607;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 608;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1094;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 904;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1123;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1227;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 451;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 242;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1051;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 613;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 616;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 617;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 618;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 936;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 619;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 620;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 905;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1219;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 623;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 336;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1064;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1049;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 401;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 935;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 208;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 934;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 765;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1132;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 834;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1073;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1041;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1259;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 626;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1118;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1169;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 766;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 835;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 790;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 629;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1199;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 630;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 631;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1061;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 947;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1159;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 634;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1050;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1128;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1158;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 768;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1154;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1150;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 636;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 637;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 795;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 640;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 642;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 643;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 769;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 770;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 644;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 450;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 464;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 908;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1213;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1072;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 648;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 837;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 838;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 771;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 772;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1236;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 244;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 839;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 763;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1042;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 246;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1086;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1040;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 649;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 650;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 247;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1106;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 651;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1249;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1000;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 325;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 653;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1156;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1068;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 709;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1144;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1173;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 804;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 655;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 654;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1155;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 840;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1074;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 656;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 657;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1246;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 210;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 658;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 659;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1097;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1153;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 312;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1172;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 774;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1022;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1162;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 661;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 663;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 197;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 775;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 489;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 666;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1175;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1179;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1117;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 388;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 946;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1244;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 402;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1063;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 211;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 465;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 668;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1282;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 930;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1069;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 776;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 399;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 670;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 671;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 987;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 252;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 284;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 815;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 674;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1087;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 675;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 676;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 677;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 929;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1129;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 841;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1057;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1131;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 679;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1145;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 777;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1245;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 681;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1107;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 682;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1060;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 684;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 686;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1108;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1266;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1109;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 812;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1052;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1088;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 689;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 778;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1221;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 928;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1070;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 690;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 779;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 791;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1110;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1077;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 691;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 692;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 950;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1038;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1065;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 780;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 693;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 368;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 781;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 799;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1116;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 695;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 696;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 697;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 810;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 698;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 926;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1089;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1214;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 701;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 256;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 966;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1152;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1168;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 257;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 706;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1146;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1274;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 907;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1201;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 586;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 286;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 823;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1134;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 707;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1138;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 710;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1177;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 288;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 809;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1272;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1277;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 843;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 214;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 712;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 998;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 713;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 782;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 816;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 807;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1210;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 290;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 718;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 719;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1130;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 941;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 808;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1090;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1164;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1133;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1139;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 260;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1105;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1280;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 783;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1095;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 999;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 721;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 722;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1267;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1135;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 724;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1170;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1226;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 784;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1198;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 803;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 732;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1091;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 734;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1248;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 927;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 883;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1137;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 847;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 735;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1053;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 785;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 736;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 786;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 737;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1174;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 787;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 266;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 739;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1270;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1265;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1121;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 741;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 216;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1167;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1268;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 985;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 811;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 849;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1122;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1157;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1055;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 746;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1056;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1202;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1059;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1278;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 220;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 910;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 748;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1165;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1092;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1241;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1242;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 820;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 945;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1111;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1184;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1178;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 1120;
SELECT * FROM `wp_buyvia_coupons` WHERE `merchant_id` = 789;

Renumbering sql - execute to renumber all store's merchant_id into correct Vendor ID
Total records:510

UPDATE `wp_buyvia_coupons` SET `merchant_id`=270 WHERE `merchant_name` = "1and1";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=223 WHERE `merchant_name` = "6pm (Amazon Company)";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1093 WHERE `merchant_name` = "7-Eleven";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=980 WHERE `merchant_name` = "A Black Friday";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1238 WHERE `merchant_name` = "A Black Friday Calendar";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1254 WHERE `merchant_name` = "A Black Friday Deal - Laptops";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1256 WHERE `merchant_name` = "A Black Friday Deal - Smartphone";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1281 WHERE `merchant_name` = "A Black Friday Deal - Smartwatch";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1253 WHERE `merchant_name` = "A Black Friday Deal - TV";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1255 WHERE `merchant_name` = "A Black Friday Deal - Video Games";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1240 WHERE `merchant_name` = "A Black Friday Giveaway";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1243 WHERE `merchant_name` = "A Black Friday Newsletter";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1239 WHERE `merchant_name` = "A Black Friday Notified";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1237 WHERE `merchant_name` = "A Cyber Monday";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=522 WHERE `merchant_name` = "A Pea in the Pod";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1079 WHERE `merchant_name` = "A&W";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1007 WHERE `merchant_name` = "A4C";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=942 WHERE `merchant_name` = "AAFES";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=512 WHERE `merchant_name` = "Abercrombie & Fitch";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1126 WHERE `merchant_name` = "Academy Sports";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=513 WHERE `merchant_name` = "Ace Hardware";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=226 WHERE `merchant_name` = "Adidas";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=227 WHERE `merchant_name` = "Adorama";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=753 WHERE `merchant_name` = "Advance Auto Parts";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=514 WHERE `merchant_name` = "Aeropostale";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1225 WHERE `merchant_name` = "Albertsons";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1212 WHERE `merchant_name` = "Aldi";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1276 WHERE `merchant_name` = "All Birds";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=940 WHERE `merchant_name` = "Amazon";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=516 WHERE `merchant_name` = "AMC Theatres";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=518 WHERE `merchant_name` = "American Eagle Outfitters";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=519 WHERE `merchant_name` = "Ann Taylor";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=955 WHERE `merchant_name` = "Apple";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=228 WHERE `merchant_name` = "Apple iTunes";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=902 WHERE `merchant_name` = "Applebees";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=805 WHERE `merchant_name` = "Arbys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=523 WHERE `merchant_name` = "Armani Exchange";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1251 WHERE `merchant_name` = "Ashley Furniture";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=524 WHERE `merchant_name` = "ASOS.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1252 WHERE `merchant_name` = "At Home";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=964 WHERE `merchant_name` = "AT&T";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=968 WHERE `merchant_name` = "ATT Wireless";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=525 WHERE `merchant_name` = "Au Bon Pain";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=755 WHERE `merchant_name` = "Audible";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=827 WHERE `merchant_name` = "Auntie Annes";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=526 WHERE `merchant_name` = "AutoZone";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=231 WHERE `merchant_name` = "B&H Photo";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=793 WHERE `merchant_name` = "backcountry.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1136 WHERE `merchant_name` = "Baja Fresh";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=468 WHERE `merchant_name` = "Banana Republic";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=232 WHERE `merchant_name` = "Barnes & Noble";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=530 WHERE `merchant_name` = "Baskin Robbins";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=531 WHERE `merchant_name` = "Bass Pro Shops";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=532 WHERE `merchant_name` = "Bath & Body Works";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1125 WHERE `merchant_name` = "Bealls";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=535 WHERE `merchant_name` = "Bed Bath & Beyond";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1080 WHERE `merchant_name` = "Beef O Bradys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=884 WHERE `merchant_name` = "Belk";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=756 WHERE `merchant_name` = "Belkin";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1099 WHERE `merchant_name` = "Benihana";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=757 WHERE `merchant_name` = "Bergdorf Goodman";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=203 WHERE `merchant_name` = "Best Buy";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=536 WHERE `merchant_name` = "Big 5 Sporting Goods";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=537 WHERE `merchant_name` = "Big Lots";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=538 WHERE `merchant_name` = "Big O Tires";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=792 WHERE `merchant_name` = "bikeNashbar.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1046 WHERE `merchant_name` = "BJs Restaurants";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=539 WHERE `merchant_name` = "BJs Wholesale Club";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=540 WHERE `merchant_name` = "Black Angus";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1081 WHERE `merchant_name` = "Blaze Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1160 WHERE `merchant_name` = "Blimpie";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=398 WHERE `merchant_name` = "Bloomingdales";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1220 WHERE `merchant_name` = "Blue Apron";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=932 WHERE `merchant_name` = "Blue Nile";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=544 WHERE `merchant_name` = "Bob Evans";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1043 WHERE `merchant_name` = "Bojangles";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=545 WHERE `merchant_name` = "Bon-Ton";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1066 WHERE `merchant_name` = "Bonefish Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=546 WHERE `merchant_name` = "Boston Market";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1247 WHERE `merchant_name` = "BrandsMart USA";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1264 WHERE `merchant_name` = "Brio Tuscan Grille";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=548 WHERE `merchant_name` = "Brooks Brothers Factory Store";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1071 WHERE `merchant_name` = "Bruegger's Bagels";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=549 WHERE `merchant_name` = "Buca di Beppo";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=758 WHERE `merchant_name` = "Budget";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1044 WHERE `merchant_name` = "Buffalo Wild Wings";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=806 WHERE `merchant_name` = "Burger King";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1115 WHERE `merchant_name` = "BurgerFi";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=550 WHERE `merchant_name` = "Burlington";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=551 WHERE `merchant_name` = "Buy Buy Baby";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=235 WHERE `merchant_name` = "Buydig.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=552 WHERE `merchant_name` = "Cabelas";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=554 WHERE `merchant_name` = "Cacique";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1141 WHERE `merchant_name` = "California Pizza Kitchen";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=236 WHERE `merchant_name` = "Canon";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1098 WHERE `merchant_name` = "Captain D's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1078 WHERE `merchant_name` = "Caribou Coffee";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=556 WHERE `merchant_name` = "Carls Jr.";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1067 WHERE `merchant_name` = "Carrabbas";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=557 WHERE `merchant_name` = "Carrows";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=558 WHERE `merchant_name` = "Carters";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=559 WHERE `merchant_name` = "Carvel";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1224 WHERE `merchant_name` = "Casey's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1195 WHERE `merchant_name` = "Caviar";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1143 WHERE `merchant_name` = "Charleys Philly Steaks";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=563 WHERE `merchant_name` = "charlotte russe";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1076 WHERE `merchant_name` = "Checkers";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1096 WHERE `merchant_name` = "Cheddars Scratch Kitchen";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1039 WHERE `merchant_name` = "Cheesecake Factory";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1258 WHERE `merchant_name` = "Chewy";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=813 WHERE `merchant_name` = "Chick-fil-A";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1100 WHERE `merchant_name` = "Chicken Express";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=566 WHERE `merchant_name` = "Chilis";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=814 WHERE `merchant_name` = "Chipotle";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=568 WHERE `merchant_name` = "Chuck E Cheeses";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1037 WHERE `merchant_name` = "Church's Chicken";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1048 WHERE `merchant_name` = "Cicis";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1166 WHERE `merchant_name` = "Cinnabon";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1196 WHERE `merchant_name` = "Claim Jumper";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=569 WHERE `merchant_name` = "Claires";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=570 WHERE `merchant_name` = "Clarks";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=571 WHERE `merchant_name` = "Coach";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=572 WHERE `merchant_name` = "Coach Outlet";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=575 WHERE `merchant_name` = "Cocos Bakery";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1142 WHERE `merchant_name` = "Cold Stone Creamery";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=573 WHERE `merchant_name` = "Cole Haan";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=903 WHERE `merchant_name` = "Columbia";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1127 WHERE `merchant_name` = "Conns";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=943 WHERE `merchant_name` = "Converse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=574 WHERE `merchant_name` = "Corner Bakery Cafe";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=576 WHERE `merchant_name` = "Cost Plus World Market";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=577 WHERE `merchant_name` = "Costco";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1101 WHERE `merchant_name` = "Cousins Subs";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1082 WHERE `merchant_name` = "Cracker Barrel";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=578 WHERE `merchant_name` = "Crate & Barrel";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=579 WHERE `merchant_name` = "Crocs";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1075 WHERE `merchant_name` = "Culver's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=580 WHERE `merchant_name` = "CVS";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=581 WHERE `merchant_name` = "CVS Photo";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1151 WHERE `merchant_name` = "D'Angelo";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=313 WHERE `merchant_name` = "Daily Steals";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1036 WHERE `merchant_name` = "Dairy Queen";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1054 WHERE `merchant_name` = "Dave & Busters";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=949 WHERE `merchant_name` = "DC Shoes";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=582 WHERE `merchant_name` = "Del Taco";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=205 WHERE `merchant_name` = "Dell Refurbished Computers";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=196 WHERE `merchant_name` = "Dell Technologies";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=997 WHERE `merchant_name` = "Dennys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1058 WHERE `merchant_name` = "Dickeys Barbecue Pit";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=584 WHERE `merchant_name` = "Dicks Sporting Goods";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=830 WHERE `merchant_name` = "Dillards";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=585 WHERE `merchant_name` = "Discount Tire";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=276 WHERE `merchant_name` = "DiscountMags.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=587 WHERE `merchant_name` = "DKNY";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=588 WHERE `merchant_name` = "Dollar General";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=589 WHERE `merchant_name` = "Dollar Tree";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=817 WHERE `merchant_name` = "Dominos Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1211 WHERE `merchant_name` = "Donatos Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1047 WHERE `merchant_name` = "DoorDash";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=592 WHERE `merchant_name` = "Dunham's Sports";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=818 WHERE `merchant_name` = "Dunkin Donuts";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1269 WHERE `merchant_name` = "Dutch Bros";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=560 WHERE `merchant_name` = "DXL";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1176 WHERE `merchant_name` = "East Coast Wings & Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=207 WHERE `merchant_name` = "Ebay";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=594 WHERE `merchant_name` = "Eddie Bauer";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1084 WHERE `merchant_name` = "Edible Arrangements";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=831 WHERE `merchant_name` = "Eileen Fisher";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1083 WHERE `merchant_name` = "Einstein Bros Bagels";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1045 WHERE `merchant_name` = "El Pollo Loco";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1279 WHERE `merchant_name` = "Etsy";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=400 WHERE `merchant_name` = "Expedia";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=595 WHERE `merchant_name` = "Express";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=596 WHERE `merchant_name` = "Family Christian Store";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=832 WHERE `merchant_name` = "Family Dollar";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1163 WHERE `merchant_name` = "Famous Dave's BBQ";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=761 WHERE `merchant_name` = "Fandango";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1250 WHERE `merchant_name` = "Farm & Home Supply";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1102 WHERE `merchant_name` = "Fatz";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1140 WHERE `merchant_name` = "Fazolis";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=598 WHERE `merchant_name` = "Finish Line";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1062 WHERE `merchant_name` = "Firehouse Subs";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1103 WHERE `merchant_name` = "First Watch";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1257 WHERE `merchant_name` = "Five Below";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1119 WHERE `merchant_name` = "Five Guys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1273 WHERE `merchant_name` = "Fleet Farm";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1171 WHERE `merchant_name` = "Flemings Steakhouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1085 WHERE `merchant_name` = "Fogo de Chao";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1215 WHERE `merchant_name` = "Food Lion";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=602 WHERE `merchant_name` = "Forever 21";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=833 WHERE `merchant_name` = "Fossil";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1161 WHERE `merchant_name` = "Fox's Pizza Den";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=911 WHERE `merchant_name` = "Foxconnect";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1275 WHERE `merchant_name` = "Fred Meyer";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=802 WHERE `merchant_name` = "FreedomPop";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=603 WHERE `merchant_name` = "Friendlys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=948 WHERE `merchant_name` = "Frontgate";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1113 WHERE `merchant_name` = "Fuddruckers";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1271 WHERE `merchant_name` = "Fuzzys Taco Shop";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=762 WHERE `merchant_name` = "Gaiam";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=240 WHERE `merchant_name` = "Gamestop";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=378 WHERE `merchant_name` = "Gap";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=605 WHERE `merchant_name` = "Gap Outlet";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=217 WHERE `merchant_name` = "General Vendor";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1197 WHERE `merchant_name` = "Genghis Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1209 WHERE `merchant_name` = "Gobble";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=241 WHERE `merchant_name` = "GoDaddy.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=607 WHERE `merchant_name` = "Godfather's Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=608 WHERE `merchant_name` = "Godiva";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1094 WHERE `merchant_name` = "Golden Corral";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=904 WHERE `merchant_name` = "Google Play";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1123 WHERE `merchant_name` = "Google Store";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1227 WHERE `merchant_name` = "GoPuff";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=451 WHERE `merchant_name` = "Green Man Gaming";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=242 WHERE `merchant_name` = "Groupon";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1051 WHERE `merchant_name` = "Grubhub";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=613 WHERE `merchant_name` = "Guess Factory Store";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=616 WHERE `merchant_name` = "H&M";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=617 WHERE `merchant_name` = "Hallmark";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=618 WHERE `merchant_name` = "Hancock Fabrics";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=936 WHERE `merchant_name` = "Hanes";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=619 WHERE `merchant_name` = "Harbor Freight Tools";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=620 WHERE `merchant_name` = "Hardees";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=905 WHERE `merchant_name` = "Harman";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1219 WHERE `merchant_name` = "Hello Fresh";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=623 WHERE `merchant_name` = "Hobby Lobby";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=336 WHERE `merchant_name` = "Home Depot";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1064 WHERE `merchant_name` = "Honey Baked Ham";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1049 WHERE `merchant_name` = "Hooters";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=401 WHERE `merchant_name` = "Hotels.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=935 WHERE `merchant_name` = "Hotwire";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=208 WHERE `merchant_name` = "HP Home";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=934 WHERE `merchant_name` = "HR Block";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=765 WHERE `merchant_name` = "HSN";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1132 WHERE `merchant_name` = "Huddle House";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=834 WHERE `merchant_name` = "Hugo Boss";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1073 WHERE `merchant_name` = "Hungry Howies";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1041 WHERE `merchant_name` = "IHOP";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1259 WHERE `merchant_name` = "Ike's Sandwiches";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=626 WHERE `merchant_name` = "Ikea";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1118 WHERE `merchant_name` = "In and Out Burger";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1169 WHERE `merchant_name` = "Insomnia Cookies";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=766 WHERE `merchant_name` = "invisibleSHIELD";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=835 WHERE `merchant_name` = "Izod Outlet";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=790 WHERE `merchant_name` = "J.Crew Factory Store";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=629 WHERE `merchant_name` = "Jack in the Box";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1199 WHERE `merchant_name` = "Jack's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=630 WHERE `merchant_name` = "Jamba Juice";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=631 WHERE `merchant_name` = "JCPenney";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1061 WHERE `merchant_name` = "Jersey Mike's Subs";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=947 WHERE `merchant_name` = "Jet.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1159 WHERE `merchant_name` = "Jet's Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=634 WHERE `merchant_name` = "Jiffy Lube";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1050 WHERE `merchant_name` = "Jimmy Johns";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1128 WHERE `merchant_name` = "Jo Ann";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1158 WHERE `merchant_name` = "Joe & The Juice";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=768 WHERE `merchant_name` = "Joe's New Balance Outlet";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1154 WHERE `merchant_name` = "Joes Crab Shack";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1150 WHERE `merchant_name` = "Johnny Rockets";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=636 WHERE `merchant_name` = "Jos. A. Bank";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=637 WHERE `merchant_name` = "Journeys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=795 WHERE `merchant_name` = "Jurlique";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=640 WHERE `merchant_name` = "Kate Spade New York";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=642 WHERE `merchant_name` = "Kenneth Cole";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=643 WHERE `merchant_name` = "KFC";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=769 WHERE `merchant_name` = "Kiehls";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=770 WHERE `merchant_name` = "Kipling";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=644 WHERE `merchant_name` = "Kirkland's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=450 WHERE `merchant_name` = "Kmart";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=464 WHERE `merchant_name` = "Kohls";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=908 WHERE `merchant_name` = "Krispy Kreme";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1213 WHERE `merchant_name` = "Kroger";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1072 WHERE `merchant_name` = "Krystal";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=648 WHERE `merchant_name` = "L.L.Bean";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=837 WHERE `merchant_name` = "Lacoste";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=838 WHERE `merchant_name` = "Lady Foot Locker";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=771 WHERE `merchant_name` = "Lands End";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=772 WHERE `merchant_name` = "Lee Jeans";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1236 WHERE `merchant_name` = "Lego";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=244 WHERE `merchant_name` = "Lenovo";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=839 WHERE `merchant_name` = "Levis";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=763 WHERE `merchant_name` = "Lids";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1042 WHERE `merchant_name` = "Little Caesars";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=246 WHERE `merchant_name` = "LivingSocial";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1086 WHERE `merchant_name` = "Logans Roadhouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1040 WHERE `merchant_name` = "Long John Silver's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=649 WHERE `merchant_name` = "Longhorn Steakhouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=650 WHERE `merchant_name` = "Lord & Taylor";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=247 WHERE `merchant_name` = "Lowes";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1106 WHERE `merchant_name` = "Lubys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=651 WHERE `merchant_name` = "Lucky Brand";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1249 WHERE `merchant_name` = "Lululemon";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1000 WHERE `merchant_name` = "Macaroni Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=325 WHERE `merchant_name` = "Macys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=653 WHERE `merchant_name` = "Maidenform";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1156 WHERE `merchant_name` = "Marcos Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1068 WHERE `merchant_name` = "Marie Callenders";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=709 WHERE `merchant_name` = "Mattress Firm";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1144 WHERE `merchant_name` = "McAlister's Deli";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1173 WHERE `merchant_name` = "McCormick & Schmick's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=804 WHERE `merchant_name` = "McDonalds";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=655 WHERE `merchant_name` = "Meijer";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=654 WHERE `merchant_name` = "Meineke Car Care";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1155 WHERE `merchant_name` = "Mellow Mushroom";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=840 WHERE `merchant_name` = "Menards";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1074 WHERE `merchant_name` = "Menchies";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=656 WHERE `merchant_name` = "Mens Wearhouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=657 WHERE `merchant_name` = "Michaels";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1246 WHERE `merchant_name` = "Micro Center";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=210 WHERE `merchant_name` = "Microsoft Store";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=658 WHERE `merchant_name` = "Midas";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=659 WHERE `merchant_name` = "Mimis Cafe";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1097 WHERE `merchant_name` = "MOD Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1153 WHERE `merchant_name` = "Moes Southwest Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=312 WHERE `merchant_name` = "Monoprice";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1172 WHERE `merchant_name` = "Morton's The Steakhouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=774 WHERE `merchant_name` = "Motorola";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1022 WHERE `merchant_name` = "Mountain Hardwear";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1162 WHERE `merchant_name` = "Mountain Mikes Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=661 WHERE `merchant_name` = "Nautica";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=663 WHERE `merchant_name` = "Neiman Marcus Last Call";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=197 WHERE `merchant_name` = "Newegg.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=775 WHERE `merchant_name` = "NeweggFlash";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=489 WHERE `merchant_name` = "Nike";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=666 WHERE `merchant_name` = "Nine West";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1175 WHERE `merchant_name` = "Ninety Nine Restaurant";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1179 WHERE `merchant_name` = "Noahs Bagel";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1117 WHERE `merchant_name` = "Noodles & Company";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=388 WHERE `merchant_name` = "Nordstrom";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=946 WHERE `merchant_name` = "Nordstrom Rack";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1244 WHERE `merchant_name` = "Northern Tool";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=402 WHERE `merchant_name` = "Oakley";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1063 WHERE `merchant_name` = "OCharleys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=211 WHERE `merchant_name` = "Office Depot and OfficeMax";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=465 WHERE `merchant_name` = "Old Navy";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=668 WHERE `merchant_name` = "Olive Garden";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1282 WHERE `merchant_name` = "Ollies Bargain Outlet";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=930 WHERE `merchant_name` = "Omaha Steaks";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1069 WHERE `merchant_name` = "On The Border";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=776 WHERE `merchant_name` = "Oneida";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=399 WHERE `merchant_name` = "Orbitz";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=670 WHERE `merchant_name` = "Origins";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=671 WHERE `merchant_name` = "OSH";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=987 WHERE `merchant_name` = "Outback Steakhouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=252 WHERE `merchant_name` = "Overstock";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=284 WHERE `merchant_name` = "Panasonic";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=815 WHERE `merchant_name` = "Panda Express";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=674 WHERE `merchant_name` = "Panera Bread";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1087 WHERE `merchant_name` = "Papa Gino's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=675 WHERE `merchant_name` = "Papa Johns Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=676 WHERE `merchant_name` = "Papa Murphys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=677 WHERE `merchant_name` = "Party City";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=929 WHERE `merchant_name` = "Patagonia";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1129 WHERE `merchant_name` = "PC Richard and Son";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=841 WHERE `merchant_name` = "Peets Coffee & Tea";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1057 WHERE `merchant_name` = "Pei Wei";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1131 WHERE `merchant_name` = "Penn Station East Coast Subs";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=679 WHERE `merchant_name` = "Pep Boys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1145 WHERE `merchant_name` = "Perkins Family Restaurant & Bakery";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=777 WHERE `merchant_name` = "Perry Ellis";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1245 WHERE `merchant_name` = "Pet Supplies Plus";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=681 WHERE `merchant_name` = "Petco";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1107 WHERE `merchant_name` = "Peter Piper Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=682 WHERE `merchant_name` = "Petsmart";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1060 WHERE `merchant_name` = "PF Changs";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=684 WHERE `merchant_name` = "Piercing Pagoda";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=686 WHERE `merchant_name` = "Pizza Hut";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1108 WHERE `merchant_name` = "Pizza Ranch";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1266 WHERE `merchant_name` = "Pollo Tropical";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1109 WHERE `merchant_name` = "Ponderosa Steakhouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=812 WHERE `merchant_name` = "Popeyes";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1052 WHERE `merchant_name` = "Postmates";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1088 WHERE `merchant_name` = "Potbelly Sandwich Shop";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=689 WHERE `merchant_name` = "Precision Tune Auto Care";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=778 WHERE `merchant_name` = "Priceline";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1221 WHERE `merchant_name` = "Publix";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=928 WHERE `merchant_name` = "PUMA";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1070 WHERE `merchant_name` = "Qdoba Mexican Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=690 WHERE `merchant_name` = "Quiznos";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=779 WHERE `merchant_name` = "QVC";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=791 WHERE `merchant_name` = "Raise";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1110 WHERE `merchant_name` = "Raising Cane's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1077 WHERE `merchant_name` = "Rallys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=691 WHERE `merchant_name` = "Ralph Lauren";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=692 WHERE `merchant_name` = "Ralph Lauren Factory Store";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=950 WHERE `merchant_name` = "Rebecca Minkoff";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1038 WHERE `merchant_name` = "Red Lobster";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1065 WHERE `merchant_name` = "Red Robin";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=780 WHERE `merchant_name` = "Redbox";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=693 WHERE `merchant_name` = "Reebok";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=368 WHERE `merchant_name` = "REI";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=781 WHERE `merchant_name` = "Republic Wireless";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=799 WHERE `merchant_name` = "Restaurant.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1116 WHERE `merchant_name` = "Ritas Ice Custard Happiness";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=695 WHERE `merchant_name` = "Rite Aid";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=696 WHERE `merchant_name` = "Rockport";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=697 WHERE `merchant_name` = "Ross Dress for Less";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=810 WHERE `merchant_name` = "Round Table Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=698 WHERE `merchant_name` = "Rubios";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=926 WHERE `merchant_name` = "Ruby Tuesday";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1089 WHERE `merchant_name` = "Ruths Chris Steak House";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1214 WHERE `merchant_name` = "Safeway";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=701 WHERE `merchant_name` = "Saks Fifth Avenue OFF 5TH";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=256 WHERE `merchant_name` = "Sams Club";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=966 WHERE `merchant_name` = "Samsung";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1152 WHERE `merchant_name` = "Schlotzsky's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1168 WHERE `merchant_name` = "Seamless";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=257 WHERE `merchant_name` = "Sears";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=706 WHERE `merchant_name` = "Sephora";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1146 WHERE `merchant_name` = "Shake Shack";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1274 WHERE `merchant_name` = "Shein";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=907 WHERE `merchant_name` = "Shoes.com";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1201 WHERE `merchant_name` = "Shoneys Restaurant";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=586 WHERE `merchant_name` = "Shop Disney";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=286 WHERE `merchant_name` = "Shutterfly";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=823 WHERE `merchant_name` = "Sierra Trading Post";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1134 WHERE `merchant_name` = "Sizzler";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=707 WHERE `merchant_name` = "Skechers";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1138 WHERE `merchant_name` = "Smashburger";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=710 WHERE `merchant_name` = "Smokey Bones Bar & Fire Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1177 WHERE `merchant_name` = "Smoothie King";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=288 WHERE `merchant_name` = "Snapfish";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=809 WHERE `merchant_name` = "Sonic";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1272 WHERE `merchant_name` = "Sonnys BBQ";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1277 WHERE `merchant_name` = "Sonos";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=843 WHERE `merchant_name` = "Sport Chalet";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=214 WHERE `merchant_name` = "Staples";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=712 WHERE `merchant_name` = "Starbucks";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=998 WHERE `merchant_name` = "Steak n Shake";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=713 WHERE `merchant_name` = "Stein Mart";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=782 WHERE `merchant_name` = "Straight Talk";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=816 WHERE `merchant_name` = "Straw Hat Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=807 WHERE `merchant_name` = "Subway";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1210 WHERE `merchant_name` = "Sunbasket";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=290 WHERE `merchant_name` = "SuperMediaStore";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=718 WHERE `merchant_name` = "Swarovski";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=719 WHERE `merchant_name` = "Swatch";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1130 WHERE `merchant_name` = "Sweetgreen";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=941 WHERE `merchant_name` = "T-Mobile";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=808 WHERE `merchant_name` = "Taco Bell";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1090 WHERE `merchant_name` = "Taco Bueno";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1164 WHERE `merchant_name` = "Taco Cabana";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1133 WHERE `merchant_name` = "Taco John's";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1139 WHERE `merchant_name` = "Taco Time";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=260 WHERE `merchant_name` = "Target";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1105 WHERE `merchant_name` = "TCBY";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1280 WHERE `merchant_name` = "Temu";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=783 WHERE `merchant_name` = "Teva Footwear";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1095 WHERE `merchant_name` = "Texas Roadhouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=999 WHERE `merchant_name` = "TGI Fridays";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=721 WHERE `merchant_name` = "The Body Shop";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=722 WHERE `merchant_name` = "The Childrens Place";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1267 WHERE `merchant_name` = "The Coffee Bean & Tea Leaf";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1135 WHERE `merchant_name` = "The Habit Burger Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=724 WHERE `merchant_name` = "The North Face";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1170 WHERE `merchant_name` = "The Spaghetti Warehouse";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1226 WHERE `merchant_name` = "Tijuana Flats";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=784 WHERE `merchant_name` = "Tillys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1198 WHERE `merchant_name` = "Tim Hortons";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=803 WHERE `merchant_name` = "TinyPrints";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=732 WHERE `merchant_name` = "TJ Maxx";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1091 WHERE `merchant_name` = "Togos";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=734 WHERE `merchant_name` = "Tory Burch";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1248 WHERE `merchant_name` = "Tractor Supply";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=927 WHERE `merchant_name` = "Travelocity";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=883 WHERE `merchant_name` = "True Value";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1137 WHERE `merchant_name` = "Tubbys Grilled Submarines";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=847 WHERE `merchant_name` = "Tuesday Morning";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=735 WHERE `merchant_name` = "Tully's Coffee";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1053 WHERE `merchant_name` = "UberEATS";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=785 WHERE `merchant_name` = "UGG";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=736 WHERE `merchant_name` = "Ulta Beauty";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=786 WHERE `merchant_name` = "Under Armour";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=737 WHERE `merchant_name` = "UNIQLO";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1174 WHERE `merchant_name` = "Uno Pizzeria & Grill";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=787 WHERE `merchant_name` = "Vera Bradley";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=266 WHERE `merchant_name` = "Verizon Wireless";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=739 WHERE `merchant_name` = "Victorias Secret";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1270 WHERE `merchant_name` = "Village Inn";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1265 WHERE `merchant_name` = "Vocelli Pizza";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1121 WHERE `merchant_name` = "Waffle House";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=741 WHERE `merchant_name` = "Walgreens";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=216 WHERE `merchant_name` = "Walmart";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1167 WHERE `merchant_name` = "Wawa";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1268 WHERE `merchant_name` = "Wayback Burgers";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=985 WHERE `merchant_name` = "Wayfair";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=811 WHERE `merchant_name` = "Wendys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=849 WHERE `merchant_name` = "Wetzels Pretzels";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1122 WHERE `merchant_name` = "Whataburger";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1157 WHERE `merchant_name` = "Which Wich";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1055 WHERE `merchant_name` = "White Castle";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=746 WHERE `merchant_name` = "Whole Foods";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1056 WHERE `merchant_name` = "Wienerschnitzel";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1202 WHERE `merchant_name` = "Wing Zone";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1059 WHERE `merchant_name` = "Wingstop";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1278 WHERE `merchant_name` = "Wish";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=220 WHERE `merchant_name` = "Woot (Amazon Company)";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=910 WHERE `merchant_name` = "Xtremeguard";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=748 WHERE `merchant_name` = "Yankee Candle";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1165 WHERE `merchant_name` = "Yard House";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1092 WHERE `merchant_name` = "Yogurtland";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1241 WHERE `merchant_name` = "Z Black Friday";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1242 WHERE `merchant_name` = "Z Cyber Monday";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=820 WHERE `merchant_name` = "Zagg";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=945 WHERE `merchant_name` = "Zappos";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1111 WHERE `merchant_name` = "Zaxbys";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1184 WHERE `merchant_name` = "Zenni Optical";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1178 WHERE `merchant_name` = "Zoes Kitchen";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=1120 WHERE `merchant_name` = "Zoup";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=789 WHERE `merchant_name` = "Zulily";

Looking for merchant_id=0
Run this after you have executed the above SQL.
Dumping sql to renumber Coupon Table merchant_id = 0 - Total records: 5

UPDATE `wp_buyvia_coupons` SET `merchant_id`=10000 WHERE `merchant_name` = "Bush's Chicken!";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=10001 WHERE `merchant_name` = "Dave's Hot Chicken";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=10002 WHERE `merchant_name` = "Pollo Campero";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=10003 WHERE `merchant_name` = "Walk-Ons Sports Bistreaux";
UPDATE `wp_buyvia_coupons` SET `merchant_id`=10004 WHERE `merchant_name` = "White Castle";