Product Customizations

[poddar8]

Hi,
I am working on the online store feature.

We want the ability to add more information to each product. Right now for
an item we can only store the Serial Number.
There are many more numbers and information associated with each item in the
inventory.
We have part numbers, revision numbers, dates, service tags, asset tags,
manufacture date, model, etc. Some of these may be meaningless for some of
the products.

For example -
We receive 10 quantities of product X500. Each X500 has a Part Number, an
ESN number, Revision Number.
When we receive 10 quantities of product M450, each of these have a part
number, serial number... but no ESN.

Is there any way to store these information?

Thanks,

[rajsaini]

Hi Naveen,

You can look at the Goods Identifiers where you can store multiple
identifier of a product. Also, if your products have serial number, you
would like to consider the serialized inventory.

Thanks,

Raj

On 08/11/10 17:12, Naveen Poddar wrote:

> Hi,
> I am working on the online store feature.
>
> We want the ability to add more information to each product. Right now for
> an item we can only store the Serial Number.
> There are many more numbers and information associated with each item in the
> inventory.
> We have part numbers, revision numbers, dates, service tags, asset tags,
> manufacture date, model, etc. Some of these may be meaningless for some of
> the products.
>
> For example -
> We receive 10 quantities of product X500. Each X500 has a Part Number, an
> ESN number, Revision Number.
> When we receive 10 quantities of product M450, each of these have a part
> number, serial number... but no ESN.
>
> Is there any way to store these information?
>
> Thanks,
>
>    

[poddar8]

Serialized inventory could be used to store serial nos.
I have had a look at the GOOD_IDENTIFICATION entity, which stores a mapping
b/w type, product & value, but in my case there are other attributes such as
part Number, an
ESN number, Revision Number. This value for each of these attribute vary for
each of the physical inventory of a product.

Thanks,

On Mon, Nov 8, 2010 at 6:20 PM, Raj Saini <[hidden email]> wrote:

> Hi Naveen,
>
> You can look at the Goods Identifiers where you can store multiple
> identifier of a product. Also, if your products have serial number, you
> would like to consider the serialized inventory.
>
> Thanks,
>
> Raj
>
>
> On 08/11/10 17:12, Naveen Poddar wrote:
>
>> Hi,
>> I am working on the online store feature.
>>
>> We want the ability to add more information to each product. Right now for
>> an item we can only store the Serial Number.
>> There are many more numbers and information associated with each item in
>> the
>> inventory.
>> We have part numbers, revision numbers, dates, service tags, asset tags,
>> manufacture date, model, etc. Some of these may be meaningless for some of
>> the products.
>>
>> For example -
>> We receive 10 quantities of product X500. Each X500 has a Part Number, an
>> ESN number, Revision Number.
>> When we receive 10 quantities of product M450, each of these have a part
>> number, serial number... but no ESN.
>>
>> Is there any way to store these information?
>>
>> Thanks,
>>
>>
>>
>
>

[Jacques Le Roux]

I'd sugest to have a look at ProductAttribute
https://localhost:8443/catalog/control/EditProductAttributes

Jacques

From: "Naveen Poddar" <[hidden email]>

> Serialized inventory could be used to store serial nos.
> I have had a look at the GOOD_IDENTIFICATION entity, which stores a mapping
> b/w type, product & value, but in my case there are other attributes such as
> part Number, an
> ESN number, Revision Number. This value for each of these attribute vary for
> each of the physical inventory of a product.
>
> Thanks,
>
> On Mon, Nov 8, 2010 at 6:20 PM, Raj Saini <[hidden email]> wrote:
>
>> Hi Naveen,
>>
>> You can look at the Goods Identifiers where you can store multiple
>> identifier of a product. Also, if your products have serial number, you
>> would like to consider the serialized inventory.
>>
>> Thanks,
>>
>> Raj
>>
>>
>> On 08/11/10 17:12, Naveen Poddar wrote:
>>
>>> Hi,
>>> I am working on the online store feature.
>>>
>>> We want the ability to add more information to each product. Right now for
>>> an item we can only store the Serial Number.
>>> There are many more numbers and information associated with each item in
>>> the
>>> inventory.
>>> We have part numbers, revision numbers, dates, service tags, asset tags,
>>> manufacture date, model, etc. Some of these may be meaningless for some of
>>> the products.
>>>
>>> For example -
>>> We receive 10 quantities of product X500. Each X500 has a Part Number, an
>>> ESN number, Revision Number.
>>> When we receive 10 quantities of product M450, each of these have a part
>>> number, serial number... but no ESN.
>>>
>>> Is there any way to store these information?
>>>
>>> Thanks,
>>>
>>>
>>>
>>
>>
>

[BJ Freeman]

