Create Back-in-Stock Alert System

What This Sidekick Query Does

Create a back-in-stock alert system for my Shopify store:

Customer-Facing:

  On out-of-stock product pages, replace “Add to Cart” with “Notify Me When Available”
  Email capture form: name + email
  Confirmation message: “We’ll email you when [Product] is back!”
  Show number of people waiting: “[X] people are waiting for this product”


Automated Flow (when product restocked):

  Trigger: Product variant inventory quantity changes from 0 to > 0
  Action 1: Send email to all subscribers for that product
  Action 2: Include product link, image, and price
  Action 3: Add urgency: “Back in stock — limited quantities!”
  Action 4: Clear the notification list for that product after sending


Email Template:
Subject: “🎉 [Product Name] is back in stock!”
Body:

  “Great news, [Name]! The [Product] you were waiting for is back.”
  Product image + name + price
  “Grab yours before it sells out again — [X] people were waiting!”
  CTA button: “Shop Now”
  Estimated stock duration based on previous sell rate


Admin Dashboard:

  List of products with active waitlists
  Number of subscribers per product
  Conversion rate: notified → purchased
  Use this data to prioritize restocking decisions


Implementation:

  Recommend approach (Shopify Flow + email, or app recommendation)
  Liquid code for the “Notify Me” button on product pages
  Email automation setup

Expected Output

Tips to Improve Results