77% content-excel-importer

Code Review | Import Post, Pages, Products Content in WordPress & WooCommerce with Excel

WordPress plugin Import Post, Pages, Products Content in WordPress & WooCommerce with Excel scored77%from 54 tests.

About plugin

  • Plugin page: content-excel-imp...
  • Plugin version: 3.9
  • PHP compatiblity: 5.2.4+
  • PHP version: 7.4.16
  • WordPress compatibility: 2.2-6.2
  • WordPress version: 6.3.1
  • First release: Jun 5, 2018
  • Latest release: Jul 13, 2023
  • Number of updates: 42
  • Update frequency: every 44.4 days
  • Top authors: taz_bambu (100%)

Code review

54 tests

User reviews

2 reviews

Install metrics

1,000+ active /32,791 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | The install procedure must perform silently
The plugin installed successfully, without throwing any errors or notices

Server metrics [RAM: ▲0.42MB] [CPU: ▲0.01ms] Passed 4 tests

Analyzing server-side resources used by Import Post, Pages, Products Content in WordPress & WooCommerce with Excel
No issues were detected with server-side resource usage
PageMemory (MB)CPU Time (ms)
Home /3.90 ▲0.4348.40 ▲9.25
Dashboard /wp-admin3.76 ▲0.4656.08 ▲0.80
Posts /wp-admin/edit.php3.81 ▲0.4551.16 ▼0.47
Add New Post /wp-admin/post-new.php6.30 ▲0.4193.20 ▼5.28
Media Library /wp-admin/upload.php3.62 ▲0.3941.41 ▲4.99

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

Filesystem and database footprint
No storage issues were detected
Filesystem: 393 new files
Database: no new tables, 6 new options
New WordPress options
theysaidso_admin_options
widget_recent-comments
db_upgraded
widget_recent-posts
can_compress_scripts
widget_theysaidso_widget

Browser metrics Passed 4 tests

An overview of browser requirements for Import Post, Pages, Products Content in WordPress & WooCommerce with Excel
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,841 ▲8014.39 ▼0.242.40 ▲0.1446.92 ▼1.22
Dashboard /wp-admin2,222 ▲425.83 ▲0.1784.16 ▼14.1437.03 ▼6.33
Posts /wp-admin/edit.php2,132 ▲322.23 ▲0.2639.16 ▲0.5732.37 ▼5.82
Add New Post /wp-admin/post-new.php1,551 ▲2523.18 ▲0.21648.43 ▼38.0536.92 ▼23.38
Media Library /wp-admin/upload.php1,430 ▲304.33 ▲0.1497.44 ▼17.9942.29 ▼4.67

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

🔸 Tests weight: 35 | Verifying that this plugin uninstalls completely without leaving any traces
The following items require your attention
  • This plugin did not uninstall successfully, leaving 6 options in the database
    • db_upgraded
    • widget_recent-comments
    • can_compress_scripts
    • widget_recent-posts
    • theysaidso_admin_options
    • widget_theysaidso_widget

Smoke tests 50% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | Just a short smoke test targeting errors on the server (in the Apache logs)
Even though everything seems fine, this is not an exhaustive test

SRP 0% from 2 tests

