Changing slugs of all products

numismy · 2025-01-30T04:45:54.644Z

Hi all! Is there an easy way to go into the data and change all slugs of our products (data type = product) to “[titleword1]-[titleword2]-[titleword3]-…”

Hopefully easy (and of course I can figure out)!!! Thank you!

geesonofgee · 2025-01-30T08:38:23.127Z

There are numbers of ways to do this.

You can upload them using a csv file; you go to the DB sort the titles by anything u’ll remember, say “date” copy all lof it in order of sorting to your excel, map each one of the slug to each product’s unique ID and upload it back to the DB.

Another way is to set up a backend workflow to make this happen, much easier but WU (if you entries are much of course) …

Set up a “new database trigger”
type =product
Action; set a thing slug -
Things to change =product before change
Slug= products title

numismy · 2025-01-31T03:58:00.555Z

Great! Once I set up, how do I run it to change the slug across all 40,000 or so data points in the dataset (i.e., how do I trigger the workflow across the entire dataset)? Thanks!

boston85719 · 2025-01-31T04:07:36.289Z

In app editor in app data use bulk button

geesonofgee · 2025-01-31T04:48:15.088Z

There you have it

numismy · 2025-02-02T22:32:57.421Z

Thank you again for the help (and unfortunately still having trouble). I set up the database trigger but having trouble triggering it (“bulk” does not show this trigger and instead prompts me to create a new API workflow). Thanks!

image672×485 16.6 KB

image808×301 12.8 KB

unicosts · 2025-03-24T04:45:05.790Z

Hi @numismy I was stuck for a while on this too but thanks to your thread I figured it out. I hope you have too but I thought I’d write it down for anyone else wanting an answer

Create a text field that is what you want your slug to be. You can also dynamically create the slug using existing fields, and it will automatically change the text to lower case and add ‘-’ instead of a space. If there are multiple of the same text in your database, it will also automatically add ‘-1’ or ‘-2’ etc to the end of your slug to ensure all are unique.
Go to Setting → API and ensure these boxes are ticket, as well as the data type you would like to work on

image1303×556 51.7 KB
Go to Backend Workflows and create a new API Workflow. Name it, and then set up a key, the type should be the type of data you want to set the slug for

image621×612 19.9 KB
Add an action ‘set a thing’s slug’, which is under the ‘Data (things)’ tab. Set the ‘thing to change’ as the option available under “WORKFLOW DATA SOURCES”. This is the key that you set up in step 3 and is the info the API passes to this workflow. Then set up the slug how you want; if you want to combine multiple text fields to create a unique slug, I recommend using the dynamic input option ‘arbitrary text’ so you can set out a long slug using multiple fields. As I said before it will automatically change the text to lower case and add ‘-’ instead of a space.

image655×259 9.72 KB
Return to your data. If you would like to run this workflow on only certain things, and not the whole data set, click ‘New View’ and then set up your conditions.

image1303×550 39 KB

image1298×517 33.2 KB
Click ‘bulk’.

image1251×462 31.9 KB
Select your API workflow from the drop-down and click ‘run workflow’.

image994×528 27.6 KB
Refresh your data to see your new slugs!

image1321×970 66.6 KB

I hope this helped; I, for one, always appreciate it when someone in the forum gives a comprehensive guide.

system · 2025-04-10T04:46:30.123Z

This topic was automatically closed after 70 days. New replies are no longer allowed.