GOOD_IDENTIFICATION as defined on page75 of the data model books allows
you to add as many Identifications as you want. You can also add
definition for the Type of Identification.
https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=GoodIdentification

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


Naveen Poddar sent the following on 11/8/2010 5:29 AM:

> Serialized inventory could be used to store serial nos.
> I have had a look at the GOOD_IDENTIFICATION entity, which stores a mapping
> b/w type, product&  value, but in my case there are other attributes such as
> part Number, an
> ESN number, Revision Number. This value for each of these attribute vary for
> each of the physical inventory of a product.
>
> Thanks,
>
> On Mon, Nov 8, 2010 at 6:20 PM, Raj Saini<[hidden email]>  wrote:
>
>> Hi Naveen,
>>
>> You can look at the Goods Identifiers where you can store multiple
>> identifier of a product. Also, if your products have serial number, you
>> would like to consider the serialized inventory.
>>
>> Thanks,
>>
>> Raj
>>
>>
>> On 08/11/10 17:12, Naveen Poddar wrote:
>>
>>> Hi,
>>> I am working on the online store feature.
>>>
>>> We want the ability to add more information to each product. Right now for
>>> an item we can only store the Serial Number.
>>> There are many more numbers and information associated with each item in
>>> the
>>> inventory.
>>> We have part numbers, revision numbers, dates, service tags, asset tags,
>>> manufacture date, model, etc. Some of these may be meaningless for some of
>>> the products.
>>>
>>> For example -
>>> We receive 10 quantities of product X500. Each X500 has a Part Number, an
>>> ESN number, Revision Number.
>>> When we receive 10 quantities of product M450, each of these have a part
>>> number, serial number... but no ESN.
>>>
>>> Is there any way to store these information?
>>>
>>> Thanks,
>>>
>>>
>>>
>>
>>
>

[poddar8]

Not sure as to how to make use of PRODUCT_ATTRIBUTE in the current scenario.
Regarding using GOOD_IDENTIFICATION & new identification types, isn't the
value for the identification type will remain constant for a product ?
In the current scenario, every inventory item for product X500 will have a
distinct value for Part Number, ESN number, Revision Number.

Please correct me if my understanding is wrong.


On Mon, Nov 8, 2010 at 10:02 PM, BJ Freeman <[hidden email]> wrote:

> GOOD_IDENTIFICATION as defined on page75 of the data model books allows you
> to add as many Identifications as you want. You can also add definition for
> the Type of Identification.
>
> https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=GoodIdentification
>
> =========================
> 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
>
>
> Naveen Poddar sent the following on 11/8/2010 5:29 AM:
>
>  Serialized inventory could be used to store serial nos.
>> I have had a look at the GOOD_IDENTIFICATION entity, which stores a
>> mapping
>> b/w type, product&  value, but in my case there are other attributes such
>> as
>> part Number, an
>> ESN number, Revision Number. This value for each of these attribute vary
>> for
>> each of the physical inventory of a product.
>>
>> Thanks,
>>
>> On Mon, Nov 8, 2010 at 6:20 PM, Raj Saini<[hidden email]>  wrote:
>>
>>  Hi Naveen,
>>>
>>> You can look at the Goods Identifiers where you can store multiple
>>> identifier of a product. Also, if your products have serial number, you
>>> would like to consider the serialized inventory.
>>>
>>> Thanks,
>>>
>>> Raj
>>>
>>>
>>> On 08/11/10 17:12, Naveen Poddar wrote:
>>>
>>>  Hi,
>>>> I am working on the online store feature.
>>>>
>>>> We want the ability to add more information to each product. Right now
>>>> for
>>>> an item we can only store the Serial Number.
>>>> There are many more numbers and information associated with each item in
>>>> the
>>>> inventory.
>>>> We have part numbers, revision numbers, dates, service tags, asset tags,
>>>> manufacture date, model, etc. Some of these may be meaningless for some
>>>> of
>>>> the products.
>>>>
>>>> For example -
>>>> We receive 10 quantities of product X500. Each X500 has a Part Number,
>>>> an
>>>> ESN number, Revision Number.
>>>> When we receive 10 quantities of product M450, each of these have a part
>>>> number, serial number... but no ESN.
>>>>
>>>> Is there any way to store these information?
>>>>
>>>> Thanks,
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>

[rajsaini]

PRODUCT_ATTRIBUTE are good to store product attributes e.g. number of pages of a book, cover type etc. You are right values of GOOD_IDENTIFICATION values are per product and not per inventory item. If you look at the inventory items, you will see fields like serial number, soft identifier etc which may be mapped to your fields of your inventory item.


On 09/11/10 11:56, Naveen Poddar wrote:

