How do I add an item with sizes and colours?
An item with sizes and colours isn’t split into several records: it is still a single one, with its variants. Each variant is a combination (for example, size M and colour red) with its own code, its description, its own stock and, if you want, its own sale and purchase prices.
What do I need before I start?
Only the item added, with its Code filled in: each variant’s code is built from it. Adding an item is explained in add an item.
You don’t need to create the sizes or the colours first: they are typed on the record itself. If your company works with manual key management, however, they are defined first in Warehouse → Sizes and colours; it is explained in set up sizes and colours.
What is on the Sizes tab?
Open the item record and go to the Sizes tab. It has two blocks:
- Size and colour breakdown: the item’s dimensions (Size, Colour, Model…, up to three) and, under each one, the values it accepts and a field to add another.
- Combinations: the item’s variants, in Grid —a grid with all the ones it can have and which ones it has— or in List —one row per combination, with its code, its description, its SKU, its barcode, its prices and whether they are published—. You switch with the two buttons in the block header.
When is what I do on the tab saved?
Only when you click Save sizes. Everything you do on the tab —choosing dimensions, adding or removing a size or a colour, creating combinations, changing prices or removing combinations— is shown straight away, but it isn’t saved until that button, and then it is all saved together. If something can’t be saved, the warning appears and nothing is saved: what you did stays on screen so you can correct it.
If you leave the record without clicking it, nothing of what you did is kept. Nor are the sizes or colours that are new to the company: they are created when you save. Discard goes back to what was saved without leaving the record.
Where do its dimensions come from?
From its item family, if the item family has them: a new item in ‘Camisetas’ already comes with Size and Colour, and with the values the item family accepts. Below the dimensions it says so: ‘Inherited from the “Camisetas” family’. It is set up on the item family record; it is explained in set up sizes and colours.
If its item family doesn’t have any, or you want others, choose them here, in First dimension, Second dimension and Third dimension. Choosing a new one makes the next one appear. Any combinations you need are fine: Size + Colour, Model + Format, only Colour, Model + Colour + Size…
As soon as the item’s sizes are changed —dimensions are chosen for it, a value is added or its first combination is created—, the dimensions become its own: changing its item family afterwards no longer affects it. As long as it has no combinations, the Inherit from the family button puts them back to those of its item family.
With combinations, the dimensions can no longer be changed: they are in each one’s code.
How do I add a size or a colour?
- On the Sizes tab, type the name in its dimension’s Add field —for example
XLin Add size, orAzul marinoin Add colour— and pressEnteror Add. - The value appears in its dimension’s list: the item now accepts it.
Adding a value doesn’t create combinations. The explosion of combinations is real —10 sizes by 12 colours is already 120—, so it is best for each one to be created when it is used: when buying it, or when creating it here.
If you type a value in each dimension at once —M and Azul marino— and press Enter, that exact combination is also created.
If the value already exists in the company —because it was used on another item—, it is reused: it doesn’t matter how you write it, ‘azul marino’, ‘Azul Marino’ or ‘AZUL MARINO’ are the same colour. If it doesn’t exist, it is created automatically. You never have to make up a key: the program sets its own internally, and on screen you always see the name.
Each item only accepts what you add to it (or what its item family accepts). Another item in the company being sold in red doesn’t make this one have red.
What you add is saved with Save sizes, like everything on the tab. If meanwhile someone else adds the same name on another item, theirs is reused when you save: you don’t end up with two ‘Azul marino’.
How do I remove a value?
With the × on the value’s tag. It only appears on values that no combination of the item uses; to remove one that is used, remove those combinations first.
If the values came from the item family’s value set, removing one makes the item have its own list (the value set’s minus that value). The same when adding: its list is the value set’s plus what was added. It doesn’t affect the other items in the item family.
What is the combinations grid like?
It is the convenient way to handle an item with many combinations. The item’s last dimension goes in columns and the others in rows:
| The item has | Rows | Columns |
|---|---|---|
| Size and colour | One per size | The colours |
| Model, colour and size | One for each pair of model and colour, such as Slim · Azul | The sizes |
| A single dimension | A single row | Its values |
All the values the item accepts are shown, whether or not it has the combination. Below it says how many it has out of how many it could have.
- Create a combination: click the
+in its empty cell. It appears straight away, with the item’s price, and is saved with Save sizes. - Add a size or a colour: type its name in the
+field at the end of the columns (and, with two dimensions, in the one below the rows) and pressEnter. It works the same as the Add fields above.
With The cell shows you choose what to see in each combination that exists:
| Option | What appears in the cell |
|---|---|
| If it exists | A mark, and the × to remove it |
| Sales price, Purchase price | Its own price, editable; empty = it inherits the item’s |
| Barcode, SKU | Its own, editable |
| Stock | What there is of that combination adding up all warehouses, view only |
Whatever you change or remove in the grid is saved with Save sizes, as in the list: they are the same combinations seen another way.
How do I create combinations?
It is best not to create them all: let them be created when you buy them —by filling in their box in the purchase grid, and they are created when it is saved; it is explained in sell an item with sizes— or when you need them. One by one, with the + in the grid. When you do want several at once:
- Click Create combinations….
- In each dimension, choose the First and the Last value of the range. By default they are all included.
- Read what the dialog says: how many combinations would come out, how many are new and how many it already has.
- Click Create.
The dialog warns you depending on how many new combinations would come out:
| New | What happens |
|---|---|
| Fewer than 100 | They are just created |
| From 100 to 499 | It warns you that there are many, and they are created |
| From 500 to 2.000 | You have to tick Yes, create the … combinations to be able to create them |
| More than 2.000 | They aren’t created: narrow the ranges |
Combinations that already existed are kept as they are, with their edited description, their SKU and their own price. Creating again doesn’t overwrite them: it only fills in what is missing. They are saved with Save sizes.
New combinations start with the same publishing mark as the item.
What do I edit on each combination?
In the List view you can change the Description, the SKU, the Barcode, the Sales price, the Purchase price and the Publish box. Remove the ones you won’t use with the bin. Click Save sizes. Prices, the SKU and the barcode can also be changed from the grid.
Each combination’s Code isn’t typed: it is built automatically from the item code and each value’s key, in the order of the item’s dimensions. Combinations that came from the Desktop ERP keep the code they had there (000000301), the one on their labels.
Save sizes is a separate button from the record’s Save changes. What is on the Sizes tab is saved with its own; the rest of the tabs, with the one in the header.
How do I give a combination a price?
In the Sales price and Purchase price columns. Leave them empty and the combination inherits the item’s Sale price 1 and purchase price; the field shows inherits when it is empty.
Each combination can cost something different: a large size is often more expensive to buy. That is why the purchase price also goes per combination.
When selling, the line takes the combination’s own sale price and, if it doesn’t have one, the item’s. It doesn’t matter how you choose it: by typing its code, in the grid or in the selection window.
When buying, the line takes, in this order:
- The last price you bought that combination at from that supplier.
- The combination’s own Purchase price.
- The last price you bought the item at from that supplier, in any size.
- The item’s purchase price.
A purchase never takes the sale price.
That price is the line’s starting point. Whatever you do afterwards on the line itself —discount, price typed by hand— works the same as on an item without variants. It is explained in set prices and price lists.
Can I change a combination’s description?
Yes, by typing over it in the Description column and clicking Save sizes. The description you type is kept and isn’t rebuilt again.
If you delete the description and save, it is rebuilt automatically from the item name and the descriptions of its values (or with the template the company has set up).
The Code doesn’t change when you save as long as the combination has the same values. If you have changed the item’s Code, just save its combinations again to bring them up to date.
How do I find a combination when invoicing?
Type its built Code in the line’s code cell. Its SKU or its Barcode also work, if you have given it them.
The line always shows the real code of what is being sold, even if you found it by typing an SKU.
If you type the base item’s code, the program asks you for the combination. It is explained in sell an item with sizes.
Can I stop using sizes on an item?
Yes, but first you have to remove all its combinations: delete them from the list and click Save sizes. Then set the First dimension to No detail, or click Inherit from the family.
Can an item with stock start having sizes?
No, if it has stock without a size. With sizes, its stock is counted per combination, and the stock without a size would no longer show in reports or in the valuation. Adjust that stock first (set it to zero) and then give it its dimensions.
Why does it warn me about units without a size?
Because the item has units that count in its total but are not in any of its combinations. They usually date from before it had sizes: an item brought from the desktop ERP, or one whose combinations were created from the record when it already had stock.
The warning shows at the top of the Sizes tab and says how many there are. Those units don’t show in what is counted per combination, and the online store, which publishes the stock of each size, doesn’t show them.
For them to count they have to be adjusted: moved to the size they belong to. Do it with whoever runs the warehouse, because it is a stock movement.
What happens if I remove a combination that already has stock or sales?
It isn’t allowed. When you click Save sizes a warning appears naming the combinations that can’t be removed and why, and nothing is saved.
A combination can’t be removed if it has stock other than zero in any warehouse or if it appears on any document line, even if its stock is at zero. Those lines are the history of which size was sold or bought.
A combination that was created and never used is removed without any problem. If what you want is to stop selling it, untick its Publish box.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| ‘The item has no dimensions: first choose which ones it uses…’ | Neither the item nor its item family has dimensions | Choose its First dimension, or give them to its item family |
| ‘The item already has combinations: its dimensions cannot be changed’ | You are trying to change its dimensions with combinations created | Remove its combinations first (if none has stock or sales) |
| ‘The item has stock without a size…’ | It has units without a size in some warehouse | Adjust that stock and try again |
| ‘The item needs a code to build the codes of its combinations.’ | The item has no Code | Give it one on the General tab |
| ‘A dimension cannot be repeated in the same item.’ | You have chosen the same dimension twice | Choose another |
| ‘“X” has no values in this item: add some first.’ | You ask to create combinations and one dimension is empty | Add at least one value in that dimension |
| ‘That’s N new combinations: confirm to create them.’ | There are more than 500 | Tick the box in the dialog, or narrow the ranges |
| ‘This would give N new combinations and at most 2000 can be created at once’ | There are too many | Narrow the ranges and create them in several goes |
| ‘The item already has …’ | That combination already exists | Nothing to do. If you were looking for another, check how you typed it |
| ‘“X” is used by combinations of the item: remove them first.’ | You are removing a value that some combination uses | Remove those combinations first |
| ‘… doesn’t exist in “Size”. With manual key management…’ | Your company defines its values by hand, and that name isn’t there | Add it in Warehouse → Sizes and colours, Dimensions tab, and add it again |
| ‘There are no free … keys left…’ | All the keys that fit in the dimension’s width have been used | Ask for the dimension’s Key width to be increased (only if no item with combinations uses it) |
| ‘Combination X/Y is duplicated.’ | Two rows with the same values | Remove one of the two |
| The combination codes have the item’s old code | You changed the item’s Code after creating them | Save its combinations again with Save sizes |
See also: Add an item · Set up sizes and colours · Sell an item with sizes · View stock by size · Set prices and price lists
More about Records
- How do I change the length of codes?
- What are trades for?
- What are customer types for?
- How do I classify my customers by type, route, trade and carrier?
- How do I set up my company’s sizes and colours?
- How do I add a sales agent?
- How do I add an item?
- How do I add a customer?
- How do I add a supplier?
- How do I add my customers’ vehicles?
- How do I add a currency?
- Mailing for your customers and suppliers