The moment it happens

Keep WooCommerce products in sync with a supplier feed

Products sent to your link are created when the SKU is new, otherwise their price and stock are updated.

Runs: The moment it happens
Apps: WooCommerce
AI: Not needed
Access: read+write

Send this to your assistant

Create a ClickRuntime automation: give me a link my supplier's feed can send products to. Match on SKU: create the WooCommerce product if it's new, otherwise update its regular price and stock quantity.

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

Add to ChatGPT Add to Claude

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

Why use it

Why teams use this automation

A WooCommerce shop that sells supplier stock needs its catalog kept in step with a spreadsheet, an ERP or a supplier feed. Someone copies new products in by hand, updates prices one row at a time and corrects stock figures every morning. Mistakes creep in: a price left unchanged after a supplier increase, a duplicate listing of the same item, and the shop sells things it cannot supply.

The automation gives you a link that other systems can send product data to. When data arrives, it looks up the product by SKU. If the SKU already exists, it updates that product's price, stock and details. If not, it creates a new product, so repeated sends never create duplicates.

It is useful for shops with a supplier feed, a warehouse system or a regular spreadsheet update. Because updates are keyed on SKU, a feed can be resent after an error without any harm.

What you get out of it

No more manual re-keying
Product data flows from where it is kept into the store, so nobody retypes names, prices and stock, which removes a regular source of typos. Those typos, such as a missing digit in a price, usually cost more than the time spent avoiding them.
Prices stay current
When a supplier raises a price, one update changes the product in the shop, so you are not selling below cost for the days it takes someone to notice. A quick price edit upstream reaches the store without anyone logging into WooCommerce.
SKU matching avoids duplicates
Looking up by SKU means the same item sent twice updates the existing product instead of creating a second listing that confuses customers and search. Duplicate listings split reviews and sales between two pages, and are painful to merge afterward.
Stock figures reflect the warehouse
Updating stock on arrival reduces overselling, which causes cancelled orders and unhappy customers. Overselling is more expensive than it looks, since each cancelled order costs time, trust and sometimes a refund fee.
Scales with the catalog
A hundred products update as easily as one, so the work does not grow as the shop does. That makes it a sound base for growing the range without hiring someone just to maintain listings.

How it works

What happens, step by step

When your supplier feed or another tool sends product data to ClickRuntime, the automation starts.
For each product it looks up the SKU in your WooCommerce store.
If the product exists, its price and stock are updated. If not, a new product is created.
The run result lists which SKUs were updated and which were created.

Before it runs live

Connect WooCommerce
Paste your automation's link into the other app's webhook settings

What you get

RunsThe moment it happens

Keep WooCommerce products in sync with a supplier feedjust nowSucceeded

Run result · Supplier feedSKU NW-2041 updated: price 24.90, stock 36 · SKU NW-2187 created

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

Act only on the items that match your own rules, and skip the rest
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 WooCommerce 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.

create_or_update_products_from_incoming_data.pyexample

from clickruntime import on_event, credentials, http

STORE = "https://yourstore.com/wp-json/wc/v3"

@on_event
def handle(event):
    item = event.json
    auth = (credentials.secret("WC_CONSUMER_KEY"), credentials.secret("WC_CONSUMER_SECRET"))
    fields = {"regular_price": str(item["price"]), "manage_stock": True,
              "stock_quantity": int(item["stock"])}
    found = http.get(f"{STORE}/products", params={"sku": item["sku"]}, auth=auth).json()
    if found:
        resp = http.put(f"{STORE}/products/{found[0]['id']}", json=fields, auth=auth)
        action = "updated"
    else:
        resp = http.post(f"{STORE}/products", json={"name": item["name"], "sku": item["sku"], **fields}, auth=auth)
        action = "created"
    resp.raise_for_status()
    return {"sku": item["sku"], "action": action, "id": resp.json()["id"]}

FAQ

Common questions

What fields can be created or updated?

Common ones include name, SKU, regular and sale price, stock quantity, description and categories. Anything the WooCommerce products API supports can be included, so list what your source system sends when you set it up.

What if the SKU is missing from the incoming data?

Without a SKU the automation cannot tell whether the product exists, so it should not guess. You can have it reject those records and email you, instead of creating duplicates. Your AI assistant can set that rule up for approval.

Is the link secure?

The address is unique to your automation, and you can require a secret token in the request so only your system can send data. WooCommerce API keys are stored as secrets, not in the link.

What permissions does it need?

read+write. 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 for each event the app sends.

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.

The moment it happens