luxehouseofcouture
New Member
- Joined
- Dec 26, 2018
- Messages
- 11
I am in the process of creating a SKU generator for my Shopify products. I want the logic for the SKU's to follow the below template.
Example Product 1:
Vendor: Zutter
Name: Shirley Brushed Waffle Tunic
Color: Light Blue/Red/White
Size: X Large
Example SKU 1:
ZUTT-SBWT-LBRW-XL
Example Product 2:
Vendor: Love Tree
Name: Transition Cardigan
Color: Light Blue
Size: Small
Example SKU 2:
LOTR-TC-LB-S
Things to Note:
You can download the example excel sheet here.
Example Product 1:
Vendor: Zutter
Name: Shirley Brushed Waffle Tunic
Color: Light Blue/Red/White
Size: X Large
Example SKU 1:
ZUTT-SBWT-LBRW-XL
Example Product 2:
Vendor: Love Tree
Name: Transition Cardigan
Color: Light Blue
Size: Small
Example SKU 2:
LOTR-TC-LB-S
Things to Note:
- Ideally, I would like to have the formulas reference the Codes tab and use the respective ID value for the adjacent matching value within the generated SKU's (i.e. the code for Booties is Btie).
- Product names variables should be generated as acronyms (i.e. Shirley Brushed Waffle Tunic would output as SSBW)
- Characters for each product variable should max at 4, using the first words in the text string to generate the variable acronym (i.e. Shirley Striped & Brushed Waffle Tunic would output as SSBW)
- In the event of a duplicate SKU, a numerical identifier should be appended to the duplicate (i.e. LT-TC-LB-S and LT-TC-LB-S-1)
- I have too many colors in my shop to create ID codes. So, we'll just need to generate an acronym to accomplish this. if a color is a phrase (i.e. Light Blue), the acronym would be LB. But if it is a multi-color option, the acronym should encompass all color options (i.e. Light Blue/Red/Green would be LBRG). I'd imagine that the formula needs to have an OR condition that looks for " " or "/" as a possible separator in order to accomplish this.
- Variables can be alpha-numerical and must be separated by hyphen's (-).
You can download the example excel sheet here.