> Not sure as to how to make use of PRODUCT_ATTRIBUTE in the current scenario.
> Regarding using GOOD_IDENTIFICATION&  new identification types, isn't the
> value for the identification type will remain constant for a product ?
> In the current scenario, every inventory item for product X500 will have a
> distinct value for Part Number, ESN number, Revision Number.
>
> Please correct me if my understanding is wrong.
>
>
> On Mon, Nov 8, 2010 at 10:02 PM, BJ Freeman<[hidden email]>  wrote:
>
>    
>> GOOD_IDENTIFICATION as defined on page75 of the data model books allows you
>> to add as many Identifications as you want. You can also add definition for
>> the Type of Identification.
>>
>> https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=GoodIdentification
>>
>> =========================
>> 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
>>
>>
>> Naveen Poddar sent the following on 11/8/2010 5:29 AM:
>>
>>   Serialized inventory could be used to store serial nos.
>>      
>>> I have had a look at the GOOD_IDENTIFICATION entity, which stores a
>>> mapping
>>> b/w type, product&   value, but in my case there are other attributes such
>>> as
>>> part Number, an
>>> ESN number, Revision Number. This value for each of these attribute vary
>>> for
>>> each of the physical inventory of a product.
>>>
>>> Thanks,
>>>
>>> On Mon, Nov 8, 2010 at 6:20 PM, Raj Saini<[hidden email]>   wrote:
>>>
>>>   Hi Naveen,
>>>        
>>>> You can look at the Goods Identifiers where you can store multiple
>>>> identifier of a product. Also, if your products have serial number, you
>>>> would like to consider the serialized inventory.
>>>>
>>>> Thanks,
>>>>
>>>> Raj
>>>>
>>>>
>>>> On 08/11/10 17:12, Naveen Poddar wrote:
>>>>
>>>>   Hi,
>>>>          
>>>>> I am working on the online store feature.
>>>>>
>>>>> We want the ability to add more information to each product. Right now
>>>>> for
>>>>> an item we can only store the Serial Number.
>>>>> There are many more numbers and information associated with each item in
>>>>> the
>>>>> inventory.
>>>>> We have part numbers, revision numbers, dates, service tags, asset tags,
>>>>> manufacture date, model, etc. Some of these may be meaningless for some
>>>>> of
>>>>> the products.
>>>>>
>>>>> For example -
>>>>> We receive 10 quantities of product X500. Each X500 has a Part Number,
>>>>> an
>>>>> ESN number, Revision Number.
>>>>> When we receive 10 quantities of product M450, each of these have a part
>>>>> number, serial number... but no ESN.
>>>>>
>>>>> Is there any way to store these information?
>>>>>
>>>>> Thanks,
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>            
>>>>
>>>>          
>>>        
>>      
>    

[Varun Bhansaly]

I think INVENTORY_ITEM_ATTRIBUTE entity could be used to store custom
attributes. Though I don't think there's UI OOTB to put values for custom
attributes into this entity. May be this will require some customization.

Thanks,
Varun

On Tue, Nov 9, 2010 at 12:33 PM, Raj Saini <[hidden email]> wrote:

> PRODUCT_ATTRIBUTE are good to store product attributes e.g. number of pages
> of a book, cover type etc. You are right values of GOOD_IDENTIFICATION
> values are per product and not per inventory item. If you look at the
> inventory items, you will see fields like serial number, soft identifier etc
> which may be mapped to your fields of your inventory item.
>
>
>
> On 09/11/10 11:56, Naveen Poddar wrote:
>
>> Not sure as to how to make use of PRODUCT_ATTRIBUTE in the current
>> scenario.
>> Regarding using GOOD_IDENTIFICATION&  new identification types, isn't the
>> value for the identification type will remain constant for a product ?
>> In the current scenario, every inventory item for product X500 will have a
>> distinct value for Part Number, ESN number, Revision Number.
>>
>> Please correct me if my understanding is wrong.
>>
>>
>> On Mon, Nov 8, 2010 at 10:02 PM, BJ Freeman<[hidden email]>  wrote:
>>
>>
>>
>>> GOOD_IDENTIFICATION as defined on page75 of the data model books allows
>>> you
>>> to add as many Identifications as you want. You can also add definition
>>> for
>>> the Type of Identification.
>>>
>>>
>>> https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=GoodIdentification
>>>
>>> =========================
>>> 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
>>>
>>>
>>> Naveen Poddar sent the following on 11/8/2010 5:29 AM:
>>>
>>>  Serialized inventory could be used to store serial nos.
>>>
>>>
>>>> I have had a look at the GOOD_IDENTIFICATION entity, which stores a
>>>> mapping
>>>> b/w type, product&   value, but in my case there are other attributes
>>>> such
>>>> as
>>>> part Number, an
>>>> ESN number, Revision Number. This value for each of these attribute vary
>>>> for
>>>> each of the physical inventory of a product.
>>>>
>>>> Thanks,
>>>>
>>>> On Mon, Nov 8, 2010 at 6:20 PM, Raj Saini<[hidden email]>   wrote:
>>>>
>>>>  Hi Naveen,
>>>>
>>>>
>>>>> You can look at the Goods Identifiers where you can store multiple
>>>>> identifier of a product. Also, if your products have serial number, you
>>>>> would like to consider the serialized inventory.
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Raj
>>>>>
>>>>>
>>>>> On 08/11/10 17:12, Naveen Poddar wrote:
>>>>>
>>>>>  Hi,
>>>>>
>>>>>
>>>>>> I am working on the online store feature.
>>>>>>
>>>>>> We want the ability to add more information to each product. Right now
>>>>>> for
>>>>>> an item we can only store the Serial Number.
>>>>>> There are many more numbers and information associated with each item
>>>>>> in
>>>>>> the
>>>>>> inventory.
>>>>>> We have part numbers, revision numbers, dates, service tags, asset
>>>>>> tags,
>>>>>> manufacture date, model, etc. Some of these may be meaningless for
>>>>>> some
>>>>>> of
>>>>>> the products.
>>>>>>
>>>>>> For example -
>>>>>> We receive 10 quantities of product X500. Each X500 has a Part Number,
>>>>>> an
>>>>>> ESN number, Revision Number.
>>>>>> When we receive 10 quantities of product M450, each of these have a
>>>>>> part
>>>>>> number, serial number... but no ESN.
>>>>>>
>>>>>> Is there any way to store these information?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

