CSV template
SKU planning worksheet
Plan SKU codes for products with sizes and colours before you set up billing software, with a consistent pattern for every variant.
What is in it
Decide your SKU pattern once, then fill in every product and variant. A consistent plan makes imports, labels and stock counts easier.
Download sku-planning-worksheet.csv (CSV)
Opens in Excel, Google Sheets or LibreOffice Calc.
Columns
- Category: Shirts, footwear, grocery…
- Style or product: The product before sizes and colours
- Style code: A short code, for example TSHIRT
- Colour: Colour name
- Colour code: For example BLU
- Size: S, M, L, 32, 500 g…
- SKU: Style code, colour code and size joined, for example TSHIRT-BLU-M
- Barcode: Manufacturer barcode if the item has one
- Price: Selling price
- Opening stock: Quantity on hand
How to use it
- Choose short, fixed codes for styles, colours and sizes.
- Never reuse an SKU for a different item, even after it is discontinued.
- Keep manufacturer barcodes where items have them.
- Import the finished sheet into your billing software, or keep it as your reference.
See the SKU naming guide.
Related
Useful next.
- Guide · 8 min readHow to Name SKUs: Rules, Patterns and Examples for Retail ShopsAn SKU is your own name for one exact item you stock. A good pattern makes billing, counting and reordering easier for years; a bad one causes confusion from the first week.
- Guide · 8 min readSize and Colour Variants: How to Manage Them in a Clothing or Footwear StoreIn a clothing or footwear store one style can mean twenty different items on the shelf. Unless each size and colour is tracked on its own, stock reports will say you have something the customer cannot buy.