ETechFlow Advanced Product Reviews for Magento 2

Rich, conversion-focused product reviews for Magento 2 (Open Source and Adobe
Commerce / Cloud). Replaces the bare core review experience with photos & video,
pros/cons, verified-buyer badges, helpful voting, review summaries, admin
replies, customer Q&A, post-purchase reminders with auto-generated coupons,
AI auto-translation, an analytics dashboard, and a full headless (GraphQL +
REST) layer with a Hyvä theme integration.

• Vendor / module: ETechFlow_AdvancedProductReviews
• Compatibility: Magento 2.4.4 – 2.4.8, PHP 8.1 – 8.4, CE / EE / Cloud
• Themes: Luma, Hyvä (via the companion ETechFlow_AdvancedProductReviewsHyva module), and headless storefronts (PWA Studio / custom)

Features

Storefront reviews

• Photos & video on reviews (real MIME sniffing, not just extension checks, to block spoofed uploads)
• Pros / cons lists and a "would recommend" flag
• Verified Buyer badge (detected from the customer's order history)
• "Was this helpful?" voting with duplicate-vote protection (per customer, and per guest via a privacy-preserving hash)
• Summary bar: average rating, star distribution, recommend %, verified count
• Filtering & sorting: by rating, verified-only, with-media; newest / oldest / most-helpful / highest / lowest
• Comments on reviews, including store (admin) replies
• AI auto-translation of reviews into the storefront language, powered by the Claude API, cached per language so each review is translated once

Customer Q&A

• Customers ask questions on a product; staff or other customers answer
• Moderation workflow (pending / approved / rejected), admin answers flagged as official

Post-purchase review reminders

• Schedules a reminder email a configurable number of days after an order completes
• Optional auto-generated coupon as a thank-you incentive (uses Magento SalesRule coupon generation)
• Skips customers who have already reviewed; idempotent per order; cron-driven

Admin

• Configuration under Stores ▸ Configuration ▸ ETechFlow ▸ Advanced Product Reviews
• Grids for Comments, Questions, and Reminders with mass actions
• Analytics dashboard (Reports ▸ Reviews Analytics): KPIs, rating distribution, 12-month trend, top products — dependency-free inline charts

Headless (Phase 7)

• GraphQL API for summary, review list, Q&A, and mutations (vote / comment / ask / translate)
• REST API for review summary and review-extra data
• Hyvä companion module renders the whole UI from the GraphQL API (Tailwind + Alpine)

Installation

Composer (recommended)

composer require etechflow/module-advanced-product-reviews
bin/magento module:enable ETechFlow_AdvancedProductReviews
bin/magento setup:upgrade
bin/magento setup:di:compile        # production mode only
bin/magento cache:flush

Manual

Copy the module to app/code/ETechFlow/AdvancedProductReviews, then run the same
module:enable / setup:upgrade / cache:flush commands.

Hyvä stores should also install the companion module
etechflow/module-advanced-product-reviews-hyva (see its own README).

Configuration

Stores ▸ Configuration ▸ ETechFlow ▸ Advanced Product Reviews

Translation and Reminders ship OFF by default. Enable them and supply the
Claude API key / coupon rule when you're ready. The Claude key is stored with
Magento's encrypted-config field and is never committed to source.

Headless API

GraphQL

All types are namespaced with etf / Etf so they never collide with core.

Queries: etfReviewSummary, etfProductReviews (paged + filter + sort),
etfProductQuestions, and etf_review_summary added onto ProductInterface
(so a products query can pull the summary inline).

Mutations: etfVoteReviewHelpful, etfPostReviewComment,
etfAskProductQuestion, etfTranslateReview.

{
  etfReviewSummary(sku: "24-MB01") {
    review_count
    average_rating
    rating_distribution { rating count percent }
  }
  etfProductReviews(sku: "24-MB01", pageSize: 5, sort: HELPFUL,
                    filter: { verified_only: true }) {
    total_count
    items { review_id title rating nickname pros cons helpful_count
            media { media_type url } comments { author_name comment } }
  }
}

REST

curl https://store.example.com/rest/V1/etechflow-reviews/summary/sku/24-MB01

Data model

Eight tables, all etechflow_*, foreign-keyed to core review with
ON DELETE CASCADE (child rows clean up when a review is deleted):
review_extra, review_media, review_vote, review_comment,
review_translation, qa_question, qa_answer, review_reminder.

product_id columns are indexed, not hard-FK'd, so the module stays
compatible with Adobe Commerce Content Staging (which swaps the catalog
primary key to row_id).

Cron

Quality

• Coding standard: Magento2 (PHP_CodeSniffer) — 0 errors
• PHP 8.1–8.4, declare(strict_types=1) throughout, constructor property promotion
• Service contracts (Api/) for repository + summary management; GraphQL and REST share the same service layer

Licensing & Activation

This module is commercially licensed. On a production host it stays inactive
until a valid license key is present — every storefront, headless
(GraphQL/REST), and admin surface is gated, so there is no ungated bypass.

• Activate: Stores ▸ Configuration ▸ eTechFlow ▸ Advanced Product Reviews ▸
  License → paste your key. Or open any admin grid (Comments / Q&A /
  Reminders / Analytics) to reach the in-admin gate page, choose a plan and
  pay by card (Stripe) — your subscription key is issued by the eTechFlow portal
  and saved automatically.
• Key types: a per-module HMAC key, the shared eTechFlow bundle key (one
  key activates every eTechFlow module on the host), or an SP-XXXX
  subscription key validated against the licensing portal (with domain + server-IP
  checks and soft expiry).
• Dev/staging is free: localhost, *.test, *.local, staging./dev.
  hosts, *.magento.cloud, ngrok tunnels, etc. bypass licensing automatically.
  You can also set Production Environment = No to bypass on any host.
• HMAC and bundle keys validate offline (no phone-home); only SP-XXXX keys
  contact the portal, and results are cached.

Uninstall

bin/magento module:disable ETechFlow_AdvancedProductReviews
# optional data removal:
bin/magento setup:upgrade

Drop the etechflow_* tables manually if you want to remove stored data.

License

OSL-3.0 / AFL-3.0. See LICENSE.txt.

Author

ETechFlow — [email protected]