Bulk Edit Countries

How do I bulk edit the countries to only display US? Currently all countries are active, however we only can sell our products in the US.

Get to your database, run this SQL command.

update NOP_Country
set Published = 0
where Name <> 'United States'

Thanks for the reply!

I will try this out tomorrow.

Thanks for this, I'll try also.

Is there a way of managing the database from within the NOP backend?  Or what's the best way of doing it?

Cheers,