Title: empty rows Last modified: January 7, 2025 --- # empty rows * Resolved [biornt](https://wordpress.org/support/users/biornt/) * (@biornt) * [1 year, 4 months ago](https://wordpress.org/support/topic/empty-rows-2/) * Hi, * Not sure if this has been answered before, but when I export (and I did set “ Fill order columns for” to “1st row only”), it will export correctly, but it will include a bunch of empty rows between entries! * Is there another filter or checkbox I am missing? * Any help is appreciated. * Thanks, * biorn Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [1 year, 4 months ago](https://wordpress.org/support/topic/empty-rows-2/#post-18231165) * hi Biorn * Could you share your settings? Please visit tab “Tools” to get them. * Thread Starter [biornt](https://wordpress.org/support/users/biornt/) * (@biornt) * [1 year, 4 months ago](https://wordpress.org/support/topic/empty-rows-2/#post-18232585) * hi there, is this the settings you need? I have not really changed anything from default, except for adding two fields. thanks for helping. * biorn * ```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-pending","wc-processing","wc-on-hold","wc-completed"],"from_date": "2024-12-16","to_date": "2025-01-07","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": "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": "0","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": "0","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": "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": "common","key": "customer_note","label": "Customer Note","format": "string","colname": "Customer Note"},{"segment": "billing","key": "billing_first_name","label": "First Name (Billing)","format": "string","colname": "First Name (Billing)"},{"segment": "billing","key": "billing_last_name","label": "Last Name (Billing)","format": "string","colname": "Last Name (Billing)"},{"segment": "billing","key": "billing_company","label": "Company (Billing)","format": "string","colname": "Company (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","label": "State Code (Billing)","format": "string","colname": "State Code (Billing)"},{"segment": "billing","key": "billing_postcode","label": "Postcode (Billing)","format": "string","colname": "Postcode (Billing)"},{"segment": "billing","key": "billing_country","label": "Country Code (Billing)","format": "string","colname": "Country Code (Billing)"},{"segment": "billing","key": "billing_email","label": "Email (Billing)","format": "string","colname": "Email (Billing)"},{"segment": "billing","key": "billing_phone","label": "Phone (Billing)","format": "string","colname": "Phone (Billing)"},{"segment": "shipping","key": "shipping_first_name","label": "First Name (Shipping)","format": "string","colname": "First Name (Shipping)"},{"segment": "shipping","key": "shipping_last_name","label": "Last Name (Shipping)","format": "string","colname": "Last Name (Shipping)"},{"segment": "shipping","key": "shipping_address","label": "Address 1&2 (Shipping)","format": "string","colname": "Address 1&2 (Shipping)"},{"segment": "shipping","key": "shipping_city","label": "City (Shipping)","format": "string","colname": "City (Shipping)"},{"segment": "shipping","key": "shipping_state","label": "State Code (Shipping)","format": "string","colname": "State Code (Shipping)"},{"segment": "shipping","key": "shipping_postcode","label": "Postcode (Shipping)","format": "string","colname": "Postcode (Shipping)"},{"segment": "shipping","key": "shipping_country","label": "Country Code (Shipping)","format": "string","colname": "Country Code (Shipping)"},{"segment": "cart","key": "payment_method_title","label": "Payment Method Title","format": "string","colname": "Payment Method Title"},{"segment": "cart","key": "cart_discount","label": "Cart Discount Amount","format": "money","colname": "Cart Discount Amount"},{"segment": "cart","key": "cart_discount_inc_tax","label": "Cart Discount Amount(inc. tax)","format": "money","colname": "Cart Discount Amount(inc. tax)"},{"segment": "cart","key": "order_subtotal","label": "Order Subtotal Amount","format": "money","colname": "Order Subtotal Amount"},{"segment": "ship_calc","key": "shipping_method_title","label": "Shipping Method Title","format": "string","colname": "Shipping Method Title"},{"segment": "ship_calc","key": "order_shipping","label": "Order Shipping Amount","format": "money","colname": "Order Shipping Amount"},{"segment": "totals","key": "order_refund","label": "Order Refund Amount","format": "money","colname": "Order Refund Amount"},{"segment": "totals","key": "order_total","label": "Order Total Amount","format": "money","colname": "Order Total Amount"},{"segment": "totals","key": "order_total_tax","label": "Order Total Tax Amount","format": "money","colname": "Order Total Tax Amount"},{"segment": "common","key": "plain_orders_additional_How_did_you_hear_about_the_Masterclass","label": "additional_How_did_you_hear_about_the_Masterclass","format": "","colname": "How did you hear about us"},{"segment": "common","key": "plain_orders_additional_Certifications","label": "additional_Certifications","format": "","colname": "Certifications"},{"segment": "products","key": "products","colname": "Products","label": "Products","format": "undefined"},{"segment": "products","key": "plain_products_sku","label": "SKU","format": "string","colname": "SKU"},{"segment": "products","key": "plain_products_line_id","label": "Item #","format": "number","colname": "Item #"},{"segment": "products","key": "plain_products_name","label": "Item Name","format": "string","colname": "Item Name"},{"segment": "products","key": "plain_products_qty_minus_refund","label": "Quantity (- Refund)","format": "number","colname": "Quantity (- Refund)"},{"segment": "products","key": "plain_products_item_price","label": "Item Cost","format": "money","colname": "Item Cost"},{"segment": "coupons","key": "coupons","colname": "Coupons","label": "Coupons","format": "undefined"},{"segment": "coupons","key": "plain_coupons_code","label": "Coupon Code","format": "string","colname": "Coupon Code"},{"segment": "coupons","key": "plain_coupons_discount_amount","label": "Discount Amount","format": "money","colname": "Discount Amount"},{"segment": "coupons","key": "plain_coupons_discount_amount_tax","label": "Discount Amount Tax","format": "money","colname": "Discount Amount Tax"}],"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 (- Refund)","format": "number","colname": "Quantity (- Refund)","default": 1,"key": "qty_minus_refund"},{"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": []} ``` * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [1 year, 4 months ago](https://wordpress.org/support/topic/empty-rows-2/#post-18232736) * hi * If order has many products inside — our plugin repeats only product details at separate row. So you will see non-empty cells if you scroll Excel file to right. * Please, open section “Setup Fields” and set “Fill order columns for” = “All rows”. or set mode “Add producst as” = “One row” * thanks, Alex * Thread Starter [biornt](https://wordpress.org/support/users/biornt/) * (@biornt) * [1 year, 4 months ago](https://wordpress.org/support/topic/empty-rows-2/#post-18232771) * alex, * thanks for the info, it seems when I set products to “one row” everything works well; I can’t believe i missed this! I’ll do some testing and let you know if i have any issues. * thanks again, biorn * Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/) * (@algolplus) * [1 year, 4 months ago](https://wordpress.org/support/topic/empty-rows-2/#post-18233358) * You’re welcome Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘empty rows’ 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/) * 5 replies * 2 participants * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/) * Last activity: [1 year, 4 months ago](https://wordpress.org/support/topic/empty-rows-2/#post-18233358) * Status: resolved