67% wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages

Code Review | Bulk Edit Posts and Products in Spreadsheet

WordPress plugin Bulk Edit Posts and Products in Spreadsheet scored67%from 54 tests.

About plugin

  • Plugin page: wp-sheet-editor-b...
  • Plugin version: 2.25.7
  • PHP version: 7.4.16
  • WordPress compatibility: 3.0-6.4
  • WordPress version: 6.3.1
  • First release: Nov 30, 2016
  • Latest release: Nov 1, 2023
  • Number of updates: 180
  • Update frequency: every 14.0 days
  • Top authors: JoseVega (100%)

Code review

54 tests

User reviews

165 reviews

Install metrics

6,000+ active /192,017 total downloads

Benchmarks

Plugin footprint 64% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | It is important to correctly install your plugin, without throwing errors or notices
Installer ran successfully

Server metrics [RAM: ▲6.65MB] [CPU: ▲48.64ms] 50% from 4 tests

This is a short check of server-side resources used by Bulk Edit Posts and Products in Spreadsheet
It is recommended to improve the following
  • RAM: Try to keep total memory usage under 10MB (currently 10.20MB on /wp-admin/admin.php?page=freemius)
  • Extra RAM: The extra memory usage should kept under 5MB (currently 6.65MB on /wp-admin/admin.php?page=freemius)
PageMemory (MB)CPU Time (ms)
Home /9.88 ▲6.4282.77 ▲43.36
Dashboard /wp-admin10.03 ▲6.73107.26 ▲54.34
Posts /wp-admin/edit.php10.08 ▲6.72111.31 ▲65.25
Add New Post /wp-admin/post-new.php12.61 ▲6.72146.07 ▲34.61
Media Library /wp-admin/upload.php9.96 ▲6.7298.87 ▲62.23
Settings /wp-admin/admin.php?page=vg_sheet_editor10.0898.85
Sheet Editor /wp-admin/admin.php?page=vgse-bulk-edit-post9.7271.52
Freemius Debug [v.2.6.0] /wp-admin/admin.php?page=freemius10.2080.33

Server storage [IO: ▲17.10MB] [DB: ▲0.00MB] Passed 3 tests

How much does this plugin use your filesystem and database?
There were no storage issued detected upon installing this plugin
Filesystem: 362 new files
Database: no new tables, 15 new options
New WordPress options
vg_sheet_editor
fs_debug_mode
widget_theysaidso_widget
vgse_can_edit_cpt_free
vgse_columns_visibility_migrated
vgse_hide_whats_new_2.25.7
fs_active_plugins
vgse_columns_visibility
widget_recent-comments
theysaidso_admin_options
...

Browser metrics Passed 4 tests

Bulk Edit Posts and Products in Spreadsheet: an overview of browser usage
Normal browser usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,962 ▲20114.35 ▲0.001.69 ▼0.0328.74 ▼15.99
Dashboard /wp-admin2,353 ▲1765.63 ▲0.0296.13 ▲1.4282.79 ▲40.53
Posts /wp-admin/edit.php2,169 ▲661.98 ▼0.0336.31 ▼4.1735.49 ▼1.57
Add New Post /wp-admin/post-new.php1,580 ▲5421.82 ▼1.34780.45 ▲87.9160.88 ▲1.64
Media Library /wp-admin/upload.php1,454 ▲634.20 ▼0.0297.61 ▼2.5275.29 ▲31.66
Settings /wp-admin/admin.php?page=vg_sheet_editor2,1495.82171.5265.01
Sheet Editor /wp-admin/admin.php?page=vgse-bulk-edit-post280.420.074.33
Freemius Debug [v.2.6.0] /wp-admin/admin.php?page=freemius1,1151.8226.2230.15

Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 50% from 4 tests

🔸 Tests weight: 35 | It is important to correctly uninstall your plugin, without leaving any traces
These items require your attention
  • This plugin did not uninstall without warnings or errors
    • > Notice in wp-content/plugins/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/vendor/freemius/includes/class-freemius.php+8546
    Undefined property: stdClass::$plugins
  • Zombie WordPress options detected upon uninstall: 12 options
    • widget_recent-comments
    • fs_accounts
    • fs_debug_mode
    • fs_active_plugins
    • vg_sheet_editor
    • widget_theysaidso_widget
    • db_upgraded
    • theysaidso_admin_options
    • vgse_columns_visibility
    • widget_recent-posts
    • ...

