• Resolved timgood85

    (@timgood85)


    Hi,

    I am looking for the option to refresh the feed in some way but cannot see it anywhere. I have made changes and want to see them reflected in merchant center but cannot see how to expedite the process. Sure, I don’t just have to wait ‘1-2days’?

    Cheers

Viewing 15 replies - 1 through 15 (of 25 total)
  • Hi @timgood85,

    I understand you’re looking to force the feed to refresh. Typically, whenever a product is created or updated, it is synced instantly to Google Merchant Center.

    You’d have to allow some time for the products to reflect in Google Merchant Center. I’m afraid there’s no way around that.

    Thread Starter timgood85

    (@timgood85)

    Hi,

    Thanks for the reply. This seems like a swing and a miss. Instead of clicking a button, I am left to faff around not knowing what level of change will be high enough to cause a recall of all items.

    Well, it’s free and I guess am getting what I pay for.

    Cheers,

    Hi @timgood85,

    Perhaps I misunderstood your question.

    Indeed, the extension automatically syncs product changes to GMC, however, you can access a “Sync All Products with Google Merchant Center” button by going to example/wp-admin/admin.php?page=connection-test-admin-page (Replace example.com with your domain)

    You’ll find the button at the bottom of the page.

    This may not ensure the product is updated immediately in GMC listings, you’d have to allow it some time for GMC to update the product listings.

    >I am left to faff around not knowing what level of change will be high enough to cause a recall of all items.

    The extension doesn’t sync changes based on the level of change, any change to a product forces a sync.

    I hope that answers your question.

    Thread Starter timgood85

    (@timgood85)

    Hi Sunday,

    In that case, I have to climb down off my high horse and apologise! Sorry for being snarky. Thanks for the help. I will check this out but it looks like it’s exactly what I was after.

    Thanks again.

    No worries! We’re here for you and always happy to help.

    I’ll go ahead and mark this thread as resolved now.

    Thread Starter timgood85

    (@timgood85)

    Hi Sunday,

    All of my products have expired, as the plugin doesn’t seem to be refreshing them. I have attempted to synd via /admin.php?page=connection-test-admin-page but when selecting ‘Sync All Products with Google Merchant Center’ my site crashes with a critical error. I have now updated 1 product and synced it individually and it is live on Merchant Center. Can you think of any way I can push the whole product catalogue live again? I have 19000 products, so 1 at a time is not an option.

    Cheers,

    Hello,

    Can you provide the error messages received?

    You can navigate to WooCommerce > System Status > Logs, then share in your response the errors received.

    We’ll look forward to hearing from you.

    Thread Starter timgood85

    (@timgood85)

    Hi,

    2022-09-19T12:45:09+00:00 CRITICAL Out of memory (allocated 2097152) (tried to allocate 2919648 bytes) in /home/virtual/vps-499a0b/c/cccada0f48/public_html/wp-content/plugins/vitesse-stock-import/public/class-vitesse-stock-import-public.php on line 116
    
    2022-09-19T12:45:24+00:00 CRITICAL Out of memory (allocated 50331648) (tried to allocate 32768 bytes) in /home/virtual/vps-499a0b/c/cccada0f48/public_html/wp-content/plugins/google-listings-and-ads/src/API/Site/Controllers/MerchantCenter/ShippingRateController.php on line 1

    It would appear I am out of memory but I have a massive memory limit of 2048. Any ideas?

    • This reply was modified 2 years, 1 month ago by timgood85.

    Hi @timgood85

    Thanks for sharing the error logs.

    I understand that you have a massive memory limit but still receives the error logs above when trying to sync the products again.

    I’d like to understand your site properly, can you please share your System Status Report, that will help us further troubleshoot.

    You can find it via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

    Thread Starter timgood85

    (@timgood85)

    Hi,

    Sure:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://vitesse-ltd.co.uk
    Site address (URL): https://vitesse-ltd.co.uk
    WC Version: 7.0.0
    REST API Version: ? 7.0.0
    WC Blocks Version: ? 8.5.1
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0.3
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_GB
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.30
    PHP Post Max Size: 512 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 2500
    cURL Version: 7.79.1
    OpenSSL/1.1.1g-fips
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.4.24-MariaDB-log
    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.4
    WC Database Prefix: 23_
    Total Database Size: 787.03MB
    Database Data Size: 482.88MB
    Database Index Size: 304.15MB
    23_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    23_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    23_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_woocommerce_order_itemmeta: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
    23_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    23_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_actionscheduler_actions: Data: 122.44MB + Index: 137.25MB + Engine InnoDB
    23_actionscheduler_claims: Data: 0.13MB + Index: 0.08MB + Engine InnoDB
    23_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_actionscheduler_logs: Data: 37.56MB + Index: 24.06MB + Engine InnoDB
    23_cmplz_cookiebanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_cmplz_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_cmplz_services: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_comments: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
    23_dgwt_wcas_index: Data: 8.52MB + Index: 0.42MB + Engine InnoDB
    23_dgwt_wcas_invindex_cache: Data: 0.23MB + Index: 0.03MB + Engine InnoDB
    23_dgwt_wcas_invindex_doclist: Data: 7.52MB + Index: 8.03MB + Engine InnoDB
    23_dgwt_wcas_invindex_wordlist: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
    23_dgwt_wcas_stats: Data: 0.27MB + Index: 0.00MB + Engine InnoDB
    23_dgwt_wcas_var_index: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    23_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
    23_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    23_e_submissions: Data: 0.05MB + Index: 0.27MB + Engine InnoDB
    23_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    23_e_submissions_values: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    23_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
    23_gla_merchant_issues: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    23_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    23_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_options: Data: 20.03MB + Index: 7.50MB + Engine InnoDB
    23_postmeta: Data: 182.72MB + Index: 69.17MB + Engine InnoDB
    23_posts: Data: 19.55MB + Index: 8.06MB + Engine InnoDB
    23_termmeta: Data: 0.38MB + Index: 0.38MB + Engine InnoDB
    23_terms: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
    23_term_relationships: Data: 4.52MB + Index: 2.52MB + Engine InnoDB
    23_term_taxonomy: Data: 0.16MB + Index: 0.11MB + Engine InnoDB
    23_tm_taskmeta: Data: 2.52MB + Index: 0.34MB + Engine InnoDB
    23_tm_tasks: Data: 1.52MB + Index: 0.13MB + Engine InnoDB
    23_usermeta: Data: 0.48MB + Index: 0.06MB + Engine InnoDB
    23_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    23_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    23_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wc_category_lookup: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
    23_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    23_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    23_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wc_product_meta_lookup: Data: 4.52MB + Index: 6.09MB + Engine InnoDB
    23_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    23_wfconfig: Data: 0.47MB + Index: 0.00MB + Engine InnoDB
    23_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wffilemods: Data: 16.55MB + Index: 0.00MB + Engine InnoDB
    23_wfhits: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
    23_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    23_wfknownfilelist: Data: 7.52MB + Index: 0.00MB + Engine InnoDB
    23_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wflogins: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    23_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    23_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    23_wfstatus: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
    23_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wpf_meta_data: Data: 5.52MB + Index: 11.58MB + Engine InnoDB
    23_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wpf_meta_values: Data: 0.02MB + Index: 0.94MB + Engine InnoDB
    23_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wpf_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wpf_modules_type: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_wpf_usage_stat: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_wpml_mails: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    23_wpr_rocket_cache: Data: 3.52MB + Index: 3.33MB + Engine InnoDB
    23_wpr_rucss_used_css: Data: 0.36MB + Index: 0.61MB + Engine InnoDB
    23_xyz_ips_short_code: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    23_yoast_indexable: Data: 26.55MB + Index: 18.09MB + Engine InnoDB
    23_yoast_indexable_hierarchy: Data: 1.52MB + Index: 1.09MB + Engine InnoDB
    23_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    23_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    23_yoast_seo_links: Data: 0.16MB + Index: 0.11MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 33240
    br_product_tab: 2
    br_tabs_location: 1
    custom_css: 3
    customize_changeset: 3
    elementor_icons: 1
    elementor_library: 30
    jet-menu: 5
    nav_menu_item: 51
    page: 12
    post: 3
    product: 19546
    revision: 492
    shop_coupon: 5
    shop_order: 73
    shop_order_refund: 10
    wp_global_styles: 4
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (30) ###
    
    ManageWP - Worker: by GoDaddy – 4.9.14
    FiboSearch - AJAX Search for WooCommerce (Pro): by FiboSearch Team – 1.20.2
    Complianz | GDPR/CCPA Cookie Consent: by Really Simple Plugins – 6.3.4
    Elementor Pro: by Elementor.com – 3.7.7
    Elementor: by Elementor.com – 3.7.8
    Facebook for WooCommerce: by Facebook – 2.6.27
    Feefo Ratings & Reviews: by Feefo – 1.0.8
    GazChap's WooCommerce Auto Category Product Thumbnails: by Gareth 'GazChap' Griffiths – 1.4
    Google Listings and Ads: by WooCommerce – 2.1.4
    OMGF: by Daan from Daan.dev – 5.4.1
    Insert PHP Code Snippet: by xyzscripts.com – 1.3.3
    JetMenu: by Crocoblock – 2.2.3
    HubSpot All-In-One Marketing - Forms, Popups, Live Chat: by HubSpot – 9.0.123
    Limit log in attempts reloaded: by Limit log in attempts reloaded – 2.25.7
    Product Tabs Manager for WooCommerce: by BeRocket – 1.1.5.6
    Vitesse Stock Import: by Pagecode – 1.0.0
    WooCommerce Manual Payment: by bfl – 2.6.11
    Product Filter by WooBeWoo: by WooBeWoo – 2.2.1
    Payment Plugins for Stripe WooCommerce: by Payment Plugins
    [email protected] – 3.3.28
    
    WooCommerce Google Analytics Integration: by WooCommerce – 1.5.15
    WooCommerce Min/Max Quantities: by WooCommerce – 2.4.24 (update to version 4.0.3 is available)
    WooCommerce PayPal Payments: by WooCommerce – 1.9.4
    WooCommerce: by Automattic – 7.0.0
    Wordfence Security: by Wordfence – 7.7.1
    Yoast SEO: by Team Yoast – 19.8
    Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.8.7
    WP Mail Logging: by Wysija – 1.10.4
    WP-Optimize - Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.2.9
    
    WP Rocket: by WP Media – 3.12.1.1
    Sequential Order Numbers for WooCommerce: by WebToffee – 1.4.8
    
    ### Inactive Plugins (0) ###
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (2) ###
    
    ManageWP - Worker Loader: by GoDaddy – 1.0.0
    StackCache: by Stack CP –
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: GBP (£)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    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: #14 - /shop/
    Basket: ? 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: #17 - /my-account/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Hello Elementor Child
    Version: 1.0.1
    Author URL: https://elementor.com/
    Child Theme: ?
    Parent Theme Name: Hello Elementor
    Parent Theme Version: 2.6.1
    Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: –
    
    ### WooCommerce PayPal Payments ###
    
    Onboarded: ?
    Shop country code: GB
    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: –
    Tracking enabled: –
    
    ### 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
    multichannel-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
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2022-10-19 09:49:53 +01:00
    Options: ?
    Notes: 51
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 64
    Oldest: 2022-10-18 13:47:31 +0100
    Newest: 2022-10-18 14:48:39 +0100
    
    Pending: 476,461
    Oldest: -0001-11-29 23:58:45 -0001
    Newest: 2022-10-18 14:42:48 +0100
    
    In-progress: 1
    Oldest: –
    Newest: –
    
    Failed: 476
    Oldest: 2022-09-09 10:14:31 +0100
    Newest: 2022-09-08 05:42:03 +0100
    
    ### Status report information ###
    
    Generated at: 2022-10-18 14:49:46 +01:00
    

    i set the memory back to 1024 as it did not solve the problem when at 2048.

    Hello,
    Thanks for sending the system report.

    Pending: 476,461
    Failed: 476

    Please navigate to WooCommerce > status > scheduled actions. You will see the site has a lot of pending actions.

    A plugin like the WP Crontrol might help you with that you can check what is happening to the cron jobs (It might help you to identify what could be affecting the syncing). Please note that Google Listings and Ads uses the Action Scheduler to sync the products.

    I hope this helps. Let us know how that goes.

    Thread Starter timgood85

    (@timgood85)

    Hi Igor,

    This might help. Are you saying that this is the cause of the issue?

    HI @timgood85

    These pending actions are cron jobs that use WordPress WP-Cron to function. Sometimes, the cron jobs are not executed properly due to troubles with servers.

    As there’s a large number of pending actions, I would give Igor’s suggestions a go and see if this works.

    Let us know how it goes!

    Thread Starter timgood85

    (@timgood85)

    Hi,

    I have sorted out all the major issues, it turned out to be an issue caused by an error on WPRocket cache, however, I am left with 1 question:

    My products are all syncing daily now, and those with updated pricing have 30 day expires on them, however, some have an expiry date that indicates that they will expire in 24 days, despite them last updating this morning. Is this normal or is it the case that each product actually needs manually updating re content in order to refresh o 30 days?

    Cheers

    Hi there @timgood85 ??

    I have sorted out all the major issues, it turned out to be an issue caused by an error on WPRocket cache

    Thanks for sharing the findings!

    I am left with 1 question:

    My products are all syncing daily now, and those with updated pricing have 30 day expires on them, however, some have an expiry date that indicates that they will expire in 24 days, despite them last updating this morning. Is this normal or is it the case that each product actually needs manually updating re content in order to refresh o 30 days?

    Per the answer provided at How does the product feed sync between Woo and Google work?:

    “To keep the product information displayed in Shopping ads and free listings up-to-date, all products synced to Google Merchant Center expire after 30 days if they are not updated. A daily update job is scheduled to run at 3 AM (store time) to re-sync the expiring products and keep them active. A product is marked as expiring if it expires within three days.”

    I hope that helps, otherwise let us know.

Viewing 15 replies - 1 through 15 (of 25 total)
  • The topic ‘Refresh feed’ is closed to new replies.