You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Hans Bakker <h....@antwebsystems.com> on 2011/09/23 07:20:39 UTC
discussion: video rentals
Now we can have rental products where the asset can be rented....
In this product type the product is a group of video rentals of the same
rental price referring to many video assets.
However now we also want to categorize these assets in order to display
them on the e-commerce website.
Is adding a fixedAssetid field to the ProductCategoryMember entity a
solution?
--
http://www.antwebsystems.com :
Quality OFBiz support for competitive rates....
Re: discussion: video rentals
Posted by Adrian Crum <ad...@sandglass-software.com>.
The problem is, you are trying to mix the pricing model with the
product/fixed asset model. That will not work.
Here is how I would set things up based on my understanding of video
rentals:
[Products / Fixed Assets]
Product: Die Hard VHS Cassette
Product Categories: VHS, Action, Drama, Bruce Willis
Fixed Assets: 10009
Product: Die Hard DVD
Product Categories: DVD, Action, Drama, Bruce Willis
Fixed Assets: 10010, 10011, 1012
Product: Die Hard IIV DVD
Product Categories: New Releases, DVD, Action, Drama, Bruce Willis
Fixed Assets: 20020, 20021, 20022
[Pricing]
Product Category: VHS
Price: $1.00 per day
Product Category: DVD
Price: $1.50 per day
Product Category: New Releases
Price: $0.50 per day
-Adrian
On 9/23/2011 7:16 AM, Hans Bakker wrote:
> On Fri, 2011-09-23 at 06:56 +0100, Adrian Crum wrote:
>> If they are the same product, then they are in the same product categories.
>>
> so that is limitation of the current datamodel?......looks like i have
> to create for every asset a product and a single inventory item of which
> many have the same price and other data, only the picture is different
> because i cannot store that on the fixed asset.
>
> Then i also better use the 'instanceOfProduct field on the fixed asset
> and do not need the fixedassetProduct entity and the recently added
> fixedAssetId field on the inventoryitem..
>
>> I have three copies of the Die Hard DVD. Why would I want to put each
>> one in a different product category? What you are suggesting doesn't
>> make sense.
>> It might help if you gave some specific examples of what you are trying
>> to do.
> I have a single product : "DVD midlevel price" relating to 10,000 dvd's
> with different fixed asset titles in different genre's but the same
> rental price
>
>> -Adrian
>>
>> On 9/23/2011 6:51 AM, Hans Bakker wrote:
>>> Can you help me think in the right direction?
>>>
>>> how can i show some fixedassets of the same product in one category and
>>> some of the assets in another category?
>>>
>>> Thank you in advance for your help.
>>>
>>> Regards,m=
>>> Hans
>>>
>>> On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote:
>>>> Hans,
>>>>
>>>> The data model supports what you are trying to do if YOU think about it.
>>>> There is no need to connect a fixed asset to a product category.
>>>>
>>>> -Adrian
>>>>
>>>> On 9/23/2011 6:44 AM, Hans Bakker wrote:
>>>>> sure can do that, but i want a specific instance showing in one category
>>>>> and another instance showing in a different category......
>>>>>
>>>>> Adrian, before you answer can you please think about it a bit?
>>>>>
>>>>> Regards,
>>>>> Hans
>>>>>
>>>>> On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote:
>>>>>> Use FixedAssetProduct.
>>>>>>
>>>>>> -Adrian
>>>>>>
>>>>>> On 9/23/2011 6:37 AM, Hans Bakker wrote:
>>>>>>> but if you want a particular instance of a product?
>>>>>>>
>>>>>>> I have products (as i described):
>>>>>>>> In this product type the product is a group of video rentals of the
>>>>>>>> same rental price referring to many video assets.
>>>>>>> Hans
>>>>>>>
>>>>>>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
>>>>>>>> A fixed asset is an instance of a product, much like an inventory item
>>>>>>>> is an instance of a product. So, no - you do not want to connect a fixed
>>>>>>>> asset to a product category.
>>>>>>>>
>>>>>>>> Product: Die Hard DVD
>>>>>>>> Product Categories: DVD, Action, Drama, Bruce Willis
>>>>>>>> Fixed Assets: 10010, 10011, 1012
>>>>>>>>
>>>>>>>> -Adrian
>>>>>>>>
>>>>>>>> On 9/23/2011 6:20 AM, Hans Bakker wrote:
>>>>>>>>> Now we can have rental products where the asset can be rented....
>>>>>>>>>
>>>>>>>>> In this product type the product is a group of video rentals of the same
>>>>>>>>> rental price referring to many video assets.
>>>>>>>>>
>>>>>>>>> However now we also want to categorize these assets in order to display
>>>>>>>>> them on the e-commerce website.
>>>>>>>>>
>>>>>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
>>>>>>>>> solution?
>>>>>>>>>
>>>>>>>>>
Re: discussion: video rentals
Posted by Paul Foxworthy <pa...@cohsoft.com.au>.
Hi Hans,
Of course you know the business problem better than anyone else does, but
even so I tend to agree with Adrian.
It seems to me "DVD midlevel price" is a pricing rule, not a product. I may
well rent two instances of "DVD midlevel price" if they were different DVD
titles (e.g. Die Hard 1 and 2). It would be most unlikely that I'd want to
rent two instances of the same title.
There are many business opportunities when you know what title a customer
has rented. For example: "we can see that you have recently rented The Lord
Of The Rings 1 and 2, here's a special offer for number 3", 'We can see
you've rented several titles starring Bruce Willis, would you like to rent
these others?".
You might want to vary the pricing for some titles compared to others: have
a Bruce Willis festival, or "the Star Wars Blu-Ray set is now out, time to
increase/decrease the price of our DVDs". So while for the moment there are
thousands of titles at the same price, there's no guarantee that will
continue forever.
You might want to track how popular a title is: "Die Hard 1 is very popular
and never in stock, we should acquire a few more copies".
There's a problem getting the products defined in Ofbiz in the first place,
but one of the online DVD catalogues might help, and you have to put the
fixed assets into Ofbiz in any case.
Cheers
Paul Foxworthy
hans_bakker wrote:
>
> On Fri, 2011-09-23 at 06:56 +0100, Adrian Crum wrote:
>> If they are the same product, then they are in the same product
>> categories.
>>
>
> so that is limitation of the current datamodel?......looks like i have
> to create for every asset a product and a single inventory item of which
> many have the same price and other data, only the picture is different
> because i cannot store that on the fixed asset.
>
> Then i also better use the 'instanceOfProduct field on the fixed asset
> and do not need the fixedassetProduct entity and the recently added
> fixedAssetId field on the inventoryitem..
>
>> I have three copies of the Die Hard DVD. Why would I want to put each
>> one in a different product category? What you are suggesting doesn't
>> make sense.
>> It might help if you gave some specific examples of what you are trying
>> to do.
>
> I have a single product : "DVD midlevel price" relating to 10,000 dvd's
> with different fixed asset titles in different genre's but the same
> rental price
>
>>
>> -Adrian
>>
>> On 9/23/2011 6:51 AM, Hans Bakker wrote:
>> > Can you help me think in the right direction?
>> >
>> > how can i show some fixedassets of the same product in one category and
>> > some of the assets in another category?
>> >
>> > Thank you in advance for your help.
>> >
>> > Regards,m=
>> > Hans
>> >
>> > On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote:
>> >> Hans,
>> >>
>> >> The data model supports what you are trying to do if YOU think about
>> it.
>> >> There is no need to connect a fixed asset to a product category.
>> >>
>> >> -Adrian
>> >>
>> >> On 9/23/2011 6:44 AM, Hans Bakker wrote:
>> >>> sure can do that, but i want a specific instance showing in one
>> category
>> >>> and another instance showing in a different category......
>> >>>
>> >>> Adrian, before you answer can you please think about it a bit?
>> >>>
>> >>> Regards,
>> >>> Hans
>> >>>
>> >>> On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote:
>> >>>> Use FixedAssetProduct.
>> >>>>
>> >>>> -Adrian
>> >>>>
>> >>>> On 9/23/2011 6:37 AM, Hans Bakker wrote:
>> >>>>> but if you want a particular instance of a product?
>> >>>>>
>> >>>>> I have products (as i described):
>> >>>>>> In this product type the product is a group of video rentals of
>> the
>> >>>>>> same rental price referring to many video assets.
>> >>>>> Hans
>> >>>>>
>> >>>>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
>> >>>>>> A fixed asset is an instance of a product, much like an inventory
>> item
>> >>>>>> is an instance of a product. So, no - you do not want to connect a
>> fixed
>> >>>>>> asset to a product category.
>> >>>>>>
>> >>>>>> Product: Die Hard DVD
>> >>>>>> Product Categories: DVD, Action, Drama, Bruce Willis
>> >>>>>> Fixed Assets: 10010, 10011, 1012
>> >>>>>>
>> >>>>>> -Adrian
>> >>>>>>
>> >>>>>> On 9/23/2011 6:20 AM, Hans Bakker wrote:
>> >>>>>>> Now we can have rental products where the asset can be rented....
>> >>>>>>>
>> >>>>>>> In this product type the product is a group of video rentals of
>> the same
>> >>>>>>> rental price referring to many video assets.
>> >>>>>>>
>> >>>>>>> However now we also want to categorize these assets in order to
>> display
>> >>>>>>> them on the e-commerce website.
>> >>>>>>>
>> >>>>>>> Is adding a fixedAssetid field to the ProductCategoryMember
>> entity a
>> >>>>>>> solution?
>> >>>>>>>
>> >>>>>>>
>
> --
> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> Alternative ofbiz website: http://www.ofbiz.info
> http://www.antwebsystems.com : Quality services for competitive rates.
>
--
View this message in context: http://ofbiz.135035.n4.nabble.com/discussion-video-rentals-tp3835766p3835962.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.
Re: discussion: video rentals
Posted by Hans Bakker <ma...@antwebsystems.com>.
On Fri, 2011-09-23 at 06:56 +0100, Adrian Crum wrote:
> If they are the same product, then they are in the same product categories.
>
so that is limitation of the current datamodel?......looks like i have
to create for every asset a product and a single inventory item of which
many have the same price and other data, only the picture is different
because i cannot store that on the fixed asset.
Then i also better use the 'instanceOfProduct field on the fixed asset
and do not need the fixedassetProduct entity and the recently added
fixedAssetId field on the inventoryitem..
> I have three copies of the Die Hard DVD. Why would I want to put each
> one in a different product category? What you are suggesting doesn't
> make sense.
> It might help if you gave some specific examples of what you are trying
> to do.
I have a single product : "DVD midlevel price" relating to 10,000 dvd's
with different fixed asset titles in different genre's but the same
rental price
>
> -Adrian
>
> On 9/23/2011 6:51 AM, Hans Bakker wrote:
> > Can you help me think in the right direction?
> >
> > how can i show some fixedassets of the same product in one category and
> > some of the assets in another category?
> >
> > Thank you in advance for your help.
> >
> > Regards,m=
> > Hans
> >
> > On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote:
> >> Hans,
> >>
> >> The data model supports what you are trying to do if YOU think about it.
> >> There is no need to connect a fixed asset to a product category.
> >>
> >> -Adrian
> >>
> >> On 9/23/2011 6:44 AM, Hans Bakker wrote:
> >>> sure can do that, but i want a specific instance showing in one category
> >>> and another instance showing in a different category......
> >>>
> >>> Adrian, before you answer can you please think about it a bit?
> >>>
> >>> Regards,
> >>> Hans
> >>>
> >>> On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote:
> >>>> Use FixedAssetProduct.
> >>>>
> >>>> -Adrian
> >>>>
> >>>> On 9/23/2011 6:37 AM, Hans Bakker wrote:
> >>>>> but if you want a particular instance of a product?
> >>>>>
> >>>>> I have products (as i described):
> >>>>>> In this product type the product is a group of video rentals of the
> >>>>>> same rental price referring to many video assets.
> >>>>> Hans
> >>>>>
> >>>>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
> >>>>>> A fixed asset is an instance of a product, much like an inventory item
> >>>>>> is an instance of a product. So, no - you do not want to connect a fixed
> >>>>>> asset to a product category.
> >>>>>>
> >>>>>> Product: Die Hard DVD
> >>>>>> Product Categories: DVD, Action, Drama, Bruce Willis
> >>>>>> Fixed Assets: 10010, 10011, 1012
> >>>>>>
> >>>>>> -Adrian
> >>>>>>
> >>>>>> On 9/23/2011 6:20 AM, Hans Bakker wrote:
> >>>>>>> Now we can have rental products where the asset can be rented....
> >>>>>>>
> >>>>>>> In this product type the product is a group of video rentals of the same
> >>>>>>> rental price referring to many video assets.
> >>>>>>>
> >>>>>>> However now we also want to categorize these assets in order to display
> >>>>>>> them on the e-commerce website.
> >>>>>>>
> >>>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
> >>>>>>> solution?
> >>>>>>>
> >>>>>>>
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Alternative ofbiz website: http://www.ofbiz.info
http://www.antwebsystems.com : Quality services for competitive rates.
Re: discussion: video rentals
Posted by Adrian Crum <ad...@sandglass-software.com>.
If they are the same product, then they are in the same product categories.
I have three copies of the Die Hard DVD. Why would I want to put each
one in a different product category? What you are suggesting doesn't
make sense.
It might help if you gave some specific examples of what you are trying
to do.
-Adrian
On 9/23/2011 6:51 AM, Hans Bakker wrote:
> Can you help me think in the right direction?
>
> how can i show some fixedassets of the same product in one category and
> some of the assets in another category?
>
> Thank you in advance for your help.
>
> Regards,m=
> Hans
>
> On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote:
>> Hans,
>>
>> The data model supports what you are trying to do if YOU think about it.
>> There is no need to connect a fixed asset to a product category.
>>
>> -Adrian
>>
>> On 9/23/2011 6:44 AM, Hans Bakker wrote:
>>> sure can do that, but i want a specific instance showing in one category
>>> and another instance showing in a different category......
>>>
>>> Adrian, before you answer can you please think about it a bit?
>>>
>>> Regards,
>>> Hans
>>>
>>> On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote:
>>>> Use FixedAssetProduct.
>>>>
>>>> -Adrian
>>>>
>>>> On 9/23/2011 6:37 AM, Hans Bakker wrote:
>>>>> but if you want a particular instance of a product?
>>>>>
>>>>> I have products (as i described):
>>>>>> In this product type the product is a group of video rentals of the
>>>>>> same rental price referring to many video assets.
>>>>> Hans
>>>>>
>>>>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
>>>>>> A fixed asset is an instance of a product, much like an inventory item
>>>>>> is an instance of a product. So, no - you do not want to connect a fixed
>>>>>> asset to a product category.
>>>>>>
>>>>>> Product: Die Hard DVD
>>>>>> Product Categories: DVD, Action, Drama, Bruce Willis
>>>>>> Fixed Assets: 10010, 10011, 1012
>>>>>>
>>>>>> -Adrian
>>>>>>
>>>>>> On 9/23/2011 6:20 AM, Hans Bakker wrote:
>>>>>>> Now we can have rental products where the asset can be rented....
>>>>>>>
>>>>>>> In this product type the product is a group of video rentals of the same
>>>>>>> rental price referring to many video assets.
>>>>>>>
>>>>>>> However now we also want to categorize these assets in order to display
>>>>>>> them on the e-commerce website.
>>>>>>>
>>>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
>>>>>>> solution?
>>>>>>>
>>>>>>>
Re: discussion: video rentals
Posted by Hans Bakker <ma...@antwebsystems.com>.
Can you help me think in the right direction?
how can i show some fixedassets of the same product in one category and
some of the assets in another category?
Thank you in advance for your help.
Regards,m=
Hans
On Fri, 2011-09-23 at 06:47 +0100, Adrian Crum wrote:
> Hans,
>
> The data model supports what you are trying to do if YOU think about it.
> There is no need to connect a fixed asset to a product category.
>
> -Adrian
>
> On 9/23/2011 6:44 AM, Hans Bakker wrote:
> > sure can do that, but i want a specific instance showing in one category
> > and another instance showing in a different category......
> >
> > Adrian, before you answer can you please think about it a bit?
> >
> > Regards,
> > Hans
> >
> > On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote:
> >> Use FixedAssetProduct.
> >>
> >> -Adrian
> >>
> >> On 9/23/2011 6:37 AM, Hans Bakker wrote:
> >>> but if you want a particular instance of a product?
> >>>
> >>> I have products (as i described):
> >>>> In this product type the product is a group of video rentals of the
> >>>> same rental price referring to many video assets.
> >>> Hans
> >>>
> >>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
> >>>> A fixed asset is an instance of a product, much like an inventory item
> >>>> is an instance of a product. So, no - you do not want to connect a fixed
> >>>> asset to a product category.
> >>>>
> >>>> Product: Die Hard DVD
> >>>> Product Categories: DVD, Action, Drama, Bruce Willis
> >>>> Fixed Assets: 10010, 10011, 1012
> >>>>
> >>>> -Adrian
> >>>>
> >>>> On 9/23/2011 6:20 AM, Hans Bakker wrote:
> >>>>> Now we can have rental products where the asset can be rented....
> >>>>>
> >>>>> In this product type the product is a group of video rentals of the same
> >>>>> rental price referring to many video assets.
> >>>>>
> >>>>> However now we also want to categorize these assets in order to display
> >>>>> them on the e-commerce website.
> >>>>>
> >>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
> >>>>> solution?
> >>>>>
> >>>>>
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Alternative ofbiz website: http://www.ofbiz.info
http://www.antwebsystems.com : Quality services for competitive rates.
Re: discussion: video rentals
Posted by Adrian Crum <ad...@sandglass-software.com>.
Hans,
The data model supports what you are trying to do if YOU think about it.
There is no need to connect a fixed asset to a product category.
-Adrian
On 9/23/2011 6:44 AM, Hans Bakker wrote:
> sure can do that, but i want a specific instance showing in one category
> and another instance showing in a different category......
>
> Adrian, before you answer can you please think about it a bit?
>
> Regards,
> Hans
>
> On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote:
>> Use FixedAssetProduct.
>>
>> -Adrian
>>
>> On 9/23/2011 6:37 AM, Hans Bakker wrote:
>>> but if you want a particular instance of a product?
>>>
>>> I have products (as i described):
>>>> In this product type the product is a group of video rentals of the
>>>> same rental price referring to many video assets.
>>> Hans
>>>
>>> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
>>>> A fixed asset is an instance of a product, much like an inventory item
>>>> is an instance of a product. So, no - you do not want to connect a fixed
>>>> asset to a product category.
>>>>
>>>> Product: Die Hard DVD
>>>> Product Categories: DVD, Action, Drama, Bruce Willis
>>>> Fixed Assets: 10010, 10011, 1012
>>>>
>>>> -Adrian
>>>>
>>>> On 9/23/2011 6:20 AM, Hans Bakker wrote:
>>>>> Now we can have rental products where the asset can be rented....
>>>>>
>>>>> In this product type the product is a group of video rentals of the same
>>>>> rental price referring to many video assets.
>>>>>
>>>>> However now we also want to categorize these assets in order to display
>>>>> them on the e-commerce website.
>>>>>
>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
>>>>> solution?
>>>>>
>>>>>
Re: discussion: video rentals
Posted by Hans Bakker <ma...@antwebsystems.com>.
sure can do that, but i want a specific instance showing in one category
and another instance showing in a different category......
Adrian, before you answer can you please think about it a bit?
Regards,
Hans
On Fri, 2011-09-23 at 06:42 +0100, Adrian Crum wrote:
> Use FixedAssetProduct.
>
> -Adrian
>
> On 9/23/2011 6:37 AM, Hans Bakker wrote:
> > but if you want a particular instance of a product?
> >
> > I have products (as i described):
> >> In this product type the product is a group of video rentals of the
> >> same rental price referring to many video assets.
> > Hans
> >
> > On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
> >> A fixed asset is an instance of a product, much like an inventory item
> >> is an instance of a product. So, no - you do not want to connect a fixed
> >> asset to a product category.
> >>
> >> Product: Die Hard DVD
> >> Product Categories: DVD, Action, Drama, Bruce Willis
> >> Fixed Assets: 10010, 10011, 1012
> >>
> >> -Adrian
> >>
> >> On 9/23/2011 6:20 AM, Hans Bakker wrote:
> >>> Now we can have rental products where the asset can be rented....
> >>>
> >>> In this product type the product is a group of video rentals of the same
> >>> rental price referring to many video assets.
> >>>
> >>> However now we also want to categorize these assets in order to display
> >>> them on the e-commerce website.
> >>>
> >>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
> >>> solution?
> >>>
> >>>
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Alternative ofbiz website: http://www.ofbiz.info
http://www.antwebsystems.com : Quality services for competitive rates.
Re: discussion: video rentals
Posted by Adrian Crum <ad...@sandglass-software.com>.
Use FixedAssetProduct.
-Adrian
On 9/23/2011 6:37 AM, Hans Bakker wrote:
> but if you want a particular instance of a product?
>
> I have products (as i described):
>> In this product type the product is a group of video rentals of the
>> same rental price referring to many video assets.
> Hans
>
> On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
>> A fixed asset is an instance of a product, much like an inventory item
>> is an instance of a product. So, no - you do not want to connect a fixed
>> asset to a product category.
>>
>> Product: Die Hard DVD
>> Product Categories: DVD, Action, Drama, Bruce Willis
>> Fixed Assets: 10010, 10011, 1012
>>
>> -Adrian
>>
>> On 9/23/2011 6:20 AM, Hans Bakker wrote:
>>> Now we can have rental products where the asset can be rented....
>>>
>>> In this product type the product is a group of video rentals of the same
>>> rental price referring to many video assets.
>>>
>>> However now we also want to categorize these assets in order to display
>>> them on the e-commerce website.
>>>
>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
>>> solution?
>>>
>>>
Re: discussion: video rentals
Posted by Hans Bakker <ma...@antwebsystems.com>.
but if you want a particular instance of a product?
I have products (as i described):
> In this product type the product is a group of video rentals of the
> same rental price referring to many video assets.
Hans
On Fri, 2011-09-23 at 06:32 +0100, Adrian Crum wrote:
> A fixed asset is an instance of a product, much like an inventory item
> is an instance of a product. So, no - you do not want to connect a fixed
> asset to a product category.
>
> Product: Die Hard DVD
> Product Categories: DVD, Action, Drama, Bruce Willis
> Fixed Assets: 10010, 10011, 1012
>
> -Adrian
>
> On 9/23/2011 6:20 AM, Hans Bakker wrote:
> > Now we can have rental products where the asset can be rented....
> >
> > In this product type the product is a group of video rentals of the same
> > rental price referring to many video assets.
> >
> > However now we also want to categorize these assets in order to display
> > them on the e-commerce website.
> >
> > Is adding a fixedAssetid field to the ProductCategoryMember entity a
> > solution?
> >
> >
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Alternative ofbiz website: http://www.ofbiz.info
http://www.antwebsystems.com : Quality services for competitive rates.
Re: discussion: video rentals
Posted by Adrian Crum <ad...@sandglass-software.com>.
A fixed asset is an instance of a product, much like an inventory item
is an instance of a product. So, no - you do not want to connect a fixed
asset to a product category.
Product: Die Hard DVD
Product Categories: DVD, Action, Drama, Bruce Willis
Fixed Assets: 10010, 10011, 1012
-Adrian
On 9/23/2011 6:20 AM, Hans Bakker wrote:
> Now we can have rental products where the asset can be rented....
>
> In this product type the product is a group of video rentals of the same
> rental price referring to many video assets.
>
> However now we also want to categorize these assets in order to display
> them on the e-commerce website.
>
> Is adding a fixedAssetid field to the ProductCategoryMember entity a
> solution?
>
>
Re: discussion: video rentals
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
I know that you have already implemented it, but I still don't understand your response to my original comment... but it is ok.
As regards the serialized/non-serialized item decision, the fact that you have decided to store the serial number in the FixedAsset entity and not in the InventoryItem entity is fine but I still think that the InventoryItem should be "serialized" (I am under the assumption that your InventoryItem cannot have a QOH greater than 1, if they are associated to FixedAsset with serial numbers in them).
Regards,
Jacopo
On Oct 5, 2011, at 10:25 AM, Hans Bakker wrote:
> Jacopo,
>
> i do not know what to say, we already finished implemented it and what
> you propose we actually did however without the serialized inventory
> because we already have a serial number on the asset....
>
> Regards,
> Hans
>
> On Wed, 2011-10-05 at 08:19 +0200, Jacopo Cappellato wrote:
>> Hi Hans,
>>
>> I can't see what in my notes would prevent from doing this, since you have already added the fixedAssetId to the InventoryItem entity (as a side note, I would have preferred the other way round, i.e. if the field inventoryItemId was added to the FixedAsset entity)?
>>
>> Regards,
>>
>> Jacopo
>>
>> On Oct 5, 2011, at 6:01 AM, Hans Bakker wrote:
>>
>>> Hi Jacopo,
>>>
>>> thanks for you comment. I did look into this but decided to not
>>> duplicate data in the system.
>>>
>>> In the case where assets for maintenance and depreciation is not
>>> connected with a serialized inventory item we will have a number of
>>> fields duplicated (cost, serial number etc) and we do not know where the
>>> asset is stored in inventory when not in use.
>>>
>>> Regards,
>>> Hans
>>>
>>> On Mon, 2011-10-03 at 12:35 +0200, Jacopo Cappellato wrote:
>>>> Hi Hans,
>>>>
>>>> I have read the threads and the blog posts, and considering the requirements:
>>>>
>>>> * the need to maintain (serialized) inventory items and ship/receive them
>>>> * the need to depreciate the items as assets
>>>>
>>>> I am wondering if you have considered the design of:
>>>>
>>>> * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item)
>>>> * using fixed assets only for the depreciation
>>>>
>>>> Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code.
>>>>
>>>> Kind regards,
>>>>
>>>> Jacopo
>>>>
>>>> On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote:
>>>>
>>>>> Thanks Adrian and Paul for the valuable comments.
>>>>>
>>>>> Taking all comments into account, we will do the following: (most is
>>>>> already done)
>>>>>
>>>>> 1. a single product can refer to one or more assets. (as is now)
>>>>> 2. An asset can refer to a single inventory item. (is added)
>>>>> 3. With this product type, the assetid will be shown on the orderitem,
>>>>> picklist and shipping slip which also will show the RA# (return auth #)
>>>>> 4. the item can be received in the facility -> receive return option.
>>>>>
>>>>> more info at:
>>>>> http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048
>>>>>
>>>>> Regards,
>>>>> Hans
>>>>>
>>>>>
>>>>> On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote:
>>>>>> Now we can have rental products where the asset can be rented....
>>>>>>
>>>>>> In this product type the product is a group of video rentals of the same
>>>>>> rental price referring to many video assets.
>>>>>>
>>>>>> However now we also want to categorize these assets in order to display
>>>>>> them on the e-commerce website.
>>>>>>
>>>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
>>>>>> solution?
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> Ofbiz on twitter: http://twitter.com/apache_ofbiz
>>>>> Alternative ofbiz website: http://www.ofbiz.info
>>>>> http://www.antwebsystems.com : Quality services for competitive rates.
>>>>>
>>>>
>>>
>>> --
>>> Ofbiz on twitter: http://twitter.com/apache_ofbiz
>>> Alternative ofbiz website: http://www.ofbiz.info
>>> http://www.antwebsystems.com : Quality services for competitive rates.
>>>
>>
>
> --
> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> Alternative ofbiz website: http://www.ofbiz.info
> http://www.antwebsystems.com : Quality services for competitive rates.
>
Re: discussion: video rentals
Posted by Hans Bakker <ma...@antwebsystems.com>.
Jacopo,
i do not know what to say, we already finished implemented it and what
you propose we actually did however without the serialized inventory
because we already have a serial number on the asset....
Regards,
Hans
On Wed, 2011-10-05 at 08:19 +0200, Jacopo Cappellato wrote:
> Hi Hans,
>
> I can't see what in my notes would prevent from doing this, since you have already added the fixedAssetId to the InventoryItem entity (as a side note, I would have preferred the other way round, i.e. if the field inventoryItemId was added to the FixedAsset entity)?
>
> Regards,
>
> Jacopo
>
> On Oct 5, 2011, at 6:01 AM, Hans Bakker wrote:
>
> > Hi Jacopo,
> >
> > thanks for you comment. I did look into this but decided to not
> > duplicate data in the system.
> >
> > In the case where assets for maintenance and depreciation is not
> > connected with a serialized inventory item we will have a number of
> > fields duplicated (cost, serial number etc) and we do not know where the
> > asset is stored in inventory when not in use.
> >
> > Regards,
> > Hans
> >
> > On Mon, 2011-10-03 at 12:35 +0200, Jacopo Cappellato wrote:
> >> Hi Hans,
> >>
> >> I have read the threads and the blog posts, and considering the requirements:
> >>
> >> * the need to maintain (serialized) inventory items and ship/receive them
> >> * the need to depreciate the items as assets
> >>
> >> I am wondering if you have considered the design of:
> >>
> >> * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item)
> >> * using fixed assets only for the depreciation
> >>
> >> Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code.
> >>
> >> Kind regards,
> >>
> >> Jacopo
> >>
> >> On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote:
> >>
> >>> Thanks Adrian and Paul for the valuable comments.
> >>>
> >>> Taking all comments into account, we will do the following: (most is
> >>> already done)
> >>>
> >>> 1. a single product can refer to one or more assets. (as is now)
> >>> 2. An asset can refer to a single inventory item. (is added)
> >>> 3. With this product type, the assetid will be shown on the orderitem,
> >>> picklist and shipping slip which also will show the RA# (return auth #)
> >>> 4. the item can be received in the facility -> receive return option.
> >>>
> >>> more info at:
> >>> http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048
> >>>
> >>> Regards,
> >>> Hans
> >>>
> >>>
> >>> On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote:
> >>>> Now we can have rental products where the asset can be rented....
> >>>>
> >>>> In this product type the product is a group of video rentals of the same
> >>>> rental price referring to many video assets.
> >>>>
> >>>> However now we also want to categorize these assets in order to display
> >>>> them on the e-commerce website.
> >>>>
> >>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
> >>>> solution?
> >>>>
> >>>>
> >>>
> >>> --
> >>> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> >>> Alternative ofbiz website: http://www.ofbiz.info
> >>> http://www.antwebsystems.com : Quality services for competitive rates.
> >>>
> >>
> >
> > --
> > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > Alternative ofbiz website: http://www.ofbiz.info
> > http://www.antwebsystems.com : Quality services for competitive rates.
> >
>
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Alternative ofbiz website: http://www.ofbiz.info
http://www.antwebsystems.com : Quality services for competitive rates.
Re: discussion: video rentals
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
Hi Hans,
I can't see what in my notes would prevent from doing this, since you have already added the fixedAssetId to the InventoryItem entity (as a side note, I would have preferred the other way round, i.e. if the field inventoryItemId was added to the FixedAsset entity)?
Regards,
Jacopo
On Oct 5, 2011, at 6:01 AM, Hans Bakker wrote:
> Hi Jacopo,
>
> thanks for you comment. I did look into this but decided to not
> duplicate data in the system.
>
> In the case where assets for maintenance and depreciation is not
> connected with a serialized inventory item we will have a number of
> fields duplicated (cost, serial number etc) and we do not know where the
> asset is stored in inventory when not in use.
>
> Regards,
> Hans
>
> On Mon, 2011-10-03 at 12:35 +0200, Jacopo Cappellato wrote:
>> Hi Hans,
>>
>> I have read the threads and the blog posts, and considering the requirements:
>>
>> * the need to maintain (serialized) inventory items and ship/receive them
>> * the need to depreciate the items as assets
>>
>> I am wondering if you have considered the design of:
>>
>> * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item)
>> * using fixed assets only for the depreciation
>>
>> Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code.
>>
>> Kind regards,
>>
>> Jacopo
>>
>> On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote:
>>
>>> Thanks Adrian and Paul for the valuable comments.
>>>
>>> Taking all comments into account, we will do the following: (most is
>>> already done)
>>>
>>> 1. a single product can refer to one or more assets. (as is now)
>>> 2. An asset can refer to a single inventory item. (is added)
>>> 3. With this product type, the assetid will be shown on the orderitem,
>>> picklist and shipping slip which also will show the RA# (return auth #)
>>> 4. the item can be received in the facility -> receive return option.
>>>
>>> more info at:
>>> http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048
>>>
>>> Regards,
>>> Hans
>>>
>>>
>>> On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote:
>>>> Now we can have rental products where the asset can be rented....
>>>>
>>>> In this product type the product is a group of video rentals of the same
>>>> rental price referring to many video assets.
>>>>
>>>> However now we also want to categorize these assets in order to display
>>>> them on the e-commerce website.
>>>>
>>>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
>>>> solution?
>>>>
>>>>
>>>
>>> --
>>> Ofbiz on twitter: http://twitter.com/apache_ofbiz
>>> Alternative ofbiz website: http://www.ofbiz.info
>>> http://www.antwebsystems.com : Quality services for competitive rates.
>>>
>>
>
> --
> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> Alternative ofbiz website: http://www.ofbiz.info
> http://www.antwebsystems.com : Quality services for competitive rates.
>
Re: discussion: video rentals
Posted by Hans Bakker <ma...@antwebsystems.com>.
Hi Jacopo,
thanks for you comment. I did look into this but decided to not
duplicate data in the system.
In the case where assets for maintenance and depreciation is not
connected with a serialized inventory item we will have a number of
fields duplicated (cost, serial number etc) and we do not know where the
asset is stored in inventory when not in use.
Regards,
Hans
On Mon, 2011-10-03 at 12:35 +0200, Jacopo Cappellato wrote:
> Hi Hans,
>
> I have read the threads and the blog posts, and considering the requirements:
>
> * the need to maintain (serialized) inventory items and ship/receive them
> * the need to depreciate the items as assets
>
> I am wondering if you have considered the design of:
>
> * using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item)
> * using fixed assets only for the depreciation
>
> Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code.
>
> Kind regards,
>
> Jacopo
>
> On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote:
>
> > Thanks Adrian and Paul for the valuable comments.
> >
> > Taking all comments into account, we will do the following: (most is
> > already done)
> >
> > 1. a single product can refer to one or more assets. (as is now)
> > 2. An asset can refer to a single inventory item. (is added)
> > 3. With this product type, the assetid will be shown on the orderitem,
> > picklist and shipping slip which also will show the RA# (return auth #)
> > 4. the item can be received in the facility -> receive return option.
> >
> > more info at:
> > http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048
> >
> > Regards,
> > Hans
> >
> >
> > On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote:
> >> Now we can have rental products where the asset can be rented....
> >>
> >> In this product type the product is a group of video rentals of the same
> >> rental price referring to many video assets.
> >>
> >> However now we also want to categorize these assets in order to display
> >> them on the e-commerce website.
> >>
> >> Is adding a fixedAssetid field to the ProductCategoryMember entity a
> >> solution?
> >>
> >>
> >
> > --
> > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > Alternative ofbiz website: http://www.ofbiz.info
> > http://www.antwebsystems.com : Quality services for competitive rates.
> >
>
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Alternative ofbiz website: http://www.ofbiz.info
http://www.antwebsystems.com : Quality services for competitive rates.
Re: discussion: video rentals
Posted by Jacopo Cappellato <ja...@hotwaxmedia.com>.
Hi Hans,
I have read the threads and the blog posts, and considering the requirements:
* the need to maintain (serialized) inventory items and ship/receive them
* the need to depreciate the items as assets
I am wondering if you have considered the design of:
* using product/inventory items (mostly) as in standard OFBiz (add to cart products then reserve,pick,ship inventory items then return product/item)
* using fixed assets only for the depreciation
Without looking at the details (and I guess I may be missing some of them) this seems to me a simpler approach that would have caused a smaller impact in the existing code.
Kind regards,
Jacopo
On Sep 27, 2011, at 4:59 AM, Hans Bakker wrote:
> Thanks Adrian and Paul for the valuable comments.
>
> Taking all comments into account, we will do the following: (most is
> already done)
>
> 1. a single product can refer to one or more assets. (as is now)
> 2. An asset can refer to a single inventory item. (is added)
> 3. With this product type, the assetid will be shown on the orderitem,
> picklist and shipping slip which also will show the RA# (return auth #)
> 4. the item can be received in the facility -> receive return option.
>
> more info at:
> http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048
>
> Regards,
> Hans
>
>
> On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote:
>> Now we can have rental products where the asset can be rented....
>>
>> In this product type the product is a group of video rentals of the same
>> rental price referring to many video assets.
>>
>> However now we also want to categorize these assets in order to display
>> them on the e-commerce website.
>>
>> Is adding a fixedAssetid field to the ProductCategoryMember entity a
>> solution?
>>
>>
>
> --
> Ofbiz on twitter: http://twitter.com/apache_ofbiz
> Alternative ofbiz website: http://www.ofbiz.info
> http://www.antwebsystems.com : Quality services for competitive rates.
>
Re: discussion: video rentals
Posted by Hans Bakker <ma...@antwebsystems.com>.
Thanks Adrian and Paul for the valuable comments.
Taking all comments into account, we will do the following: (most is
already done)
1. a single product can refer to one or more assets. (as is now)
2. An asset can refer to a single inventory item. (is added)
3. With this product type, the assetid will be shown on the orderitem,
picklist and shipping slip which also will show the RA# (return auth #)
4. the item can be received in the facility -> receive return option.
more info at:
http://www.antwebsystems.com/control/ViewBlogArticle?contentId=91048
Regards,
Hans
On Fri, 2011-09-23 at 12:20 +0700, Hans Bakker wrote:
> Now we can have rental products where the asset can be rented....
>
> In this product type the product is a group of video rentals of the same
> rental price referring to many video assets.
>
> However now we also want to categorize these assets in order to display
> them on the e-commerce website.
>
> Is adding a fixedAssetid field to the ProductCategoryMember entity a
> solution?
>
>
--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Alternative ofbiz website: http://www.ofbiz.info
http://www.antwebsystems.com : Quality services for competitive rates.