Is brands supported in ofbiz ?

[imssk]

Hi,

I have a requirement where I need to create manufacturers which I can
insert as parties. Manufacturers can have zero or more brands. Each
brand can have zero or more products.

  - Is brands supported in ofbiz ?  I have checked the data model but
not able to find.
  - If not what would be the best way to achieve this ?

IMO I should extend ofbiz data model and create a new brand table and
manufacturer-brand table.
Brand table would have all the brands and manufacturer-brand table would
have the manufacturer brand association.
Also extend the product table and include brandId as a drop-down.
Product has OEM Party ID(which I think is nothing but manufacturer) and
based on the OEM Party Id the brandId can be populated.

Any design pointers are much welcomed.

--

Thanks,
Shailen ([hidden email])
[phone]
Mohali, Chandigarh - 160062

[Abhishake Agarwal]

Hi,

you can create a party with role manufacturer. Then you can add party in
category which can act as a brand.

Regards,
Abhishake

On Thu, Dec 16, 2010 at 1:13 PM, Shailen <[hidden email]>wrote:

> Hi,
>
> I have a requirement where I need to create manufacturers which I can
> insert as parties. Manufacturers can have zero or more brands. Each brand
> can have zero or more products.
>
>  - Is brands supported in ofbiz ?  I have checked the data model but not
> able to find.
>  - If not what would be the best way to achieve this ?
>
> IMO I should extend ofbiz data model and create a new brand table and
> manufacturer-brand table.
> Brand table would have all the brands and manufacturer-brand table would
> have the manufacturer brand association.
> Also extend the product table and include brandId as a drop-down. Product
> has OEM Party ID(which I think is nothing but manufacturer) and based on the
> OEM Party Id the brandId can be populated.
>
> Any design pointers are much welcomed.
>
> --
>
> Thanks,
> Shailen ([hidden email])
> [phone]
> Mohali, Chandigarh - 160062
>
>

[imssk]

Thanks Abhishake for your inputs. but IMO brand and categories are two
different things as a brand can only be associated with only one
manufacturer while a category can be associated with multiple manufacturers.
So how can I restrict this association of multiple manufacturers?

Regards,
Shailen ([hidden email])
[phone]
Mohali, Chandigarh - 160062


On Thursday 16 December 2010 05:26 PM, Abhishake Agarwal wrote:

> Hi,
>
> you can create a party with role manufacturer. Then you can add party in
> category which can act as a brand.
>
> Regards,
> Abhishake
>
> On Thu, Dec 16, 2010 at 1:13 PM, Shailen<[hidden email]>wrote:
>
>> Hi,
>>
>> I have a requirement where I need to create manufacturers which I can
>> insert as parties. Manufacturers can have zero or more brands. Each brand
>> can have zero or more products.
>>
>>   - Is brands supported in ofbiz ?  I have checked the data model but not
>> able to find.
>>   - If not what would be the best way to achieve this ?
>>
>> IMO I should extend ofbiz data model and create a new brand table and
>> manufacturer-brand table.
>> Brand table would have all the brands and manufacturer-brand table would
>> have the manufacturer brand association.
>> Also extend the product table and include brandId as a drop-down. Product
>> has OEM Party ID(which I think is nothing but manufacturer) and based on the
>> OEM Party Id the brandId can be populated.
>>
>> Any design pointers are much welcomed.
>>
>> --
>>
>> Thanks,
>> Shailen ([hidden email])
>> [phone]
>> Mohali, Chandigarh - 160062
>>
>>

[hans_bakker]

A manufacturer = supplier which produces products, on the product you
can define suppliers. A product has a brandname field.

so what is missing?

Regards,
Hans

--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.

On Thu, 2010-12-16 at 18:13 +0530, Shailen wrote:

> Thanks Abhishake for your inputs. but IMO brand and categories are two
> different things as a brand can only be associated with only one
> manufacturer while a category can be associated with multiple manufacturers.
> So how can I restrict this association of multiple manufacturers?
>
> Regards,
> Shailen ([hidden email])
> [phone]
> Mohali, Chandigarh - 160062
>
>
> On Thursday 16 December 2010 05:26 PM, Abhishake Agarwal wrote:
> > Hi,
> >
> > you can create a party with role manufacturer. Then you can add party in
> > category which can act as a brand.
> >
> > Regards,
> > Abhishake
> >
> > On Thu, Dec 16, 2010 at 1:13 PM, Shailen<[hidden email]>wrote:
> >
> >> Hi,
> >>
> >> I have a requirement where I need to create manufacturers which I can
> >> insert as parties. Manufacturers can have zero or more brands. Each brand
> >> can have zero or more products.
> >>
> >>   - Is brands supported in ofbiz ?  I have checked the data model but not
> >> able to find.
> >>   - If not what would be the best way to achieve this ?
> >>
> >> IMO I should extend ofbiz data model and create a new brand table and
> >> manufacturer-brand table.
> >> Brand table would have all the brands and manufacturer-brand table would
> >> have the manufacturer brand association.
> >> Also extend the product table and include brandId as a drop-down. Product
> >> has OEM Party ID(which I think is nothing but manufacturer) and based on the
> >> OEM Party Id the brandId can be populated.
> >>
> >> Any design pointers are much welcomed.
> >>
> >> --
> >>
> >> Thanks,
> >> Shailen ([hidden email])
> >> [phone]
> >> Mohali, Chandigarh - 160062
> >>
> >>

