Avatax [300] Invalid or missing state/province code
-
Hello,
Once a month, when our customers subscriptions renew, all subscriptions get automatically put on hold. The error is:
[300] Invalid or missing state/province code (COL). COL is not a known state or province.From my understanding the Woocommerce code for Colorado is COL, and for Avatax it is CO and this may be where the problems lies. Our store is based in Colorado so I assume that’s where the issue is steming from. I do find it odd that this problem only occurs for automatic subscription renewls and not for standard orders.
If you can provide a fix that would be really helpful.
The page I need help with: [log in to see the link]
-
I just looked at the failed-scheduled-actions report, and this is what comes back.
06-29-2022 @ 12:19:05 - scheduled action 1065802 (subscription payment) failed to finish processing due to the following error: Uncaught Error: Call to a member function get() on null in /storage/www/hempdepotco.com/htdocs/wp-content/plugins/wpseo-local/woocommerce/shipping/class-wc-shipping.php:99 Stack trace: #0 /storage/www/hempdepotco.com/htdocs/wp-includes/class-wp-hook.php(307): Yoast_WCSEO_Local_Shipping->taxable_address_filter() #1 /storage/www/hempdepotco.com/htdocs/wp-includes/plugin.php(191): WP_Hook->apply_filters() #2 /storage/www/hempdepotco.com/htdocs/wp-content/plugins/woocommerce-avatax/src/class-wc-avatax-order-handler.php(1261): apply_filters() #3 /storage/www/hempdepotco.com/htdocs/wp-content/plugins/woocommerce-avatax/src/class-wc-avatax-order-handler.php(1210): WC_AvaTax_Order_Handler->get_taxable_address() #4 /storage/www/hempdepotco.com/htdocs/wp-content/plugins/woocommerce-avatax/src/integrations/class-wc-avatax-integrations.php(148): WC_AvaTax_Order_Handler->is_order_taxable() #5 /storage/www/hempdepotco.com/htdocs/wp-includes/class-wp-hook.php(307): WC_AvaTax_Integrations->recalculate_renewal_taxes() #6 /sto 06-29-2022 @ 12:19:05 - action args: subscription_id: 84864
Hello,
Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.? Once you’ve done that, paste it here in your response.
`
### WordPress Environment ###WordPress address (URL): https://hempdepotco.com
Site address (URL): https://hempdepotco.com
WC Version: 6.6.1
REST API Version: ? 6.6.1
WC Blocks Version: ? 7.6.2
Action Scheduler Version: ? 3.4.0
Log Directory Writable: ?
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –### Server Environment ###
Server Info: nginx/1.18.0
PHP Version: 7.4.26
PHP Post Max Size: 100 MB
PHP Time Limit: 300
PHP Max Input Vars: 20000
cURL Version: 7.68.0
OpenSSL/1.1.1fSUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.13-MariaDB-1:10.5.13+maria~focal-log
Max Upload Size: 100 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?### Database ###
WC Database Version: 6.6.1
WC Database Prefix: wp_
Total Database Size: 478.76MB
Database Data Size: 395.87MB
Database Index Size: 82.89MB
wp_woocommerce_sessions: Data: 2.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 21.55MB + Index: 12.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_ac_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_ac_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_3_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_ac_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_4_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_5_ac_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_5_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_5_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_5_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_6_ac_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_6_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_6_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_6_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_7_ac_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_7_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_7_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_7_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8_ac_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_8_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_actionscheduler_actions: Data: 7.09MB + Index: 6.16MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 4.22MB + Index: 2.84MB + Engine InnoDB
wp_ac_abandoned_cart_history_lite: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_ac_email_templates_lite: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
wp_ac_guest_abandoned_cart_history_lite: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_affiliates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_customermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_direct_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_referralmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_affiliate_wp_referrals: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_rest_consumers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_affiliate_wp_visits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_aiowps_events: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aiowps_failed_logins: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aiowps_global_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aiowps_login_activity: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aiowps_login_lockdown: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_aiowps_permanent_block: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bsk_pdf_manager_cats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bsk_pdf_manager_pdfs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bsk_pdf_manager_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bwf_contact: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wp_bwf_contact_meta: Data: 0.07MB + Index: 0.02MB + Engine MyISAM
wp_bwf_wc_customers: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_cf_forms: Data: 0.19MB + Index: 0.02MB + Engine InnoDB
wp_cf_form_entries: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_cf_form_entry_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cf_form_entry_values: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_cf_pro_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cf_queue_failures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cf_queue_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.05MB + Index: 0.04MB + Engine MyISAM
wp_comments: Data: 5.91MB + Index: 2.26MB + Engine MyISAM
wp_defender_lockout: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_defender_lockout_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_et_bloom_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_et_divi_ab_testing_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_et_social_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ewwwio_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_facetwp_index: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_coupon_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_customers: Data: 0.13MB + Index: 0.25MB + Engine InnoDB
wp_followup_customer_carts: Data: 1.52MB + Index: 0.14MB + Engine InnoDB
wp_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_customer_orders: Data: 0.14MB + Index: 0.06MB + Engine InnoDB
wp_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_email_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_email_orders: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
wp_followup_email_tracking: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_followup_followup_history: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_order_categories: Data: 0.27MB + Index: 0.25MB + Engine InnoDB
wp_followup_order_items: Data: 0.17MB + Index: 0.23MB + Engine InnoDB
wp_followup_subscribers: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_draft_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gf_entry: Data: 0.30MB + Index: 0.03MB + Engine MyISAM
wp_gf_entry_meta: Data: 1.06MB + Index: 0.69MB + Engine MyISAM
wp_gf_entry_notes: Data: 0.09MB + Index: 0.03MB + Engine MyISAM
wp_gf_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gf_form_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_gf_form_view: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_itsec_lockouts: Data: 0.05MB + Index: 0.08MB + Engine InnoDB
wp_itsec_logs: Data: 170.69MB + Index: 10.09MB + Engine InnoDB
wp_itsec_temp: Data: 0.13MB + Index: 0.20MB + Engine InnoDB
wp_layerslider: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_field_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_nf3_upgrades: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_options: Data: 14.63MB + Index: 1.28MB + Engine MyISAM
wp_pmxe_exports: Data: 1.50MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_podsrel: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_postmeta: Data: 65.68MB + Index: 21.61MB + Engine MyISAM
wp_posts: Data: 26.98MB + Index: 1.73MB + Engine MyISAM
wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_quickcard_transaction: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_analytics_ga: Data: 0.25MB + Index: 0.17MB + Engine InnoDB
wp_rank_math_analytics_gsc: Data: 3.52MB + Index: 3.92MB + Engine InnoDB
wp_rank_math_analytics_inspections: Data: 1.52MB + Index: 0.14MB + Engine InnoDB
wp_rank_math_analytics_keyword_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_analytics_objects: Data: 0.19MB + Index: 0.06MB + Engine InnoDB
wp_rank_math_internal_links: Data: 1.52MB + Index: 0.16MB + Engine InnoDB
wp_rank_math_internal_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_refersion_cart_tracking: Data: 0.28MB + Index: 0.27MB + Engine InnoDB
wp_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
wp_revslider_css_bkp: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_sliders: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_form_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_form_view: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_incomplete_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_lead: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_lead_detail: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_lead_detail_long: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_lead_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_rg_lead_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_searchwp_index: Data: 0.19MB + Index: 0.31MB + Engine InnoDB
wp_searchwp_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_searchwp_status: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_searchwp_tokens: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_search_filter_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_search_filter_term_results: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_sgpb_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sgpb_subscription_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_shareasale_wc_tracker_datafeeds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_shopmagic_automation_outcome: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_shopmagic_automation_outcome_logs: Data: 0.14MB + Index: 0.02MB + Engine InnoDB
wp_shopmagic_guest: Data: 0.30MB + Index: 0.00MB + Engine InnoDB
wp_shopmagic_guest_meta: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
wp_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_shortpixel_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_shortpixel_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sp_email_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_swift_performance_image_optimizer: Data: 1.52MB + Index: 0.13MB + Engine InnoDB
wp_swift_performance_warmup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_taxjar_record_queue: Data: 0.20MB + Index: 0.11MB + Engine MyISAM
wp_termmeta: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
wp_terms: Data: 0.05MB + Index: 0.09MB + Engine MyISAM
wp_term_relationships: Data: 0.07MB + Index: 0.13MB + Engine MyISAM
wp_term_taxonomy: Data: 0.03MB + Index: 0.04MB + Engine MyISAM
wp_tinvwl_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_tinvwl_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_tinvwl_lists: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usermeta: Data: 7.52MB + Index: 4.03MB + Engine InnoDB
wp_users: Data: 0.33MB + Index: 0.25MB + Engine InnoDB
wp_vxc_zoho_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_vxc_zoho_log: Data: 0.36MB + Index: 0.02MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wcs_payment_retries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.31MB + Index: 0.20MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.72MB + Engine InnoDB
wp_wc_order_stats: Data: 1.52MB + Index: 0.44MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.14MB + Index: 0.13MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_wc_zapier_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfblockediplog: Data: 0.31MB + Index: 0.00MB + Engine InnoDB
wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfconfig: Data: 0.48MB + Index: 0.00MB + Engine InnoDB
wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilemods: Data: 16.55MB + Index: 0.00MB + Engine InnoDB
wp_wfhits: Data: 1.02MB + Index: 0.22MB + Engine InnoDB
wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfknownfilelist: Data: 7.52MB + Index: 0.00MB + Engine InnoDB
wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflogins: Data: 0.44MB + Index: 0.16MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_square_customers: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wp_phpmyadmin_extension__errors_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_indexable: Data: 5.52MB + Index: 3.44MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.16MB + Index: 0.27MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_yoast_prominent_words: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_seo_links: Data: 1.52MB + Index: 0.53MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.34MB + Index: 0.00MB + Engine InnoDB### Post Type Counts ###
_pods_field: 5
_pods_group: 1
_pods_pod: 1
_pods_template: 3
acf-field: 4
acf-field-group: 1
attachment: 3034
batch_lookup: 330
conductor_qb_queries: 1
custom_css: 4
custom-css-js: 1
customize_changeset: 1
elementor_library: 26
et_body_layout: 4
et_footer_layout: 1
et_pb_layout: 91
et_template: 21
et_theme_builder: 1
flamingo_contact: 1826
flamingo_inbound: 1177
follow_up_email: 1
jet-smart-filters: 1
nav_menu_item: 64
nf_sub: 3
oembed_cache: 525
page: 71
popupbuilder: 1
post: 334
postman_sent_mail: 250
product: 205
product_variation: 85
rank_math_schema: 1
revision: 2252
search-filter-widget: 1
shop_coupon: 10
shop_order: 10147
shop_order_refund: 11
shop_subscription: 318
shopmagic_automation: 1
sp_wps_shortcodes: 1
vgwc: 1
vxc_zoho: 1
wpcf7_contact_form: 1
wpsl_stores: 225
yith-wcbm-badge: 1### Security ###
Secure connection (HTTPS): ?
Hide errors from visitors: ?### Active Plugins (44) ###
ManageWP – Worker: by GoDaddy – 4.9.14
Gravity Forms: by Gravity Forms – 2.6.4
Akismet Anti-Spam: by Automattic – 4.2.4
Analytify – Google Analytics Dashboard Widget: by Analytify – 2.0.6
Caldera Forms: by Caldera Forms – 1.9.7
Classic Widgets: by WordPress Contributors – 0.3
Coinbase Commerce: by Coinbase Commerce – 1.2.1
Contact Form 7: by Takayuki Miyoshi – 5.6
Simple Custom CSS and JS: by SilkyPress.com – 3.40
Disable Comments: by WPDeveloper – 2.3.6
Divi Booster: by Dan Mossop – 3.8.9
GTM4WP: by Thomas Geiger – 1.16
Easy Table of Contents: by Magazine3 – 2.0.26
Elementor Pro: by Elementor.com – 3.7.2
Elementor: by Elementor.com – 3.6.7
FacetWP – Pods integration: by FacetWP
LLC – 1.2.2FacetWP: by FacetWP
LLC – 3.9.6UPS Live Rates and Access Points: by Octolize – 1.17.13
Gravity Forms reCAPTCHA Add-On: by Gravity Forms – 1.1
Pods – Custom Content Types and Fields: by Pods Framework Team – 2.8.23
Popup Builder: by Sygnoos – 4.1.12
Post SMTP: by Post SMTP – 2.1.3
Tiered Price Table for WooCommerce: by Kolya Lukin – 4.0.0
Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 5.12.0
WooCommerce All Products For Subscriptions: by WooCommerce – 3.3.1
WooCommerce AvaTax: by SkyVerge – 1.16.1
Checkout Fields Manager for WooCommerce: by QuadLayers – 6.0.7.5
WooCommerce Pre-Orders: by WooCommerce – 1.7.0 (update to version 1.7.2 is available)
WooCommerce Product Reviews Pro: by SkyVerge – 1.15.2 (update to version 1.17.4 is available)
WooCommerce – ShipStation Integration: by WooCommerce – 4.1.48
WooCommerce Smart Coupons: by StoreApps – 5.6.0
WooCommerce Square: by WooCommerce – 3.1.0
WooCommerce Subscriptions: by WooCommerce – 4.4.0
WooCommerce: by Automattic – 6.6.1
Wordfence Security: by Wordfence – 7.5.11
Yoast SEO Premium: by Team Yoast – 18.7
Yoast SEO: by Team Yoast – 19.2
Analytify Pro: by WPBrigade – 4.1.5
Analytify – WooCommerce Tracking: by WPBrigade – 4.1.7
Analytify – Google Analytics Dashboard: by Analytify – 4.2.2
WP Debugging: by Andy Fragen – 2.11.13
WP Rocket: by WP Media – 3.10.5.1
WP Store Locator: by Tijmen Smit – 2.2.235
Yoast SEO: WooCommerce: by Team Yoast – 14.9### Inactive Plugins (19) ###
Caldera Easy Pods: by David Cramer <[email protected]> – 1.1.10
CalderaWP License Manager: by CalderaWP – 1.2.11
Crypto Payment Gateway for WooCommerce: by TripleA Team – 1.8.1
Envato Market: by Envato – 2.0.6
Flamingo: by Takayuki Miyoshi – 2.3
Jetpack: by Automattic – 11.1
Multi-Step Checkout for WooCommerce: by SilkyPress – 2.21.1
Ninja Forms: by Saturday Drive – 3.6.12
Ninja Forms – Layout & Styles: by The WP Ninjas – 3.0.29
Query Monitor: by John Blackbourn – 3.9.0
Rank Math SEO: by Rank Math – 1.0.92.1
Rank Math SEO PRO: by Rank Math – 3.0.13
Refersion for WooCommerce: by Refersion
Inc. – 4.9.2SearchWP: by SearchWP – 4.1.22
SearchWP Shortcodes: by SearchWP – 1.8.2
WooCommerce Admin: by WooCommerce – 3.3.2
WooCommerce Shipping & Tax: by WooCommerce – 1.26.2
WP Downgrade | Specific Core Version: by Reisetiger – 1.2.5
WP Mail SMTP: by WPForms – 3.4.0### Dropin Plugins (1) ###
advanced-cache.php: advanced-cache.php
### Must Use Plugins (1) ###
ManageWP – Worker Loader: by GoDaddy –
### Settings ###
API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)
variable-subscription (variable-subscription)Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)Connected to WooCommerce.com: ?
Enforce Approved Product Download Directories: –### WC Pages ###
Shop base: #44859 – /shop/
Cart: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
Checkout: #44861 – /checkout/
My account: #44862 – /my-account/
Terms and conditions: #45003 – /terms-of-use/### Theme ###
Name: HempDepotCo – Divi Child Theme
Version: (update to version 0 is available)
Author URL:
Child Theme: ?
Parent Theme Name: Divi
Parent Theme Version: 4.17.4
Parent Theme Author URL: https://www.elegantthemes.com
WooCommerce Support: ?### Templates ###
Overrides: –
### Subscriptions ###
WCS_DEBUG: ? No
Subscriptions Mode: ? Live
Subscriptions Live URL: https://hempdepotco.com
Subscription Statuses: wc-active: 29
wc-pending-cancel: 1
wc-on-hold: 77
wc-cancelled: 211WooCommerce Account Connected: ? Yes
Active Product Key: ? Yes
Custom Retry Rules: ? No
Custom Retry Rule Class: ? No
Custom Raw Retry Rule: ? No
Custom Retry Rule: ? No
Retries Migration Status: ? Completed
Report Cache Enabled: ? Yes
Cache Update Failures: ? 0 failure### Store Setup ###
Country / State: United States (US) — Colorado
### Subscriptions by Payment Gateway ###
Square: wc-active: 29
wc-cancelled: 211
wc-on-hold: 77
wc-pending-cancel: 1### Payment Gateway Support ###
Square: products
card_types
customer_decline_messages
payment_form
authorization
charge
charge-virtual
capture_charge
refunds
voids
customer_id
tokenization
add_payment_method
token_editor
subscriptions
subscription_suspension
subscription_cancellation
subscription_reactivation
subscription_amount_changes
subscription_date_changes
multiple_subscriptions
subscription_payment_method_change_customer
subscription_payment_method_change_admin
pre-ordersCoinbase: products
### Square ###
Environment: Production
Tokenization Enabled:
Debug Mode: Display at Checkout & Log### Admin ###
Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-pageDisabled Features: minified-js
settingsDaily Cron: ? Next scheduled: 2022-07-07 18:06:10 -06:00
Options: ?
Notes: 90
Onboarding: completed### All Products for WooCommerce Subscriptions ###
Template Overrides: –
### Action Scheduler ###
Canceled: 4
Oldest: 2022-06-08 09:16:01 -0600
Newest: 2022-07-06 18:20:29 -0600Complete: 14,467
Oldest: 2022-06-07 16:13:56 -0600
Newest: 2022-07-07 10:32:05 -0600Failed: 274
Oldest: 2020-01-20 17:31:03 -0700
Newest: 2022-07-06 16:06:04 -0600Pending: 38
Oldest: 2022-07-07 10:46:29 -0600
Newest: 2022-08-07 06:38:18 -0600### Smart Coupons related settings ###
Number of coupons to show: 5
Number of characters in auto-generated coupon code:
Valid order status for auto-generating coupon: processing
completedInclude tax in the amount of the generated gift card: no
Deduct credit/gift before doing tax calculations: no
Gift Card discount is inclusive of tax: no
Automatic deletion: no
Coupon emails: yes
Printing coupons: yes
Sell gift cards at less price?: no
Use gift card applied in first subscription order for subsequent renewals until credit reaches zero: yes
Renewal orders should not generate coupons even when they include a product that issues coupons: no
Allow sending of coupons to others: yes
Allow schedule sending of coupons?: no
Combine emails: no
Auto generated coupon email: yes
Combined auto generated coupons email: no
Acknowledgement email: yes
Enable taxes: yes
Prices entered with tax: no
Rounding: yes
Display prices in the shop: excl
Display prices during cart and checkout: excl
Display tax totals: single
Enable the use of coupon codes: yes
Calculate coupon discounts sequentially: no
Account endpoints > Coupons: wc-smart-coupons### Status report information ###
Generated at: 2022-07-07 10:34:40 -06:00
Hi @seanhdco
Thank you for sending over your system status. I see that you are using the following plugins:
WooCommerce Subscriptions: by WooCommerce – 4.4.0
WooCommerce Subscriptions: by WooCommerce – 4.4.0Since they are premium plugins, you have access to our support team at WooCommerce.com. Please contact us at?WooCommerce.com > My Account > Support, and we’ll be happy to help you there.
- The topic ‘Avatax [300] Invalid or missing state/province code’ is closed to new replies.