Tom, you can get the next object_id by calling db_nextval acs_object_id_seq. Pass this object_id to product__new and your new product will have the object_id as product_id.
This is how it works in the ecommerce package for ec_product__new. From your post it is not clear wether you mean a different product__new procedure or not.
