Product availability on certain days of the week

Topic summary

A bakery owner needs to restrict product availability based on pickup day, not order day—for example, focaccia should only be available for Wednesday and Saturday pickup, even when ordered in advance.

Initial Suggestions:

  • Use Shopify Flow to automatically publish/unpublish products or adjust inventory on specific days
  • Apps like “Order Delivery Date & Pickup” or “Zapiet - Pickup + Delivery” for scheduling pickup dates

Key Challenge Identified:
The original poster clarified that customers need to order in advance (e.g., ordering Friday for Wednesday pickup), so solutions based on the current date won’t work. Products must display based on the selected collection date, not “now.”

Revised Solutions:

  • Pickup date apps (Pickeasy, Zapiet): Let customers select a pickup date first, then dynamically show only products available that day—the recommended approach
  • Dual-location workaround: Use separate inventory locations (“Store” and “Backorder”) with Flow automation to manage stock visibility on baking days
  • Custom development: Build a date picker with JavaScript filtering based on product metafields
  • Collection-based workaround: Create day-specific collections with a date picker redirect

Status: The discussion remains open with the original poster expressing interest in trying a suggested solution.

Summarized with AI on October 27. AI used: claude-sonnet-4-5-20250929.

I am setting up a store for a bakery where not all products are available on all days. For example Focaccia is only available on Wednesday and Saturday.
They offer in store pickup. So I would like to restrict a product to only be available for pickup on the days that item is baked. I am looked in the app store but I cant seem to find an app that allows products to be restricted to certain days of the week.

Shopify has no built-in feature for limiting stock based on the day, but you can club custom coding or third-party apps which control local pickup and scheduling. And while there isn’t an app directly designed to limit product availability by weekday, you can use apps such as Order Delivery Date & Pickup or Zapiet - Pickup + Delivery to restrict pickup dates and create custom rules. You can also set up to display Focaccia pick-up options only on Wednesdays and Saturdays, corresponding with your bakery’s schedule.

Should not be a problem. You can set up a Flow to run each Wednesday morning and evening and, say, publish/unpublish the product in question or set it’s inventory policy/quantity to make it buyable/sold-out.

Unpublished products would not be shown on your storefront at all, so probably changing inventory (policy/quantities) would be the better option.

Hi @dana3000 ,

Shopify Flow is actually the perfect solution for your bakery’s day-specific product availability needs. You can automate this without needing any paid apps.

Here’s how to set up Shopify Flow to make your focaccia only available on Wednesday and Saturday:

Step 1: Create the “Show Focaccia” Flow

  1. Go to Settings > Apps and sales channels > Shopify Flow

  2. Create a new flow

  3. Add trigger: “Scheduled trigger” - set to run daily at 12:01 AM

  4. Add condition: Check if current day is Wednesday or Saturday using this Liquid code:

    {% assign today = 'now' | date: '%A' %}{{ today == 'Wednesday' or today == 'Saturday' }}
    
  5. Add action: “Publish product to sales channel” - select your focaccia product and Online Store

Step 2: Create the “Hide Focaccia” Flow

  1. Create another flow with the same scheduled trigger

  2. Add condition to check if day is NOT Wednesday or Saturday:

    {% assign today = 'now' | date: '%A' %}{{ today != 'Wednesday' and today != 'Saturday' }}
    
  3. Add action: “Unpublish product from sales channel” - select focaccia and Online Store

For Multiple Products: You can create similar flows for each product with different baking schedules. Just duplicate the flows and change the day conditions and product selections.

Benefits:

  • Completely free (included with Shopify)
  • Runs automatically once set up
  • No monthly subscription fees
  • Customers only see products available for pickup on correct days

The flows will ensure your focaccia automatically appears and disappears from your store based on your baking schedule. Once configured, you never have to manually manage product visibility again. Also, if you want we’d love to set this up for you, for free.

Cheers!
Shubham | Untechnickle

Thanks for this explanation of flow. However I don’t think will work as items can be ordered in advance. So for example someone could order on a Friday for collection on a Wednesday. So the Wednesday items would need to be visible in the store based on the collection day not the order day.
There would almost need to be a way that a collection day could be set first and then that would display the items relevant to the day selected. Any ideas if that would be possible with Flow to base the date of the flow on collection not ‘now’?

Unpublishing is not an option then.

You may consider setting up 2 locations then, say, “Store” and “Backorder”.

Pickup location is “Store” which has no stock unless it’s Wednesday. “Backorder” has stock always and is a “transfer” location for pickup.

If customer wants to buy on Friday, they will see “Pickup currently unavailable”, but will be still able to buy for pickup (because it’s available in transfer location) and at checkout they will see a different message, say “Usually ready in 5+ days” .

On Wednesday morning scheduled flow runs and sets inventory in “Store” to positive. Visitors will see “Pickup available, usually ready in 1 hour” (for example).

Mark all preorders as ready for pickup.

Wednesday evening another flow zeroes stock in “Store”.

Then you also need to some kind of a text on the product page to explain that pickup is only available on Wednesday; not sure if it’s possible to change the “Usually ready in XX” texts (well, it’s possible, but it’s store-wide, not per product, the best you can is set it to “Available as stated on product page” or something alike for “transfer” location message).

https://help.shopify.com/en/manual/fulfillment/setup/delivery-methods/pickup-in-store

Hi @dana3000 ,

Thanks for that excellent point about advance ordering - you’re absolutely right that my Flow suggestion wouldn’t work for your scenario. I was thinking too narrowly about the current date rather than the collection date.

You’ve identified the core issue perfectly: customers need to select their collection date first, and then see only the products available for that specific day. Shopify Flow can only work with “now” (current date), but you need the product visibility to be based on a future collection date that the customer selects.

For your bakery’s advance ordering needs, here are the viable solutions:

Best Option - Pickup/Delivery Date Apps: Apps like “Pickup Delivery Date —Pickeasy” or “Zapiet - Pickup + Delivery” are specifically designed for this scenario. They work by having customers select a pickup/collection date first, then dynamically showing only the products available on that chosen date. This is exactly what bakeries need for advance ordering.

Alternative - Custom Development: We could build a custom solution that displays a date picker on your store, uses JavaScript to filter products based on the selected date, and stores your baking schedules in product metafields. This would give you complete control but requires more development time.

Simple Workaround - Collection-Based: Create separate collections for each day (like “Wednesday Items” and “Saturday Items”) with a custom date picker that redirects customers to the appropriate collection. Less elegant but works with native Shopify features.

For your bakery’s specific needs with focaccia on Wednesday/Saturday and advance ordering, I’d recommend starting with one of the pickup date apps. They’re designed exactly for businesses like yours where product availability depends on the service date, not the order date.

Best regards,

Shubham | Untechnickle

Hi Mymco,

Yes I would would be interested in giving this a trial.

Thank you

1 Like