I asked this question over a year ago, and got some helpful responses but ultimately no solution that addressed our problem. Hoping things may have changed since then.
I work with a bakery that does a lot of preorders—think birthday cakes that customers preorder days or weeks ahead of time for pickup on a specific future date. Luckily, demand exceeds our current production and storage capacity. Unfortunately, this means we have to limit the number of cakes we schedule for each date, preventing us from selling online as there is currently no way (that we know of) to set daily limits at the product level (i.e., limit cake preorders for a specific date once we reach capacity, but still allow preorders on that date for other items like cookies that haven't reached capacity).
There is a great app called Zapiet Store Pickup + Delivery that does 99% of what we need in order to move our preordering online—the main use is that it allows the customer to choose their pickup/delivery date and time—but it sadly doesn't allow the user to set daily limits at the product level. It does allow the user to specify the number of pickup/delivery slots per hour/day, but this is not useful to us.
Is there any app that would accomplish what we need, either on its own or in conjunction with the Zapiet app?
Elias here with Shopify Support. Thank you for posting this question and sharing the additional context!
You can use a third-party app, such as Order Limits - MinMaxify or OrderLogic - Min & Max Limits, to set an ordering limit on specific products. These apps offer different limits that you can set up, such as limiting individual products or limiting the quantities or totals on the cart page, and these limits can be applied to the cart page. While I can't confirm whether there would be any issues with Zapiet Store Pickup + Delivery, these apps don't seem to interfere with each other. Nevertheless, I'd encourage testing these apps directly in your store using your store settings, so that you can do test orders and check on the checkout process for your customers. If you need any help with these apps, you can always reach out to the developers directly through the contact information found in the Support section of their app pages.
I'd love to know if this is what you're looking for. Keep me posted!