openerp - How do I import/update (eg cost price) in Odoo -

i using odoo v8 in combination magento. imported products magento odoo, mass update multiple fields on products in odoo based on internal reference field: - cost price - supplier - inventory levels - weight - status - leadtime

what best way that? can use import csv function or have directly via database?

thanks, michael

if need update lot of data, suggest use csv file, reduces write code more use xml file insert/update/etc... data in data base, , in personal opinion insert/update/etc... data manually it's not best practice.

for example insert country state in data base:

by csv file:

id country_id:id name code state_us_1 alabama al state_us_2 alaska ak state_us_3 arizona az state_us_4 arkansas ar state_us_5 california ca state_us_6 colorado co state_us_7 connecticut ct state_us_8 delaware de

by xml file:

<record model="res.country.state" id="state_us_1">     <field name="name">alabam</field>     <field name="code">al</field>     <field name="country_id" ref="base.us"/> </record>  <record model="res.country.state" id="state_us_2">     <field name="name">alaska</field>     <field name="code">ak</field>     <field name="country_id" ref="base.us"/> </record> 

one record every data!

i hope can you!