I'm currently managing a fairly large and complex Magento2 site. Admittedly, I'm more of a front-end guy. As such, I had a question.
We have 82 stores (one for each corporate customer). Each store also has external company admins who ONLY approve orders for their respective stores. They can only see their store orders when they log in. Shipping and payment methods also vary by store (in that some methods are turned off for certain stores, and have different names).
Currently, each of these is set up as a unique website (with store and store view). So, 82 websites. (ie pepsi.magento.com, coke.magento.com, fresco.magento.com, etc). This number will grow.
We had it stated to us as fact that the database is being duplicated with each new website > store > store view creation. This seems like someone is pulling my chain. Just wanted to ask the question here.
Does creating a new "website > store > store view" add database bloat, resulting in an unscalable model? Is it better (or even advisable/possible) to use categories for each store, with subcategories for the product?