Weekly stock renewal

4 0 0
Agh after searching for hours I think I’m admitting defeat.

We are essentially a food factory. We deliver on one day of the week and replenish the stock after said delivery day. Now the plan was to use zapier so customers could choose which week they would like to order their delivery for (maybe two weeks away) the issue i Foresee is the inventory will only represent the stock we are holding for this current week(which is our max capacity) and won’t deduct it from the following weeks inventory and this resulting in a loss of sales.