How to close store with sql command?

how to close store with sql comand?

I tried
update [Setting]  set value = 'True' where name= 'storeinformationsettings.storeclosed'

but seems like I am missing something

The settings are cached, if you change it directly in the database, you'll have to wait until they expire in the httpruntime cache.

EDIT: as mentionned by AndyMcKenna, if you're allowed some other interactions than sql commands in your scenario, there are ways to force the cache to be cleared.

asoares wrote:

Couldn't you restart the application or IIS to force that?

Seems like Clear Cache is what you need:

https://www.nopcommerce.com/boards/t/17357/what-are-clear-cache-and-restart-application.aspx

AndyMcKenna wrote:

Yes you're right, my answer was in respect to closing the store using a sql command. But if the person can take another action, the ones you suggested definitely work. Maybe if we know the whole scenario behind the original question we can provide a better answer :)

can it be dome programatically?
I am doing import program, and would like it to close the store firt, do the import and open store again.

nopAndrew wrote:
Hi
Sure you can do it programatically like a cron in sql job comment . So ll close and u do whatever then ll open .