• Resolved revelationatheletics

    (@revelationatheletics)


    THe plugin settings keeps on loading…

    It is not allowing us to add the Phone number or address.

    This causes the plugin to feed our new products and we miss out on sales for those products.

    Please provide appropriate solution.

    TIA.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Hi @revelationatheletics

    I understand that the Google Listings and Ads plugin keeps on loading endlessly and as a result it is not being possible to add the Phone number or address.

    Was it working fine before, and this issue is happening recently? Do you remember making any changes before the issue started such as updating or installing other plugin(s)?

    Secondly, do you see any fatal errors at WooCommerce > Status > Logs tab > Select google_listings and ads

    We would also need to check if it is a memory shortage issue, so in your response please include 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 revelationatheletics

    (@revelationatheletics)

    Hi @margaretwporg

    The issue occured last week. We thought this is due to Plugin update so after that only we have the plugin updated thinking the issue will be sorted but it still exists.

    Yes, we see a fatal error. Please refer this screenshot: https://www.awesomescreenshot.com/image/32599341?key=dbca2f42535ffa860cf9bfd57db2c9df

    Copy of our site’s System Status:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://shop.okrah.com
    Site address (URL): https://shop.okrah.com
    WC Version: 6.9.2
    REST API Version: ? 6.9.2
    WC Blocks Version: ? 8.3.2
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0.2
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: ?
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.30
    PHP Post Max Size: 516 MB
    PHP Time Limit: 60
    PHP Max Input Vars: 1000
    cURL Version: 7.85.0
    OpenSSL/1.1.1q
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.23-23
    Max Upload Size: 512 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.9.2
    WC Database Prefix: blf_
    Total Database Size: 58.83MB
    Database Data Size: 48.61MB
    Database Index Size: 10.22MB
    blf_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
    blf_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    blf_woocommerce_order_items: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    blf_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
    blf_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    blf_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_woocommerce_payment_tokens: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    blf_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_actionscheduler_actions: Data: 3.02MB + Index: 1.58MB + Engine InnoDB
    blf_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_actionscheduler_logs: Data: 0.50MB + Index: 0.42MB + Engine InnoDB
    blf_cartflows_ca_cart_abandonment: Data: 0.28MB + Index: 0.02MB + Engine InnoDB
    blf_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_comments: Data: 0.45MB + Index: 0.48MB + Engine InnoDB
    blf_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
    blf_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    blf_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    blf_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_nextend2_smartslider3_sliders: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    blf_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_nextend2_smartslider3_slides: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
    blf_options: Data: 10.19MB + Index: 0.16MB + Engine InnoDB
    blf_postmeta: Data: 19.44MB + Index: 3.00MB + Engine InnoDB
    blf_posts: Data: 8.45MB + Index: 0.34MB + Engine InnoDB
    blf_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_usermeta: Data: 1.50MB + Index: 1.95MB + Engine InnoDB
    blf_users: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
    blf_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    blf_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_wc_customer_lookup: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    blf_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    blf_wc_order_stats: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
    blf_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
    blf_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_wmfo_fraud_attempts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_wmfo_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_wt_iew_action_history: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    blf_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blf_yoast_indexable: Data: 0.28MB + Index: 0.17MB + Engine InnoDB
    blf_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
    blf_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blf_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blf_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 480
    custom_css: 4
    elementor_library: 11
    nav_menu_item: 21
    oembed_cache: 1
    page: 14
    post: 2
    product: 222
    product-feed: 1
    revision: 747
    shop_coupon: 1
    shop_order: 1026
    shop_order_refund: 14
    shop_subscription: 108
    wc_stamps_label: 5
    wp_global_styles: 1
    wpforms: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (26) ###
    
    Starter Templates: by Brainstorm Force – 3.1.16
    Better Search Replace: by Delicious Brains – 1.4.1
    CartFlows: by CartFlows Inc – 1.11.1
    Classic Widgets: by WordPress Contributors – 0.3
    Duplicate Page: by mndpsingh287 – 4.4.9
    Elementor: by Elementor.com – 3.7.6
    Flexible Shipping: by Octolize – 4.14.0
    Google Listings and Ads: by WooCommerce – 2.1.2
    Min and Max Quantity for WooCommerce: by BeRocket – 1.3.2.4
    NitroPack: by NitroPack LLC – 1.5.15
    Product Import Export for WooCommerce: by WebToffee – 2.2.4
    Simple Banner: by Ryan Petersen – 2.12.1
    Smart Slider 3: by Nextend – 3.5.1.9
    WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.19
    Woo Manage Fraud Orders: by Prasidhda Malla – 2.5.6
    Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.2
    Product Feed PRO for WooCommerce: by AdTribes.io – 11.8.7
    Woo Products Widgets For Elementor: by Themelocation – 1.0.6
    WooCommerce All Products For Subscriptions: by WooCommerce – 3.2.2
    WooCommerce Stripe Gateway: by WooCommerce – 6.7.0
    WooCommerce Stamps.com API integration: by WooCommerce – 1.3.26
    WooCommerce Subscriptions: by WooCommerce – 4.0.2
    WooCommerce: by Automattic – 6.9.2
    Yoast SEO: by Team Yoast – 19.6.1
    WPForms Lite: by WPForms – 1.7.6
    Custom Product Tabs for WooCommerce: by YIKES
    Inc. – 1.7.9
    
    ### Inactive Plugins (3) ###
    
    Order Export for WooCommerce: by JEM Plugins – 3.2
    Product Feed Manager for WooCommerce: by RexTheme – 7.2.19
    WooCommerce UPC, EAN, and ISBN: by Scott Bolinger – 0.5.1
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### 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)
    subscription (subscription)
    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: #38 - /store/
    Cart: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
    Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.
    My account: #41 - /my-account/
    Terms and conditions: #14257 - /terms-and-conditions/
    
    ### Theme ###
    
    Name: Astra Child
    Version: 1.0.0
    Author URL: https://wpastra.com/about/
    Child Theme: ?
    Parent Theme Name: Astra
    Parent Theme Version: 3.9.2
    Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: astra-child/woocommerce/emails/customer-completed-order.php
    
    ### Subscriptions ###
    
    WCS_DEBUG: ? No
    Subscriptions Mode: ? Live
    Subscriptions Live URL: https://shop.okrah.com
    Subscription Statuses: wc-active: 83
    wc-pending-cancel: 15
    wc-pending: 1
    wc-on-hold: 5
    wc-cancelled: 4
    
    WooCommerce Account Connected: ? No
    Report Cache Enabled: ? Yes
    Cache Update Failures: ? 0 failure
    
    ### Store Setup ###
    
    Country / State: United States (US) — Ohio
    
    ### Subscriptions by Payment Gateway ###
    
    Stripe: wc-active: 83
    wc-cancelled: 4
    wc-on-hold: 5
    wc-pending: 1
    wc-pending-cancel: 15
    
    ### Payment Gateway Support ###
    
    Stripe: products
    refunds
    tokenization
    add_payment_method
    subscriptions
    subscription_cancellation
    subscription_suspension
    subscription_reactivation
    subscription_amount_changes
    subscription_date_changes
    subscription_payment_method_change
    subscription_payment_method_change_customer
    subscription_payment_method_change_admin
    multiple_subscriptions
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    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
    
    Disabled Features: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2022-09-21 06:24:14 -05:00
    Options: ?
    Notes: 61
    Onboarding: completed
    
    ### All Products for WooCommerce Subscriptions ###
    
    Template Overrides: –
    
    ### Action Scheduler ###
    
    Complete: 5,064
    Oldest: 2022-08-20 16:22:24 +0000
    Newest: 2022-09-20 14:44:19 +0000
    
    Failed: 182
    Oldest: 2022-07-12 19:37:15 +0000
    Newest: 2022-09-20 13:45:50 +0000
    
    Pending: 109
    Oldest: 2022-09-20 15:13:53 +0000
    Newest: 2022-12-14 20:03:59 +0000
    
    ### Status report information ###
    
    Generated at: 2022-09-20 09:47:51 -05:00
    

    Let me know the fix please.

    Thread Starter revelationatheletics

    (@revelationatheletics)

    @margaretwporg

    Did you receivie my message. Awaiting your response.

    Hi @revelationatheletics

    To check better into this can you provide the error logs in text, please?

    We’ll look forward to hearing from you.

    Thread Starter revelationatheletics

    (@revelationatheletics)

    @ihereira

    Here is the error logs in text

    google-listings-and-ads-2022-08-22-769fc0e6684672deadd526021dda17c2.log

    2022-08-22T03:46:41+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\WCProductAdapter::map_product_categories Product category (ID: 14392): ["Cardiovascular Health"].
    2022-08-22T03:46:42+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\ProductSyncer::update_by_batch_requests Submitted 1 products:
    [{"woocommerce_id":14392,"google_id":"online:en:US:gla_14392"}]
    2022-08-22T17:20:15+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\WCProductAdapter::map_product_categories Product category (ID: 9671): ["Immune Health"].
    2022-08-22T17:20:17+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\ProductSyncer::update_by_batch_requests Submitted 1 products:
    [{"woocommerce_id":9671,"google_id":"online:en:US:gla_9671"}]
    2022-08-22T19:53:36+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\WCProductAdapter::map_product_categories Product category (ID: 9671): ["Immune Health"].
    2022-08-22T19:53:37+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\ProductSyncer::update_by_batch_requests Submitted 1 products:
    [{"woocommerce_id":9671,"google_id":"online:en:US:gla_9671"}]
    2022-08-22T20:01:46+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\WCProductAdapter::map_product_categories Product category (ID: 9671): ["Immune Health"].
    2022-08-22T20:01:47+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\ProductSyncer::update_by_batch_requests Submitted 1 products:
    [{"woocommerce_id":9671,"google_id":"online:en:US:gla_9671"}]
    2022-08-22T22:05:17+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\WCProductAdapter::map_product_categories Product category (ID: 9671): ["Immune Health"].
    2022-08-22T22:05:19+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\Product\ProductSyncer::update_by_batch_requests Submitted 1 products:
    [{"woocommerce_id":9671,"google_id":"online:en:US:gla_9671"}]

    Let me know.

    Plugin Support Chris Moreira – a11n

    (@chrism245)

    It does look like there is an authentication issue with the Google Merchant Center account.

    1. Revoke the previous access permissions to your Google account so you can reconnect. Open the Security tab for your Google account: https://myaccount.google.com/security/.
    2. Click on the link “Manage third party access” and then remove access for the WooCommerce app.
    3. Go to WP-Admin > Marketing > Google Listings & Ads and reconnect your Google account, making sure to grant all requested scopes by checking the boxes.
    3. Reconnect your Merchant Account.

    ![https://d.pr/i/D0svJv](https://d.pr/i/D0svJv+)
    Full Size: https://d.pr/i/D0svJv

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Google Listings and Ads plugin Keeps on Loading’ is closed to new replies.