Hello,
If you have "simple" object to import (ie: not a multi variant product like I try to do right now, see my thread if interested) then I suggest you to use some XML RPC tool to update the product list (but also customers, contacts, or others object when you will become familiar with XML RPC).
This way you'll directly go thru the Controller of the MVC (Model Controller View) architecture of OpenERP and all data integrity (thru product.template model or others) will be checked/updated/...
For just importing "simple" products (name, ref, uom, price, ean13, ... ) it take around 30s on my ubuntu server (running as a VM on my laptop) for 5000 products from a cvs file (using my own perl script).
The only thing to prepare before if you want to only load product.product are :
product.category
=> You have to define the category (name, parent, account,...) and get back the id to use them as part of the product.product model within categ_id field
product.uom
=> you have to create required unit (ie: I need surface unit like cm² and have to create a Surface category then cm² unit part of Surface) and get back the id to use them as part of the product.product model within uom_id (default unit) and uom_po_id (unit for ordering if not same as default).
OpenERP Controller will update product.template itself you will not have to deal/bother with it (interesting isn't it ? :o) ).
Have a look to the OpenERP dev guide for more XML RPC exemples (I script in perl but work for any RPC XML capable language).
h t t p : / / doc.openerp.com/v6.0/developer/6_22_XML-RPC_web_services
My "main" advice is that dealing with Controller of the OpenERP MCV is safer than dealing directly with PGSQL DB mainly as :
- some model not always belong on a "one to one" with a table.
- quite all "[many|one]2[many|one]" relations seems only to be defines within the Controller rules, not the pgSQL DB.
Hope this will help you.
@++
Nicolas
Did you have a look to youtube ? There is a tutorial for importing products directly into postgresql. It helped me a lot.