Automatically refresh dead stock listings and create discount codes

Finds Shopify products that haven't sold in 30 days, rewrites their listings, and creates a discount code.

How the work actually flows

A straight line. Runs once per one per dead stock product.

Pattern: Sequence (1) ยท Multiple Instances with a priori Design-Time Knowledge (13)

flowchart TD trig(["every monday schedule"]):::trigtime s0["check unsold products"]:::task s1[["rewrite product listing"]]:::mi s2["update listing in shopify"]:::task s3["create discount code"]:::task s4[("log change and send summary")]:::store trig --> s0 s0 -->|"one per one per dead stock product"| s1 s1 --> s2 s2 --> s3 s3 --> s4 out[/"refreshed listings with discount codes"/]:::out pay{{"clears dead stock automatically"}}:::pay s4 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepRuns once per itemA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
E-commerce & ProductMessaging & NotificationsSpreadsheet & Database Ops
Connects
ShopifyGoogle SheetsTelegramOpenAI

The problem it solves

Products that stop selling just sit in your catalog looking stale, and you rarely have time to go back and refresh old listings or figure out a smart discount. Dead stock quietly ties up cash and clutters your store.

Who it fits

Shopify store owners who want to clear unsold inventory without manual work.

How it works

  1. Every Monday, the system checks which products had no orders in the past 30 days
  2. AI rewrites the title and description for each dead stock item
  3. AI suggests a discount percentage for that product
  4. The listing is updated in Shopify and a discount code is created
  5. The change is logged to Google Sheets and a Telegram summary is sent
What you get

Refreshed listings someone approves before publishing

Unsold products get a rewritten listing and a ready discount code every week without you touching Shopify.

What you get

Refreshed product listings, new discount codes, and a summary of what changed.

What you need

A Shopify store with admin API access, an OpenAI API key, a Google account, and a Telegram bot.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Back to the AI Playbook