Title: Export not generating data Last modified: June 13, 2022 --- # Export not generating data * [bastienkoert](https://wordpress.org/support/users/bastienkoert/) * (@bastienkoert) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/) * Hi, * When running the exporter, i can’t get any data out of the system. This was working in staging and we tested it when going live. I know there are new sales in the WC that haven’t been exported yet. * Can you let me know what tables are used to store the .’mark as exported’ data? Then i can check the records to see if there are no records that need exporting. Also is there a way to see what filters are running in the SQL or via the interface to see what other items might be factors in not getting data? * Thanks, * Bastien Koert Viewing 15 replies - 1 through 15 (of 15 total) * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15734641) * Hi Bastien * We add new record to wp_postmeta, meta_key = woe_order_exported. * Please, open section “Misc Settings”, mark “Enable debug output” and press Preview. * Thread Starter [bastienkoert](https://wordpress.org/support/users/bastienkoert/) * (@bastienkoert) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15736344) * Hi * We did try the debug option, it provided no output. There was nothing in the wc logs * Thanks, * Bastien * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15736465) * Could you please switch format to XLS and press Preview? * Thread Starter [bastienkoert](https://wordpress.org/support/users/bastienkoert/) * (@bastienkoert) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15736683) * no results after changing it to xls from xml * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15736835) * What do you see when you press Preview? * Please, use browser to check JS errors too. Short guide – [https://wordpress.org/support/article/using-your-browser-to-diagnose-javascript-errors/#step-3-diagnosis](https://wordpress.org/support/article/using-your-browser-to-diagnose-javascript-errors/#step-3-diagnosis) * Thread Starter [bastienkoert](https://wordpress.org/support/users/bastienkoert/) * (@bastienkoert) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15736908) * * is all that appears. no JS console errors. * I was getting an error about not being able to read the traits file * `[Tue Jun 14 15:16:56.386556 2022] [proxy_fcgi:error] [pid 10386:tid 140453500393216][ client 76.64.206.160:58238] AH01071: Got error 'PHP message: PHP Warning: include( classes/admin/tabs/ajax/trait-wc-order-export-ajax-helpers.php): failed to open stream: No such file or directory in /var/www/vhosts/shopjetersystems.com/httpdocs/ wp-content/plugins/woo-order-export-lite/woo-order-export-lite.php on line 65PHP message: PHP Warning: include(classes/admin/tabs/ajax/trait-wc-order-export-ajax- helpers.php): failed to open stream: No such file or directory in /var/www/vhosts/ shopjetersystems.com/httpdocs/wp-content/plugins/woo-order-export-lite/woo-order- export-lite.php on line 65PHP message: PHP Warning: include(): Failed opening' classes/admin/tabs/ajax/trait-wc-order-export-ajax-helpers.php' for inclusion( include_path='.:/opt/plesk/php/7.4/share/pear') in /var/www/vhosts/shopjetersystems. com/httpdocs/wp-content/plugins/woo-order-export-lite/woo-order-export-lite.php on line 65PHP message: PHP Fatal error: Trait 'WC_Order_Export_Ajax_Helpers' not found in /var/www/vhosts/shopjetersystems.com/httpdocs/wp-content/plugins/ woo-order-export-lite/classes/admin/tabs/ajax/trait-wc-order-export-admin-tab- abstract-ajax-export.php on line 6', referer: https://shopjetersystems.com/` * But i dont see that anymore. The only other error is this one [Tue Jun 14 16: 43:14.881954 2022] [proxy_fcgi:error] [pid 21446:tid 140453627664128] [client 67.213.92.222:54402] AH01071: Got error ‘PHP message: billing_email was called incorrectly. Order properties should not be accessed directly. Backtrace: do_action(‘ wp_ajax_getswp’), WP_Hook->do_action, WP_Hook->apply_filters, getswp, WC_Abstract_Legacy_Order- >__get, wc_doing_it_wrong. This message was added in version 3.0.’, referer: [https://shopjetersystems.com/](https://shopjetersystems.com/) * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15736916) * Please, submit your settings as new ticekt to [https://algolplus.freshdesk.com/](https://algolplus.freshdesk.com/) * Use tab Tools to get them * Thread Starter [bastienkoert](https://wordpress.org/support/users/bastienkoert/) * (@bastienkoert) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15737142) * Just to let you know this works in our staging environment with the same settings * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15737206) * Ok. * What do you see when you press Preview? * Thread Starter [bastienkoert](https://wordpress.org/support/users/bastienkoert/) * (@bastienkoert) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15737302) * in live or staging? * live setings * ``` { "now": { "version": "2.0", "mode": "now", "title": "", "skip_empty_file": true, "log_results": false, "from_status": [], "to_status": [], "change_order_status_to": "", "statuses": [ "wc-pending", "wc-processing", "wc-on-hold", "wc-completed" ], "from_date": "", "to_date": "", "sub_start_from_date": "", "sub_start_to_date": "", "sub_end_from_date": "", "sub_end_to_date": "", "sub_next_paym_from_date": "", "sub_next_paym_to_date": "", "from_order_id": " ", "to_order_id": " ", "shipping_locations": [], "shipping_methods": [], "item_names": [], "item_metadata": [], "user_roles": [], "user_names": [], "user_custom_fields": [], "billing_locations": [], "payment_methods": [], "any_coupon_used": "0", "coupons": [], "order_custom_fields": [], "product_categories": [], "product_vendors": [], "products": [], "product_sku": "", "exclude_products": [], "product_taxonomies": [], "product_custom_fields": [], "product_attributes": [], "product_itemmeta": [], "format": "XML", "format_xls_use_xls_format": "0", "format_xls_sheet_name": "Orders", "format_xls_display_column_names": "1", "format_xls_auto_width": "1", "format_xls_direction_rtl": "0", "format_xls_force_general_format": "0", "format_xls_remove_emojis": "0", "format_xls_row_images_width": "50", "format_xls_row_images_height": "50", "format_csv_enclosure": "\"", "format_csv_delimiter": ",", "format_csv_linebreak": "\\r\\n", "format_csv_display_column_names": "1", "format_csv_add_utf8_bom": "0", "format_csv_item_rows_start_from_new_line": "0", "format_csv_encoding": "UTF-8", "format_csv_delete_linebreaks": "0", "format_csv_remove_linebreaks": "0", "format_csv_force_quotes": "0", "format_tsv_linebreak": "\\r\\n", "format_tsv_display_column_names": "1", "format_tsv_add_utf8_bom": "0", "format_tsv_item_rows_start_from_new_line": "0", "format_tsv_encoding": "UTF-8", "format_xml_root_tag": "orders", "format_xml_order_tag": "order", "format_xml_product_tag": "item", "format_xml_coupon_tag": "coupon", "format_xml_prepend_raw_xml": "", "format_xml_append_raw_xml": "", "format_xml_self_closing_tags": "1", "format_xml_preview_format": "0", "format_json_start_tag": "[", "format_json_end_tag": "]", "format_json_unescaped_slashes": 0, "format_json_numeric_check": 0, "format_json_encode_unicode": 0, "format_pdf_display_column_names": "1", "format_pdf_repeat_header": "1", "format_pdf_direction_rtl": 0, "format_pdf_orientation": "L", "format_pdf_page_size": "A4", "format_pdf_font_size": "8", "format_pdf_header_text": "", "format_pdf_footer_text": "", "format_pdf_pagination": "C", "format_pdf_fit_page_width": "0", "format_pdf_cols_width": "25", "format_pdf_cols_align": "L", "format_pdf_cols_vertical_align": "T", "format_pdf_page_header_text_color": "#000000", "format_pdf_page_footer_text_color": "#000000", "format_pdf_table_header_text_color": "#000000", "format_pdf_table_header_background_color": "#FFFFFF", "format_pdf_table_row_text_color": "#000000", "format_pdf_table_row_background_color": "#FFFFFF", "format_pdf_logo_source_id": "0", "format_pdf_logo_source": "", "format_pdf_logo_width": "0", "format_pdf_logo_height": "15", "format_pdf_logo_align": "R", "format_pdf_row_images_width": "15", "format_pdf_row_images_height": "15", "format_pdf_row_images_add_link": "0", "format_pdf_row_dont_page_break_order_lines": "0", "format_html_display_column_names": "1", "format_html_repeat_header_last_line": "0", "format_html_font_size": "13", "format_html_header_text": "", "format_html_footer_text": "", "format_html_cols_align": "L", "format_html_header_text_color": "#000000", "format_html_footer_text_color": "#000000", "format_html_table_header_text_color": "#000000", "format_html_table_header_background_color": "#FFFFFF", "format_html_table_row_text_color": "#000000", "format_html_table_row_background_color": "#FFFFFF", "format_html_row_images_width": "100", "format_html_row_images_height": "100", "format_html_images_add_link": "0", "format_html_custom_css": "", "all_products_from_order": "1", "skip_refunded_items": "0", "skip_suborders": "0", "export_refunds": "0", "export_matched_items": "0", "date_format": "Y-m-d", "time_format": "H:i", "sort_direction": "DESC", "sort": "order_id", "format_number_fields": "0", "export_all_comments": "0", "export_refund_notes": "0", "strip_tags_product_fields": "0", "round_item_tax_rate": "0", "cleanup_phone": "0", "convert_serialized_values": "0", "enable_debug": "0", "billing_details_for_shipping": "0", "custom_php": "1", "custom_php_code": "", "mark_exported_orders": "1", "export_unmarked_orders": "1", "summary_report_by_products": "0", "duplicated_fields_settings": [], "summary_report_by_customers": "0", "order_fields": [ { "segment": "common", "key": "order_number", "label": "Order Number", "format": "string", "colname": "order_number" }, { "segment": "common", "key": "order_status", "label": "Order Status", "format": "string", "colname": "order_status" }, { "segment": "common", "key": "order_date", "label": "Order Date", "format": "date", "colname": "order_date" }, { "segment": "ship_calc", "key": "order_shipping", "label": "Order Shipping Amount", "format": "money", "colname": "order_shipping" }, { "segment": "totals", "key": "order_total", "label": "Order Total Amount", "format": "money", "colname": "order_total" }, { "segment": "totals", "key": "plain_orders__purchase_order_number", "label": "_purchase_order_number", "format": "string", "colname": "po_number" }, { "segment": "misc", "key": "_shipping_trading_partner_code", "label": "_shipping_trading_partner_code", "format": "string", "colname": "csi_code" }, { "segment": "products", "key": "products", "label": "Products", "format": "undefined", "colname": "items" }, { "segment": "coupons", "key": "coupons", "label": "Coupons", "format": "undefined", "colname": "coupons" }, { "segment": "shipping", "key": "plain_orders_shipping_phone_number", "label": "shipping_phone_number", "format": "string", "colname": "shipping_telephone" } ], "order_product_fields": [ { "label": "SKU", "key": "sku", "segment": "products", "format": "string", "colname": "sku" }, { "label": "Item Name", "key": "name", "segment": "products", "format": "string", "colname": "name" }, { "label": "Quantity", "key": "qty", "segment": "products", "format": "number", "colname": "qty" }, { "label": "Item Cost", "key": "item_price", "segment": "products", "format": "money", "colname": "price" }, { "label": "box_size", "key": "box_size", "segment": "products", "format": "string", "colname": "box_size" }, { "label": "Item Discount Amount", "key": "discount_amount", "segment": "products", "format": "money", "colname": "item_discount" } ], "order_coupon_fields": [ { "label": "Coupon Code", "key": "code", "segment": "coupons", "format": "string", "colname": "code" } ], "id": 0, "post_type": "shop_order", "export_rule_field": "date", "export_filename": "850_EXT.xml", "summary_row_title": "Total" }, "profiles": [], "cron": [], "order-action": [] } ``` * Thread Starter [bastienkoert](https://wordpress.org/support/users/bastienkoert/) * (@bastienkoert) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15737385) * Would you like access to the backend? * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15738132) * Yes, everything is ok with settings. * What do you see when you press Preview ? For XML format. * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15738142) * My bad, the settings is NOT ok. * Please, go to section “Orders Range” and remove space in each field. * Thread Starter [bastienkoert](https://wordpress.org/support/users/bastienkoert/) * (@bastienkoert) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15740416) * thanks, that did it. * Can i suggest maybe a trim() on those two fields to prevent similar situations in the future? * Thanks, * Bastien * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15740434) * yes, we did it just now 😉 Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘Export not generating data’ is closed to new replies. * ![](https://ps.w.org/woo-order-export-lite/assets/icon-256x256.png?rev=1365554) * [Advanced Order Export For WooCommerce](https://wordpress.org/plugins/woo-order-export-lite/) * [Frequently Asked Questions](https://wordpress.org/plugins/woo-order-export-lite/#faq) * [Support Threads](https://wordpress.org/support/plugin/woo-order-export-lite/) * [Active Topics](https://wordpress.org/support/plugin/woo-order-export-lite/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woo-order-export-lite/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woo-order-export-lite/reviews/) * 15 replies * 2 participants * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/) * Last activity: [3 years, 12 months ago](https://wordpress.org/support/topic/export-not-generating-data/#post-15740434) * Status: not resolved