Sync Master Sheet – Product Sync with Google Sheet for WooCommerce

Help you to connect your WooCommerce website with Google Sheet as well as Manage your Stock easy from one menu with Advance Filter

v2.0.4Saiful IslamUpdated Added 400 installs100% rating0% support resolved
30
Score
136
Errors
300
Warnings
+0
Change

Category Scores

Security0
Repo94
Performance100
Maintainability28

Issues to Review

Prioritized issue groups from the latest Plugin Check scan

436 findings

Maintainability

284

11 issue groups

Security

90

10 issue groups

I18n

51

4 issue groups

WARNINGMaintainabilityNon-prefixed global variableGlobal variables defined by a theme/plugin should start with the theme/plugin prefix. Found: "$AppsScriptAccessCode".215
Category
Maintainability
Occurrences
215
Severity
warning

Sample message

Global variables defined by a theme/plugin should start with the theme/plugin prefix. Found: "$AppsScriptAccessCode".

ERRORSecurityOutput is not escapedAll output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"🛠️ <strong>File:</strong> <span style='color:#8d8d8d;'>$file</span> on line <span style='color:#4b4b4b;'>$line</span>"'.41
Category
Security
Occurrences
41
Severity
error

Sample message

All output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '"🛠️ <strong>File:</strong> <span style='color:#8d8d8d;'>$file</span> on line <span style='color:#4b4b4b;'>$line</span>"'.

ERRORI18nText Domain MismatchMismatched text domain. Expected 'product-sync-master-sheet' but got 'appsero'.30
Category
I18n
Occurrences
30
Severity
error

Sample message

Mismatched text domain. Expected 'product-sync-master-sheet' but got 'appsero'.

ERRORMaintainabilitywp function not compatible with requires wpFunction "get_rest_url()" requires WordPress 4.4.0, but your plugin minimum supported version is WordPress 4.0.0.24
Category
Maintainability
Occurrences
24
Severity
error

Sample message

Function "get_rest_url()" requires WordPress 4.4.0, but your plugin minimum supported version is WordPress 4.0.0.

ERRORI18nNo Empty StringsThe $text text string should have translatable content. Found: ''11
Category
I18n
Occurrences
11
Severity
error

Sample message

The $text text string should have translatable content. Found: ''

WARNINGSecurityNonce verification recommendedProcessing form data without nonce verification.10
Category
Security
Occurrences
10
Severity
warning

Sample message

Processing form data without nonce verification.

WARNINGSecurityInterpolated SQL is not preparedUse placeholders and $wpdb-&gt;prepare(); found interpolated variable $ids_placeholder at &quot;DELETE FROM $table_name WHERE id IN ($ids_placeholder)&quot;9
Category
Security
Occurrences
9
Severity
warning

Sample message

Use placeholders and $wpdb-&gt;prepare(); found interpolated variable $ids_placeholder at &quot;DELETE FROM $table_name WHERE id IN ($ids_placeholder)&quot;

WARNINGMaintainabilityDirect QueryUse of a direct database call is discouraged.8
Category
Maintainability
Occurrences
8
Severity
warning

Sample message

Use of a direct database call is discouraged.

WARNINGSecurityMissing nonce verificationProcessing form data without nonce verification.8
Category
Security
Occurrences
8
Severity
warning

Sample message

Processing form data without nonce verification.

ERRORI18nMissing Translators CommentA function call to __() with texts containing placeholders was found, but was not accompanied by a "translators:" comment on the line above to clarify the meaning of the placeholders.8
Category
I18n
Occurrences
8
Severity
error

Sample message

A function call to __() with texts containing placeholders was found, but was not accompanied by a "translators:" comment on the line above to clarify the meaning of the placeholders.

Show 15 more
WARNINGMaintainabilityNo Caching7
Category
Maintainability
Occurrences
7
Severity
warning

Sample message

Direct database call without caching detected. Consider using wp_cache_get() / wp_cache_set() or wp_cache_delete().

WARNINGMaintainabilityNon-prefixed hook name7
Category
Maintainability
Occurrences
7
Severity
warning

Sample message

Hook names invoked by a theme/plugin should start with the theme/plugin prefix. Found: &quot;active_plugins&quot;.

ERRORMaintainabilityMissing direct file access protection7
Category
Maintainability
Occurrences
7
Severity
error

Sample message

PHP file should prevent direct access. Add a check like: if ( ! defined( 'ABSPATH' ) ) exit;

