Missing orders on export | WordPress.org

[ad_1]

{
"now": {
"version": "2.0",
"mode": "now",
"title": "",
"skip_empty_file": true,
"log_results": false,
"from_status": [],
"to_status": [],
"change_order_status_to": "",
"statuses": [],
"from_date": "2020-05-01",
"to_date": "2020-06-05",
"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": "0",
"skip_refunded_items": "1",
"skip_suborders": "0",
"export_refunds": "0",
"export_matched_items": "0",
"date_format": "Y-m-d",
"time_format": "H:i",
"sort_direction": "DESC",
"sort": "_shipping_postcode",
"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": "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": "1",
"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": "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": "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",
"label": "Quantity",
"format": "number",
"colname": "Quantity"
},
{
"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"
},
{
"segment": "user",
"key": "summary_report_total_count",
"label": "Summary Report Total Orders",
"format": "number",
"colname": "Summary Report Total Orders"
},
{
"segment": "user",
"key": "summary_report_total_count_items",
"label": "Summary Report Total Items",
"format": "number",
"colname": "Summary Report Total Items"
},
{
"segment": "user",
"key": "summary_report_total_count_items_exported",
"label": "Summary Report Total Items (Exported)",
"format": "number",
"colname": "Summary Report Total Items (Exported)"
},
{
"segment": "user",
"key": "summary_report_total_amount",
"label": "Summary Report Total Amount",
"format": "money",
"colname": "Summary Report Total Amount"
},
{
"segment": "user",
"key": "summary_report_total_amount_paid",
"label": "Summary Report Total Amount Paid",
"format": "money",
"colname": "Summary Report Total Amount Paid"
},
{
"segment": "user",
"key": "summary_report_total_shipping",
"label": "Summary Report Total Shipping",
"format": "money",
"colname": "Summary Report Total Shipping"
},
{
"segment": "user",
"key": "summary_report_total_discount",
"label": "Summary Report Total Discount",
"format": "money",
"colname": "Summary Report Total Discount"
},
{
"segment": "user",
"key": "summary_report_total_refund_count",
"label": "Summary Report Total Refunds",
"format": "number",
"colname": "Summary Report Total Refunds"
},
{
"segment": "user",
"key": "summary_report_total_refund_amount",
"label": "Summary Report Total Refund Amount",
"format": "money",
"colname": "Summary Report Total Refund Amount"
}
],
"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": []
}

Hi @algolplus, thanks for responding

Here you go, I’m exporting order via woocommerce orders

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer