Hi,
I am in the process of implementing an inventory.I've googled for sample articles, but no joy.
As far as I can see, I have to store the items that belong to a particular shop, and mark them as in the "transfer pool" when a user wants to transfer them to another shop.
schema so far:
tblShop
shopId
productId
qtyInStock
qtyToBeTransferred
This seems to be overly simple.I am sure that there are many other issues involved, and I'd rather find out sooner rather than later.Has anyone found any decent articles or gotchas that I should be aware of?
Many thanks.
yogi.