FREE EXCEL TEMPLATE
Download an editable Excel product list for your clothing shop
Start with 12 clothing models and 96 colour/size combinations. Edit the examples to match what you actually sell.
Preview of colour and size combinations
In the table below, the black cotton T-shirt has four rows (S, M, L and XL) as CLO-001 to CLO-004, and the white T-shirt another four as CLO-005 to CLO-008. Each row is a separate item, not a size hidden inside one product.
| Item code | Item name | Category | Unit |
|---|---|---|---|
| CLO-001 | Cotton T-shirt / Black / S | Tops | Piece |
| CLO-002 | Cotton T-shirt / Black / M | Tops | Piece |
| CLO-003 | Cotton T-shirt / Black / L | Tops | Piece |
| CLO-004 | Cotton T-shirt / Black / XL | Tops | Piece |
| CLO-005 | Cotton T-shirt / White / S | Tops | Piece |
| CLO-006 | Cotton T-shirt / White / M | Tops | Piece |
| CLO-007 | Cotton T-shirt / White / L | Tops | Piece |
| CLO-008 | Cotton T-shirt / White / XL | Tops | Piece |
Browse the remaining 88 items
| Item code | Item name | Category | Unit |
|---|---|---|---|
| CLO-009 | Casual shirt / Blue / S | Tops | Piece |
| CLO-010 | Casual shirt / Blue / M | Tops | Piece |
| CLO-011 | Casual shirt / Blue / L | Tops | Piece |
| CLO-012 | Casual shirt / Blue / XL | Tops | Piece |
| CLO-013 | Casual shirt / White / S | Tops | Piece |
| CLO-014 | Casual shirt / White / M | Tops | Piece |
| CLO-015 | Casual shirt / White / L | Tops | Piece |
| CLO-016 | Casual shirt / White / XL | Tops | Piece |
| CLO-017 | Jeans / Blue / 30 | Bottoms | Piece |
| CLO-018 | Jeans / Blue / 32 | Bottoms | Piece |
| CLO-019 | Jeans / Blue / 34 | Bottoms | Piece |
| CLO-020 | Jeans / Blue / 36 | Bottoms | Piece |
| CLO-021 | Jeans / Black / 30 | Bottoms | Piece |
| CLO-022 | Jeans / Black / 32 | Bottoms | Piece |
| CLO-023 | Jeans / Black / 34 | Bottoms | Piece |
| CLO-024 | Jeans / Black / 36 | Bottoms | Piece |
| CLO-025 | Cotton trousers / Beige / 30 | Bottoms | Piece |
| CLO-026 | Cotton trousers / Beige / 32 | Bottoms | Piece |
| CLO-027 | Cotton trousers / Beige / 34 | Bottoms | Piece |
| CLO-028 | Cotton trousers / Beige / 36 | Bottoms | Piece |
| CLO-029 | Cotton trousers / Black / 30 | Bottoms | Piece |
| CLO-030 | Cotton trousers / Black / 32 | Bottoms | Piece |
| CLO-031 | Cotton trousers / Black / 34 | Bottoms | Piece |
| CLO-032 | Cotton trousers / Black / 36 | Bottoms | Piece |
| CLO-033 | Casual dress / Navy / S | Dresses and abayas | Piece |
| CLO-034 | Casual dress / Navy / M | Dresses and abayas | Piece |
| CLO-035 | Casual dress / Navy / L | Dresses and abayas | Piece |
| CLO-036 | Casual dress / Navy / XL | Dresses and abayas | Piece |
| CLO-037 | Casual dress / Beige / S | Dresses and abayas | Piece |
| CLO-038 | Casual dress / Beige / M | Dresses and abayas | Piece |
| CLO-039 | Casual dress / Beige / L | Dresses and abayas | Piece |
| CLO-040 | Casual dress / Beige / XL | Dresses and abayas | Piece |
| CLO-041 | Long-sleeved blouse / White / S | Tops | Piece |
| CLO-042 | Long-sleeved blouse / White / M | Tops | Piece |
| CLO-043 | Long-sleeved blouse / White / L | Tops | Piece |
| CLO-044 | Long-sleeved blouse / White / XL | Tops | Piece |
| CLO-045 | Long-sleeved blouse / Black / S | Tops | Piece |
| CLO-046 | Long-sleeved blouse / Black / M | Tops | Piece |
| CLO-047 | Long-sleeved blouse / Black / L | Tops | Piece |
| CLO-048 | Long-sleeved blouse / Black / XL | Tops | Piece |
| CLO-049 | Light jacket / Grey / S | Jackets and knitwear | Piece |
| CLO-050 | Light jacket / Grey / M | Jackets and knitwear | Piece |
| CLO-051 | Light jacket / Grey / L | Jackets and knitwear | Piece |
| CLO-052 | Light jacket / Grey / XL | Jackets and knitwear | Piece |
| CLO-053 | Light jacket / Black / S | Jackets and knitwear | Piece |
| CLO-054 | Light jacket / Black / M | Jackets and knitwear | Piece |
| CLO-055 | Light jacket / Black / L | Jackets and knitwear | Piece |
| CLO-056 | Light jacket / Black / XL | Jackets and knitwear | Piece |
| CLO-057 | Knitted jumper / Beige / S | Jackets and knitwear | Piece |
| CLO-058 | Knitted jumper / Beige / M | Jackets and knitwear | Piece |
| CLO-059 | Knitted jumper / Beige / L | Jackets and knitwear | Piece |
| CLO-060 | Knitted jumper / Beige / XL | Jackets and knitwear | Piece |
| CLO-061 | Knitted jumper / Navy / S | Jackets and knitwear | Piece |
| CLO-062 | Knitted jumper / Navy / M | Jackets and knitwear | Piece |
| CLO-063 | Knitted jumper / Navy / L | Jackets and knitwear | Piece |
| CLO-064 | Knitted jumper / Navy / XL | Jackets and knitwear | Piece |
| CLO-065 | Everyday abaya / Black / S | Dresses and abayas | Piece |
| CLO-066 | Everyday abaya / Black / M | Dresses and abayas | Piece |
| CLO-067 | Everyday abaya / Black / L | Dresses and abayas | Piece |
| CLO-068 | Everyday abaya / Black / XL | Dresses and abayas | Piece |
| CLO-069 | Everyday abaya / Navy / S | Dresses and abayas | Piece |
| CLO-070 | Everyday abaya / Navy / M | Dresses and abayas | Piece |
| CLO-071 | Everyday abaya / Navy / L | Dresses and abayas | Piece |
| CLO-072 | Everyday abaya / Navy / XL | Dresses and abayas | Piece |
| CLO-073 | Adult pyjama set / Grey / S | Nightwear | Set |
| CLO-074 | Adult pyjama set / Grey / M | Nightwear | Set |
| CLO-075 | Adult pyjama set / Grey / L | Nightwear | Set |
| CLO-076 | Adult pyjama set / Grey / XL | Nightwear | Set |
| CLO-077 | Adult pyjama set / Blue / S | Nightwear | Set |
| CLO-078 | Adult pyjama set / Blue / M | Nightwear | Set |
| CLO-079 | Adult pyjama set / Blue / L | Nightwear | Set |
| CLO-080 | Adult pyjama set / Blue / XL | Nightwear | Set |
| CLO-081 | Children’s outfit / Blue / 4Y | Children’s clothing | Set |
| CLO-082 | Children’s outfit / Blue / 6Y | Children’s clothing | Set |
| CLO-083 | Children’s outfit / Blue / 8Y | Children’s clothing | Set |
| CLO-084 | Children’s outfit / Blue / 10Y | Children’s clothing | Set |
| CLO-085 | Children’s outfit / Green / 4Y | Children’s clothing | Set |
| CLO-086 | Children’s outfit / Green / 6Y | Children’s clothing | Set |
| CLO-087 | Children’s outfit / Green / 8Y | Children’s clothing | Set |
| CLO-088 | Children’s outfit / Green / 10Y | Children’s clothing | Set |
| CLO-089 | Children’s pyjama set / Pink / 4Y | Children’s clothing | Set |
| CLO-090 | Children’s pyjama set / Pink / 6Y | Children’s clothing | Set |
| CLO-091 | Children’s pyjama set / Pink / 8Y | Children’s clothing | Set |
| CLO-092 | Children’s pyjama set / Pink / 10Y | Children’s clothing | Set |
| CLO-093 | Children’s pyjama set / Blue / 4Y | Children’s clothing | Set |
| CLO-094 | Children’s pyjama set / Blue / 6Y | Children’s clothing | Set |
| CLO-095 | Children’s pyjama set / Blue / 8Y | Children’s clothing | Set |
| CLO-096 | Children’s pyjama set / Blue / 10Y | Children’s clothing | Set |
How clothing items are built in this file
Each row combines the model, colour and size in one name, with its own internal code and a sale unit (piece or set). Categories separate tops, trousers, dresses, jackets and children’s wear. These are preparation columns in Excel; the import fields Sonbola accepts depend on your edition.
From the first rows: you have 10 black T-shirts in size S (CLO-001) and 3 in size XL (CLO-004). If you merge both sizes into one item called “black T-shirt”, you will not see which size sold out and which is still on the shelf. Keep each combination on its own row, and edit the names, colours and sizes to match what you actually sell.
- Remove models you do not sell, and edit names so they match the label in your shop.
- Enter the real manufacturer barcode in the text field so leading zeros are not dropped.
- Add quantities and purchase and selling prices in one currency.
- Use the blank worksheet for models that are not in the examples, or for extra items.
Common mistakes when preparing clothing items
- Putting every size of a model in one item, so the stock figure no longer distinguishes S from XL.
- Writing the colour only in the name, without a separate row for each colour, so black and white mix at the till and in a count.
- Entering the barcode as a number rather than text, which strips leading zeros and no longer matches the label.
- Mixing the units “piece” and “set” on the same model without checking, especially on pyjamas and children’s sets.
The list is for preparing items only. To compare a physical count with recorded stock, use the stocktaking template. For how Sonbola handles a clothing till and returns, see software for clothing stores.
Before you import a clothing list into Sonbola
Download the import template from your Sonbola account, then match the columns and review a small sample before importing the full list. This downloadable starter list has not been verified as an import format for every Sonbola edition.
Read the Excel preparation and import guideTry the next step in Sonbola
Explore invoices, stock and customer balances for your business. After recording data and transactions, ask the smart assistant about figures available to your account; profit access is for the company owner.
Web trial: 14 days. For the updated Windows app with Sonbola AI, visit the desktop download page.
Download your copy
Updated 11 November 2026. Suggested product names; no manufacturer barcode or market-price database.