I am working on a multi-store solution(all using same products) and at the moment am going down the multi(sub)domain route, which I dont like because I dont have overview of all data and I have to export products to each of 7 store subdomain dbs.
It would be much better if it could be in one db.

A simple solution could be to set an order prefix based on which store is selected then each store could have a role with access only to a certain prefix and admin order views etc could be limited to a specific prefix.
I think your module sets up one prefix for use for all orders.
Could this solution be achieved using this module... if so, and being a noob to custom modules, any pointers on how I would go about it would be great.