Bulk update collection items where [...conditions...]

Design help CMS
1

I am trying out webflow in the trial area and really loving the experience so far. I just tried setting up my collections like Product → ProductRegion → Regions (based on advice from @memetican ) and so far that works great.

I thought I’d try out the auto generate sample data feature but under specified what I wanted the AI to type into the fields for ProductRegion.Description and ProductRegion.Name. Is there a way to do some kind of bulk update on collection items?

Something like an SQL statement that does:

UPDATE ProductRegion SET Description = null WHERE Product.RegionId = 'argentina'

then followed up by

Update ProductRegion SET Name = CONCAT(ProductName, ' > ', RegionName)

In a production environment, I can expect to have hundreds of records in each collection. So I was wondering how I might go about conditional bulk updates?

This is my dev / experimental area

Here is my public share link: LINK
(how to access public share link)

2

No but if you like using AI you should look into Claude Desktop + Webflow’s MCP server.
There you can modify your CMS data directly from an LLM like Claude.

Incidentally that’s how I generated the test data in the demo I sent in your last post.

1 Like
3

Ah ok. Actually, generating test data was really jsut for testing.

If this were real production data and i wanted to do things without AI, would my approach be to export it to Excel, then just write some formulas to do what ever edits I need, then re-import?

1 Like
4

If you want to work with the data externally, then yes.
Or Google Sheets, Airtable, etc.

1 Like