Export products hanging

Hey there, @lostguybrazil! Thanks for contacting us. I’m happy to help you.

I tried to replicate the issue on my website, but I was able to export the products.

To confirm, are you using the default WooCommerce exporter or are you using a plugin?

Can you please check if your database is updated? You can do it by either following the warning message a the top of the page on WooCommerce area of the dashboard or going to WooCommerce > Status > Tools > Update Database.

Be sure you have a good backup in place of your full site and database. You can ask your host for backup functionality or you can consider using a service like Jetpack. If something goes wrong, you will be able to restore it.

Can you also please share the Fatal error logs (if any) under WooCommerce > Status > Logs. Then you can use the selector to search for Fatal Errors.
You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

Looking forward to your reply.

Have a wonderful day!

Hi @carolm29, thanks for your answer. I am using the?default WooCommerce exporter.

I have run the WooCommerce > Status > Tools > Update Database and the problem persists. I have also checked for WooCommerce > Status > Logs > fatal-errors, but I don’t see anything related to this issue.

What I have noticed is that when I press Products > All Products > Export > Export Products, an export file is created in the /wp-content/uploads folder with the current timestamp (e.g. “wc-product-export-13-6-2024-1718306975189.csv”).

The export works fine if I don’t include the column “Attributes”.

Hello User (@lostguybrazil)

Thank you for your reply.

Could you try to export a small number of products like 10?
If that does not work try 5 and then 3.

I am trying to determine if that has to do anything with the amount of data generated by the number of products.

I checked and noticed that you cannot set a number of products to export.
But you can create a new category (Test Export) and add 10 products to it.
Then choose that category in the export settings.

Let me know about your findings. ??

Best regards.

Hi @doublezed2, thanks for your reply. I have tried to export a category with 10 products and another one with 7 products – and it did not work.

When I manually select a lot of columns (incl. all custom meta), the export works for all products: https://imgur.com/a/izhl3qo

When I add “Attributes”, it does not. I have tried to include only “Attributes” column and the export does not work.

So it seems that the problem is in that column.

Not sure if it’s worth mentioning, but I use the Germanized plugin.

Thanks and kind regards

Hey, @lostguybrazil!

It is possible this is caused by a conflict, but before we suggest a conflict test, can you please go to Tools > Site Health and see if there are any warnings there?

If there isn’t, please turn on debug mode, as explained here, so we can see if it generates error logs to give us clues on what is going on.

Looking forward to your reply.

Have a wonderful day!

Thanks, @carolm29 – seems to be a problem related to the Germanized plugin. I will contact the author of the plugin.

[20-Jun-2024 19:53:44 UTC] PHP Fatal error: Uncaught Error: Call to a member function get_name() on string in /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-content/plugins/woocommerce-germanized/includes/class-wc-gzd-product-attribute-helper.php:151
Stack trace: 0 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-content/plugins/woocommerce-germanized/includes/export/class-wc-gzd-product-export.php(217): WC_GZD_Product_Attribute_Helper->get_attribute() 1 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-includes/class-wp-hook.php(324): WC_GZD_Product_Export->export_product_attribute_data() 2 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-includes/plugin.php(205): WP_Hook->apply_filters() 3 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-content/plugins/woocommerce/includes/export/class-wc-product-csv-exporter.php(268): apply_filters() 4 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-content/plugins/woocommerce/includes/export/class-wc-product-csv-exporter.php(190): WC_Product_CSV_Exporter->generate_row_data() 5 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-content/plugins/woocommerce/includes/export/abstract-wc-csv-batch-exporter.php(117): WC_Product_CSV_Exporter->prepare_data_to_export() 6 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-content/plugins/woocommerce/includes/admin/class-wc-admin-exporters.php(165): WC_CSV_Batch_Exporter->generate_file() 7 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-includes/class-wp-hook.php(324): WC_Admin_Exporters->do_ajax_product_export() 8 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() 9 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-includes/plugin.php(517): WP_Hook->do_action() 10 /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-admin/admin-ajax.php(192): do_action() 11 {main}

thrown in /var/www/vhosts/MYWEBSITE.COM/httpdocs/wp-content/plugins/woocommerce-germanized/includes/class-wc-gzd-product-attribute-helper.php on line 151

Hi @lostguybrazil,

seems to be a problem related to the?Germanized plugin. I will contact the author of the plugin.

Thanks for confirming that the issue was with the Germanized plugin. As this is a third-party plugin, their support team stands a better chance at helping troubleshoot the issue even further.

With that said, I’ll go ahead and mark this thread as solved. Feel free to reach out if you have any further questions and concerns.

All the best.