declare @StoreId int;

declare @Region varchar(20);

set @StoreId = (select default_value from system_default where Default_Name = 'Main_store_id');

set @Region = (select default_value from system_default where default_name = 'Region_code');

If(@StoreId in (2,3,6,9,17,24,25,26,27,35,38,41,50,54,62,67,68,69,70,75,76,82,85,86,90,93,96,100,101,106,110,111,113,118,121,124,126,127,128,129,131,135,142,146,149,150,155,156,158,162,164,165,173,174,177,182,183,185,199,215,219,220,227,242,246,251,262,276))
begin

update SystemSetting set SettingValueDecimal = '0.00' where SettingKey = 'StandardAvailability';

Update SystemSetting set SettingValueDecimal = '0.00' where SettingKey = 'KeylineAvailability';

update SystemSetting set SettingValueDecimal = '0.00' where SettingKey = 'PromoAvailability';

update SystemSetting set SettingValueBit = 0 where SettingKey in ('ReorderBulkingPeriod','IsBulkingSeason');

update SystemSetting set SettingValueBit = 0 where SettingKey = 'FIC';

end;



if (@Region != 'SADC')
begin
update seller set countryid = NULL where CountryId <> 1;
end