Product - Manufacturer Party Id question

[Ritesh Trivedi]

Hi,

How do you create a party as a manufacturer, if you wanted to associate this manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT table?

I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role or a type which is either manufacturer or OEM. What am I missing?

[Pranay Pandey]

Hi,

This creation can be done in following manner..
1. create a Role type in ROLE_TYPE
2. create a party in PARTY.
3. Associate this party to a role in PARTY_ROLE.
4.Then associate this with the Product by the party ID you have.

Thanks and Regards

On Jan 29, 2008 4:39 AM, Ritz123 <[hidden email]> wrote:

>
> Hi,
>
> How do you create a party as a manufacturer, if you wanted to associate
> this
> manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
> table?
>
> I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role
> or a type which is either manufacturer or OEM. What am I missing?
> --
> View this message in context:
> http://www.nabble.com/Product---Manufacturer-Party-Id-question-tp15148239p15148239.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

--
Thenks & Regards
--
Pranay Pandey
Inodre, India

[Jacques Le Roux]

Not sure if it's what you are looking for but OOTB supplier role is the nearer.
Look at DemoSupplier for instance. I guess that if you need a manufaturer of OEM role type you will need to create it.

Jacques

From: "Ritz123" <[hidden email]>

>
> Hi,
>
> How do you create a party as a manufacturer, if you wanted to associate this
> manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
> table?
>
> I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role
> or a type which is either manufacturer or OEM. What am I missing?
> --
> View this message in context: http://www.nabble.com/Product---Manufacturer-Party-Id-question-tp15148239p15148239.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

[Ritesh Trivedi]

Thanks guys for the replies.

That would have been my guess and next step - but I am just surprized that even if we have a designated column specifically for manufacturer party id, and there are so many roles already in the role type table except manufacturer. Bit intriguing.

Pranay Pandey wrote

Hi,

This creation can be done in following manner..
1. create a Role type in ROLE_TYPE
2. create a party in PARTY.
3. Associate this party to a role in PARTY_ROLE.
4.Then associate this with the Product by the party ID you have.

Thanks and Regards

On Jan 29, 2008 4:39 AM, Ritz123 <[e-mail]> wrote:

>
> Hi,
>
> How do you create a party as a manufacturer, if you wanted to associate
> this
> manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
> table?
>
> I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role
> or a type which is either manufacturer or OEM. What am I missing?
> --
> View this message in context:
> http://www.nabble.com/Product---Manufacturer-Party-Id-question-tp15148239p15148239.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>


--
Thenks & Regards
--
Pranay Pandey
Inodre, India

[BJ Freeman]

Not sure that a manufacture party is any different from a SupplierID.
how someone has product to sell you is not important, as they can sell
it to you.
unless I am missing something.

Ritz123 sent the following on 1/28/2008 3:09 PM:
> Hi,
>
> How do you create a party as a manufacturer, if you wanted to associate this
> manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
> table?
>
> I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role
> or a type which is either manufacturer or OEM. What am I missing?

[Adrian Crum]

BJ,

Sometimes it matters who manufactures a product. We keep track of that here. Suppliers can carry
more than one manfacturer. Purchasing decisions can be based on manufacturer.

If you do a search of the mailing lists, you'll find where I've given example scenarios in the past.

-Adrian

BJ Freeman wrote:

> Not sure that a manufacture party is any different from a SupplierID.
> how someone has product to sell you is not important, as they can sell
> it to you.
> unless I am missing something.
>
> Ritz123 sent the following on 1/28/2008 3:09 PM:
>
>>Hi,
>>
>>How do you create a party as a manufacturer, if you wanted to associate this
>>manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
>>table?
>>
>>I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role
>>or a type which is either manufacturer or OEM. What am I missing?
>
>
>

[Ritesh Trivedi]

Well (at least in my case) supplier and manufacturers are 2 different entities.

Supplier (besides some of the other things) is used to purchase the products from and hence generating the PO etc etc. Manufacturer on the other hand is used in the website to identify/search/categorize products as well as to distinguish within the group of similar products which mfg products are selling more etc. I dont necessarily need contact mechanism etc for the manufacturer but I do need products to be tagged by certain manufacturers.

BJ Freeman wrote

Not sure that a manufacture party is any different from a SupplierID.
how someone has product to sell you is not important, as they can sell
it to you.
unless I am missing something.

