Meet with Joe via Hangout to discuss database schematics

[theheadphonelist]

Thanks for starting to work on this bro! Are you available tonight? Tomorrow evening?

[timproctor]

Sure! Let's set something up for tomorrow, can you 7pm MST or 6pm your time?

[theheadphonelist]

Sure, the 31st at 7 PM MST it is!

[theheadphonelist]

[timproctor]

1. log-in with gmail (mvp for now) *****_log in concerns *_****
2. persistence with log-in like head-fi.org or github
3. uploading images (paperclip gem)

*DATABASES*****

3. user table with multiple scopes like admin, manufacturer, audiologist, etc
4. products table (possible three)
5. reviews for retailer
6. reviews for audiologist
7. comment on manufacturer
8. user owns review which is attached to product
9. images
10. amazon links (11. amazon uk) down-the-road

---

review is linked to the audiologist and the user that wrote it review is linked to the retailer and the user that wrote it review is linked to the product and the user that wrote it

---

user selects templates for reviews or a more in-depth template early thoughts: gamification to earn more advanced review templating

[theheadphonelist]

The Headphone List is a review site designed to evolve the way reviews are published, allowing reviewers of various levels and with different perspectives to all contribute to information exchange. Reviews are displayed in a “list” format with filtering to improve the ease of finding products that are relevant to the viewer. Users can participate in the list concept, creating their own list.

Current site functionality to retain: • Posts and categories, with the ability to cross-categorize and have sub-categories • Post creation, editing, previewing, and image manipulation with featured image, and excerpts (if this can be created on the front-end vs. the dashboard, like Wordpress, that is preferred) • Convenient SEO settings, or automatic SEO settings • Entry of database information through the post page for table display • Table display with current functionality including: o Sorting o Filtering o Linking to posts or customized URLs o Color coding o User system • Flexible commenting system • Social integration • Ad integration • Homepage customization • Site search • Sidebar that is easy to manipulate • Easy to use menu system • Easy to change font sizes for system components (such as the menus) • Basic user functionality • Retain current URLs and content (including comments)

New Functional requirements overview (prioritized):

1. Amazon affiliate API integration a. Auto link products (not sure the options here, but possibly we manually add ASIN/SKU to products for each Amazon worldwide so a specific product is linked, and if no ASIN/SKU it auto-selects product matches)
2. Ability to create, modify, and edit databases from the front end, create and edit lists (tables) with customizable filtering (see f below), display data on a Google map, and create templates for posts, including inline ads and database fields a. Lists can display thumbnail images b. Logged in users can hide columns or choose to display more with an “Edit List View” button i. If a column that is part of a formula is hidden, a popup will ask “use original calculation for [field name]” or “remove hidden columns from [field name] calculation” c. Comparison type of database that connects to two of the same type of database entries d. Matching type of database entry that connects two or more of the same type of database entries e. Products can be linked with a ‘version,’ ‘same,’ ‘upgrade,’ ‘similar sound,’ or ‘compliment’ tag that can be displayed in the associated products templates; i.e. regular, Bluetooth, and headset versions of the same headphone or same headphone from two different manufacturers f. Filtering i. Conditional text search ii. Checkboxes, toggles (multi-check boxes), ranges (for example, possibly a smaller version of the slider in the JQUERY UI tab), etc. iii. Show number of results g. Ability to edit all table records from one page h. Import/export an Excel spreadsheet to create a new table, append data in an existing table, or replace all data in a table
3. Better SEO optimization and improved site speed (need a new host?)
4. Enable front-end data entry by users a. Admin settings for approval levels for: i. New entries ii. Suggested changes by users; i.e. a user can “update information” iii. Flags for deletion/change/merger with reason/comment; i.e. users can flag content as incorrect, inappropriate, or duplicate b. Admin tools to allow easy searching display of user input for review/approval

5. Mobile friendly design

1. Ebay and other affiliate integration
2. Q&A tags for comments a. Upvote or downvote of questions, answers, and comments by logged in users (like Quora?) b. Group questions and answers, including additional drill-down questions c. List questions and answers both on product pages as well as on categorized Q&A pages d. Full search for questions to avoid repeat questions, with a feature that auto-searches by keywords and makes suggestions e. Admin/editor ability to highlight and “sticky” questions, answers, and/or comments to the top of a post or page f. Ability for select user types to link comments from other pages to Q&A page g. Ability for users to “save” comments, questions, and answers for later reference from their user page
3. Multiple user types with different permission sets and page/post permission sets a. User Types i. Administrators ii. Editors iii. Super users iv. Users v. Manufacturers vi. Retailers vii. Audiologists b. Management page to control: i. User types to page/post type access; i.e. Super Users will be able to create databases and modify databases they have created ii. Specific users set to ownership of specific pages; i.e. a user will be assigned a page and that user will be the only user (other than Administrators and Editors) that can change content from that point forward c. Cookies & privacy policy
4. Affiliate price display a. Ability to set default affiliate display by location and select affiliates; i.e. people in Australia will get amazon.com affiliate links in addition to local affiliate links; if amazon.com has a lower cost than local affiliates, amazon.com would be displayed first; if the product isn’t available in another country, show affiliates that will ship to the country b. User ability to display/hide select affiliates when logged in; user can select “save changes” or “change display this session” c. User can select affiliates to display primarily by price or location
5. Google DFP (double click for publishers) integration
6. Regional advertising capability matches user location with advertiser a. Payment acceptance system for advertising and select user type subscriptions b. Match retailer and audiologist location with user location, and prominently place and highlight local companies c. Sale price engine: ability for companies with a paid subscription to enter and schedule sales prices that display on a special page and prominently in appropriate searches d. Paid advertising for larger ads (or can go through Google DFP if setup)
7. Deal alert page a. User entered deal alerts (global slickdeals?) b. Alert opt-in users of large price drops for all or select products c. Admin / Editor / Super User ability to highlight a deal alert (like slickdeals frontpage)
8. Advanced display features a. Display scores in graphical format for products and the ability to show multiples when compared (example of individual product below) http://en.goldenears.net/57025 b. Ability to dynamically display sound properties given the appropriate fields are entered (examples below)
9. Advanced user functionality a. Customizable user pages b. User ranking system i. Add points for entering products, manufacturers, etc. ii. Add points for filling out user profile iii. Content quality rating
10. Rate user content either +1 or -1 (like karma) c. User matching system that pairs people that listen to the same music and like the same products i. If 2 users have over 60% or a certain # of products that are the same, alert them ii. Flag on the back end to turn on/off iii. Geo-matching d. User product ownership database with display of ownership in a timeline format e. Ability to sort any data by user type or specific user(s)
11. Ability for users to select which list columns to display a. Give users the option to recalculate formulas based on displayed columns, or all columns
12. Email system a. Templates b. Filtering by type c. Ability to auto-create d. Checkbox for weekly/monthly newsletter e. Auto-created newsletter with embedded ads
13. Social media auto-posting a. Admins can set user type, data type, and/or specific users along with social media channels; i.e. user type Super User will auto-publish new posts via Twitter; user A’s posts will auto-publish on Facebook, Twitter, and Google+
14. Currency conversion by location a. Ability to show prices in local currency, even if shipping from an affiliate with another currency listed
15. Forum (ability to turn on/off)