Smoke tests 50% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | This is a shallow check for server-side errors
Even though no errors were found, this is by no means an exhaustive test

SRP 50% from 2 tests

🔹 Tests weight: 20 | The single-responsibility principle: PHP files have to remain inert when accessed directly, throwing no errors and performing no actions
Almost there! Just fix the following items
  • 3× GET requests to PHP files trigger server-side errors or Error 500 responses:
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_action() in wp-content/plugins/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/modules/wp-sheet-editor/inc/integrations/visual-composer.php:15
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_action() in wp-content/plugins/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/modules/wp-sheet-editor/inc/integrations/elementor.php:107
    • > PHP Fatal error
      Uncaught Error: Call to undefined function VGSE() in wp-content/plugins/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/modules/wp-sheet-editor/views/whats-new/2.6.0.php:3

User-side errors 0% from 1 test

🔹 Test weight: 20 | This is a shallow check for browser errors
These are user-side errors you should fix
    • > GET request to /wp-admin/admin.php?page=vgse-bulk-edit-post
    • > Network (severe)
    wp-admin/admin.php?page=vgse-bulk-edit-post - Failed to load resource: the server responded with a status of 403 (Forbidden)

Optimizations

Plugin configuration 90% from 29 tests

readme.txt Passed 16 tests

Don't ignore readme.txt as it is the file that instructs WordPress.org on how to present your plugin to the world
5 plugin tags: spreadsheet, woocommerce, easy digital downloads, bulk edit, events

wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/wp-sheet-editor.php 77% from 13 tests

Analyzing the main PHP file in "Bulk Edit Posts and Products in Spreadsheet" version 2.25.7
It is important to fix the following:
  • Main file name: It is recommended to name the main PHP file as the plugin slug ("wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages.php" instead of "wp-sheet-editor.php")
  • Text Domain: The text domain name must use dashes instead of underscores, and it must be lowercase
  • Requires at least: Required version must be the same as the one declared in readme.txt ("3.6" instead of "3.0")

Code Analysis 97% from 3 tests

File types Passed 1 test

🔸 Test weight: 35 | There should be no dangerous file extensions present in any WordPress plugin
Everything looks great! No dangerous files found in this plugin177,113 lines of code in 239 files:
LanguageFilesBlank linesComment linesLines of code
PO File2618,62927,36964,278
JavaScript1215,52818,55554,363
PHP17810,32018,80547,633
CSS179113397,678
SVG3002,674
Markdown12110429
JSON10042
XML13016

PHP code 50% from 2 tests

Analyzing logical lines of code, cyclomatic complexity, and other code metrics
Please fix the following
  • Please reduce cyclomatic complexity of classes to less than 1000 (currently 3,096)
Cyclomatic complexity
Average complexity per logical line of code0.61
Average class complexity74.84
▷ Minimum class complexity1.00
▷ Maximum class complexity3,096.00
Average method complexity4.57
▷ Minimum method complexity1.00
▷ Maximum method complexity94.00
Code structure
Namespaces0
Interfaces1
Traits0
Classes90
▷ Abstract classes33.33%
▷ Concrete classes8796.67%
▷ Final classes00.00%
Methods1,933
▷ Static methods24012.42%
▷ Public methods1,50377.75%
▷ Protected methods170.88%
▷ Private methods41321.37%
Functions130
▷ Named functions12696.92%
▷ Anonymous functions43.08%
Constants156
▷ Global constants10969.87%
▷ Class constants4730.13%
▷ Public constants47100.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

All PNG images should be compressed to minimize bandwidth usage for end users
9 PNG files occupy 0.09MB with 0.03MB in potential savings
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
modules/wp-sheet-editor/assets/vendor/images/chosen-sprite@2x.png0.72KB0.83KB0.00%
modules/wp-sheet-editor/assets/imgs/freemius-icon.png12.54KB6.09KB▼ 51.47%
modules/wp-sheet-editor/assets/vendor/images/input-unchecked.png0.15KB0.15KB0.00%
modules/wp-sheet-editor/assets/imgs/icon-20x20.png45.33KB0.51KB▼ 98.88%
modules/wp-sheet-editor/assets/vendor/images/input-checked.png0.31KB0.32KB0.00%