How to Create a SKU Format

A SKU format is a simple recipe that tells the app how to build SKUs (Stock Keeping Units) from the columns in your CSV file. You don’t need to know programming — just follow the rules below.

---

1. Referencing Columns

Each column in your CSV can be referenced by a letter:

• {A} = first column
• {B} = second column
• {C} = third column
• ... and so on.
• After {Z}, it continues as {AA}, {AB}, {AC}...

---

2. Basic Format

You can combine text and column references inside braces { }.

{A}-{B}

• If A = "Shirt" and B = "Red", the {A}-{B} SKU will be:

Shirt-Red

You can also add your own fixed text:

SKU-{A}-{B}

Gives:

SKU-Shirt-Red

---

3. Transformations

You can apply transformations to change how the column text is used. Add them after a colon : inside the braces.

Common Transformations

Code	Description	Example Input	Example Output
1-9	Trim	{A:3} from Blue Long Trousers	Blu
C	Consonants	{A:C} from Blue Long Trousers	BlLngTrsrs
I	Initials	{A:I} from Blue Long Trousers	BLT
L	Lowercase	{A:L} from Blue Long Trousers	blue long trousers
P	Pad to 3 chars (with 'X')	{A:P} from M	MXX
5P	Trim and pad to n characters (with 'X')	{A:5P} from M	MXXXX
Z	Zero-pad number to 3 digits	{A:Z} from 42	042
5Z	Zero-pad number to n digits	{A:5Z} from 42	00042
S	Slug (replace spaces/symbols with _)	{A:S} from Blue Long Trousers	Blue_Long_Trousers
U	Uppercase	{A:U} from Blue Long Trousers	BLUE LONG TROUSERS
W	First word only	{A:W} from Blue Long Trousers	Blue

---

4. Combining Multiple Transforms

You can chain multiple transformations together:

{A:U3} → Uppercase, then take the first 3 letters

If A = "trousers", the result is:

TRO

---

5. Examples

CSV Row (A=Name, B=Color, C=ID)	Format	Result
Shirt, Red, 42	{A}-{B}-{C}	Shirt-Red-42
Shirt, Red, 42	{A:U}-{B:U}	SHIRT-RED
Blue Long Trousers, Navy, 7	{A:I}-{B:3}-{C:3Z}	BLT-Nav-007
Hat, Black, 1234	SKU-{C:5P}	SKU-01234

---

6. Tips

• Always wrap column references in { }.
• Use plain text outside braces for fixed words.
• Combine transformations to shorten, clean, or format values.
• If a column is empty, the SKU part will also be empty.

---

✅ With these rules, you can create SKU formats that match your business needs — simple or advanced!