Advanced Order Export

Hello Alex,

I’m using your plugin “Advanced Order Export For WooCommerce” to generate my report. Every time I click the button “EXPORT”, the SQL requests sent to the database crashes my website, leaving the Front End with a 504 Error (Timeout). I’ve been in touch with my hosting for the last 7 days. We checked all the parameters of the hosting in order to fix the issue. I even went to migrate to a new hosting which offered better performances and stability.

I managed to visualize the SQL Request sent by the plugin when I press “Export” and here is the result (I apologies for the length of this response) :
—————————————————————————————
# User@Host: devservicesenlig_dev_user[devservicesenlig_dev_user] @ localhost []
# Thread_id: 351 Schema: devservicesenlig_dev1 QC_hit: No
# Query_time: 934.750202 Lock_time: 0.001023 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0
SET timestamp=1549474550;
SELECT ID AS order_id FROM wp_posts AS orders
LEFT JOIN wp_postmeta AS ordermeta_cf_1 ON ordermeta_cf_1.post_id = orders.ID AND ordermeta_cf_1.meta_key=’Payer first name’ LEFT JOIN wp_postmeta AS ordermeta_cf_2 ON ordermeta_cf_2.post_id = orders.ID AND ordermeta_cf_2.meta_key=’Payer last name’ LEFT JOIN wp_postmeta AS ordermeta_cf_3 ON ordermeta_cf_3.post_id = orders.ID AND ordermeta_cf_3.meta_key=’_billing_address_1′ LEFT JOIN wp_postmeta AS ordermeta_cf_4 ON ordermeta_cf_4.post_id = orders.ID AND ordermeta_cf_4.meta_key=’_billing_address_2′ LEFT JOIN wp_postmeta AS ordermeta_cf_5 ON ordermeta_cf_5.post_id = orders.ID AND ordermeta_cf_5.meta_key=’_billing_city’ LEFT JOIN wp_postmeta AS ordermeta_cf_6 ON ordermeta_cf_6.post_id = orders.ID AND ordermeta_cf_6.meta_key=’_billing_company’ LEFT JOIN wp_postmeta AS ordermeta_cf_7 ON ordermeta_cf_7.post_id = orders.ID AND ordermeta_cf_7.meta_key=’_billing_country’ LEFT JOIN wp_postmeta AS ordermeta_cf_8 ON ordermeta_cf_8.post_id = orders.ID AND ordermeta_cf_8.meta_key=’_billing_email’ LEFT JOIN wp_postmeta AS ordermeta_cf_9 ON ordermeta_cf_9.post_id = orders.ID AND ordermeta_cf_9.meta_key=’_billing_phone’ LEFT JOIN wp_postmeta AS ordermeta_cf_10 ON ordermeta_cf_10.post_id = orders.ID AND ordermeta_cf_10.meta_key=’confirm_email’ LEFT JOIN wp_postmeta AS ordermeta_cf_11 ON ordermeta_cf_11.post_id = orders.ID AND ordermeta_cf_11.meta_key=’miam_autorisation_info_perso’ LEFT JOIN wp_postmeta AS ordermeta_cf_12 ON ordermeta_cf_12.post_id = orders.ID AND ordermeta_cf_12.meta_key=’miam_college_royal’ LEFT JOIN wp_postmeta AS ordermeta_cf_13 ON ordermeta_cf_13.post_id = orders.ID AND ordermeta_cf_13.meta_key=’miam_fonction’ LEFT JOIN wp_postmeta AS ordermeta_cf_14 ON ordermeta_cf_14.post_id = orders.ID AND ordermeta_cf_14.meta_key=’miam_lieu_apprentissage’ LEFT JOIN wp_postmeta AS ordermeta_cf_15 ON ordermeta_cf_15.post_id = orders.ID AND ordermeta_cf_15.meta_key=’miam_matricule’ LEFT JOIN wp_postmeta AS ordermeta_cf_16 ON ordermeta_cf_16.post_id = orders.ID AND ordermeta_cf_16.meta_key=’miam_niveau_programme’ LEFT JOIN wp_postmeta AS ordermeta_cf_17 ON ordermeta_cf_17.post_id = orders.ID AND ordermeta_cf_17.meta_key=’miam_nom_programme’ LEFT JOIN wp_postmeta AS ordermeta_cf_18 ON ordermeta_cf_18.post_id = orders.ID AND ordermeta_cf_18.meta_key=’miam_recevoir_info’ LEFT JOIN wp_postmeta AS ordermeta_cf_19 ON ordermeta_cf_19.post_id = orders.ID AND ordermeta_cf_19.meta_key=’miam_service’ LEFT JOIN wp_postmeta AS ordermeta_cf_20 ON ordermeta_cf_20.post_id = orders.ID AND ordermeta_cf_20.meta_key=’miam_sofeduq’
WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.post_date>=’2019-01-15 00:00:00′ AND orders.post_date<=’2019-02-04 23:59:59′ AND orders.post_status NOT in (‘auto-draft’,’trash’) AND ( ordermeta_cf_1.meta_value IN (’empty’) ) AND ( ordermeta_cf_2.meta_value IN (’empty’) ) AND ( ordermeta_cf_3.meta_value IN (’empty’) ) AND ( ordermeta_cf_4.meta_value IN (’empty’) ) AND ( ordermeta_cf_5.meta_value IN (’empty’) ) AND ( ordermeta_cf_6.meta_value IN (’empty’) ) AND ( ordermeta_cf_7.meta_value IN (’empty’) ) AND ( ordermeta_cf_8.meta_value IN (’empty’) ) AND ( ordermeta_cf_9.meta_value IN (’empty’) ) AND ( ordermeta_cf_10.meta_value IN (’empty’) ) AND ( ordermeta_cf_11.meta_value IN (’empty’) ) AND ( ordermeta_cf_12.meta_value IN (’empty’) ) AND ( ordermeta_cf_13.meta_value IN (’empty’) ) AND ( ordermeta_cf_14.meta_value IN (’empty’) ) AND ( ordermeta_cf_15.meta_value IN (’empty’) ) AND ( ordermeta_cf_16.meta_value IN (’empty’) ) AND ( ordermeta_cf_17.meta_value IN (’empty’) ) AND ( ordermeta_cf_18.meta_value IN (’empty’) ) AND ( ordermeta_cf_19.meta_value IN (’empty’) ) AND ( ordermeta_cf_20.meta_value IN (’empty’) ) AND orders.ID IN (SELECT DISTINCT order_items.order_id FROM wp_woocommerce_order_items as order_items
LEFT JOIN wp_woocommerce_order_itemmeta AS orderitemmeta_product ON orderitemmeta_product.order_item_id = order_items.order_item_id
WHERE order_item_type=’line_item’ AND (orderitemmeta_product.meta_key IN (‘_variation_id’, ‘_product_id’) AND orderitemmeta_product.meta_value<>’0′ AND orderitemmeta_product.meta_value IN (‘4691’)) );
—————————————————————————————
I tried exporting the report for a few days, for only ONE day, I’m still experiencing the same issue.

Thank you in advance for any help you can give me.

Regards,

T.

Hello Alex,

I followed your advice, I cleared all the filters, pressed Export and it works perfectly.
Thanks for the help.

T.