• Resolved seanhdco

    (@seanhdco)


    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]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter seanhdco

    (@seanhdco)

    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.

    Thread Starter seanhdco

    (@seanhdco)

    `
    ### 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.1f

    SUHOSIN 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.2

    FacetWP: by FacetWP
    LLC – 3.9.6

    UPS 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.2

    SearchWP: 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: 211

    WooCommerce 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-orders

    Coinbase: 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-page

    Disabled Features: minified-js
    settings

    Daily 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 -0600

    Complete: 14,467
    Oldest: 2022-06-07 16:13:56 -0600
    Newest: 2022-07-07 10:32:05 -0600

    Failed: 274
    Oldest: 2020-01-20 17:31:03 -0700
    Newest: 2022-07-06 16:06:04 -0600

    Pending: 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
    completed

    Include 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

    Thread Starter seanhdco

    (@seanhdco)

    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.0

    Since 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.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Avatax [300] Invalid or missing state/province code’ is closed to new replies.