Re: Customer Product ID Mapping

[deepak nigam-2]

Hi James,

I am not sure if it is the best way, but you can use PartyAttribute table
to map customers with product.

Thanks & Regards
--
Deepak Nigam

On Thu, Nov 21, 2019, 6:09 PM <[hidden email]> wrote:

>
>
> On the catalog tab I see the suppliers tab which is a good way to map
> the suppliers product ID to our internal product ID.  What is the best
> way to map a customers product ID to our product ID.  Is there a way out
> of the box?
>
>
> Thanks,
>
>
> James
>

[Nicolas Malin-2]

This depends of your business context where and how you will use it.

Some ideas :

  * few suppliers but huge request to resolve products -> GoodIdentification
  * Products need more information how supplier works with its ->
SupplierProduct
  * No special use just for information or huge switch Product and
Supplier or Other -> extend ProductRole

Cheers Nicolas

On 21/11/2019 13:38, [hidden email] wrote:

>
> On the catalog tab I see the suppliers tab which is a good way to map
> the suppliers product ID to our internal product ID.  What is the best
> way to map a customers product ID to our product ID.  Is there a way out
> of the box?
>
>
> Thanks,
>
>
> James
>

[Jacques Le Roux]

Hi James,

You can use "Internal Name" for your Internal Name and "Product Name" or "Brand Name" for  the "customers product ID"

https://demo-trunk.ofbiz.apache.org/catalog/control/EditProduct?productId=GZ-1000

Jacques

Le 21/11/2019 à 13:38, [hidden email] a écrit :

>
> On the catalog tab I see the suppliers tab which is a good way to map
> the suppliers product ID to our internal product ID.  What is the best
> way to map a customers product ID to our product ID.  Is there a way out
> of the box?
>
>
> Thanks,
>
>
> James
>

[Jacques Le Roux]

Why  customers have different IDs ?

Jacques

Le 21/11/2019 à 23:43, [hidden email] a écrit :

> There can be several customers that have different IDs
>
> So GZ-1000 in the system could be:
>
> 1234 customer a
> 5736 customer b
> 5275 customer c
>
> etc
>
> Need to be able to search by customers number and use it on the print
> out for sales order
> -------- Original Message --------
> Subject: Re: Customer Product ID Mapping
> From: Jacques Le Roux <[hidden email]>
> Date: Thu, November 21, 2019 10:17 am
> To: [hidden email]
>
> Hi James,
>
> You can use "Internal Name" for your Internal Name and "Product Name" or
> "Brand Name" for  the "customers product ID"
>
> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProduct?productId=GZ-1000
>
> Jacques
>
> Le 21/11/2019 à 13:38, [hidden email] a écrit :
>> On the catalog tab I see the suppliers tab which is a good way to map
>> the suppliers product ID to our internal product ID. What is the best
>> way to map a customers product ID to our product ID. Is there a way out
>> of the box?
>>
>>
>> Thanks,
>>
>>
>> James
>>

[Jacques Le Roux]

There is nothing OOTB for that. I suggest you follow Deepak's solution. You will also need some custom code I guess...

Jacques

Le 22/11/2019 à 15:55, [hidden email] a écrit :

> In the fastener industry customers, suppliers, and manufacturers all
> have different product IDs for the same product.  So a customer can call
> in and they want to use their unique product ID when ordering.  The
> supplier tab in catalog does a decent job mapping the suppliers product
> ID.  Any similar feature for the customers product ID
>
> -------- Original Message --------
> Subject: Re: Customer Product ID Mapping
> From: Jacques Le Roux <[hidden email]>
> Date: Fri, November 22, 2019 4:40 am
> To: [hidden email]
>
> Why  customers have different IDs ?
>
> Jacques
>
> Le 21/11/2019 à 23:43, [hidden email] a écrit :
>> There can be several customers that have different IDs
>>
>> So GZ-1000 in the system could be:
>>
>> 1234 customer a
>> 5736 customer b
>> 5275 customer c
>>
>> etc
>>
>> Need to be able to search by customers number and use it on the print
>> out for sales order
>> -------- Original Message --------
>> Subject: Re: Customer Product ID Mapping
>> From: Jacques Le Roux <[hidden email]>
>> Date: Thu, November 21, 2019 10:17 am
>> To: [hidden email]
>>
>> Hi James,
>>
>> You can use "Internal Name" for your Internal Name and "Product Name" or
>> "Brand Name" for the "customers product ID"
>>
>> https://demo-trunk.ofbiz.apache.org/catalog/control/EditProduct?productId=GZ-1000
>>
>> Jacques
>>
>> Le 21/11/2019 à 13:38, [hidden email] a écrit :
>>> On the catalog tab I see the suppliers tab which is a good way to map
>>> the suppliers product ID to our internal product ID. What is the best
>>> way to map a customers product ID to our product ID. Is there a way out
>>> of the box?
>>>
>>>
>>> Thanks,
>>>
>>>
>>> James
>>>