Turning Long Etsy Product Names into Short Codes Automatically

How To
, , ,
1

Hello everyone,

I’m struggling with a problem I can’t seem to solve, and I would really appreciate your help!

I sell games for couples on the Etsy marketplace, and I want to automate the process of recording order information into a Google Sheet. One of the key pieces of information I need to store is the name and quantity of products purchased. However, the product names in my listings are quite long, and I’d prefer to record them using short, simplified names. I only have three main products, so this should be fairly straightforward.

Currently, when an order includes 2 items, the formula I’m using outputs something like this:

"Date Card Game For Couples, Wild Couple Game For Lovers, Wild Couple Game For Lovers"

What I would like instead is a more concise output that also includes the quantity of each item, formatted like this:

"Date (1), Wild (2)"

I’ve tried several approaches, but nothing has worked so far.

I’ve attached some images to illustrate my current setup and formula:

  • Image 1: My current scenario for automating order data.
  • Image 2: Functions that Ive used so far

scenario 1
scenario 12082×892 87.8 KB

image
image699×404 22.9 KB

If anyone has any suggestions on how I could modify my scenario or adjust my formula to achieve this result, I would be extremely grateful!

Thank you so much for any advice or help!

2

Hey Matyas,

if you want the first word from each title to be used as key, you can use {{get(split(“title”; space); 1)}}.

If its not going to be the first word, you can use a switch() formula to define your own rule, or a switch module for easier management. Alternatively you can also use a separate google sheet where you can define product names and codes and use that, then you wont have to edit the scenario when a new product is added.

Then when you have the new array with only the key words you can use a modification of this flow Counting and categorizing items in an array - #3 by alex.newpath

2 Likes
3

Hello Stoyan,

thank you for the suggestion! In the end, it worked the best with the separate Google Sheet you recommended.

Thanks a lot!