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, |
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, > > |
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, >> >> >> > > |
Administrator
|
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, >>> >>> >>> >> >> > |
In reply to this post by poddar8
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, >>> >>> >>> >> >> > |
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, >>>> >>>> >>>> >>>> >>> >>> >> > |
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, >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >> > |
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 |
In reply to this post by poddar8
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, >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >> > |
Free forum by Nabble | Edit this page |