Thanks. That's kind of what I figured. Was hoping I could just write a simple sql insert but that doesn't look likely. Might just have to use the initial inventory routine.

SQL is a dangerous way to go - it bypasses all of the business logic. You could quickly end up with a mess of a database. OpenERP wasn't written to handle a database in an inconsistent state and it won't do so elegantly. You should configure the server to log SQL calls so you can see what is happening when something is done via the UI to make sure you are 100% sure you understand the data model and can use SQL properly to update the database.

Yeah, I was thinking the same thing and looking at how to enable logging in PostgresQL. Any tips? I've got logging set to "all" in the conf file, but it's not logging anything - i made changes to the inventory and product and get nuthin...

http://lmgtfy.com/?q=openerp+sql+logging

first thing i did was google it. got logging on postgresql enabled and i think everything in the conf file is right... still don't get any sql stuff... i'm stuck...i'll post it on stackoverflow and see if anyone there knows what i'm missing... thanks for your help though.

Take a look at OpenERP Webservice!