Report - Enterprise Shipping for Pitney Bowes 3.0.23

Does "Enterprise Shipping for Pitney Bowes" work with WordPress 5.9.3 and PHP 7.4.8? A smoke test was performed on 2022-05-20 14:58:10 UTC.

Summary

Errors

1	Database errors
	No JavaScript exceptions
	All test pages loaded successfully
	No resource errors

Performance

Memory usage: 7.66 KiB
The average PHP memory usage increased by this amount after activating by the plugin.

Page speed impact: insignificant.
The plugin didn't make the site noticeably slower.

Environment

WordPress version	5.9.3
PHP version	7.4.8
MySQL version	8.0.21
PHP memory limit	256M

Plugin Info

Last updated	2024-04-21T15:58:00+00:00
Active installs	<10
WordPress.org page	https://wordpress.org/plugins/pb-shipping/
Badges	Get badge code

Pages 3

Screenshots are not available. Old screenshots of less popular plugins are eventually deleted to save disk space.

Plugins ‹ Test site — WordPress

URL	/wp-admin/plugins.php?plugin_status=all&paged=1&s
Requested URL	/wp-admin/plugins.php?action=activate&plugin=pb-shipping%2Fpb_functions.php&plugin_status=all&paged=1&s&_wpnonce=e6e63b3c6d
Aspect	after-activation
HTTP status	200
Load time	0.313 s
Memory usage	3.51 MiB
JS errors	None
Resource errors	None

Settings → PB Ship Admin

URL	/wp-admin/options-general.php?page=pb-admin
Aspect	menu-item
HTTP status	200
Load time	0.209 s
Memory usage	3.24 MiB
JS errors	None
Resource errors	None

Test site – Just another WordPress site

URL	/
Aspect	front-page
HTTP status	200
Load time	0.344 s
Memory usage	3.36 MiB
JS errors	None
Resource errors	None

Benchmark

URL	Load time			Memory usage
URL	Inactive	Active	Change	Inactive	Active	Change
/wp-admin/index.php	0.342 s	0.250 s	-0.092 s	3.37 MiB	3.38 MiB	+ 10.83 KiB
/wp-admin/edit.php	0.181 s	0.195 s	+0.014 s	3.4 MiB	3.41 MiB	+ 10.12 KiB
/wp-admin/post-new.php	0.887 s	0.994 s	+0.107 s	5.68 MiB	5.7 MiB	+ 15.19 KiB
/wp-admin/upload.php	0.379 s	0.304 s	-0.075 s	3.25 MiB	3.27 MiB	+ 17.7 KiB
/wp-admin/options-writing.php	0.246 s	0.142 s	-0.104 s	3.24 MiB	3.24 MiB	+ 1.55 KiB
/wp-admin/media-new.php	0.273 s	0.199 s	-0.074 s	3.23 MiB	3.24 MiB	+ 17.87 KiB
/wp-admin/edit-tags.php?taxonomy=category	0.200 s	0.192 s	-0.008 s	3.27 MiB	3.28 MiB	+ 10.77 KiB
/wp-admin/post-new.php?post_type=page	0.666 s	0.657 s	-0.009 s	5.68 MiB	5.69 MiB	+ 10.77 KiB
/wp-admin/options-discussion.php	0.235 s	0.350 s	+0.115 s	3.22 MiB	3.24 MiB	+ 18.18 KiB
/wp-admin/edit-comments.php	0.213 s	0.228 s	+0.015 s	3.27 MiB	3.28 MiB	+ 9.68 KiB
/	0.320 s	0.221 s	-0.099 s	3.4 MiB	3.36 MiB	- 38.39 KiB
Average	0.358 s	0.339 s	-0.019 s	3.73 MiB	3.73 MiB	+ 7.66 KiB

Code Statistics

Note: Third-party libraries and minified JS/CSS files are excluded from these statistics where possible, so the numbers you see here may be lower than those reported by other tools.

PHP

Language		%	Lines of code	Comment lines	Files
	PHP	100.0%	3,171	105	5
Total			3,171	105	5

PHP Code Analysis | More results »

Lines of code	3,266
Total complexity	957
Median class complexity	0.0
Median method complexity	0.0
Most complex class	—
Most complex function	espb_admin()

Classes	0
Methods	0
Functions	65

Additions

Things that the plugin adds to the site. This section is not intended to be comprehensive. The test tool only looks for a few specific types of added content.

Options `wp_options` 1

pb_db_version

PHP Error Log 23 lines

[20-May-2022 14:58:27 UTC] WordPress database error Table 'wordpress.wp_d59z13rzdw_posts' doesn't exist for query 
    SELECT o.ID order_id
    ,m.meta_id
    ,DATE_FORMAT(s.meta_value,'%Y-%m-%d')shipped
    ,d.meta_value delivery_est
    ,IFNULL((SELECT meta_value FROM wp_d59z13rzdw_postmeta WHERE meta_key='_shipping_first_name' AND post_id=o.ID),(SELECT meta_value FROM wp_d59z13rzdw_postmeta WHERE meta_key='_billing_first_name' AND post_id=o.ID))fname
    ,(SELECT 1 FROM wp_d59z13rzdw_postmeta JOIN wp_d59z13rzdw_options ON option_name=CONCAT('sms_sb_',meta_value) WHERE meta_key='_billing_phone' AND post_id=o.ID)subscribe
    ,(SELECT meta_value FROM wp_d59z13rzdw_postmeta LEFT JOIN wp_d59z13rzdw_options ON option_name=CONCAT('pb_unsb_',meta_value) WHERE option_name IS NULL AND meta_key='_billing_phone' AND post_id=o.ID)phone
    ,(SELECT LOWER(meta_value) FROM wp_d59z13rzdw_postmeta LEFT JOIN wp_d59z13rzdw_options ON option_name=CONCAT('pb_unsb_',meta_value) WHERE option_name IS NULL AND meta_key='_billing_email' AND post_id=o.ID)email
    ,m.meta_key label
    ,m.meta_value label_meta
    FROM wp_d59z13rzdw_posts o
    JOIN wp_d59z13rzdw_postmeta s ON s.post_id=o.ID AND s.meta_key='_last_shipped' AND s.meta_value>=NOW()-INTERVAL 20 DAY
    LEFT JOIN wp_d59z13rzdw_postmeta d ON d.post_id=o.ID AND d.meta_key='delivery_est' AND DATE_FORMAT(d.meta_value,'%Y-%m-%d')>DATE_FORMAT(s.meta_value,'%Y-%m-%d')
    JOIN wp_d59z13rzdw_postmeta m ON m.post_id=o.ID AND m.meta_key LIKE '_pb_label_meta%' AND m.meta_value NOT LIKE '%inbound%' AND m.meta_value NOT LIKE '%cancel%' AND m.meta_value NOT LIKE '%returnToSender%' AND m.meta_value NOT LIKE '%delivered,%'
    WHERE o.post_type='shop_order'
    AND (LENGTH('0')>1 OR (d.post_id IS NULL OR DATE_FORMAT(d.meta_value,'%Y-%m-%d') BETWEEN DATE_FORMAT(NOW()-INTERVAL 3 DAY,'%Y-%m-%d') AND DATE_FORMAT(NOW()+INTERVAL 5 DAY,'%Y-%m-%d')))
    AND o.post_status IN ('wc-refunded','wc-completed')
    
    
    ORDER BY m.meta_id DESC
    LIMIT 50;
   made by require_once('wp-admin/admin.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, espb_fetch_delivery_status, espb_r

Enterprise Shipping for Pitney Bowes 3.0.23