[rajsaini]

Hi Hans,

Brand name field is a free text and there is no relationship with
manufacturer. If a product is manufacturer A it it must be associated
with brand related to that manufacturer. Brand Name field does not
enforce such constraints.

Thanks,

Raj

On Thursday 16 December 2010 06:32 PM, Hans Bakker wrote:
> A manufacturer = supplier which produces products, on the product you
> can define suppliers. A product has a brandname field.
>
> so what is missing?
>
> Regards,
> Hans
>
>    

[Abhishake Agarwal]

Hi,

You can give a type to category as brand category and restrict the
association with only one manufacturer.

Regards,
Abhsihake

On Thu, Dec 16, 2010 at 6:13 PM, Shailen <[hidden email]>wrote:

> Thanks Abhishake for your inputs. but IMO brand and categories are two
> different things as a brand can only be associated with only one
> manufacturer while a category can be associated with multiple manufacturers.
> So how can I restrict this association of multiple manufacturers?
>
> Regards,
>
> Shailen ([hidden email])
> [phone]
> Mohali, Chandigarh - 160062
>
>
> On Thursday 16 December 2010 05:26 PM, Abhishake Agarwal wrote:
>
>> Hi,
>>
>> you can create a party with role manufacturer. Then you can add party in
>> category which can act as a brand.
>>
>> Regards,
>> Abhishake
>>
>> On Thu, Dec 16, 2010 at 1:13 PM, Shailen<[hidden email]
>> >wrote:
>>
>>  Hi,
>>>
>>> I have a requirement where I need to create manufacturers which I can
>>> insert as parties. Manufacturers can have zero or more brands. Each brand
>>> can have zero or more products.
>>>
>>>  - Is brands supported in ofbiz ?  I have checked the data model but not
>>> able to find.
>>>  - If not what would be the best way to achieve this ?
>>>
>>> IMO I should extend ofbiz data model and create a new brand table and
>>> manufacturer-brand table.
>>> Brand table would have all the brands and manufacturer-brand table would
>>> have the manufacturer brand association.
>>> Also extend the product table and include brandId as a drop-down. Product
>>> has OEM Party ID(which I think is nothing but manufacturer) and based on
>>> the
>>> OEM Party Id the brandId can be populated.
>>>
>>> Any design pointers are much welcomed.
>>>
>>> --
>>>
>>> Thanks,
>>> Shailen ([hidden email])
>>> [phone]
>>> Mohali, Chandigarh - 160062
>>>
>>>
>>>

[BJ Freeman]

you have product.manufacturerPartyId which is many from relationship
from party,

=========================
BJ Freeman
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Shailen sent the following on 12/15/2010 11:43 PM:

> Hi,
>
> I have a requirement where I need to create manufacturers which I can
> insert as parties. Manufacturers can have zero or more brands. Each
> brand can have zero or more products.
>
> - Is brands supported in ofbiz ? I have checked the data model but not
> able to find.
> - If not what would be the best way to achieve this ?
>
> IMO I should extend ofbiz data model and create a new brand table and
> manufacturer-brand table.
> Brand table would have all the brands and manufacturer-brand table would
> have the manufacturer brand association.
> Also extend the product table and include brandId as a drop-down.
> Product has OEM Party ID(which I think is nothing but manufacturer) and
> based on the OEM Party Id the brandId can be populated.
>
> Any design pointers are much welcomed.
>

[imssk]

Yes Hans, Raj has got it right. We have brand name. A user can enter
anything in that free text field. Also if I select a particular
manufacturer then I should not be able to select brand of another
manufacturer. So I idea to introduce a new brand table and
manufacturer-brand table get points.

Regards,
Shailen ([hidden email])
[phone]
Mohali, Chandigarh - 160062


On Thursday 16 December 2010 06:39 PM, Raj Saini wrote:

> Hi Hans,
>
> Brand name field is a free text and there is no relationship with
> manufacturer. If a product is manufacturer A it it must be associated
> with brand related to that manufacturer. Brand Name field does not
> enforce such constraints.
>
> Thanks,
>
> Raj
>
> On Thursday 16 December 2010 06:32 PM, Hans Bakker wrote:
>> A manufacturer = supplier which produces products, on the product you
>> can define suppliers. A product has a brandname field.
>>
>> so what is missing?
>>
>> Regards,
>> Hans
>>
>