[Ted S]

More answers on getting started and customizing PRF can be found in the Install Guide

How does this mod work?
Rather than waiting for a user to open up a new thread talking about a product or service, you create a single “master” thread through your Admin Panel. This automatically creates a product record which shows up in a formatted, easy to follow section above the newly created thread containing an image, title, price and all sorts of other details.

Users looking for information can then turn to this single thread to get an overview snapshot, post a follow up question, and of course click over to write their own review or browse the existing ones.

How do reviews work?
Each time a user reviews a product, the main thread is updated both to include the review into the summary and with a post of the detailed comments. If you chose to do so, a separate thread can also be created in a different forum to increase conversation on the review.

Will this help me get more traffic / search engine rankings?
When users [or search engines] go looking for information what they want is clear, relevant and recent information. By moving conversation into a single thread this is provided in a digestible way that users are more likely to click on, search engines find easier to pick out over thousands of similar posts. Plus reviews are prime for sharing, discussing and passing around. So yes, this should increase traffic.

Can I have non-product threads in the same forum?
You can allow other threads in the same forums however this is likely to confuse your users as they will not see the product header bar and is not recommended.

Can I use this mod for displaying more than just standard products?
Sure. Anything that has consistent information and can be reviewed will work… whether your forum covers cruises, day spas or home repair services, this mod will fit the bill.

What fields can I fill out on each product?
1. Product Title
2. MSRP Price
3. Affiliate Shop URL & Title
4. Short & Long Description
5. Product Image [now uploadable]
6. UPC / ISBN / SKU for easy searching

How do I get the customized forums like in your images?
The install guide explains this in detail but sufficient to say it requires a quick code change to your forumdisplay script. We wish this wasn't the case but for now that's the only way to completely override the thread listings.

How does the activity stream get impacted?
Products and reviews are regular posts... sort of. To avoid odd looking updates we hide all of the activity from PRF in your activity system and instead create our own records written to reflect what's really happening each time an item is reviewed. Simple, and if we can say so... pretty slick.

[Ted S]

Held for Variables & Customization

[Ted S]

This post contains a list of suggested / planned features.

Planned Changes [Week of 1/16]
- Link to reviews in each user's profile [optional]
- Tab with a list of user's recent reviews [optional]
- Alternative star image colors
- WYSIWYG editor for writing a review

Planned For the Next Major Release [TBD]
- Image Uploading & Resizing

Other Suggestions I'm Aware Of
- Multiple update "types" [reviews, news, fact, question] w/ inline comments and sorting of posts
- Custom fields to add to reviews
- Additional images
- Additional videos
- Custom rating groups [service, reliability, appearance, etc]
- Product thumbnails on search listing page
- Sidebar widget with most recent reviews
- Sidebar widget with top products from the past X hours

[TheLastSuperman]

Been waiting for this, downloading now .

[mmackinnon]

Tried to install and got this:

Database error in vBulletin 4.1.4:

Invalid SQL:
ALTER TABLE user ADD productreviews INT UNSIGNED NULL;

MySQL Error : Table 'crna_vbulletin.user' doesn't exist
Error Number : 1146
Request Date : Tuesday, September 6th 2011 @ 09:38:07 PM
Error Date : Tuesday, September 6th 2011 @ 09:38:08 PM
Script : http://www.nurse-anesthesia.org/admi...=productimport
Referrer : http://www.nurse-anesthesia.org/admi...?do=productadd
IP Address : 68.98.69.63
Username : ADMIN
Classname : vB_Database
MySQL Version : 5.1.39-log

[thecore762]

Will test this out this weekend!
Looking forward to this!

[Ted S]

Originally Posted by mmackinnon

Tried to install and got this:

Database error in vBulletin 4.1.4:

Invalid SQL:
ALTER TABLE user ADD productreviews INT UNSIGNED NULL;

MySQL Error : Table 'crna_vbulletin.user' doesn't exist
Error Number : 1146
Request Date : Tuesday, September 6th 2011 @ 09:38:07 PM
Error Date : Tuesday, September 6th 2011 @ 09:38:08 PM
Script : http://www.nurse-anesthesia.org/admi...=productimport
Referrer : http://www.nurse-anesthesia.org/admi...?do=productadd
IP Address : 68.98.69.63
Username : ADMIN
Classname : vB_Database
MySQL Version : 5.1.39-log

Looks like I'm missing the prefix check. Pesky prefixes...

1.0.1 beta coming in a few minutes.

[Ted S]

Very minor update released to address table prefix issues with the installer.

This only impacts those using prefixes.

[Sforums]

This looks very promising!
At our forum we have many vendors selling multiple products. Each vendor has it's own subforum. Does this mean I can have this mod implemented in each of their subforums?

[Ricsca]

Demo?

[ProFifaLeagues]

Working superb for us on 4.1.3
thank you!
Anyway we can change the list price from $ to the £ sign?

[Ramsesx]

Very interesting, will checking it out in some minutes.

[Ramsesx]

If I click at "be the first to write a review" get following db error:

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT pf.threadid,pf.title,pf.reviews,pf.rating,pf.price,pf.short_desc,pf.mfrg,pf.upc, pf.sku,thread.forumid
FROM vb3_pf_product as pf
JOIN vb3_thread ON pf.threadid = thread.threadid
WHERE productid = '1' AND active = 1;

MySQL Error : Unknown column 'thread.forumid' in 'field list'
Error Number : 1054

Also the tools menu is below the product listing and the manufacturer is not visible.
The above error is only if I have in the acp "Create New Thread on Review" set to no.
If it is set to yes I get the message "This feature is not configured yet. Please check back soon." if trying to write a review.
And if I add a forum ID in the acp setting "Review Thread Forum ID" get above db error again.
There are also db errors when clicking at "Manage" in "Manage Product Reviews Forums" (value 0)

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT COUNT(productid) AS count
FROM vb3_pf_product
WHERE pf_product.productid <> 0;

MySQL Error : Unknown column 'pf_product.productid' in 'where clause'
Error Number : 1054

[Mr_Running]

must create products in order for the mod to show up

Where do we create the products?