I am trying to do the same: I have some products, defined some parties (actually Party groups) and now I am trying to associate the products to these parties with a Vendor role. In https://localhost:8443/catalog/control/addPartyToProduct if I select a role different from "Not Applicable" I get the following error:
ERROR: Could not complete the Add Party to Product [file:/F:/ofbiz/applications/product/script/org/ofbiz/product/product/ProductServices.xml#addPartyToProduct] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProductRole][createdStamp,2008-04-22 21:40:09.906(java.sql.Timestamp)][createdTxStamp,2008-04-22 21:40:09.859(java.sql.Timestamp)][fromDate,2008-04-22 21:40:09.906(java.sql.Timestamp)][lastUpdatedStamp,2008-04-22 21:40:09.906(java.sql.Timestamp)][lastUpdatedTxStamp,2008-04-22 21:40:09.859(java.sql.Timestamp)][partyId,10001(java.lang.String)][productId,PNE-0002(java.lang.String)][roleTypeId,VENDOR(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_ROLE (PRODUCT_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_ROLE' caused a violation of foreign key constraint 'PROD_RLE_PTYRLE' for key (10001,VENDOR). The statement has been rolled back.))] I am using an ofbiz installation in which I have only loaded the seeds. Is there some other step I am missing? Thank you, -Bruno 2008/4/22 Raj Saini <[EMAIL PROTECTED]>: > Divide your product in general categories. And use the parties tab to add > manufacturer role to a product. You can use get a list of manufacturers from > the product and role association entity (I don't remember exactly but I > think it is ProductRole ). > > Thanks, > > Raj > > > shristhi sharma wrote: > > > I am trying to configure ofbiz for auto parts store. I wish to classify > > products into two major categories. General category (Wheels for > > example) > > and brands (Bridgestone). > > > > I am looking sidedeepcategory.bsh, CommonScreens.xml and > > CategoryWorker.java > > > > Guys, i donno the efficient way of doing this .. i am afraid it will be > > a > > big mess at the end. Any suggestion will be great. > > > > Thanks > > > > > > > >
