Item "as category"

Hello! Let me explain my question with an example: i would like to have:
- Sellers
- Manufacturers
- Products
- Reviews

I would like to make a review site, where everyone could sign up and insert and review products, and where manufacturers and sellers could sign up and mark which products they make/sell.

In a test site I've created the first three items, the relation and reverse relation fields are working like a charm: in the Product item I can see who makes and who sells it, and in the Manufacturer and Seller items I can see which Products are made/sold by that Manufacturer/Seller.

Now the tricky part: the reviews. Let's start with a list of Products in the category view. When I select one Product, the Product's page opens, and under the Product's description (where I can also see who makes and sells it) I would like to list all of it's Reviews.

That's why I asked the "item as category" thing: the Product becomes a kind of category where I have all the related Reviews (and I can order them by time, rating, user etc.)

I have other questions, but I'll ask them later on

an idea
0 a category for all product item
1 a link to a category with you review (1 product => 1 categorie)
2 at top of your category use universal module to load the item current with your field and after the review

regards

Thanks, tomorrow I'll try

Hello,

Micker's suggestion
might work in display your data, but
- You need backend access to create one category per product, and is bit cumbersome to maintain. You could create a link to "review submit that includes the category id", but how do you get this category id?
and even after you get it how do you create the link to the item form that is product review? Furthermore some changes to item form might be needed


-- Currently FLEXIcontent has
an one-to-many RELATION for
item<-->multiple categories

-- A real implementation we implemented (in FLEXIcontent) involves adding an one-to-many RELATION like:
item<-->multiple items

So,
1. maybe we need an need DB schema relation
2. maybe we can make some enhancements to RELATION field

Before saying anything further, i need to ask your reviews are complex? , i mean are they more than just a single Text ?

This is interesting part and I think this will be very useful.

What I am thinking is...

- Sellers
- Manufacturers
- Products
- Reviews

Maybe create 3 different Categories and Type for Review.
- Reviews_for_Sellers
- Reviews_for_Manufacturers
- Reviews_for_Products
and all the Reviews item form will have e.g. ProductID field to select same product.

In Products Type,

Each product item must have ProductID field.
Use three Relation fields to list all related reviews from each Reviews Categories.

@ggppdk:
So, in relation field, We will need a function to collect all related items from specified category automatically by comparing ProductID, instead of selecting items by manually in item form.
George, is this what you mean, right?

It's gonna be very useful coz authors don't have to update the relation field(selecting items from category manually) when new related items available!!

The idea in little words (a little as i can) is:

e.g.
1. You have 2 Content Types:
- products, reviews

2. You have a relation field assigned to "product" Content Type, which is called "Review"
-- this will list the related reviews in the item view of product item

3. BUT : (here is the change/enhancement)
the relation field besides listing the reviews VIA THE RELATION FIELD "Review" (list can show any field of them, description, etc,)
it will also present a link called:
Add new "Review"
(inside quotes is the label of relation field)

4. This link will have a URL variable e.g.

&relation_field=field_id&relation_item=item_id
(id of relation field and the item id of the product)

and it will open item form of Review and on Save of new "Review" Type item, ... it will update also update the value of "Review" field of the product[/b]

This can be done by adding code to "Relation Reverse" Field that we will assign to "Review" Content Type