Two root category

[shristhi sharma]

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

[rajsaini]

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
>
>  

[Bruno Busco]

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 <[hidden email]>:

> 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
> >
> >
> >
>
>

[Bruno Busco]

OK,
-SOLVED-
I have found that I need to specify that a party can play a role here
https://localhost:8443/partymgr/control/viewroles?partyId=10000
before linking to a product with that role. (Sorry...)

-Bruno

2008/4/22 Bruno Busco <[hidden email]>:

> 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 <[hidden email]>:
>
> 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
> > >
> > >
> > >
> >
> >
>

[Valentina Sirkova]

Quoting shristhi sharma <[hidden email]>:

> 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
>

Hi,
What the others suggested you is  the right approach. Just one  
clarification if  you would like to sell as products what is under  
your brands category and you wonder how to organize your categories  
then it will be useful for you to see these links:  
http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide
The methods in CategoryWorker.java reffered from sidedeepcategory.bsh  
build the product catalog category tree starting from root. You could  
assosiate other categories to the root through ProductCategoryRollup
Valentina :)

[rajsaini]

Have you created new roles if they do not exists? You will also need to
associate those roles to your party in party manager before you
associate a party in catalog manager. Party lookup catalog manager shows
all the roles, instead it should show only roles the selected party is
member. Therefore, be careful to choose only role which your party is
associated in party manager.

Raj
Bruno Busco wrote:

> 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 <[hidden email]>:
>
>  
>> 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
>>>
>>>
>>>
>>>      
>>    
>
>  

[Bruno Busco]

Suppose my products are tyres and I would like to show in the product detail
screen a little brand logo (goodyear, bridgestone etc.) and this should be
clickable and take to the brand web site.
What is the best way to implement?
I have seen a "brand" field in the product page but I am confused about
using this field (that seems to be a simple string) or link the product to a
"Party group" that can have the web site and logo associated to it.
If this second solution should be used do you suggest to define a new party
role for what I have to do or may be some already exists?

Thank you,
-Bruno

2008/4/23 Raj Saini <[hidden email]>:

> Have you created new roles if they do not exists? You will also need to
> associate those roles to your party in party manager before you associate a
> party in catalog manager. Party lookup catalog manager shows all the roles,
> instead it should show only roles the selected party is member. Therefore,
> be careful to choose only role which your party is associated in party
> manager.
>
> Raj
>
> Bruno Busco wrote:
>
> > 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 <[hidden email]>:
> >
> >
> >
> > > 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
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>

[rajsaini]

You are right, brand field is simple text. I am also not sure what could
be the purpose it.

However, there is also a OEM field on product page. OEM stands for
"Original Equipment Manufacturer". I am not sure what is the intended
use of this field but it looks most suitable to me. You can create a
Party Group for each manufacturer and associate with product using OEM
field.

Thanks,

Raj

Bruno Busco wrote:

> Suppose my products are tyres and I would like to show in the product detail
> screen a little brand logo (goodyear, bridgestone etc.) and this should be
> clickable and take to the brand web site.
> What is the best way to implement?
> I have seen a "brand" field in the product page but I am confused about
> using this field (that seems to be a simple string) or link the product to a
> "Party group" that can have the web site and logo associated to it.
> If this second solution should be used do you suggest to define a new party
> role for what I have to do or may be some already exists?
>
> Thank you,
> -Bruno
>
> 2008/4/23 Raj Saini <[hidden email]>:
>
>  
>> Have you created new roles if they do not exists? You will also need to
>> associate those roles to your party in party manager before you associate a
>> party in catalog manager. Party lookup catalog manager shows all the roles,
>> instead it should show only roles the selected party is member. Therefore,
>> be careful to choose only role which your party is associated in party
>> manager.
>>
>> Raj
>>
>> Bruno Busco wrote:
>>
>>    
>>> 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 <[hidden email]>:
>>>
>>>
>>>
>>>      
>>>> 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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>          
>>>>        
>>>
>>>      
>>    
>
>