Products sales summary

Hello

it should be programmed, as start point – you can use 1st code from section
https://docs.algolplus.com/algol_order_export/export-products-as-columns/

thanks, Alex

Sorry but I don’t like to display products as columns, I have to put a products quantity summary after orders details.

Like this
PRODUCT QUANTITY
Product A 20
Product B 50

thanks in advance

yes, I understand your requirements.
but we don’t have solution for it .

Could you upload your settings as new ticket to https://algolplus.freshdesk.com/ ?

Visit >WooCommerce>Export Orders>Tools to get them.

As you can see I create a seond report with the product sales summary, but I would like put both in a same report.

{
“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”: “XLS”,
“format_xls_use_xls_format”: “0”,
“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_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_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”: “1”,
“skip_suborders”: “0”,
“export_refunds”: “0”,
“export_matched_items”: “0”,
“date_format”: “m\/d\/Y”,
“time_format”: “H:i”,
“sort_direction”: “ASC”,
“sort”: “order_id”,
“format_number_fields”: “1”,
“export_all_comments”: “1”,
“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”: “add_filter(\u0027woe_get_order_value_producto_cantidad\u0027,function ($value, $order,$fieldname) {\r\n \r\n$product_list = \u0027\u0027;\r\n$order_item = $order->get_items();\r\n\r\n foreach( $order_item as $product ) {\r\n $value = $value . $product[\u0027name\u0027]. \u0027 x \u0027 .$product[\u0027quantity\u0027].\”,\”.\”\\n\” ; \r\n }\r\n\r\n$result = substr($value , 0, -2);\r\n return $result;\r\n},10,3);”,
“mark_exported_orders”: “0”,
“export_unmarked_orders”: “0”,
“summary_report_by_products”: “0”,
“duplicated_fields_settings”: {
“products”: {
“repeat”: “inside_one_cell”,
“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”: “products”,
“key”: “products”,
“colname”: “Productos”,
“label”: “Productos”,
“format”: “undefined”
},
{
“segment”: “common”,
“key”: “order_number”,
“label”: “N\u00famero de pedido”,
“format”: “string”,
“colname”: “Pedido”
},
{
“segment”: “shipping”,
“key”: “shipping_first_name”,
“label”: “Nombre (env\u00edo)”,
“format”: “string”,
“colname”: “Nombre”
},
{
“segment”: “shipping”,
“key”: “shipping_last_name”,
“label”: “Apellidos (env\u00edo)”,
“format”: “string”,
“colname”: “Apellidos”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_ci”,
“label”: “_shipping_ci”,
“format”: “string”,
“colname”: “CI”
},
{
“segment”: “shipping”,
“key”: “shipping_address”,
“label”: “Direcci\u00f3n lineas 1 y 2 (env\u00edo)”,
“format”: “string”,
“colname”: “Direcci\u00f3n”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_state”,
“label”: “_shipping_state”,
“format”: “”,
“colname”: “Provincia”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_city”,
“label”: “_shipping_city”,
“format”: “”,
“colname”: “Municipio”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_movil”,
“label”: “_shipping_movil”,
“format”: “string”,
“colname”: “Tel\u00e9fono”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_telefono”,
“label”: “_shipping_telefono”,
“format”: “string”,
“colname”: “M\u00f3vil”
},
{
“segment”: “product_totals”,
“key”: “count_total_items”,
“label”: “Total de art\u00edculos”,
“format”: “number”,
“colname”: “Cant. Bultos”
},
{
“segment”: “common”,
“key”: “plain_orders_producto_cantidad”,
“label”: “producto_cantidad”,
“format”: “string”,
“colname”: “Productos”
},
{
“segment”: “common”,
“key”: “order_date”,
“label”: “Fecha del pedido”,
“format”: “date”,
“colname”: “Fecha del pedido”
},
{
“segment”: “coupons”,
“key”: “coupons”,
“colname”: “Cupones”,
“label”: “Cupones”,
“format”: “undefined”
}
],
“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”: “Item Name”,
“format”: “string”,
“colname”: “Item Name”,
“default”: 1,
“key”: “name”
},
{
“label”: “Cantidad”,
“format”: “number”,
“colname”: “Cantidad”,
“default”: 1,
“key”: “qty”
},
{
“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”: “Manifiesto-%y-%m-%d-%h-%i-%s.xlsx”
},
“profiles”: {
“1”: {
“version”: “2.0”,
“mode”: “profiles”,
“title”: “MANIFIESTO”,
“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”: “XLS”,
“format_xls_use_xls_format”: “0”,
“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_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_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”: “1”,
“skip_suborders”: “0”,
“export_refunds”: “0”,
“export_matched_items”: “0”,
“date_format”: “m\/d\/Y”,
“time_format”: “H:i”,
“sort_direction”: “ASC”,
“sort”: “order_id”,
“format_number_fields”: “1”,
“export_all_comments”: “1”,
“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”: “add_filter(\u0027woe_get_order_value_producto_cantidad\u0027,function ($value, $order,$fieldname) {\r\n \r\n$product_list = \u0027\u0027;\r\n$order_item = $order->get_items();\r\n\r\n foreach( $order_item as $product ) {\r\n $value = $value . $product[\u0027name\u0027]. \u0027 x \u0027 .$product[\u0027quantity\u0027].\”,\”.\”\\n\” ; \r\n }\r\n\r\n$result = substr($value , 0, -2);\r\n return $result;\r\n},10,3);”,
“mark_exported_orders”: “0”,
“export_unmarked_orders”: “0”,
“summary_report_by_products”: “0”,
“duplicated_fields_settings”: {
“products”: {
“repeat”: “inside_one_cell”,
“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”: “products”,
“key”: “products”,
“colname”: “Productos”,
“label”: “Productos”,
“format”: “undefined”
},
{
“segment”: “common”,
“key”: “order_number”,
“label”: “N\u00famero de pedido”,
“format”: “string”,
“colname”: “Pedido”
},
{
“segment”: “shipping”,
“key”: “shipping_first_name”,
“label”: “Nombre (env\u00edo)”,
“format”: “string”,
“colname”: “Nombre”
},
{
“segment”: “shipping”,
“key”: “shipping_last_name”,
“label”: “Apellidos (env\u00edo)”,
“format”: “string”,
“colname”: “Apellidos”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_ci”,
“label”: “_shipping_ci”,
“format”: “string”,
“colname”: “CI”
},
{
“segment”: “shipping”,
“key”: “shipping_address”,
“label”: “Direcci\u00f3n lineas 1 y 2 (env\u00edo)”,
“format”: “string”,
“colname”: “Direcci\u00f3n”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_state”,
“label”: “_shipping_state”,
“format”: “”,
“colname”: “Provincia”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_city”,
“label”: “_shipping_city”,
“format”: “”,
“colname”: “Municipio”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_movil”,
“label”: “_shipping_movil”,
“format”: “string”,
“colname”: “Tel\u00e9fono”
},
{
“segment”: “shipping”,
“key”: “plain_orders__shipping_telefono”,
“label”: “_shipping_telefono”,
“format”: “string”,
“colname”: “M\u00f3vil”
},
{
“segment”: “product_totals”,
“key”: “count_total_items”,
“label”: “Total de art\u00edculos”,
“format”: “number”,
“colname”: “Cant. Bultos”
},
{
“segment”: “common”,
“key”: “plain_orders_producto_cantidad”,
“label”: “producto_cantidad”,
“format”: “string”,
“colname”: “Productos”
},
{
“segment”: “common”,
“key”: “order_date”,
“label”: “Fecha del pedido”,
“format”: “date”,
“colname”: “Fecha del pedido”
},
{
“segment”: “coupons”,
“key”: “coupons”,
“colname”: “Cupones”,
“label”: “Cupones”,
“format”: “undefined”
}
],
“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”: “Item Name”,
“format”: “string”,
“colname”: “Item Name”,
“default”: 1,
“key”: “name”
},
{
“label”: “Cantidad”,
“format”: “number”,
“colname”: “Cantidad”,
“default”: 1,
“key”: “qty”
},
{
“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”: 1,
“post_type”: “shop_order”,
“export_rule_field”: “date”,
“export_filename”: “Manifiesto-%y-%m-%d-%h-%i-%s.xlsx”,
“use_as_bulk”: “on”
},
“2”: {
“version”: “2.0”,
“mode”: “profiles”,
“title”: “RESUMEN x PRODUCTOS”,
“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”: “XLS”,
“format_xls_use_xls_format”: “0”,
“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_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_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”: “1”,
“skip_suborders”: “0”,
“export_refunds”: “0”,
“export_matched_items”: “0”,
“date_format”: “m\/d\/Y”,
“time_format”: “H:i”,
“sort_direction”: “ASC”,
“sort”: “order_id”,
“format_number_fields”: “1”,
“export_all_comments”: “1”,
“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”: “0”,
“export_unmarked_orders”: “0”,
“summary_report_by_products”: “1”,
“duplicated_fields_settings”: {
“products”: {
“repeat”: “inside_one_cell”,
“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”: “Cupones”,
“label”: “Cupones”,
“format”: “undefined”
},
{
“segment”: “products”,
“key”: “products”,
“colname”: “Productos”,
“label”: “Productos”,
“format”: “undefined”
},
{
“segment”: “products”,
“key”: “plain_products_product_name”,
“label”: “nombre del Producto”,
“format”: “string”,
“colname”: “Producto”
},
{
“segment”: “products”,
“key”: “plain_products_summary_report_total_qty”,
“label”: “Cantidad total del informe resumido”,
“format”: “number”,
“colname”: “Cantidad”
}
],
“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”: “Item Name”,
“format”: “string”,
“colname”: “Item Name”,
“default”: 1,
“key”: “name”
},
{
“label”: “Cantidad”,
“format”: “number”,
“colname”: “Cantidad”,
“default”: 1,
“key”: “qty”
},
{
“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”: 2,
“post_type”: “shop_order”,
“export_rule_field”: “date”,
“export_filename”: “RESUMEN x PRODUCTOS-%y-%m-%d-%h-%i-%s.xlsx”,
“use_as_bulk”: “on”
}
},
“cron”: [],
“order-action”: []
}

Please, you upload your settings as new ticket to https://algolplus.freshdesk.com/

it’s settings for pro version.

yes

Please, you upload your settings as new ticket to https://algolplus.freshdesk.com/