Skip to content

Daily

Flag FBA SKUs that are running low

A daily email lists the SKUs with fewer than 20 fulfillable units so you can send stock in time.

Runs
Daily
Apps
Amazon Seller Central
AI
Not needed
Access
Amazon Fulfillment / Inventory role

Send this to your assistant

Create a ClickRuntime automation: every morning, email me my FBA SKUs with fewer than 20 fulfillable units, lowest first, with the product name and current count.

Paste it into your assistant. It tells you what it will send or change before it runs live.

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

When Fulfilled by Amazon stock runs out, your listing loses the Buy Box or disappears from search, and your ranking, built over months, starts to slip. Restocking takes weeks: you order from the supplier, ship to the prep center, create the inbound shipment and wait for the warehouse to check it in. A seller who finds out about a low stock level when it hits zero has already lost sales and ranking, and the rebuild costs advertising money.

Each day, the automation reads your FBA inventory summaries, filters to the SKUs below the quantity you set and emails the list. Each line shows the SKU, title and the units that are fulfillable now.

It helps sellers with many SKUs who cannot watch each one, and for anyone with long lead times from their supplier.

What you get out of it

  • Restocks start before you sell out

    A warning at 30 units, for a product that sells 10 a day, leaves three weeks, enough to order, ship and check in. Waiting for zero leaves a gap. The arithmetic is simple, but only if you see the number in time.

  • Rankings are protected

    Stockouts hurt a listing's search rank and Buy Box eligibility. Staying in stock keeps the position you have paid to build, which saves ad spend later. Winning back a lost position can take weeks of discounts and ads.

  • The supplier gets earlier orders

    Placing an order in time often gives you a better price and a choice of shipping method, instead of paying for air freight to close a gap. Planned orders are cheaper than emergency ones.

  • Many SKUs are covered at once

    The email lists everything that is low, so a catalog of hundreds of items is monitored by one routine, without a person scanning the Inventory dashboard. That is a task nobody wants to do by hand each morning.

  • Cash planning is easier

    Knowing which products will need restocking this month tells you how much cash to reserve, so a large purchase order is not a surprise. Purchase orders are rarely small, so the notice helps finance too.

How it works

What happens, step by step

  1. Once a day, ClickRuntime checks how much stock you have in Amazon's warehouses for each FBA product.

  2. It picks out the SKUs that have dropped below your threshold.

  3. You get an email listing each one with its name and how many units are left, so you can send more in time.

Before it runs live

  • Connect Amazon Seller Central

What you get

RunsDaily
Flag FBA SKUs that are running lowtoday, 9:00Succeeded
Email · Low FBA stock- NW-BOTTLE-750 (Insulated bottle, 750 ml, sage): 6

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.
  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

  • Run it at a different time, more or less often, or only on weekdays
  • Add an AI step, for example to summarize, sort or draft a reply
  • Add another app, for example also send it to Slack
  • Combine it with other Amazon Seller Central steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.
low_fba_inventory_alert.pyexample
from clickruntime import on_trigger, credentials, http, notify

US = "ATVPDKIKX0DER"

@on_trigger
def run(event):
    headers = {"x-amz-access-token": credentials.connection("amazon-seller-central", "us")}
    low, token = [], None
    while True:
        params = {"granularityType": "Marketplace", "granularityId": US, "marketplaceIds": US, "details": "true"}
        if token:
            params["nextToken"] = token
        body = http.get("https://sellingpartnerapi-na.amazon.com/fba/inventory/v1/summaries",
                        headers=headers, params=params).json()
        for s in body["payload"]["inventorySummaries"]:
            qty = s["inventoryDetails"]["fulfillableQuantity"]
            if qty < 20:
                low.append((qty, s["sellerSku"], s["productName"]))
        token = (body.get("pagination") or {}).get("nextToken")
        if not token:
            break
    if not low:
        return {"low": 0}
    notify.email_me(f"{len(low)} FBA SKUs under 20 units",
                    "\n".join(f"- {sku} ({name[:60]}): {qty}" for qty, sku, name in sorted(low)))
    return {"low": len(low)}

FAQ

Common questions

Does it use fulfillable quantity or total quantity?
Fulfillable quantity is the units that can be sold now, so it is the best measure for a warning. Inbound and reserved units can be shown beside it so you see what is on the way.
Can different SKUs have different thresholds?
Yes. A fast seller might alert at 50 units and a slow one at 10. The thresholds can come from a table with each SKU, so they reflect the sales rate and lead time of each product.
Does it include inventory at all fulfillment centers?
The inventory summaries give the total by SKU for your marketplace, across Amazon's fulfillment centers. It does not report which warehouse holds the stock. Amazon does not report which individual warehouse holds your units, so the email shows only the total by SKU.
What permissions does it need?
Amazon Fulfillment / Inventory role. Nothing else in your accounts is used.
Does it need AI?
No. It runs without AI, so it doesn't use your plan's AI allowance.
How many runs does it use?
One run each time it runs (daily). Checks that find nothing to do and stop right away aren't counted.
Can I change how it works?
Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Set up “Flag FBA SKUs that are running low” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.