any guides for the minimum data required for initial setup.... we have 150,000 Sku so the CSV import tool is not robust enough.
for products it seems like 2 tables (product_template first then product-product) do i just need the not NULL fields populating ?
what about customers and procurement rules ?
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.
About This Community
|Asked: 3/4/13, 12:58 PM|
|Seen: 3839 times|
|Last updated: 3/16/15, 8:10 AM|