PHPackages mage/product-view - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. mage/product-view ActiveMagento2-module[Database & ORM](/categories/database) mage/product-view ================= Magento 2 module to Create Prodcut View Flat table 1.0.9(1y ago)49PHP Since Nov 28Pushed 1y ago1 watchersCompare [ Source](https://github.com/Genaker/mage-product-view-table)[ Packagist](https://packagist.org/packages/mage/product-view)[ RSS](/packages/mage-product-view/feed)WikiDiscussions main Synced 1mo ago READMEChangelog (7)Dependencies (2)Versions (9)Used By (0) Installation ============ [](#installation) ``` composer require mage/product-view ``` All the tables(ViewTable, MView, JSON) will be create on **setup:upgrade** You can also run it with the command **bin/magento pview:run**, which will populate the table with the data. ``` bin/magento pview:run ``` Command Output: [![image](https://private-user-images.githubusercontent.com/9213670/391270578-7743836f-dd98-4618-806f-223a766558dd.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzUxNzE3MDAsIm5iZiI6MTc3NTE3MTQwMCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MDU3OC03NzQzODM2Zi1kZDk4LTQ2MTgtODA2Zi0yMjNhNzY2NTU4ZGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDJUMjMxMDAwWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MmVkNzRmYzZhMTM3MGFiODE4NDliMWVhOTkwMTZmMjhiNWExMmFiZGNkYmIzYmE4ZDRkNjUyZTYzYzhhMTA2ZiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.8mCvTnVQsAvIO4VpSQGtx1NZPrMOHHU-zbB0hQWDcVI)](https://private-user-images.githubusercontent.com/9213670/391270578-7743836f-dd98-4618-806f-223a766558dd.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzUxNzE3MDAsIm5iZiI6MTc3NTE3MTQwMCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MDU3OC03NzQzODM2Zi1kZDk4LTQ2MTgtODA2Zi0yMjNhNzY2NTU4ZGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDJUMjMxMDAwWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MmVkNzRmYzZhMTM3MGFiODE4NDliMWVhOTkwMTZmMjhiNWExMmFiZGNkYmIzYmE4ZDRkNjUyZTYzYzhhMTA2ZiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.8mCvTnVQsAvIO4VpSQGtx1NZPrMOHHU-zbB0hQWDcVI) By running this code *populateProductJsonTableFromView($changeLog = false)* with the **true** parameter, you are generating data only for change log data Tables will be generated: - **catalog\_product\_view** : it is a view, not a table. Runs direct SQL to the core magento tables. Update mechanism **not** required however, has performace of the raw queries [![image](https://private-user-images.githubusercontent.com/9213670/391271184-31770dc4-3c81-4a3b-895f-205d62b2cf89.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzUxNzE3MDAsIm5iZiI6MTc3NTE3MTQwMCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MTE4NC0zMTc3MGRjNC0zYzgxLTRhM2ItODk1Zi0yMDVkNjJiMmNmODkucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDJUMjMxMDAwWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MjQzYTk3MWZmMjJmZTMzMTNhZmQ1ZmMyZjllNzNjYmQ1ZDJhNjNiM2FlNThhNzIwZGRkODA1OGY1ZDBjMmUyNCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.CwJgQCbN_ObOTXhufLZ-qhrMZXmQ_eft3Htz8BFgC7M)](https://private-user-images.githubusercontent.com/9213670/391271184-31770dc4-3c81-4a3b-895f-205d62b2cf89.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzUxNzE3MDAsIm5iZiI6MTc3NTE3MTQwMCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MTE4NC0zMTc3MGRjNC0zYzgxLTRhM2ItODk1Zi0yMDVkNjJiMmNmODkucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDJUMjMxMDAwWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9MjQzYTk3MWZmMjJmZTMzMTNhZmQ1ZmMyZjllNzNjYmQ1ZDJhNjNiM2FlNThhNzIwZGRkODA1OGY1ZDBjMmUyNCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.CwJgQCbN_ObOTXhufLZ-qhrMZXmQ_eft3Htz8BFgC7M)- **catalog\_product\_view\_MVIEW** : materialized view table from the view table. An update mechanism is required [![image](https://private-user-images.githubusercontent.com/9213670/391270772-e0218e36-0870-476b-be57-a32a5faf461b.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzUxNzE3MDAsIm5iZiI6MTc3NTE3MTQwMCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MDc3Mi1lMDIxOGUzNi0wODcwLTQ3NmItYmU1Ny1hMzJhNWZhZjQ2MWIucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDJUMjMxMDAwWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NmEzMzA3ZjkyZTllZDZkYmEyOTI2YmUzNWU5ODc1OTRmNTdkODQ4NWVjN2Y1NjJiMmY2ODNhZDU3Njc3M2ZhYiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.-IXLEHhbDSYUWq1F8-hxGWgkw6DFquiKOkGu9v7xNTY)](https://private-user-images.githubusercontent.com/9213670/391270772-e0218e36-0870-476b-be57-a32a5faf461b.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzUxNzE3MDAsIm5iZiI6MTc3NTE3MTQwMCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MDc3Mi1lMDIxOGUzNi0wODcwLTQ3NmItYmU1Ny1hMzJhNWZhZjQ2MWIucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDJUMjMxMDAwWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NmEzMzA3ZjkyZTllZDZkYmEyOTI2YmUzNWU5ODc1OTRmNTdkODQ4NWVjN2Y1NjJiMmY2ODNhZDU3Njc3M2ZhYiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.-IXLEHhbDSYUWq1F8-hxGWgkw6DFquiKOkGu9v7xNTY)- **product\_json** : table with the denormilised json attribute data in the *data* field. An update mechanism is also required [![image](https://private-user-images.githubusercontent.com/9213670/391271298-b751ebad-7022-456c-a095-5b0969385cda.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzUxNzE3MDAsIm5iZiI6MTc3NTE3MTQwMCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MTI5OC1iNzUxZWJhZC03MDIyLTQ1NmMtYTA5NS01YjA5NjkzODVjZGEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDJUMjMxMDAwWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NzMzZmQyNTVlMmQ2OGYyZTc2NjFkMGExMWE2OTk1OTg1OGI3ZTM0ZWY1ZmMwOTBkYzUxMjllOTVlNDJhODU2MCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.CW1y2UwDoqRHIjMvuH1A3yYpFZ_MMssFC2vp7yI2Ack)](https://private-user-images.githubusercontent.com/9213670/391271298-b751ebad-7022-456c-a095-5b0969385cda.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NzUxNzE3MDAsIm5iZiI6MTc3NTE3MTQwMCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MTI5OC1iNzUxZWJhZC03MDIyLTQ1NmMtYTA5NS01YjA5NjkzODVjZGEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDQwMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA0MDJUMjMxMDAwWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NzMzZmQyNTVlMmQ2OGYyZTc2NjFkMGExMWE2OTk1OTg1OGI3ZTM0ZWY1ZmMwOTBkYzUxMjllOTVlNDJhODU2MCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.CW1y2UwDoqRHIjMvuH1A3yYpFZ_MMssFC2vp7yI2Ack) ### Health Score 27 — LowBetter than 49% of packages Maintenance39 Infrequent updates — may be unmaintained Popularity9 Limited adoption so far Community9 Small or concentrated contributor base Maturity44 Maturing project, gaining track record Bus Factor1 Top contributor holds 72.7% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~4 days Total 7 Last Release 514d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/2614da2cb514a3749cd296d237c9ca3430f4dafa09b4e49e338a6b1794a5acf4?d=identicon)[genaker](/maintainers/genaker) --- Top Contributors [![wseng](https://avatars.githubusercontent.com/u/6572161?v=4)](https://github.com/wseng "wseng (8 commits)")[![Genaker](https://avatars.githubusercontent.com/u/9213670?v=4)](https://github.com/Genaker "Genaker (3 commits)") ### Embed Badge ![Health badge](/badges/mage-product-view/health.svg) ``` [![Health](https://phpackages.com/badges/mage-product-view/health.svg)](https://phpackages.com/packages/mage-product-view) ``` ### Alternatives [doctrine/orm Object-Relational-Mapper for PHP 10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter a PHP SQL highlighting library 3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database The Illuminate Database package. 2.8k52.4M9.4k](/packages/illuminate-database)[ramsey/uuid-doctrine Use ramsey/uuid as a Doctrine field type. 90440.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel Reliese Components for Laravel Framework code generation. 1.7k3.4M16](/packages/reliese-laravel)[wildside/userstamps Laravel Userstamps provides an Eloquent trait which automatically maintains `created\_by` and `updated\_by` columns on your model, populated by the currently authenticated user in your application. 7511.7M13](/packages/wildside-userstamps) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)