Sonbola SONBOLA

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.

96 suggested items · 2 worksheets · no registration

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.

First 8 suggested items
Item codeItem nameCategoryUnit
CLO-001Cotton T-shirt / Black / STopsPiece
CLO-002Cotton T-shirt / Black / MTopsPiece
CLO-003Cotton T-shirt / Black / LTopsPiece
CLO-004Cotton T-shirt / Black / XLTopsPiece
CLO-005Cotton T-shirt / White / STopsPiece
CLO-006Cotton T-shirt / White / MTopsPiece
CLO-007Cotton T-shirt / White / LTopsPiece
CLO-008Cotton T-shirt / White / XLTopsPiece
Browse the remaining 88 items
Remaining suggested items
Item codeItem nameCategoryUnit
CLO-009Casual shirt / Blue / STopsPiece
CLO-010Casual shirt / Blue / MTopsPiece
CLO-011Casual shirt / Blue / LTopsPiece
CLO-012Casual shirt / Blue / XLTopsPiece
CLO-013Casual shirt / White / STopsPiece
CLO-014Casual shirt / White / MTopsPiece
CLO-015Casual shirt / White / LTopsPiece
CLO-016Casual shirt / White / XLTopsPiece
CLO-017Jeans / Blue / 30BottomsPiece
CLO-018Jeans / Blue / 32BottomsPiece
CLO-019Jeans / Blue / 34BottomsPiece
CLO-020Jeans / Blue / 36BottomsPiece
CLO-021Jeans / Black / 30BottomsPiece
CLO-022Jeans / Black / 32BottomsPiece
CLO-023Jeans / Black / 34BottomsPiece
CLO-024Jeans / Black / 36BottomsPiece
CLO-025Cotton trousers / Beige / 30BottomsPiece
CLO-026Cotton trousers / Beige / 32BottomsPiece
CLO-027Cotton trousers / Beige / 34BottomsPiece
CLO-028Cotton trousers / Beige / 36BottomsPiece
CLO-029Cotton trousers / Black / 30BottomsPiece
CLO-030Cotton trousers / Black / 32BottomsPiece
CLO-031Cotton trousers / Black / 34BottomsPiece
CLO-032Cotton trousers / Black / 36BottomsPiece
CLO-033Casual dress / Navy / SDresses and abayasPiece
CLO-034Casual dress / Navy / MDresses and abayasPiece
CLO-035Casual dress / Navy / LDresses and abayasPiece
CLO-036Casual dress / Navy / XLDresses and abayasPiece
CLO-037Casual dress / Beige / SDresses and abayasPiece
CLO-038Casual dress / Beige / MDresses and abayasPiece
CLO-039Casual dress / Beige / LDresses and abayasPiece
CLO-040Casual dress / Beige / XLDresses and abayasPiece
CLO-041Long-sleeved blouse / White / STopsPiece
CLO-042Long-sleeved blouse / White / MTopsPiece
CLO-043Long-sleeved blouse / White / LTopsPiece
CLO-044Long-sleeved blouse / White / XLTopsPiece
CLO-045Long-sleeved blouse / Black / STopsPiece
CLO-046Long-sleeved blouse / Black / MTopsPiece
CLO-047Long-sleeved blouse / Black / LTopsPiece
CLO-048Long-sleeved blouse / Black / XLTopsPiece
CLO-049Light jacket / Grey / SJackets and knitwearPiece
CLO-050Light jacket / Grey / MJackets and knitwearPiece
CLO-051Light jacket / Grey / LJackets and knitwearPiece
CLO-052Light jacket / Grey / XLJackets and knitwearPiece
CLO-053Light jacket / Black / SJackets and knitwearPiece
CLO-054Light jacket / Black / MJackets and knitwearPiece
CLO-055Light jacket / Black / LJackets and knitwearPiece
CLO-056Light jacket / Black / XLJackets and knitwearPiece
CLO-057Knitted jumper / Beige / SJackets and knitwearPiece
CLO-058Knitted jumper / Beige / MJackets and knitwearPiece
CLO-059Knitted jumper / Beige / LJackets and knitwearPiece
CLO-060Knitted jumper / Beige / XLJackets and knitwearPiece
CLO-061Knitted jumper / Navy / SJackets and knitwearPiece
CLO-062Knitted jumper / Navy / MJackets and knitwearPiece
CLO-063Knitted jumper / Navy / LJackets and knitwearPiece
CLO-064Knitted jumper / Navy / XLJackets and knitwearPiece
CLO-065Everyday abaya / Black / SDresses and abayasPiece
CLO-066Everyday abaya / Black / MDresses and abayasPiece
CLO-067Everyday abaya / Black / LDresses and abayasPiece
CLO-068Everyday abaya / Black / XLDresses and abayasPiece
CLO-069Everyday abaya / Navy / SDresses and abayasPiece
CLO-070Everyday abaya / Navy / MDresses and abayasPiece
CLO-071Everyday abaya / Navy / LDresses and abayasPiece
CLO-072Everyday abaya / Navy / XLDresses and abayasPiece
CLO-073Adult pyjama set / Grey / SNightwearSet
CLO-074Adult pyjama set / Grey / MNightwearSet
CLO-075Adult pyjama set / Grey / LNightwearSet
CLO-076Adult pyjama set / Grey / XLNightwearSet
CLO-077Adult pyjama set / Blue / SNightwearSet
CLO-078Adult pyjama set / Blue / MNightwearSet
CLO-079Adult pyjama set / Blue / LNightwearSet
CLO-080Adult pyjama set / Blue / XLNightwearSet
CLO-081Children’s outfit / Blue / 4YChildren’s clothingSet
CLO-082Children’s outfit / Blue / 6YChildren’s clothingSet
CLO-083Children’s outfit / Blue / 8YChildren’s clothingSet
CLO-084Children’s outfit / Blue / 10YChildren’s clothingSet
CLO-085Children’s outfit / Green / 4YChildren’s clothingSet
CLO-086Children’s outfit / Green / 6YChildren’s clothingSet
CLO-087Children’s outfit / Green / 8YChildren’s clothingSet
CLO-088Children’s outfit / Green / 10YChildren’s clothingSet
CLO-089Children’s pyjama set / Pink / 4YChildren’s clothingSet
CLO-090Children’s pyjama set / Pink / 6YChildren’s clothingSet
CLO-091Children’s pyjama set / Pink / 8YChildren’s clothingSet
CLO-092Children’s pyjama set / Pink / 10YChildren’s clothingSet
CLO-093Children’s pyjama set / Blue / 4YChildren’s clothingSet
CLO-094Children’s pyjama set / Blue / 6YChildren’s clothingSet
CLO-095Children’s pyjama set / Blue / 8YChildren’s clothingSet
CLO-096Children’s pyjama set / Blue / 10YChildren’s clothingSet

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.

  1. Remove models you do not sell, and edit names so they match the label in your shop.
  2. Enter the real manufacturer barcode in the text field so leading zeros are not dropped.
  3. Add quantities and purchase and selling prices in one currency.
  4. 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 guide

Try 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.