You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Shailen <kh...@gmail.com> on 2010/12/16 08:43:28 UTC
Is brands supported in ofbiz ?
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 (khichi.shailendra@gmail.com)
+91-9216020360
Mohali, Chandigarh - 160062
Re: Is brands supported in ofbiz ?
Posted by Shailen <kh...@gmail.com>.
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 (khichi.shailendra@gmail.com)
+91-9216020360
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
>>
>
Re: Is brands supported in ofbiz ?
Posted by Raj Saini <ra...@gmail.com>.
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
>
>
Re: Is brands supported in ofbiz ?
Posted by Hans Bakker <ma...@antwebsystems.com>.
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 (khichi.shailendra@gmail.com)
> +91-9216020360
> 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<kh...@gmail.com>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 (khichi.shailendra@gmail.com)
> >> +91-9216020360
> >> Mohali, Chandigarh - 160062
> >>
> >>
Re: Is brands supported in ofbiz ?
Posted by Abhishake Agarwal <ab...@gmail.com>.
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 <kh...@gmail.com>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 (khichi.shailendra@gmail.com)
> +91-9216020360
> 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<khichi.shailendra@gmail.com
>> >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 (khichi.shailendra@gmail.com)
>>> +91-9216020360
>>> Mohali, Chandigarh - 160062
>>>
>>>
>>>
Re: Is brands supported in ofbiz ?
Posted by Shailen <kh...@gmail.com>.
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 (khichi.shailendra@gmail.com)
+91-9216020360
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<kh...@gmail.com>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 (khichi.shailendra@gmail.com)
>> +91-9216020360
>> Mohali, Chandigarh - 160062
>>
>>
Re: Is brands supported in ofbiz ?
Posted by Abhishake Agarwal <ab...@gmail.com>.
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 <kh...@gmail.com>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 (khichi.shailendra@gmail.com)
> +91-9216020360
> Mohali, Chandigarh - 160062
>
>
Re: Is brands supported in ofbiz ?
Posted by BJ Freeman <bj...@free-man.net>.
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.
>