Living in your retail store

It's very doable indeed @aaronrulz - I made Malcolm open a furniture store once and he had to stay there until he paid back the family fortune which he used to start the store. It was fun - he did everything but go out. He even had clubs over and gave them access to the locked rooms. Nancy used to come over and help in the store sometimes when he was too tired from club activities. She would leave when it was time for work and not come back until I summoned her.

Some tips

Remember to have a private bathroom in the store that's locked so he won't have to go upstairs to bath or so forth.
Have a buffet table and provide food and drinks sometimes - some clients will buy without your sim chatting them up.