Dec 07, 2022 07:43 AM - edited Dec 07, 2022 07:44 AM
Hi,
Who's gonna help to :
- concatenate Row 1+2+3 with a limitation of 3 character per row and a total character of 16 ?
I need to create unique reference (in e-commerce) called Variant SKU looking like
Modele, Size, Color but as we are limited in number of characters (16) it would look like
#MOD-SI-COL
In this view : Variant SKU will be a formula including
#SAM (from marque (brand in french)-modele-vendor
taking only the 3 first characters
thanks guys 🍭
Solved! Go to Solution.
Dec 07, 2022 09:21 AM
@Michael_Leidens Hi, it seems easy at first site. You can use the formula:
UPPER(CONCATENATE("#",LEFT(Brand,3),"-",LEFT(Model,3),"-",LEFT(Vendor,3)))
But here comes a problem of duplicate items if, say, the model names start with the same first characters. So, for model I would suggest using unique codes. However, in this case we are going to have SKU within SKU.
Dec 07, 2022 09:35 AM
Thank you Andrey.
You are right. Actually we will use model/size/color which is unique.
I didn't mention it and the screenshot I published was taken before. But indeed, otherwise we would might have duplicate.
Dec 07, 2022 09:21 AM
@Michael_Leidens Hi, it seems easy at first site. You can use the formula:
UPPER(CONCATENATE("#",LEFT(Brand,3),"-",LEFT(Model,3),"-",LEFT(Vendor,3)))
But here comes a problem of duplicate items if, say, the model names start with the same first characters. So, for model I would suggest using unique codes. However, in this case we are going to have SKU within SKU.
Dec 07, 2022 09:35 AM
Thank you Andrey.
You are right. Actually we will use model/size/color which is unique.
I didn't mention it and the screenshot I published was taken before. But indeed, otherwise we would might have duplicate.