--
Regards,
Varun Bhansaly

[BJ Freeman]

You have a good point

The simplest is to use the InventoryItemAttribute
https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=InventoryItemAttribute&find=true&VIEW_SIZE=50&VIEW_INDEX=0
you will have to add code to deal with the InventoryItemAttribute.

the Direction I took was more complicated.
I added a GoodIdentification to the InventoryItem
https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=InventoryItem
This requires a lot of changes related to GoodIdentification current code,.

=========================
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
Naveen Poddar sent the following on 11/8/2010 10:26 PM:

> Not sure as to how to make use of PRODUCT_ATTRIBUTE in the current scenario.
> Regarding using Naveen Poddar sent the following on 11/8/2010 10:26 PM:&  new identification types, isn't the
> value for the identification type will remain constant for a product ?
> In the current scenario, every inventory item for product X500 will have a
> distinct value for Part Number, ESN number, Revision Number.
>
> Please correct me if my understanding is wrong.
>
>
> On Mon, Nov 8, 2010 at 10:02 PM, BJ Freeman<[hidden email]>  wrote:
>
>> GOOD_IDENTIFICATION as defined on page75 of the data model books allows you
>> to add as many Identifications as you want. You can also add definition for
>> the Type of Identification.
>>
>> https://demo-trunk.ofbiz.apache.org/webtools/control/ViewRelations?entityName=GoodIdentification
>>
>> =========================
>> 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
>>
>>
>> Naveen Poddar sent the following on 11/8/2010 5:29 AM:
>>
>>   Serialized inventory could be used to store serial nos.
>>> I have had a look at the GOOD_IDENTIFICATION entity, which stores a
>>> mapping
>>> b/w type, product&   value, but in my case there are other attributes such
>>> as
>>> part Number, an
>>> ESN number, Revision Number. This value for each of these attribute vary
>>> for
>>> each of the physical inventory of a product.
>>>
>>> Thanks,
>>>
>>> On Mon, Nov 8, 2010 at 6:20 PM, Raj Saini<[hidden email]>   wrote:
>>>
>>>   Hi Naveen,
>>>>
>>>> You can look at the Goods Identifiers where you can store multiple
>>>> identifier of a product. Also, if your products have serial number, you
>>>> would like to consider the serialized inventory.
>>>>
>>>> Thanks,
>>>>
>>>> Raj
>>>>
>>>>
>>>> On 08/11/10 17:12, Naveen Poddar wrote:
>>>>
>>>>   Hi,
>>>>> I am working on the online store feature.
>>>>>
>>>>> We want the ability to add more information to each product. Right now
>>>>> for
>>>>> an item we can only store the Serial Number.
>>>>> There are many more numbers and information associated with each item in
>>>>> the
>>>>> inventory.
>>>>> We have part numbers, revision numbers, dates, service tags, asset tags,
>>>>> manufacture date, model, etc. Some of these may be meaningless for some
>>>>> of
>>>>> the products.
>>>>>
>>>>> For example -
>>>>> We receive 10 quantities of product X500. Each X500 has a Part Number,
>>>>> an
>>>>> ESN number, Revision Number.
>>>>> When we receive 10 quantities of product M450, each of these have a part
>>>>> number, serial number... but no ESN.
>>>>>
>>>>> Is there any way to store these information?
>>>>>
>>>>> Thanks,
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>