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 1w 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.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODQ5ODE2MTgsIm5iZiI6MTc4NDk4MTMxOCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MDU3OC03NzQzODM2Zi1kZDk4LTQ2MTgtODA2Zi0yMjNhNzY2NTU4ZGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDcyNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA3MjVUMTIwODM4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NDVjNzRmMTljZjRhMGJjMWMyMWUyZmY3NzRkM2QyZDRmOGE3NWU1MmY2OGY1NTgyNWE1OTUzYWZhNmI2NGJiZCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.QMhgihgFJ9LisVR5FTD9MLbGEnXEkXZiaH4Uftt53po)](https://private-user-images.githubusercontent.com/9213670/391270578-7743836f-dd98-4618-806f-223a766558dd.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODQ5ODE2MTgsIm5iZiI6MTc4NDk4MTMxOCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MDU3OC03NzQzODM2Zi1kZDk4LTQ2MTgtODA2Zi0yMjNhNzY2NTU4ZGQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDcyNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA3MjVUMTIwODM4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NDVjNzRmMTljZjRhMGJjMWMyMWUyZmY3NzRkM2QyZDRmOGE3NWU1MmY2OGY1NTgyNWE1OTUzYWZhNmI2NGJiZCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.QMhgihgFJ9LisVR5FTD9MLbGEnXEkXZiaH4Uftt53po) 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.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODQ5ODE2MTgsIm5iZiI6MTc4NDk4MTMxOCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MTE4NC0zMTc3MGRjNC0zYzgxLTRhM2ItODk1Zi0yMDVkNjJiMmNmODkucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDcyNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA3MjVUMTIwODM4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ZjJiZTllNzRkN2Q0MTdkY2VlYjg4OThhNzQ5MTkwMzgzZjA5YjNjMDBmMGVmZDBlYjUyMWQyZWQwMTUyMGZkOCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.2U_SuLAxYdLZ9oBKp6id1kiszAi0i7mBNvvFIWi36TU)](https://private-user-images.githubusercontent.com/9213670/391271184-31770dc4-3c81-4a3b-895f-205d62b2cf89.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODQ5ODE2MTgsIm5iZiI6MTc4NDk4MTMxOCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MTE4NC0zMTc3MGRjNC0zYzgxLTRhM2ItODk1Zi0yMDVkNjJiMmNmODkucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDcyNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA3MjVUMTIwODM4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ZjJiZTllNzRkN2Q0MTdkY2VlYjg4OThhNzQ5MTkwMzgzZjA5YjNjMDBmMGVmZDBlYjUyMWQyZWQwMTUyMGZkOCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.2U_SuLAxYdLZ9oBKp6id1kiszAi0i7mBNvvFIWi36TU)- **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.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODQ5ODE2MTgsIm5iZiI6MTc4NDk4MTMxOCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MDc3Mi1lMDIxOGUzNi0wODcwLTQ3NmItYmU1Ny1hMzJhNWZhZjQ2MWIucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDcyNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA3MjVUMTIwODM4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NmY3MTkxMzk4NTVkZDM3OTE4OWMwODI2MGI0YmVmNDExM2Y3ZWYwM2RhY2I4ZGMzYmRkYzg3NDM5NGQ3ODlhNCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.fahv7PpOM2wf35TqfrFx5hMZv7br6vxvsc2DTVrKuiA)](https://private-user-images.githubusercontent.com/9213670/391270772-e0218e36-0870-476b-be57-a32a5faf461b.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODQ5ODE2MTgsIm5iZiI6MTc4NDk4MTMxOCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MDc3Mi1lMDIxOGUzNi0wODcwLTQ3NmItYmU1Ny1hMzJhNWZhZjQ2MWIucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDcyNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA3MjVUMTIwODM4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NmY3MTkxMzk4NTVkZDM3OTE4OWMwODI2MGI0YmVmNDExM2Y3ZWYwM2RhY2I4ZGMzYmRkYzg3NDM5NGQ3ODlhNCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.fahv7PpOM2wf35TqfrFx5hMZv7br6vxvsc2DTVrKuiA)- **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.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODQ5ODE2MTgsIm5iZiI6MTc4NDk4MTMxOCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MTI5OC1iNzUxZWJhZC03MDIyLTQ1NmMtYTA5NS01YjA5NjkzODVjZGEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDcyNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA3MjVUMTIwODM4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ZjRmYmViNjcxYzZhNWI5M2UyNzE0NTE3MWMxYWU1ZmQ4MDVjZTRhYTM5MjU2N2EyZTA4MTNmOWQyMDQ4MDRmYyZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.nLoI-IJZZuBqUG1it-7FhymeWToX0e6mIdxKePE7zcw)](https://private-user-images.githubusercontent.com/9213670/391271298-b751ebad-7022-456c-a095-5b0969385cda.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3ODQ5ODE2MTgsIm5iZiI6MTc4NDk4MTMxOCwicGF0aCI6Ii85MjEzNjcwLzM5MTI3MTI5OC1iNzUxZWJhZC03MDIyLTQ1NmMtYTA5NS01YjA5NjkzODVjZGEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDcyNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjA3MjVUMTIwODM4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9ZjRmYmViNjcxYzZhNWI5M2UyNzE0NTE3MWMxYWU1ZmQ4MDVjZTRhYTM5MjU2N2EyZTA4MTNmOWQyMDQ4MDRmYyZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmcmVzcG9uc2UtY29udGVudC10eXBlPWltYWdlJTJGcG5nIn0.nLoI-IJZZuBqUG1it-7FhymeWToX0e6mIdxKePE7zcw) ### Health Score 26 — LowBetter than 40% of packages Maintenance35 Infrequent updates — may be unmaintained Popularity9 Limited adoption so far Community9 Small or concentrated contributor base Maturity45 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 606d ago ### Community Maintainers ![](https://avatars.githubusercontent.com/u/9213670?v=4)[Yegor Shytikov](/maintainers/genaker)[@Genaker](https://github.com/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 [jdorn/sql-formatter a PHP SQL highlighting library 3.8k117.8M121](/packages/jdorn-sql-formatter)[backup-manager/backup-manager A framework agnostic database backup manager with user-definable procedures and support for S3, Dropbox, FTP, SFTP, and more with drivers for popular frameworks. 1.7k1.6M11](/packages/backup-manager-backup-manager)[propel/propel1 Propel is an open-source Object-Relational Mapping (ORM) for PHP5. 8351.6M88](/packages/propel-propel1)[insolita/yii2-migration-generator Set of gii tools for generating files for migration by schema of table , phpdoc or table data 108508.0k5](/packages/insolita-yii2-migration-generator)[xpdo/xpdo A PDO-based Object/Relational Bridge Library 7088.4k4](/packages/xpdo-xpdo)[voku/session2db A PHP library acting as a wrapper for PHP's default session handling functions which stores data in a MySQL database, providing both better performance and better security and protection against session fixation and session hijacking. 2920.0k](/packages/voku-session2db) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)