Title: Missing orders during export Last modified: November 18, 2024 --- # Missing orders during export * [ohdearbambi](https://wordpress.org/support/users/ohdearbambi/) * (@ohdearbambi) * [1 year, 6 months ago](https://wordpress.org/support/topic/missing-orders-during-export/) * Hello, I keep on getting missing orders when I try to export my orders. My admins would bulk change orders to the processing status before exporting, and after exporting they will be switched to the completed status. For a bit of context we need to export quite a bit of orders in one go, about 40 ish orders at a time. As my admins were trying to export processing orders, some orders would not show up in the excel file. * I did not personally test out mass exporting on orders with the processing status since it would hinder my admins workflow. But I tried to export orders that did not show when my admin exported, the only difference was that I was exporting them when the status of those orders are completed. The orders that did not show up at first, did show up during my testing. * I tried to find if there were issues similar to what I’m experiencing by the support thread and found [this](https://wordpress.org/support/topic/missing-orders-on-export/) thread. It seemed similar to what I was having now, but I do not have “Summary report by customers” mode on, so not the fix I needed. * I’ve updated the plugin to the latest version yesterday, but even now we’re still experiencing this issue. This is my plugin’s settings: * ```wp-block-code {"now": {"version": "2.0","mode": "now","title": "","skip_empty_file": true,"log_results": false,"from_status": [],"to_status": [],"change_order_status_to": "","statuses": ["wc-processing"],"from_date": "2024-09-30","to_date": "2024-11-18","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": ["905"],"product_taxonomies": [],"product_custom_fields": [],"product_attributes": [],"product_itemmeta": [],"format": "XLS","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": "Product","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": "1","export_all_comments": "0","export_refund_notes": "0","strip_tags_product_fields": "0","strip_html_tags": "0","round_item_tax_rate": "0","cleanup_phone": "0","convert_serialized_values": "0","enable_debug": "0","billing_details_for_shipping": "0","custom_php": "0","custom_php_code": "","mark_exported_orders": "0","export_unmarked_orders": "0","summary_report_by_products": "0","duplicated_fields_settings": {"products": {"repeat": "rows","populate_other_columns": "1","max_cols": "10","group_by": "product","line_delimiter": "\n"},"coupons": {"repeat": "rows","max_cols": "10","group_by": "product","line_delimiter": "\n"}},"summary_report_by_customers": "0","order_fields": [{"segment": "coupons","key": "coupons","colname": "Coupons","label": "Coupons","format": "undefined"},{"segment": "common","key": "order_id","label": "Order ID","format": "number","colname": "Order ID"},{"segment": "products","key": "products","colname": "Products","label": "Products","format": "undefined"},{"segment": "products","key": "plain_products_product_name","label": "Product Name","format": "string","colname": "Product Name"},{"segment": "products","key": "plain_products_product_variation","label": "Product Variation","format": "string","colname": "Product Variation"},{"segment": "products","key": "plain_products_qty","label": "Quantity","format": "number","colname": "Quantity"},{"segment": "cart","key": "payment_method","label": "Payment Method","format": "string","colname": "Payment Method"},{"segment": "cart","key": "order_subtotal","label": "Order Subtotal Amount","format": "money","colname": "Order Subtotal Amount"},{"segment": "totals","key": "order_total","label": "Order Total Amount","format": "money","colname": "Order Total Amount"},{"segment": "user","key": "user_login","label": "Customer Username","format": "string","colname": "Customer Username"},{"segment": "user","key": "customer_user","label": "Customer User ID","format": "number","colname": "Customer User ID"},{"segment": "user","key": "user_email","label": "Customer User Email","format": "string","colname": "Customer User Email"},{"segment": "billing","key": "billing_phone","label": "Phone (Billing)","format": "string","colname": "Phone (Billing)"},{"segment": "ship_calc","key": "order_shipping","label": "Order Shipping Amount","format": "money","colname": "Order Shipping Amount"},{"segment": "ship_calc","key": "plain_orders__additional_wooccm2","label": "_additional_wooccm2","format": "","colname": "Tracking number"},{"segment": "billing","key": "billing_full_name","label": "Full Name (Billing)","format": "string","colname": "Full Name (Billing)"},{"segment": "billing","key": "billing_address","label": "Address 1&2 (Billing)","format": "string","colname": "Address 1&2 (Billing)"},{"segment": "billing","key": "billing_city","label": "City (Billing)","format": "string","colname": "City (Billing)"},{"segment": "billing","key": "billing_state_full","label": "State Name (Billing)","format": "string","colname": "State Name (Billing)"},{"segment": "billing","key": "billing_address_2","label": "Address 2 (Billing)","format": "string","colname": "Address 2 (Billing)"},{"segment": "billing","key": "billing_postcode","label": "Postcode (Billing)","format": "string","colname": "Postcode (Billing)"},{"segment": "billing","key": "billing_phone","label": "Phone (Billing)","format": "string","colname": "Phone (Billing)"},{"segment": "misc","key": "plain_orders__additional_wooccm3","label": "_additional_wooccm3","format": "","colname": "Order Notes"},{"segment": "common","key": "paid_date","label": "Paid Date","format": "date","colname": "Paid Date"},{"segment": "ship_calc","key": "plain_orders__additional_wooccm1","label": "_additional_wooccm1","format": "","colname": "Expedition"}],"order_product_fields": [{"label": "SKU","format": "string","colname": "SKU","default": 1,"key": "sku"},{"label": "Item #","format": "number","colname": "Item #","default": 1,"key": "line_id"},{"label": "Item Name","format": "string","colname": "Item Name","default": 1,"key": "name"},{"label": "Quantity","format": "number","colname": "Quantity","default": 1,"key": "qty"},{"label": "Item Cost","format": "money","colname": "Item Cost","default": 1,"key": "item_price"}],"order_coupon_fields": [{"label": "Coupon Code","format": "string","colname": "Coupon Code","default": 1,"key": "code"},{"label": "Discount Amount","format": "money","colname": "Discount Amount","default": 1,"key": "discount_amount"},{"label": "Discount Amount Tax","format": "money","colname": "Discount Amount Tax","default": 1,"key": "discount_amount_tax"}],"id": 0,"post_type": "shop_order","export_rule_field": "date","export_filename": "orders-%y-%m-%d-%h-%i-%s.xlsx","summary_row_title": "Total"},"profiles": [],"cron": [],"order-action": []} ``` Viewing 1 replies (of 1 total) * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [1 year, 6 months ago](https://wordpress.org/support/topic/missing-orders-during-export/#post-18142428) * hello * How exactly your admins run export? Do they use >WooCommerce>Orders>Bulk Actions >Export as XLS ?if they don’t use bulk — please, open “Misc Settings”, mark “ Enable debug output”, press button “Preview” and analyze SQLs. Viewing 1 replies (of 1 total) The topic ‘Missing orders during export’ 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/) * 1 reply * 2 participants * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/) * Last activity: [1 year, 6 months ago](https://wordpress.org/support/topic/missing-orders-during-export/#post-18142428) * Status: not resolved