Daily Squarespace low-stock reorder digest in Slack and Asana

Build me an agent workflow that runs every weekday at 7am (cron trigger) and watches my Squarespace store for low-stock and out-of-stock variants, then files reorder tasks in Asana and posts a rollup to Slack.

Each run the agent should:

1. Call the Squarespace Forms operation "Retrieve All Inventory" to pull the current quantity and SKU for every product variant. Paginate until done.

2. Call the Squarespace Forms operation "Retrieve All Products" so it can map each variant ID back to a human-readable product name (and confirm SKU). Cache the mapping for the run.

3. For every variant whose quantity is at or below a configurable threshold (default 5 units), decide a priority: "critical" if quantity is 0, "high" if quantity is 1 or the variant is at most 25% of the threshold, otherwise "normal". Write a one-paragraph reorder rationale that mentions the product name, variant, SKU, current quantity, and how close it is to zero.

4. Skip any variant for which the agent has already created an Asana reorder task in the last 7 days. Persist this de-duplication state across runs (keyed by SKU or variant ID) so the same item doesn't get re-filed every morning. Make the window configurable.

5. For each remaining low-stock variant, call the Asana operation "Create a Task" in a configurable Asana project. The task name should read like "Reorder: <product name> (<variant>) — <SKU>". The task description should include the SKU, current quantity, threshold, priority, and the one-paragraph rationale. Set the due date to 3 business days from today. Allow an optional default assignee.

6. After all tasks are created, call the Slack operation "Send a Message" to post a single rollup message in a configurable channel. The message should list every item queued this run (product, variant, SKU, current quantity, priority) grouped by priority, with a short headline like "Reorder load for <date>: N items". If nothing crossed the threshold, post a brief "All variants above threshold" note instead.

Configurable inputs the workflow should expose: low-stock threshold (default 5), de-duplication window in days (default 7), Asana project ID, optional Asana assignee, business-day offset for due date (default 3), Slack channel, and the cron schedule (default 7:00 local time, Mon–Fri).

Operational rules: handle Squarespace pagination and 429 rate limits with backoff, treat missing or null inventory entries as 0, never throw on a single bad variant (log and continue), and make the rollup message succeed even if some Asana task creations failed (report which ones failed in the rollup).

Additional information

What does this prompt do?

Checks your Squarespace store inventory every weekday morning and flags any product variant that has dropped below your reorder threshold.
Files a reorder task in Asana for each low item, with the product name, SKU, current quantity, a short reorder rationale, and a due date three business days out.
Posts one tidy rollup in Slack so the ops team sees the whole day's reorder load in a single message, not a dozen pings.
Skips items it already filed in the last 7 days so the same SKU doesn't get a new task every morning.

What do I need to use this?

A Squarespace site on a plan that includes the Commerce API (Core, Plus, Advanced, Business, Commerce Basic, or Commerce Advanced).
An Asana workspace and a project where reorder tasks should land.
A Slack workspace and the channel you want the daily rollup posted to.
A reorder threshold in mind (the default is 5 units per variant).

How can I customize it?

Change the threshold per variant or per product line so fast movers trigger earlier than slow movers.
Pick the Asana project, assignee, and due-date offset that match how your ops team actually picks up reorder work.
Swap the Slack channel, retime the 7am run, or skip weekends and holidays to match your team's hours.
Tighten or loosen the 7-day duplicate window if you reorder more or less often than once a week.

Frequently asked questions

Will this work with my Squarespace plan?

You need a plan that includes the Commerce API: Core, Plus, Advanced, Business, Commerce Basic, or Commerce Advanced. If you can see Developer API Keys in Settings, you're good.

Does it cover every product variant, including different sizes and colors?

Yes. It pulls inventory at the variant level, then maps each low variant back to its parent product name and SKU so the Asana task is easy to act on.

How does it decide what's urgent?

It looks at how close the current quantity is to zero relative to your threshold. Items at or near zero are flagged as higher priority in the reorder rationale than items just under the threshold.

Won't I get a duplicate task for the same SKU every morning?

No. The workflow remembers what it already filed and skips any SKU it has already created a reorder task for in the last 7 days. You can adjust that window.

Can I change the Slack channel or run time later?

Yes. The channel, run time, threshold, Asana project, and duplicate window are all easy knobs to tweak after the workflow is running.