How do I add several items at once with the assistant?
Paste the list to the assistant —or attach the sheet— and tell it to create them. It prepares a single card with all the records and adds them with one click. Up to 50 items per action fit.
How do I ask it?
You ask it in plain language and give it the list in the same message. A table copied from a spreadsheet, a list typed by hand or an attached file all work:
‘Create the records for all these products: Sofá Oslo 3 plazas · Sofás · 1.299 Mesita Roma · Dormitorio · 149 Silla Nórdica · Sillas · 89’
You can also attach the file and just type ‘add these items’: the paperclip accepts CSV, TXT and XLSX spreadsheets, and it is explained in attach a CSV or a spreadsheet.
Whatever you paste or attach stays as working material for the conversation: if you then correct something (‘the first three go at 10 %’), there is no need to paste the table again.
Which columns does it understand?
For each item it understands these details, and only the name is required:
| Detail | What it does |
|---|---|
| Name | The only thing that’s essential |
| Code | If your list has a code or reference column, it is used as it is. If it has none, the ERP sets it following your series |
| Item family | By its name. If it doesn’t exist, it is created with the item |
| Description | The sales description |
| Brand | It must already exist in your brands master |
| Price | Excluding VAT, or including VAT if you state the rate |
You don’t need headings with those exact names: the assistant reads the table as you give it and shows you on the card how it has understood each row. Anything that doesn’t fit any of those details is completed later on the *item*’s record.
What about the item family, the brand and VAT?
The item family is given by its name and, if it doesn’t exist, it is created with the item. You don’t need to create it beforehand or know any number: type ‘Sofás’ and, if your catalogue doesn’t have it, the card tells you it is going to create it. If you want to create separate item families —or a sub-family inside another—, ask it for that too: ‘create the Sofás y sillones family’, ‘add the Mesitas de noche sub-family inside Dormitorio’. An item family that already exists isn’t duplicated.
The brand must already exist. The brands master has its own code and the assistant doesn’t invent it: if the brand you give isn’t there, the item is created without a brand and the result warns you so that you can set it on the record.
VAT isn’t assumed. If you give prices including VAT, the rate (21, 10, 4…) is needed so that the ERP stores the base. If you don’t say it, it asks you once and for the whole list; it never chooses one on its own. If you give prices excluding VAT, there is nothing to ask.
What can’t be included when adding them?
Two things, and both have their place.
Not the image. That goes on the item’s record, in the header: it is explained in add an item.
Not the opening stock either. Setting stock is a warehouse movement, not a detail on the record. Once they are created, ask for it as a count: ‘adjust the stock: there are 4 of the Sofá Oslo and 12 of the Mesita Roma’. The assistant does it in a separate action, with its own confirmation.
Everything else —supplier, price lists, sizes and colours— is completed later on the record, just as if you had added it by hand.
What does it show me before creating them?
A Proposed action card with the summary (‘Create 5 new items’) and the Action details drop-down, which in a batch add is already open: what you are confirming is the records, one row per item, not the summary.
Read it before confirming. Those details are exactly what is going to be created, with the item family it has worked out for each one and the code from your list. If your list had codes and they don’t appear in the details, don’t confirm: tell it ‘use the codes from the table’ and it prepares the card for you again. A row without a code is a row the ERP will give the next number in your series.
The batch is checked in full before anything is created, and it all goes in or nothing does. If a row is wrong —a repeated code, a VAT rate that isn’t your company’s—, no record is created: it tells you which row and what is wrong with it, you correct it and repeat it.
And if some already exist?
An item that already has the same name doesn’t bring down the batch: it is skipped and the result says which one. The comparison ignores capitals and accents, so ‘Sofá Oslo’ and ‘sofa oslo’ are the same name. The others are created as normal.
When you ask it for a single item and there is already one with that name, the add is rejected and it tells you the code of the existing one. If you really want two with the same name, tell it and it creates it.
And if there are more than 50?
Fifty is the limit for one action. With a longer list, the assistant splits it into several actions and proposes them to you one after another; you can also split it yourself and send it in two messages.
A very large spreadsheet isn’t a conversation, it is an import: for a whole catalogue there is the import screen, which is the route designed for that.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| ‘Item X “…” already exists…’ | You asked for just one and there is already another with that name | Use the existing one, or tell it you want another the same |
| ‘…: already exists as X’ in the result | A row in the batch was skipped because of a repeated name | Nothing: the rest were created. Check that record |
| ‘Row N (“…”): an item with code “…” already exists.’ | That row’s code is already in use | Nothing has been created: remove that code —the ERP sets it— and repeat |
| ‘Row N (“…”): code “…” is repeated in the batch…’ | Two rows have the same code | Correct the list and repeat it |
| The item is created without a brand | That brand isn’t in your master | Create it in Brands and set it on the record |
| It asks you for the VAT rate | You gave prices including VAT without stating the rate | Tell it the rate: it applies to the whole list |
See also: Ask the assistant to do something · Attach a CSV or a spreadsheet · Add an item
More about Assistant
- Can I attach a CSV or a spreadsheet for the assistant?
- Can I show the assistant an image or a PDF?
- How do I teach the assistant about my company?
- How do I choose how much effort the assistant makes?
- Working with the assistant
- How do I ask for a professional analysis and what does it cost me?
- How do I ask the assistant to do something in the ERP?
- How do I put the assistant on my website?
- How do I ask the assistant something?
- Test the assistant and find out what it costs
- Can I tell the assistant to stop asking me about the professional analysis?
- What does the assistant know and what doesn’t it?