# Data import - here: articles

**URL:** https://discuss.tryton.org/t/data-import-here-articles/2679
**Category:** User
**Created:** [May 5, 2020, 8:39am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679 "2020-05-05T08:39:13Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [May 5, 2020, 8:39am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/1 "2020-05-05T08:39:13Z")

</div>

I’m trying to import a CSV list of articles. Found the “import” menu entry meanwhile, but when triggering the import, it says “Fehler mit Warenbestand” (error with stock). I assume, this is for the reason that there is not an item as “Warenbestand / stock” in my list:

 ![Bildschirmfoto von 2020-05-05 10-24-33](https://discuss-cdn.tryton.org/uploads/default/original/1X/99c379633e59a4d619aeedb26bd76955efa7ec89.png)

Modules “stock” and “stock\_consignment” are activated - do I need another one to handle stock?

A second question occurs:  
For what reason are there some double entries, e.g. “Listenpreis” or "Methode Kostenpreis ?

Thanks lot in advance,  
Wolf

---

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [May 5, 2020, 9:53am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/2 "2020-05-05T09:53:10Z")

</div>

Could you list (in english if possible) the name of fields you are importing?

Sorry but as a non german speaker I did not understand most of your words.

P.S: Please open a single topic for each question you have

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [May 5, 2020, 9:57am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/3 "2020-05-05T09:57:14Z")

</div>

Name  
Listenpreis (listed price)  
Varianten/Beschreibung (variants / description)  
ID  
Varianten/Artikelnummer (variants / ID of article)  
Warenbestand (stock - amount of items available)  
Mindestbestand vor Warnung (minimum stock before waring)  
Gewünschter Lagerbestand (stock desired)  
Lieferant (supplier)  
Lieferanten-Artikelnummer (supplier’s ID of article)  
Einkaufspreis (purchase price of article)

> [@pokoli](#):
>
> P.S: Please open a single topic for each question you have

Yes, I will.

---

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [May 5, 2020, 10:06am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/4 "2020-05-05T10:06:26Z")

</div>

> [@herrdeh](#):
>
> Warenbestand (stock - amount of items available)

This field is not importable by default. I bet you have a custom module that modifies the field and the error is there.

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [May 5, 2020, 10:53am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/5 "2020-05-05T10:53:47Z")

</div>

> [@pokoli](#):
>
> This field is not importable by default.

Nonono. Everything very much vanilla. But I didnt know that I cannot import number of items available. No way?

Now I got a bit further on, and end up with this error:

````Traceback
  File "/usr/local/lib/python37/dist-packages/trytond/wsgipy", line 108, in dispatch_request
    return endpoint(request, **requestview_args)
  File "/usr/local/lib/python37/dist-packages/trytond/protocols/dispatcherpy", line 48, in rpc
    request, database_name, *requestrpc_params)
  File "/usr/local/lib/python37/dist-packages/trytond/wsgipy", line 76, in auth_required
    return wrapped(*args, **kwargs)
  File "/usr/local/lib/python37/dist-packages/trytond/protocols/wrapperspy", line 131, in wrapper
    return func(request, pool, *args, **kwargs)
  File "/usr/local/lib/python37/dist-packages/trytond/protocols/dispatcherpy", line 186, in _dispatch
    result = rpcresult(meth(*c_args, **c_kwargs))
  File "/usr/local/lib/python37/dist-packages/trytond/model/modelstoragepy", line 974, in import_data
    records = clscreate(to_create)
  File "/usr/local/lib/python37/dist-packages/trytond/modules/product/productpy", line 157, in create
    return super(Template, cls)create(vlist)
  File "/usr/local/lib/python37/dist-packages/trytond/model/modelsqlpy", line 159, in wrapper
    return func(cls, *args, **kwargs)
  File "/usr/local/lib/python37/dist-packages/trytond/model/modelsqlpy", line 667, in create
    fieldset(cls, fname, *fargs)
  File "/usr/local/lib/python37/dist-packages/trytond/model/fields/one2manypy", line 241, in set
    actions[action](ids, *args)
KeyError: '3'```
````

---

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [May 5, 2020, 11:23am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/6 "2020-05-05T11:23:08Z")

</div>

> [@herrdeh](#):
>
> But I didnt know that I cannot import number of items available. No way?

You must create an inventory for the location and then add a line for each product available. Have a look at the [documentation](https://docs.tryton.org/projects/modules-stock/en/latest/#inventory).

---

<div class="post-metadata">

### Author: ![josesalvador](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/josesalvador/32/602_2.png) [@josesalvador](https://discuss.tryton.org/u/josesalvador)
#### Post date: [May 5, 2020, 11:28am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/7 "2020-05-05T11:28:07Z")

</div>

> [@pokoli](#):
>
> You must create an inventory for the location and then add a line for each product available. Have a look at the [documentation](https://docs.tryton.org/projects/modules-stock/en/latest/#inventory).

[The documentation says](https://docs.tryton.org/projects/modules-stock/en/latest/#inventory) that doesn’t suite for initial importations…

---

<div class="post-metadata">

### Author: ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [May 5, 2020, 6:50pm UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/8 "2020-05-05T18:50:17Z")

</div>

> [@josesalvador](#):
>
> [The documentation says](https://docs.tryton.org/projects/modules-stock/en/latest/#inventory) that doesn’t suite for initial importations…

Only when a non fixed cost price is used for inventory valuation

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [May 6, 2020, 10:30am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/9 "2020-05-06T10:30:19Z")

</div>

I postponed the attempt to import amounts in stock and tried to import a inventory list without first. I simplified it as much as possible, but got the same error as under msg. #5.

Here is the CSV file  
[https://www.dropbox.com/s/ogxif9z4osggj6x/3-test-Artikelliste-kkb.csv?dl=0](https://www.dropbox.com/s/ogxif9z4osggj6x/3-test-Artikelliste-kkb.csv?dl=0)

; and ’ are separators.

---

<div class="post-metadata">

### Author: ![herrdeh](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/herrdeh/32/821_2.png) [@herrdeh](https://discuss.tryton.org/u/herrdeh)
#### Post date: [May 8, 2020, 8:03am UTC](https://discuss.tryton.org/t/data-import-here-articles/2679/10 "2020-05-08T08:03:58Z")

</div>

Should I file a bug report? - But I tend to believe that the problem is not the software…