🔹 Tests weight: 20 | It is important to ensure that your PHP files perform no action when accessed directly, respecting the single-responsibility principle
Please fix the following items
  • 5× PHP files perform the task of outputting text when accessed with GET requests:
    • > /wp-content/plugins/content-excel-importer/Classes/markbaker/matrix/examples/test.php
    • > /wp-content/plugins/content-excel-importer/Classes/markbaker/complex/examples/testFunctions.php
    • > /wp-content/plugins/content-excel-importer/Classes/markbaker/complex/examples/testOperations.php
    • > /wp-content/plugins/content-excel-importer/Classes/markbaker/matrix/buildPhar.php
    • > /wp-content/plugins/content-excel-importer/Classes/markbaker/complex/examples/complexTest.php
  • 98× PHP files trigger server-side errors or warnings when accessed directly (only 10 are shown):
    • > PHP Fatal error
      Uncaught Error: Call to undefined function plugin_dir_path() in wp-content/plugins/content-excel-importer/content-excel-importer_content.php:3
    • > PHP Fatal error
      Uncaught Error: Class 'PhpOffice\\PhpSpreadsheet\\Style\\Supervisor' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/Font.php:7
    • > PHP Fatal error
      Uncaught Error: Class 'PhpOffice\\PhpSpreadsheet\\Writer\\BaseWriter' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls.php:28
    • > PHP Fatal error
      Uncaught Error: Class 'PhpOffice\\PhpSpreadsheet\\Worksheet\\CellIterator' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/RowCellIterator.php:8
    • > PHP Fatal error
      Uncaught Error: Interface 'PhpOffice\\PhpSpreadsheet\\IComparable' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Drawing/Shadow.php:8
    • > PHP Fatal error
      Uncaught Error: Interface 'PhpOffice\\PhpSpreadsheet\\IComparable' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Comment.php:7
    • > PHP Fatal error
      Uncaught Error: Class 'PhpOffice\\PhpSpreadsheet\\Reader\\BaseReader' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Gnumeric.php:23
    • > PHP Fatal error
      Uncaught Error: Interface 'PhpOffice\\PhpSpreadsheet\\Reader\\IReader' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/BaseReader.php:8
    • > PHP Fatal error
      Uncaught Error: Class 'PhpOffice\\PhpSpreadsheet\\Reader\\Xlsx\\BaseParserClass' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Xlsx/SheetViewOptions.php:7
    • > PHP Fatal error
      Uncaught Error: Class 'PhpOffice\\PhpSpreadsheet\\Exception' not found in wp-content/plugins/content-excel-importer/Classes/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Exception.php:7

User-side errors Passed 1 test

🔹 Test weight: 20 | This is a shallow check for browser errors
Everything seems fine, but this is not an exhaustive test

Optimizations

Plugin configuration 93% from 29 tests

readme.txt Passed 16 tests

You should put a lot of thought into formatting readme.txt as it is used by WordPress.org to prepare the public listing of your plugin
6 plugin tags: excel, migrate, bulk import, importer, excel import...

content-excel-importer/content-excel-importer.php 85% from 13 tests

This is the main PHP file of "Import Post, Pages, Products Content in WordPress & WooCommerce with Excel" version 3.9, providing information about the plugin in the header fields and serving as the principal entry point to the plugin's functions
The following require your attention:
  • Requires at least: Required version does not match the one declared in readme.txt ("3.0.1" instead of "2.2")
  • Plugin Name: A shorter plugin name is better (currently 74 characters long instead of max. 70)

Code Analysis 95% from 3 tests

File types Passed 1 test

🔸 Test weight: 35 | This is an overview of programming languages used in this plugin; dangerous file extensions are not allowed
Success! There were no dangerous files found in this plugin63,209 lines of code in 337 files:
LanguageFilesBlank linesComment linesLines of code
PHP31513,19131,45660,012
Markdown942302,002
JSON600684
CSS1353197
JavaScript1607185
YAML314182
Bourne Again Shell16324
XML10023

PHP code 0% from 2 tests

Analyzing cyclomatic complexity and code structure
Please fix the following
  • Class cyclomatic complexity should be reduced to less than 1000 (currently 1,011)
  • Cyclomatic complexity of methods has to be reduced to less than 100 (currently 387)
Cyclomatic complexity
Average complexity per logical line of code0.38
Average class complexity42.67
▷ Minimum class complexity1.00
▷ Maximum class complexity1,011.00
Average method complexity4.40
▷ Minimum method complexity1.00
▷ Maximum method complexity387.00
Code structure
Namespaces45
Interfaces10
Traits0
Classes232
▷ Abstract classes166.90%
▷ Concrete classes21693.10%
▷ Final classes00.00%
Methods2,997
▷ Static methods69023.02%
▷ Public methods2,30476.88%
▷ Protected methods852.84%
▷ Private methods60820.29%
Functions86
▷ Named functions7283.72%
▷ Anonymous functions1416.28%
Constants779
▷ Global constants20.26%
▷ Class constants77799.74%
▷ Public constants777100.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

It is recommended to compress PNG files in your plugin to minimize bandwidth usage
4 PNG files occupy 0.18MB with 0.09MB in potential savings
Potential savings
Compression of 4 random PNG files using pngquant
FileSize - originalSize - compressedSavings
images/default.png14.13KB5.96KB▼ 57.80%
images/extendwp.png5.75KB3.37KB▼ 41.46%
images/content-excel-importer-horizontal.png76.84KB34.30KB▼ 55.36%
images/content-excel-importer-pro.png86.39KB38.01KB▼ 56.01%