I don’t know how to upload an csv full of my product
This indeed is a big challenge in Tryton.
I suggest you create a list of all your product properties (name, ID, list price, variants etc) and ask experts here to create a set of table headers for you. Creating these headers is really hard, but with those, it’s quite easy to do the import.
Sorry, I’m not enough of an expert to create these headers for you.
Cheers,
Wolf
What do you mean by “overwrite”? Is it that you want to update existing records with new values?
“Really hard”…really? I’m not a user yet, but getting closer, and information on imports is important.
Is there much difference in the procedure for the initial import of new products (which would be the action of a novice user) and the subsequent import (for price updates, descriptions etc.), as I assume the OP is proposing?
CSV import is not the best way to work with Tryton.
Most of the service companies are indeed using scripts to import the initial data (usually from an older system). This is because such way is reproductible and testable while CSV import is manual and error prone.
The update of existing data is usually done manually because there are not very much use case where more is needed.
There is one case I can think of which is the update of supplier price but usually this depends on the supplier format.
When talking about CSV import you can use a CSV file to import records of a single table. Note that the single table is important as tryton is a relational model an sometimes you wan’t to update that of several tables in a bunch, so CSV will not work for such case.
Once you have some data loaded into a tryyton table, you can export it using a CSV file including the ID field (which is the internal identifier of the record inside tryton). Uploading the CSV file with the id will update all the fields present on the table, so you can use such feature to update a bunch of records in a single step.
ok, indeed something to practise on a development copy first!