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