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?