I'm developing an E-commerce solution website for Medium based company. I need to create Administrative functions as well. One of requirement from my client is to "Provide product stock numbers and and sales re-order level activation" in the Administrative pages.
What I'm asking is?...In order to create "Product stock numbers" and "Sales re-order level activation functions"..I've created only Product entity in my database related to this issue. (Product table)
I didn't create Stock entity seprately(stock table) in my database. I've thought product is enough.
So that I can calculate stock numbers by deducting the sold items from the product table and the sold items is equal to re-order level activation. so It automatically comes in. But now I think It's more process oriented and seems to be a difficult task. I'm not an expert in ASP too. so
Can u please explain an alternative or easy way to - "Provide product stock numbers and and sales re-order level activation in developing an E-commerce site."?
Thanks in Advance for ur help