“Empty column header” error in Google Merchant

  • Resolved mugwumpr

    (@mugwumpr)


    5 years, 5 months ago

    Hello,

    I’ve been running your plugin for a month with no errors. Consistently error-free and around 25,000 products in the feed.

    In the last few days I’ve had all my products repeatedly disapproved in GMC due to a “empty column header” error. When I check the plugin’s feed settings, it’s showing processing at 101%.

    I shut the feed down, deactivate and reactivate the plugin, reactivate the feed and manually run the processing. It works for a day or so, then the error is back. Now, I only have ~600 products in my feed.

    I’ve made NO changes to the settings whatsoever once I got it set up initially.

    I’m using a pipe-delimited CSV file. When I tried using the XML file, it was just an undifferentiated block of text that GMC didn’t recognize.

    Any idea what borked when I wasn’t looking?

    Thanks!

Viewing 13 replies - 1 through 13 (of 13 total)
  • AdTribes.io Development Team

    (@jorisverwater)

    5 years, 5 months ago

    Hi mugwumpr,

    Thanks forusing our plugin and reaching out to us. We haven’t made any changes to the plugin the last 4 days and the releases before that could not have caused such behaviour. That is why I suspect it has something to do with your server-settings/configuration or a plugin you installed recently that is somehow conflicting or taking away server resources.

    Did you check the apache/wordpress and woocommerce logs to see if there is anything in there that points in the right direction? The thing to look for in the logs is “woo-product-feed-pro”. When you do find something then please copy/paste it in this topic.

    All the best,
    Eva

    Thread Starter mugwumpr

    (@mugwumpr)

    5 years, 5 months ago

    Hi Eva,

    Thanks for your reply. Sadly, there’s nothing in the logs that happened during the relevant time period.

    I’ve reset the logs and will watch them for anything useful.

    I’ve removed a few unused plugins lately, but I haven’t added any in the last week.

    AdTribes.io Development Team

    (@jorisverwater)

    5 years, 5 months ago

    Hi,

    Thanks for checking the logs. Sorry to hear you found nothing in it, that will make it hard to determine what is happening to your feed.

    Could you retrieve the debug.log of our plugin and copy/paste the URL? Instructions on how to retrieve the debug.log can be found here: https://adtribes.io/send-your-debug-log-to-support/

    We might be able to find some clues in it as to what is happening.

    All the best,
    Eva

    Thread Starter mugwumpr

    (@mugwumpr)

    5 years, 5 months ago

    Hi Eva,

    Here’s the link: https://dobrador.com/wp-content/uploads/woo-product-feed-pro/logs/debug.log

    It happened again last night, and this time there were entries in the error log (dozens of ’em)! I’ve posted a 3-minute selection below.

    [11-Aug-2019 08:32:00 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112878351 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:01 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879040 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:02 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879166 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:02 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879196 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:02 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879241 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:02 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879453 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:02 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879457 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:04 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879871 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:04 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879884 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:04 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879885 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:04 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879916 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:32:04 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112879919 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:13 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112895821 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:13 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112895828 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:13 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112895944,112895945 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:14 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112895967 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:14 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112895994 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:14 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112895999 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:14 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112896077 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:14 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112896101 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:14 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112896102 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[11-Aug-2019 08:33:14 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 112896133 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata

    Thanks for looking into this.

    AdTribes.io Development Team

    (@jorisverwater)

    5 years, 5 months ago

    Hi,

    Thanks for sending over the debug.log. I had a look at it and found that the product feed creation hasn’t been running that stable at all last couple of weeks.

    See this:
    https://www.dropbox.com/s/zyxjf1eh8zf4auo/not-stable.png?dl=0

    You’ll see that some days no update was done at all and number in your feed vary from 500 to 38.000 on any given day. Currently your CSV feed has about 32.000 items in it (header seems fine to us).

    I would advise to:
    – split the feed in smaller sizes of maximum 5000 – 10000 items per feed (use filters for this), meaning you would have to create a few feeds;
    – switch from CSV to XML file format as it is more stable.

    Best,
    Eva

    Thread Starter mugwumpr

    (@mugwumpr)

    5 years, 5 months ago

    Thanks for looking at it, Eva.

    It’s been pretty wobbly lately, for sure.

    I tried XML before, but it generated a solid block of undifferentiated text. Could that have been caused by the size of the file, too?

    Is there an easy way to filter based on number of records, or do I have to dig around for the product IDs? Yes, I’m looking for a lazy way to do this. ;o)

    AdTribes.io Development Team

    (@jorisverwater)

    5 years, 5 months ago

    Hi mugwumpr,

    The undifferentiated solid block of text most likely is indeed caused by the file size. It just means that the browser was unable to process the entire XML file, never reached the end of the file and as such did not recognise it as XML.

    Unfortunately there is no way to filter on number of records as you would need filters that support an AND statement. Ours do not do that yet. Filtering on category, product tags, product name or any other attribute is the most common way of doing this.

    All the best
    Eva

    Thread Starter mugwumpr

    (@mugwumpr)

    5 years, 5 months ago

    Hi Eva,

    I’ve divided it into 4 feeds based on categories, but the t-shirt category is still huge (~200 designs with 176 variations each). If I can’t make smaller feeds by subdividing it, is there a way to run it less frequently than daily?

    All 4 processing are using up all the resources on the server. Aside from adding new stuff periodically, there are few changes to any of it that would require daily updates. Updating weekly, biweekly, or even monthly would be plenty. Heck, even a manual on-demand option would work fine.

    Is there a snippet I could add for that? Or some wee tweak? I love the plugin, but it’s killing my store. It’s on a VPS with insanely high memory and processing settings already.

    Thank you for your help and patience.

    AdTribes.io Development Team

    (@jorisverwater)

    5 years, 5 months ago

    Hi mugwumpr,

    We are currently working on a version of the plugin that will only run a daily, twicedaily or hourly update when a change has been made to a product (price, stock, attributes). When no changes have been made to any product there is no use in updating the feeds and use server resources for it. I expect this version of the plugin to be released somewhere the upcoming month.

    Until then you can set the refresh interval of your feed(s) to “no refresh” and trigger a manual update of the feed whenever you want:
    https://www.dropbox.com/s/6u1okhkp0gpddue/refresh.png?dl=0

    Hope this helps?

    All the best,
    Eva

    Thread Starter mugwumpr

    (@mugwumpr)

    5 years, 5 months ago

    Hi Eva,

    That rocks, thanks!

    I totally missed the “no refresh” option. That does exactly what I need.

    Thank you so much for your help!

    Thread Starter mugwumpr

    (@mugwumpr)

    5 years, 5 months ago

    Sorry, I’m back.

    I set up 4 feeds, one for each of the 4 main categories, following the instructions on your blog. Filter –> Category equals “category name” –> include only.

    I ran them (which still takes hours, but whatever), and all have 0 products.

    There’s only the one filter, and a rule that applies the appropriate Google product category to everything in the file.

    There are 154 products (at about 175 variations each) in the T-Shirt category, but this is the processed feed: https://dobrador.com/wp-content/uploads/woo-product-feed-pro/xml/d4f5ef3078f29f93ddd9d78cabf29013.xml

    Debug log again: https://dobrador.com/wp-content/uploads/woo-product-feed-pro/logs/debug.log

    What am I doing wrong? I’m trying it with the Wall Art category by having it filter on the words “Wall Art” in the title instead of the category. It’s currently running.

    [Edited to add:]

    There are also tons of these errors in the log still:

    [14-Aug-2019 22:00:38 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 135440696,135440697 ) made by do_action_ref_array('woosea_cron_hook'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_create_all_feeds, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
[14-Aug-2019 22:00:38 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_postmeta WHERE meta_id IN( 135440889 ) made by do_action_ref_array('woosea_create_batch_event'), WP_Hook->do_action, WP_Hook->apply_filters, woosea_continue_batch, WooSEA_Get_Products->woosea_get_products, WP_Query->the_post, WP_Query->setup_postdata, do_action_ref_array('the_post'), WP_Hook->do_action, WP_Hook->apply_filters, auto_featured_image, set_post_thumbnail, delete_post_meta, delete_metadata
    • This reply was modified 5 years, 5 months ago by mugwumpr. Reason: Me know speel gud
    • This reply was modified 5 years, 5 months ago by mugwumpr.
    AdTribes.io Development Team

    (@jorisverwater)

    5 years, 5 months ago

    Hi,

    Thanks for sending over the debug.log. It does however show you have only 1 feed configured and not 4?

    Could you reach out to support@adtribes.io? Make sure to reference this topic in your email. We will take it from there.

    Best,
    Eva

    AdTribes.io Development Team

    (@jorisverwater)

    5 years, 4 months ago

    Hi,

    Assuming the issue at hand has been resolved or our support is no longer needed I am going to close this issue for housekeeping reasons now.

    Do not hesitate to reach out again whenever you need our help again.

    All the best,
    Eva

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘“Empty column header” error in Google Merchant’ is closed to new replies.