Login / Sign up
Spreadsheet data

How to add a prefix and suffix to SKU values in Excel

2026-06-28
Task

A supplier file contains SKU values such as 00123, 00456, and 00789. The California catalog needs the format US-00123-CA: a country prefix and a state suffix on every SKU.

Short answer

Create the output column sku_ready from sku and add two transformations: Add to beginning with US-, then Add to end with -CA.

How to do it in Eofferix

  1. Upload the CSV or XLSX file with the sku column and open the table editor. The sample also keeps a product column so the rows are easy to check.

  2. Create the output column sku_ready from the source column sku, or select the existing result column.

  3. Open the settings for the sku_ready column with the gear icon in its header.

    Opening the sku_ready column settings in the Eofferix table editor
    The animation opens the settings of the result column sku_ready.

  4. In Transformations, add Add to beginning with US-, then add Add to end with -CA.

    Two Eofferix rules: Add to beginning US- and Add to end -CA
    Rules run from top to bottom: prefix US- first, suffix -CA second.

  5. Save the column settings and check several preview rows. Leading zeros in SKU values must stay intact.

Before / after

Before

source data
skuproduct
00123Hudson desk lamp
00456Maple wall shelf
00789Trail travel mug

After

result
sku_readyproduct
US-00123-CAHudson desk lamp
US-00456-CAMaple wall shelf
US-00789-CATrail travel mug

What to keep in mind

  • Use this setup when the same prefix and suffix apply to every row.
  • If some SKU values already contain US- or -CA, add a condition to avoid duplicates.
  • Do not convert SKU values to numbers before processing: leading zeros such as 00123 are part of the identifier.

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up