Ritz123 sent the following on 1/28/2008 3:09 PM:
> Hi,
>
> How do you create a party as a manufacturer, if you wanted to associate this
> manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
> table?
>
> I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role
> or a type which is either manufacturer or OEM. What am I missing?

[SkipDever]

Adrian

I agree.  There are many businesses where you buy items from a wholesaler
that are essentially identical except that they are manufactured by
different companies.  Plumbing supplies, lumber and machine tools come to
mind.  The wholesaler is the supplier.  However, customers freqently request
items made by a particular manufacturer that they have had success with in
the past, hence the need to identify that attribute.

Skip

-----Original Message-----
From: Adrian Crum [mailto:[hidden email]]
Sent: Tuesday, January 29, 2008 10:46 AM
To: [hidden email]
Subject: Re: Product - Manufacturer Party Id question


BJ,

Sometimes it matters who manufactures a product. We keep track of that here.
Suppliers can carry
more than one manfacturer. Purchasing decisions can be based on
manufacturer.

If you do a search of the mailing lists, you'll find where I've given
example scenarios in the past.

-Adrian

BJ Freeman wrote:

> Not sure that a manufacture party is any different from a SupplierID.
> how someone has product to sell you is not important, as they can sell
> it to you.
> unless I am missing something.
>
> Ritz123 sent the following on 1/28/2008 3:09 PM:
>
>>Hi,
>>
>>How do you create a party as a manufacturer, if you wanted to associate

this
>>manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
>>table?
>>
>>I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role
>>or a type which is either manufacturer or OEM. What am I missing?
>
>
>

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.11/1244 - Release Date: 1/25/2008
7:44 PM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.11/1244 - Release Date: 1/25/2008
7:44 PM

[BJ Freeman]

Hmmmmmm
what I did was make a good ident for mfg number
https://demo.hotwaxmedia.com/catalog/control/EditProductGoodIdentifications?productId=WG-9943
seemed a lot less work.


Adrian Crum sent the following on 1/29/2008 10:45 AM:

> BJ,
>
> Sometimes it matters who manufactures a product. We keep track of that
> here. Suppliers can carry more than one manfacturer. Purchasing
> decisions can be based on manufacturer.
>
> If you do a search of the mailing lists, you'll find where I've given
> example scenarios in the past.
>
> -Adrian
>
> BJ Freeman wrote:
>> Not sure that a manufacture party is any different from a SupplierID.
>> how someone has product to sell you is not important, as they can sell
>> it to you.
>> unless I am missing something.
>>
>> Ritz123 sent the following on 1/28/2008 3:09 PM:
>>
>>> Hi,
>>>
>>> How do you create a party as a manufacturer, if you wanted to
>>> associate this
>>> manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
>>> table?
>>>
>>> I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a
>>> role
>>> or a type which is either manufacturer or OEM. What am I missing?
>>
>>
>>
>
>
>

[Jacques Le Roux]

Sounds like a good idea  

Jacques

From: "BJ Freeman" <[hidden email]>

> Hmmmmmm
> what I did was make a good ident for mfg number
> https://demo.hotwaxmedia.com/catalog/control/EditProductGoodIdentifications?productId=WG-9943
> seemed a lot less work.
>
>
> Adrian Crum sent the following on 1/29/2008 10:45 AM:
>> BJ,
>>
>> Sometimes it matters who manufactures a product. We keep track of that
>> here. Suppliers can carry more than one manfacturer. Purchasing
>> decisions can be based on manufacturer.
>>
>> If you do a search of the mailing lists, you'll find where I've given
>> example scenarios in the past.
>>
>> -Adrian
>>
>> BJ Freeman wrote:
>>> Not sure that a manufacture party is any different from a SupplierID.
>>> how someone has product to sell you is not important, as they can sell
>>> it to you.
>>> unless I am missing something.
>>>
>>> Ritz123 sent the following on 1/28/2008 3:09 PM:
>>>
>>>> Hi,
>>>>
>>>> How do you create a party as a manufacturer, if you wanted to
>>>> associate this
>>>> manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT
>>>> table?
>>>>
>>>> I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a
>>>> role
>>>> or a type which is either manufacturer or OEM. What am I missing?
>>>
>>>
>>>
>>
>>
>>
>