[Solved] Stock keeping System [closed]

You would need at the very least two tables. One for storing stores and other for products. One table for each store makes little sense to me.