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

That would be just great!!
We can make reviews "component" with powerful Relation field.

Hello,
benefit of solution is that it will be "clean" and also allow multiple type of relations of each Content Type.

Nevertheless a complete implementation will require some more work
e.g. item's manager support of listing the related items,
and other we may have not anticipated now

This will be added in a timely manner ...

Regards

Hello ggppdk!

ggppdk wrote: 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

I didn't had time to make some serious test, but yes, I came to the same conclusion

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

Yes, my reviews are complex. They'll have some combobox fields, some text fields and 5 different ratings (for 5 different properties (plus the relations I've said in my first post). The products are complex too. They'll have the relations (as stated before), images, text fields, radio images etc.

Let me mention also some other "advanced" features/fields:
1. The site'll have multiple languages, so the Products will have multiple languages too. Reviewers will post reviews in their preferred language. If they'll want to, they'll be able to translate their own reviews.
2. The reviews should be "base" or "advanced". The base, simpler review is meant for casual users, while the advanced review is for expert/professional users, who exactly know how to review every single feature.
3. A product in it's information should show it's rating. The rating is calculated by averaging the ratings from all the reviews (in all languages). Obviously, if a review is translated in e.g. 2 languages, it should count as one review, not as two.

This is my ideal site, I don't know if everything is possible, I just wanted to explain to you everything, so you have the whole picture of my idea.

Let me show you a practical example (from a well known review site) of something similar. I have a page with a list of products: www.ciao.co.uk/nf/Mice_Trackball ... 3-mouse~o3
The list could be ordered by rating, reviewer, date added, alphabetically etc. In this list I can see the average rating of the product.

When I click on a particular product I get this: www.ciao.co.uk/Logitech_MX_Mouse__6462472
Product's page with it's features (included average rating), and in the lower part of the page all the related reviews, which could be ordered in different manners (by rating, reviewer, reviewer "reputation" etc.).

Sorry to bother you again, I read this post multiple times:

ggppdk wrote: 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

Is this already possible, or were you talking about a future functionality? Also, assigning a Relation field to the Product item instead of assigning it to the Review would force me to add a Review, then go to the Product, and edit the relation field by adding the newly added Review. Shouldn't the Relation field be in the Review, and the Inverse relation in the Product?