Yeah it's a nightmare. And you can only repeal in your own neighborhood so if you have a restaurant you're stuffed. Only way around it is to turn off NAPs in settings, place a household in the same neighborhood and repeal all the active NAPs.
I had the same in my sims restaurant the other day, sims didn't sit and eat they just walked around taking everything. I lost the piano, half the tables, half the dividers, the restaurant was getting to the stage of being non functional within one shift. Really not sure who in their right mind thought this NAP was a good idea. No matter what it's annoying, I can't find any positive about every lot being destroyed by looting.