WARNINGMaintainabilityDynamic hook name6
Category
Maintainability
Occurrences
6
Severity
warning

Sample message

Hook names invoked by a theme/plugin should start with the theme/plugin prefix. Found: &quot;$action_hook&quot;.

WARNINGSecurityInput is not sanitized6
Category
Security
Occurrences
6
Severity
warning

Sample message

Detected usage of a non-sanitized input variable: $_FILES[&#039;json_file&#039;]

WARNINGSecurityRequest data is not unslashed6
Category
Security
Occurrences
6
Severity
warning

Sample message

$_GET[&#039;s&#039;] not unslashed before sanitization. Use wp_unslash() or similar

WARNINGSecurityDatabase parameter is not escaped4
Category
Security
Occurrences
4
Severity
warning

Sample message

Unescaped parameter $table_name used in $wpdb-&gt;get_var()\n$table_name assigned unsafely at line 285.

WARNINGMaintainabilityerror log var dump3
Category
Maintainability
Occurrences
3
Severity
warning

Sample message

var_dump() found. Debug code should not normally be used in production.

ERRORMaintainabilityrand rand3
Category
Maintainability
Occurrences
3
Severity
error

Sample message

rand() is discouraged. Use the far less predictable wp_rand() instead.

ERRORSecuritySQL query is not prepared2
Category
Security
Occurrences
2
Severity
error

Sample message

Use placeholders and $wpdb->prepare(); found $prepared_query

WARNINGSecurityUnfinished Prepare2
Category
Security
Occurrences
2
Severity
warning

Sample message

Replacement variables found, but no valid placeholders found in the query.

ERRORMaintainabilitydate date2
Category
Maintainability
Occurrences
2
Severity
error

Sample message

date() is affected by runtime timezone changes which can cause date/time to be incorrectly displayed. Use gmdate() instead.

WARNINGMaintainabilityerror log debug backtrace2
Category
Maintainability
Occurrences
2
Severity
warning

Sample message

debug_backtrace() found. Debug code should not normally be used in production.

WARNINGSecurityInput is not validated2
Category
Security
Occurrences
2
Severity
warning

Sample message

Detected usage of a possibly undefined superglobal array index: $_POST[&#039;params&#039;]. Check that the array index exists before using it.

ERRORI18nMissing Arg Domain2
Category
I18n
Occurrences
2
Severity
error

Sample message

Missing $domain parameter in function call to __().

External Connections

Potential connections found in static code analysis.

33 domains

Outbound calls

127

External assets

2

Incoming endpoints

17

Notable Domains

codeastrology.com14 · outbound
sheets.googleapis.com11 · outbound
docs.google.com5 · outbound
appsero.com4 · outbound
nikitahl.com4 · outbound

Platform / Reference Domains

w3.org25 · platform/reference
wordpress.org16 · platform/reference
ps.w.org9 · platform/reference
profiles.wordpress.org5 · platform/reference
gnu.org1 · platform/reference
s.w.org1 · platform/reference

External Asset Domains

cdnjs.cloudflare.com3 · asset + outbound
youtube-nocookie.com2 · asset + outbound

Incoming Endpoints

No public endpoints detected.

Admin AJAX endpoints17
wp_ajax_appsero_refresh_license_authenticated

wp_ajax

wp_ajax_handle_json_file_uploadauthenticated

wp_ajax

wp_ajax_noprev_pssg_cleared_sheetauthenticated

wp_ajax

wp_ajax_noprev_pssg_quick_table_updateauthenticated

wp_ajax

wp_ajax_noprev_pssg_syncronize_productsauthenticated

wp_ajax

wp_ajax_pssg_cleared_sheetauthenticated

wp_ajax

wp_ajax_pssg_configure_form_submitauthenticated

wp_ajax

wp_ajax_pssg_dismiss_appscript_noticeauthenticated

wp_ajax

wp_ajax_pssg_generate_access_keyauthenticated

wp_ajax

wp_ajax_pssg_quick_table_updateauthenticated

wp_ajax

wp_ajax_pssg_regenerate_access_keyauthenticated

wp_ajax

wp_ajax_pssg_reset_column_orderauthenticated

wp_ajax

5 more hidden

Score History

First score snapshot

v2.0.4

30

Latest

Findings
436
Errors
136
Warnings
300
Check
2.0.0

Relationship Map

Author, categories, issues, domains, and nearby plugins.

37 nodes

Related Plugins