Hello everybody,
I am creating an ecommerce site that I want to have a simple inventory system. There is only one product and I want there to be an admin page that someone can go in type in added inventory shipments. For example type 200 t-shirts.
Then whenever an order is placed the amount of t-shirts ordered gets deducted.
The part that I need help with is that I want the back-end inventory update system to show the last 20 inventory changes. I want them all logged in order. Is the best way to do this to create a new database record every time the inventory is update. So if the back-end user enters 200 t-shirts, should I make a dateabase entry and everytime an order is placed, I'll place a record that deletes one order.
And then I would like to take it to the next step by grouping daily sales inventory deductions. What I mean, is that if there 20 orders that day and each one had 3 shirts in it. I want the log to show daily orders deduction 60 shirts.
Hope I explained all this clearly, any advice on how to go about this is much appreciated.
Start Free Trial
