• Hi folks, hope you are doing well. I´ve been trying to export in excel and csv format but critical error comes out. Is this a bug or it´s just a missconfig?. Here below you cand find config:


    {
    "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"
    ],
    "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": "42225",
    "to_order_id": "42230",
    "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": "CSV",
    "format_xls_use_xls_format": "1",
    "format_xls_sheet_name": "Pedidos",
    "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": "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": "common",
    "key": "order_number",
    "label": "N\u00famero de pedido",
    "format": "string",
    "colname": "N\u00famero de pedido"
    },
    {
    "segment": "common",
    "key": "order_id",
    "label": "ID del pedido",
    "format": "number",
    "colname": "ID del pedido"
    },
    {
    "segment": "common",
    "key": "order_status",
    "label": "Estado del pedido",
    "format": "string",
    "colname": "Estado del pedido"
    },
    {
    "segment": "common",
    "key": "order_date",
    "label": "Fecha del pedido",
    "format": "date",
    "colname": "Fecha del pedido"
    },
    {
    "segment": "common",
    "key": "customer_note",
    "label": "Nota del cliente",
    "format": "string",
    "colname": "Nota del cliente"
    },
    {
    "segment": "billing",
    "key": "billing_first_name",
    "label": "Nombre (facturaci\u00f3n)",
    "format": "string",
    "colname": "Nombre (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_last_name",
    "label": "Apellidos (facturaci\u00f3n)",
    "format": "string",
    "colname": "Apellidos (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_company",
    "label": "Empresa (facturaci\u00f3n)",
    "format": "string",
    "colname": "Empresa (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_address",
    "label": "Direcci\u00f3n lineas 1 y 2 (facturaci\u00f3n)",
    "format": "string",
    "colname": "Direcci\u00f3n lineas 1 y 2 (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_city",
    "label": "Ciudad (facturaci\u00f3n)",
    "format": "string",
    "colname": "Ciudad (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_state",
    "label": "C\u00f3digo de provincia (facturaci\u00f3n)",
    "format": "string",
    "colname": "C\u00f3digo de provincia (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_postcode",
    "label": "C\u00f3digo postal (facturaci\u00f3n)",
    "format": "string",
    "colname": "C\u00f3digo postal (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_country",
    "label": "C\u00f3digo del pa\u00eds (facturaci\u00f3n)",
    "format": "string",
    "colname": "C\u00f3digo del pa\u00eds (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_email",
    "label": "Correo electr\u00f3nico (facturaci\u00f3n)",
    "format": "string",
    "colname": "Correo electr\u00f3nico (facturaci\u00f3n)"
    },
    {
    "segment": "billing",
    "key": "billing_phone",
    "label": "Tel\u00e9fono (facturaci\u00f3n)",
    "format": "string",
    "colname": "Tel\u00e9fono (facturaci\u00f3n)"
    },
    {
    "segment": "shipping",
    "key": "shipping_first_name",
    "label": "Nombre (env\u00edo)",
    "format": "string",
    "colname": "Nombre (env\u00edo)"
    },
    {
    "segment": "shipping",
    "key": "shipping_last_name",
    "label": "Apellidos (env\u00edo)",
    "format": "string",
    "colname": "Apellidos (env\u00edo)"
    },
    {
    "segment": "shipping",
    "key": "shipping_address",
    "label": "Direcci\u00f3n lineas 1 y 2 (env\u00edo)",
    "format": "string",
    "colname": "Direcci\u00f3n lineas 1 y 2 (env\u00edo)"
    },
    {
    "segment": "shipping",
    "key": "shipping_city",
    "label": "Ciudad (env\u00edo)",
    "format": "string",
    "colname": "Ciudad (env\u00edo)"
    },
    {
    "segment": "shipping",
    "key": "shipping_state",
    "label": "C\u00f3digo de provincia (env\u00edo)",
    "format": "string",
    "colname": "C\u00f3digo de provincia (env\u00edo)"
    },
    {
    "segment": "shipping",
    "key": "shipping_postcode",
    "label": "C\u00f3digo postal (env\u00edo)",
    "format": "string",
    "colname": "C\u00f3digo postal (env\u00edo)"
    },
    {
    "segment": "shipping",
    "key": "shipping_country",
    "label": "C\u00f3digo del pa\u00eds (env\u00edo)",
    "format": "string",
    "colname": "C\u00f3digo del pa\u00eds (env\u00edo)"
    },
    {
    "segment": "cart",
    "key": "payment_method_title",
    "label": "T\u00edtulo del m\u00e9todo de pago",
    "format": "string",
    "colname": "T\u00edtulo del m\u00e9todo de pago"
    },
    {
    "segment": "cart",
    "key": "cart_discount",
    "label": "Importe de descuento del carrito",
    "format": "money",
    "colname": "Importe de descuento del carrito"
    },
    {
    "segment": "cart",
    "key": "cart_discount_inc_tax",
    "label": "Cantidad de descuento en el carrito (impuestos incluidos)",
    "format": "money",
    "colname": "Cantidad de descuento en el carrito (impuestos incluidos)"
    },
    {
    "segment": "cart",
    "key": "order_subtotal",
    "label": "Importe de subtotal del pedido",
    "format": "money",
    "colname": "Importe de subtotal del pedido"
    },
    {
    "segment": "ship_calc",
    "key": "shipping_method_title",
    "label": "T\u00edtulo del m\u00e9todo de env\u00edo",
    "format": "string",
    "colname": "T\u00edtulo del m\u00e9todo de env\u00edo"
    },
    {
    "segment": "ship_calc",
    "key": "order_shipping",
    "label": "Importe de env\u00edo del pedido",
    "format": "money",
    "colname": "Importe de env\u00edo del pedido"
    },
    {
    "segment": "totals",
    "key": "order_refund",
    "label": "Importe reembolsado del pedido",
    "format": "money",
    "colname": "Importe reembolsado del pedido"
    },
    {
    "segment": "totals",
    "key": "order_total",
    "label": "Importe total del pedido",
    "format": "money",
    "colname": "Importe total del pedido"
    },
    {
    "segment": "totals",
    "key": "order_total_tax",
    "label": "Importe total de impuestos del pedido",
    "format": "money",
    "colname": "Importe total de impuestos del pedido"
    },
    {
    "segment": "products",
    "key": "products",
    "colname": "Productos",
    "label": "Productos",
    "format": "undefined"
    },
    {
    "segment": "products",
    "key": "plain_products_sku",
    "label": "SKU",
    "format": "string",
    "colname": "SKU"
    },
    {
    "segment": "products",
    "key": "plain_products_line_id",
    "label": "Art\u00edculo #",
    "format": "number",
    "colname": "Art\u00edculo #"
    },
    {
    "segment": "products",
    "key": "plain_products_name",
    "label": "Nombre del art\u00edculo",
    "format": "string",
    "colname": "Nombre del art\u00edculo"
    },
    {
    "segment": "products",
    "key": "plain_products_qty_minus_refund",
    "label": "Cantidad (- reembolso)",
    "format": "number",
    "colname": "Cantidad (- reembolso)"
    },
    {
    "segment": "products",
    "key": "plain_products_item_price",
    "label": "Coste de art\u00edculo",
    "format": "money",
    "colname": "Coste de art\u00edculo"
    },
    {
    "segment": "coupons",
    "key": "coupons",
    "colname": "Cupones",
    "label": "Cupones",
    "format": "undefined"
    },
    {
    "segment": "coupons",
    "key": "plain_coupons_code",
    "label": "C\u00f3digo de cup\u00f3n",
    "format": "string",
    "colname": "C\u00f3digo de cup\u00f3n"
    },
    {
    "segment": "coupons",
    "key": "plain_coupons_discount_amount",
    "label": "Importe de descuento",
    "format": "money",
    "colname": "Importe de descuento"
    },
    {
    "segment": "coupons",
    "key": "plain_coupons_discount_amount_tax",
    "label": "Importe de impuestos del descuento",
    "format": "money",
    "colname": "Importe de impuestos del descuento"
    }
    ],
    "order_product_fields": [
    {
    "label": "SKU",
    "format": "string",
    "colname": "SKU",
    "default": 1,
    "key": "sku"
    },
    {
    "label": "Art\u00edculo #",
    "format": "number",
    "colname": "Art\u00edculo #",
    "default": 1,
    "key": "line_id"
    },
    {
    "label": "Nombre del art\u00edculo",
    "format": "string",
    "colname": "Nombre del art\u00edculo",
    "default": 1,
    "key": "name"
    },
    {
    "label": "Cantidad (- reembolso)",
    "format": "number",
    "colname": "Cantidad (- reembolso)",
    "default": 1,
    "key": "qty_minus_refund"
    },
    {
    "label": "Coste de art\u00edculo",
    "format": "money",
    "colname": "Coste de art\u00edculo",
    "default": 1,
    "key": "item_price"
    }
    ],
    "order_coupon_fields": [
    {
    "label": "C\u00f3digo de cup\u00f3n",
    "format": "string",
    "colname": "C\u00f3digo de cup\u00f3n",
    "default": 1,
    "key": "code"
    },
    {
    "label": "Importe de descuento",
    "format": "money",
    "colname": "Importe de descuento",
    "default": 1,
    "key": "discount_amount"
    },
    {
    "label": "Importe de impuestos del descuento",
    "format": "money",
    "colname": "Importe de impuestos del descuento",
    "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.csv",
    "summary_row_title": "Total"
    },
    "profiles": [],
    "cron": [],
    "order-action": []
    }


Viewing 1 replies (of 1 total)
  • Plugin Author algol.plus

    (@algolplus)

    Hi

    Your settings are ok.

    Please, try button “Export w/o progress bar” (at bottom of the page).

    if it won’t help — open >WooCommerce>Status>Logs and review “fatal-errors’ file.
    We need to know exact error message.

    thanks , Alex

Viewing 1 replies (of 1 total)

The topic ‘Critical error when trying to export’ is closed to new replies.