Skip to main content

Hello-


I saw this formula for creating SKU’s based off of Single Selects and codes:


SWITCH(

{Product Category},

“Mural”, “MUR”,

“Magnets”, “MAG”

) & “-” &

SWITCH(

{Class},

“Economy”, “EC”,

“Deluxe”, “DX”,

“Premium”, “PM”,

“Platinum”, “PT”

) & “-” &

SWITCH(

{Substrate},

“Canvas”, “CN”,

“Wood”, “WD”

) & “-” &

SUBSTITUTE({Size}, " x ", “”) & “-” &

SUBSTITUTE({Product Name}, " ", “”)


My Question is: Is there a way to not specifically call out the IF selected in the field types, basically what ever you select becomes the “CODE” - because I have thousands of selections that would not work here - would take me forever to write and I don’t want to have to add new ones as the new parts come in - make sense?

I’m not entirely sure what you’re asking for. The example you gave shortens specific words in a not-necessarily-uniform way. If “whatever you select becomes the code”, what else is there to do?


It would help if you provided what your data currently looks like (screenshot) and then describe exactly what its supposed to look like.

Basically anytime you select any drop down selection, it auto populates with the code it’s attached with creating the SKU # from the formula built in. But I don’t want to have to add in all of the options is what I am asking if there is a workaround.


Thank you for your help.

Reply


Terms & Conditions