List a new product on Etsy, type a SKU, look back, and realize it doesn’t match the pattern from last month. Small e-commerce sellers and craft sellers lose hours to that exact problem. This excel sku generator fixes it by turning your product attributes into a clean, repeatable code every single time.
The headline feature is pattern-based SKU generation that combines product attributes into a consistent code. You define up to four product category levels on the Setup sheet, list the values that belong in each level, and assign a short abbreviation to every value. The excel sku generator then stitches those abbreviations together in order, separated by a delimiter you choose, and outputs a finished Stock Keeping Unit on the Products sheet.
That structure means a handmade soy candle, lavender, large, gift-boxed becomes the same code today, next month, and next year. Add a new color or scent, and the pattern absorbs it without breaking the rest of your catalog. The result is a sku creator spreadsheet that scales as your shop grows on Etsy, Shopify, or Amazon.
Setup is built for beginners. Drop your product categories into the four configurable lists, pick a delimiter (dash, dot, underscore, whatever you prefer), and a sample SKU previews instantly so you can see the format before committing.
The Products sheet adds the safety nets. Automatic duplicate validation flags any code that already exists in your catalog, and automatic barcode generation produces a scannable barcode for each row. Works for any product type, from jewelry to baked goods to digital downloads.
Download includes both the Excel workbook and a Google Sheets version, plus a pre-filled example file so you can see a working catalog before you build your own. One purchase, both formats.
Pattern-based SKU generation is the whole point. Define the rules once, let the excel sku generator handle every product code from here forward, and stop second-guessing whether your inventory labels match.