Level 88
I would probably use a separated table that keeps the count that's connected to the order per date. If you count those items in the database they should together have a max of 123 per date.
I bet you can code this yourself ;)
Oct 22, 2019
1
Level 1
Help me to auto restock product
Hello.. pls help me, i make a pre sell product and i want every day can autorestock product to next day, this my form customers transactions :
- Select product: milk
- Select date : 12 dec 2019 (this booking date)
- Available stock : 123
- How much order : 23
So if other customer order with same date 12 dec 2019 available stock 100, and if available stock 0, form number 4 disable.
And than, for next date or other date available stock auto update 123.
U have idea ? Pls share me code to for my project.. thanks u
Please or to participate in this conversation.