• Resolved javay4395

    (@javay4395)


    After reading other post I am supplying the following details:

    We are using Content API(Google Merchant) and WooCommerce for WordPress.
    
    Google Merchant Center – Should be over 60 items but only 24 are sync since initially connecting 
    
    Here are the logs and status report
    
    ------------------------------------------------------------------------------------------------------------------------------------------
    Logs
    Lastest google log
    2022-07-27T07:19:58+00:00 ERROR Automattic\WooCommerce\GoogleListingsAndAds\Internal\DependencyManagement\GoogleServiceProvider::handle_unauthorized_error Client error: <code>POST https://api-vipgo.woocommerce.com/google/google-mc/content/v2.1/585581480/reports/search</code> resulted in a <code>401 Unauthorized</code> response:
    {"statusCode":401,"error":"Unauthorized","message":"Site is not connected to Google account for google-mc"}
    
    2022-07-27T07:19:58+00:00 ERROR Automattic\WooCommerce\GoogleListingsAndAds\Internal\DependencyManagement\GoogleServiceProvider::handle_unauthorized_error Client error: <code>POST https://api-vipgo.woocommerce.com/google/google-mc/content/v2.1/585581480/reports/search</code> resulted in a <code>401 Unauthorized</code> response:
    {"statusCode":401,"error":"Unauthorized","message":"Site is not connected to Google account for google-mc"}
    
    2022-07-27T07:20:42+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\MerchantCenter\MerchantStatuses::filter_valid_statuses A Google ID was not found in Merchant Center.
    2022-07-27T07:20:42+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\MerchantCenter\MerchantStatuses::filter_valid_statuses A Google ID was not found in Merchant Center.
    2022-07-27T07:20:42+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\MerchantCenter\MerchantStatuses::filter_valid_statuses A Google ID was not found in Merchant Center.
    2022-07-27T07:20:42+00:00 DEBUG Automattic\WooCommerce\GoogleListingsAndAds\MerchantCenter\MerchantStatuses::filter_valid_statuses A Google ID was not found in Merchant Center.
    
    --------------------------------------------------------------------------------------------------------------------------------
    Status Report
    ---------------------------------------------------------------------------------------------------------------------------------
    

    ### WordPress Environment ###

    WordPress address (URL): https://www.mddealstore.com
    Site address (URL): https://www.mddealstore.com
    WC Version: 6.7.0
    REST API Version: ? 6.7.0
    WC Blocks Version: ? 7.8.3
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0.1
    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.29
    PHP Post Max Size: 516 MB
    PHP Time Limit: 60
    PHP Max Input Vars: 1000
    cURL Version: 7.81.0
    OpenSSL/1.1.1n

    SUHOSIN Installed: –
    MySQL Version: 5.6.41-84.1
    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.7.0
    WC Database Prefix: wp_
    Total Database Size: 28.10MB
    Database Data Size: 24.62MB
    Database Index Size: 3.48MB
    wp_woocommerce_sessions: Data: 1.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: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + 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_actionscheduler_actions: Data: 0.27MB + Index: 0.19MB + 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: 0.19MB + Index: 0.16MB + Engine InnoDB
    wp_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_comments: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
    wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
    wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_nextend2_smartslider3_sliders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_nextend2_smartslider3_slides: Data: 0.05MB + Index: 0.11MB + Engine InnoDB
    wp_options: Data: 10.70MB + Index: 0.15MB + Engine MyISAM
    wp_postmeta: Data: 3.83MB + Index: 0.35MB + Engine MyISAM
    wp_posts: Data: 4.12MB + Index: 0.18MB + Engine MyISAM
    wp_rank_math_analytics_objects: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_meta: Data: 0.02MB + 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_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_terms: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_term_relationships: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_usermeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
    wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + 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.02MB + 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.02MB + Index: 0.02MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

    ### Post Type Counts ###

    attachment: 719
    custom_css: 1
    customize_changeset: 44
    elementor_library: 3
    jetpack_migration: 2
    jp_img_sitemap: 4
    jp_sitemap: 4
    jp_sitemap_master: 4
    mailpoet_page: 1
    nav_menu_item: 24
    page: 17
    post: 3
    product: 103
    product_variation: 13
    revision: 300
    shop_coupon: 2
    shop_order: 15
    shop_order_refund: 1
    sp_wcslider: 1
    wp_global_styles: 2
    wpcf7_contact_form: 1
    yaymail_template: 11

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (22) ###

    Akismet Anti-Spam: by Automattic – 5.0
    Blocksy Companion: by CreativeThemes – 1.8.43
    Classic Widgets: by WordPress Contributors – 0.3
    Contact Form 7: by Takayuki Miyoshi – 5.6.1
    Elementor: by Elementor.com – 3.6.7
    Instant Indexing: by Rank Math – 1.1.16
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.7.0
    Google Listings and Ads: by WooCommerce – 2.0.1
    Hello Dolly: by Matt Mullenweg – 1.7.2
    Jetpack: by Automattic – 11.1.2
    MOJO Marketplace: by Mike Hansen – 1.6.2
    OptinMonster: by OptinMonster Popup Builder Team – 2.8.1
    Really Simple SSL: by Really Simple Plugins – 5.3.2
    Rank Math SEO: by Rank Math – 1.0.93.1
    Smart Slider 3: by Nextend – 3.5.1.7
    WooCommerce Amazon Pay: by WooCommerce – 2.2.2
    WooCommerce Payments: by Automattic – 4.4.0
    WooCommerce PayPal Payments: by WooCommerce – 1.9.1
    WooCommerce Shipping & Tax: by WooCommerce – 1.26.2
    WooCommerce: by Automattic – 6.7.0
    WPForms Lite: by WPForms – 1.7.5.3
    YayMail – WooCommerce Email Customizer: by YayCommerce – 3.0

    ### Inactive Plugins (0) ###

    ### Must Use Plugins (1) ###

    Endurance Page Cache: by Mike Hansen – 2.2

    ### 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: #8 – /shop/
    Cart: #366 – /cart-2/
    Checkout: #367 – /checkout-2/
    My account: #368 – /my-account-2/
    Terms and conditions: #12 – /refund_returns/

    ### Theme ###

    Name: Blocksy
    Version: 1.8.43
    Author URL: https://creativethemes.com
    Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ?

    ### Templates ###

    Overrides: blocksy/woocommerce/cart/cart.php
    blocksy/woocommerce/cart/mini-cart.php
    blocksy/woocommerce/content-widget-product.php
    blocksy/woocommerce/content-widget-reviews.php
    blocksy/woocommerce/myaccount/my-account.php
    blocksy/woocommerce/product-searchform.php
    blocksy/woocommerce/single-product/tabs/tabs.php

    ### Subscriptions ###

    WCS_DEBUG: ? No
    Subscriptions Mode: ? Staging
    Subscriptions Live URL: https://mddealstore.com
    Subscription Statuses: –
    WooCommerce Account Connected: ? No

    ### Store Setup ###

    Country / State: United States (US) — Florida

    ### Payment Gateway Support ###

    WooCommerce Payments: products
    refunds
    multiple_subscriptions
    subscription_cancellation
    subscription_payment_method_change_admin
    subscription_payment_method_change_customer
    subscription_payment_method_change
    subscription_reactivation
    subscription_suspension
    subscriptions
    gateway_scheduled_payments
    tokenization
    add_payment_method

    PayPal: refunds

    ### WooCommerce PayPal Payments ###

    Onboarded: ?
    Shop country code: US
    WooCommerce currency supported: ?
    PayPal card processing available in country: ?
    Pay Later messaging available in country: ?
    Webhook status: –
    Vault enabled: ?
    Logging enabled: –
    Reference Transactions: –
    Used PayPal Checkout plugin: –

    ### 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
    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-28 01:00:51 +00:00
    Options: ?
    Notes: 36
    Onboarding: completed

    ### WooCommerce Payments ###

    Version: 4.4.0
    Connected to WPCOM: Yes
    Blog ID: 207428553
    Account ID: acct_1L4bKk2EtD9xzspe

    ### Action Scheduler ###

    Complete: 612
    Oldest: 2022-06-26 22:12:31 +0000
    Newest: 2022-07-27 07:19:12 +0000

    Failed: 29
    Oldest: 2022-07-07 13:11:11 +0000
    Newest: 2022-07-08 16:43:40 +0000

    Pending: 9
    Oldest: 2022-07-27 17:29:34 +0000
    Newest: 2022-08-02 12:18:21 +0000

    ### Status report information ###

    Generated at: 2022-07-27 07:42:22 +00:00
    `
    —————————————————————–
    If I need to update please are you referring to the woocoocommerce plug-in or what would I need to update and how? Please advise

    thank you so much for you help with this as we have been struggling with this for weeks.

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

    (@javay4395)

    The plugin was updated 2 weeks ago.

    Hi @javay4395,

    The log you shared points specifically to a connection issue.

    Please go to Marketing > Google Listings & Ads > Settings, at the bottom of the page click Disconnect from all accounts.

    After that, set up the extension again and connect to your existing merchant center account. That should resolve the issue you’re seeing.

    Let us know if you need further assistance.

    Thread Starter javay4395

    (@javay4395)

    I disconnected and reconnected big mistake seems to have broken all my free listing.

    I am able to see 91 listing but 4 are approved and 86 are disapproved. I had to wait 7 days to get them approved the last time.

    Another issue:
    all listings are not erroring in Merchant center. Is there a way to set the shipping weight( lbs ) in wordpress so that merchant center is not erroring out? I need to select lbs,oz,etc as well as availability(in-stock) in merchant center.

    Mirko P.

    (@rainfallnixfig)

    Hi @javay4395,

    Thanks for getting back to us.

    Sorry to hear you still have disapproved products – normally disconnecting and reconnecting won’t cause this if you haven’t updated the products but any issues requiring your attention will be listed on your Google Listings & Ads Product Feed and will include all the necessary details, including the affected products and suggested actions.

    You can edit products individually, or make edits in bulk through Products > Bulk actions > Edit. Your product feed will then should be synced automatically within 1–2 days.

    Is there a way to set the shipping weight( lbs ) in wordpress so that merchant center is not erroring out? I need to select lbs,oz,etc as well as availability(in-stock) in merchant center.

    It seems that you want to set [shipping_weight] (https://support.google.com/merchants/answer/6324503) and Availability (https://support.google.com/merchants/answer/6324448) as product attributes, correct? I can see in the product data that these values are not available by default but there’s already a pull request in Github to add extra product attributes – https://github.com/woocommerce/google-listings-and-ads/pull/428.

    If the problem with disapproved products persists, please contact us at WooCommerce.com > My Account > Support.

    You may need to log into your WooCommerce.com account before you can access that page.

    Include a link to this forum thread when you submit the ticket so that we can keep track of what’s already been done.

    Thanks.

    Thread Starter javay4395

    (@javay4395)

    thank you for your apply. I am in the process of working with google once again because no changes were made for my products to be disapproved. Matter of fact it states I am not eligible for free listing right after I disconnected and reconnected which caused all my products to be disapproved. I had to go through the same thing prior to disconnecting so I know it was that action that caused me to get my edibility revoked of free listing. So now I have to wait yet another week to get approved again before I can do anything regarding the underlining product disapproval. So yes disconnecting and reconnecting caused the issue.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Products not syncing since original connection to Google Listing’ is closed to new replies.