83% sheets-to-wp-table-live-sync

Code Review | Sheets To WP Table Live Sync

WordPress plugin Sheets To WP Table Live Sync scored83%from 54 tests.

About plugin

  • Plugin page: sheets-to-wp-tabl...
  • Plugin version: 3.3.0
  • PHP compatiblity: 5.4+
  • PHP version: 7.4.16
  • WordPress compatibility: 5.0-6.4
  • WordPress version: 6.3.1
  • First release: May 4, 2021
  • Latest release: Nov 28, 2023
  • Number of updates: 101
  • Update frequency: every 9.3 days
  • Top authors: azizultex (62.38%)devdrarif (29.7%)wppool (8.91%)mahfuz01 (1.98%)

Code review

54 tests

User reviews

19 reviews

Install metrics

2,000+ active /44,173 total downloads

Benchmarks

Plugin footprint 82% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Checking the installer triggered no errors
This plugin's installer ran successfully

Server metrics [RAM: ▲1.20MB] [CPU: ▲3.30ms] Passed 4 tests

A check of server-side resources used by Sheets To WP Table Live Sync
Normal server usage
PageMemory (MB)CPU Time (ms)
Home /4.66 ▲1.1942.49 ▼0.45
Dashboard /wp-admin4.51 ▲1.1656.09 ▼5.31
Posts /wp-admin/edit.php4.62 ▲1.2562.98 ▲13.08
Add New Post /wp-admin/post-new.php7.13 ▲1.24109.27 ▲5.86
Media Library /wp-admin/upload.php4.44 ▲1.2145.62 ▲13.61

Server storage [IO: ▲25.05MB] [DB: ▲0.00MB] 67% from 3 tests

Filesystem and database footprint
It is recommended to fix the following issues
  • Filesystem usage must be lower than 25MB (currently using 25.05MB)
Filesystem: 310 new files
Database: 2 new tables, 18 new options
New tables
wp_gswpts_tabs
wp_gswpts_tables
New WordPress options
deafaultAffiliateInterval
gswptsAffiliateNotice
deafaultNoticeInterval
can_compress_scripts
deafaultUpgradeInterval
link_support_mode
widget_theysaidso_widget
img_link_pro_support_has_run
widget_recent-comments
widget_recent-posts
...

Browser metrics Passed 4 tests

This is an overview of browser requirements for Sheets To WP Table Live Sync
Minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /3,112 ▲32514.31 ▼0.041.73 ▼0.0927.32 ▼18.53
Dashboard /wp-admin2,480 ▲3035.56 ▼0.0895.99 ▼0.8780.17 ▲33.29
Posts /wp-admin/edit.php2,399 ▲3022.13 ▲0.1238.74 ▲3.4436.81 ▲4.24
Add New Post /wp-admin/post-new.php6,668 ▲5,13428.55 ▲3.29825.25 ▲214.9679.24 ▲12.43
Media Library /wp-admin/upload.php1,689 ▲2894.12 ▼0.08101.65 ▲4.8881.23 ▲41.38
Settings /wp-admin/admin.php?page=gswpts-dashboard#/settings1,2367.73423.1475.21
Dashboard /wp-admin/admin.php?page=gswpts-dashboard#/1,1807.33340.3646.61
Get Started /wp-admin/admin.php?page=gswpts-dashboard#/doc1,4227.29350.6855.76
Manage Tab /wp-admin/admin.php?page=gswpts-dashboard#/tabs1,2117.51322.1850.38
Recommended Plugins /wp-admin/admin.php?page=gswpts-dashboard#/recommendation1,1707.26359.3743.18

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

🔸 Tests weight: 35 | Checking the uninstaller removed all traces of the plugin
You still need to fix the following
  • This plugin did not uninstall successfully, leaving 12 options in the database
    • widget_recent-comments
    • link_support_code_has_run
    • link_support_mode
    • widget_theysaidso_widget
    • widget_recent-posts
    • gswptsManageTabs
    • img_link_pro_support_has_run
    • deafaultUpgradeInterval
    • theysaidso_admin_options
    • can_compress_scripts
    • ...

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | This is a shallow check for server-side errors
Even though everything seems fine, this is not an exhaustive test

SRP 50% from 2 tests

🔹 Tests weight: 20 | SRP (Single-Responsibility Principle) - PHP files must act as libraries and never output text or perform any action when accessed directly in a browser
Almost there! Just fix the following items
  • 1× GET requests to PHP files have triggered server-side errors or warnings:
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_url() in wp-content/plugins/sheets-to-wp-table-live-sync/app/templates/documentation_page.php:23

User-side errors Passed 1 test

🔹 Test weight: 20 | This is just a short smoke test looking for browser issues
Everything seems fine on the user side

Optimizations

Plugin configuration 90% from 29 tests

readme.txt 94% from 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
These attributes need your attention: You can look at the official readme.txt

sheets-to-wp-table-live-sync/sheets-to-wp-table-live-sync.php 85% from 13 tests

The primary PHP file in "Sheets To WP Table Live Sync" version 3.3.0 is used by WordPress to initiate all plugin functionality
You should first fix the following items:
  • Description: If Twitter did it, so should we! Keep the description under 140 characters (currently 195 characters long)
  • Text Domain: The text domain is optional since WordPress version 4.6; if you do specify it, it must be the same as the plugin slug

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | An overview of files in this plugin; executable files are not allowed
Everything looks great! No dangerous files found in this plugin115,246 lines of code in 217 files:
LanguageFilesBlank linesComment linesLines of code
JavaScript2112,90325,61276,045
Sass321,7445910,389
CSS1780580610,103
PHP541,8733,3498,610
TypeScript36489784,894
SVG505133,901
PO File1372400960
Markdown1650179
JSON30076
XML1163864
JSX13025

PHP code Passed 2 tests

This is a short overview of cyclomatic complexity and code structure for this plugin
No complexity issues detected
Cyclomatic complexity
Average complexity per logical line of code0.45
Average class complexity28.19
▷ Minimum class complexity1.00
▷ Maximum class complexity119.00
Average method complexity3.43
▷ Minimum method complexity1.00
▷ Maximum method complexity71.00
Code structure
Namespaces7
Interfaces0
Traits0
Classes32
▷ Abstract classes00.00%
▷ Concrete classes32100.00%
▷ Final classes00.00%
Methods359
▷ Static methods328.91%
▷ Public methods28479.11%
▷ Protected methods133.62%
▷ Private methods6217.27%
Functions9
▷ Named functions333.33%
▷ Anonymous functions666.67%
Constants6
▷ Global constants583.33%
▷ Class constants116.67%
▷ Public constants1100.00%

Plugin size 50% from 2 tests

Image compression 50% from 2 tests

Using a strong compression for your PNG files is a great way to speed-up your plugin
42 PNG files occupy 5.60MB with 2.49MB in potential savings
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
lib/wppool/halloween.png309.68KB124.62KB▼ 59.76%
.wordpress-org/screenshot-2.png348.71KB161.44KB▼ 53.70%
react/build/images/theme-three-dark-table.5eed58c6.png10.19KB4.89KB▼ 52.03%
assets/public/common/datatables/tables/images/sort_asc_disabled.png0.14KB0.25KB0.00%
.wordpress-org/screenshot-4.png349.19KB152.06KB▼ 56.45%