TOTALS per DAY | WordPress.org

oops got a fast answer. It´s getting worse (like every part of italian bureaucrazy). Not only do i have to list the dayly sum of all orders (gross/brutto), the sum also has to be splitted into corresponding taxrates.

example: https://studiocommercialeonline.it/come-compilare-il-registro-dei-corrispettivi …. http://studiocommercialeonline.it/wp-content/uploads/2013/08/registro-corrispettivi-excel.xls

	
			Totale corrispettivi giornalieri	CORRISPETTIVI				
	2016		4%	10%	22%	__%	__%
R	riporto	0	0	0	0		
1	1.6	30	10	20	0		
2	2.6	0	0	0	0		
3	3.6	10	0	10	0		
4		0					
5		0					
6		0					
7		0					
8		0					
9		0					
10		0					
11		0					
12		0					
13		0					
14		0					
15		0					
16		0					
17		0					
18		0					
19		0					
20		0					
21		0					
22		0					
23		0					
24		0					
25		0					
26		0					
27		0					
28		0					
29		0					
30		0					
31		0					
							
Totale		40	10	30	0		
AR      	40	10	30	0	0	0
							

What i have right now is this (its beautiful ; … but not following italian logic):

{
    "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",
            "wc-on-hold",
            "wc-completed"
        ],
        "from_date": "2022-10-01",
        "to_date": "2022-10-31",
        "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": "d\/m\/Y",
        "time_format": "",
        "sort_direction": "DESC",
        "sort": "post_date",
        "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": "1",
        "billing_details_for_shipping": "0",
        "custom_php": "1",
        "custom_php_code": "\/\/export Shipping line as Products \r\nadd_filter(\u0027woe_fetch_order_products\u0027, function ($products,$order,$labels, $format, $static_vals) {\r\n\t$i = count ($products);\r\n\tforeach ( $order->get_items(\u0027shipping\u0027) as $item_id=>$item ) {\r\n\t\t$row = array();\r\n\t\t$i++;\r\n\t\t$taxes = $item->get_total_tax();\r\n\t\tforeach ( $labels as $field => $label ) {\r\n\t\t\tif ( $field == \u0027line_id\u0027 ) {\r\n\t\t\t\t$row[ $field ] = $i;\r\n\t\t\t} elseif ( $field == \u0027sku\u0027 ) {\r\n\t\t\t\t$row[ $field ] = $item[\"method_id\"];\r\n\t\t\t} elseif ( $field == \u0027name\u0027 ) {\r\n\t\t\t\t$row[\u0027name\u0027] = $item[\"name\"];\r\n\t\t\t} elseif ( $field == \u0027qty\u0027 ) {\r\n\t\t\t\t$row[\u0027qty\u0027] = 1;\r\n\t\t\t} elseif ( $field == \u0027item_price\u0027 ) {\r\n\t\t\t\t$row[\u0027item_price\u0027] = $item[\"cost\"];\r\n\t\t\t} elseif ( $field == \u0027price\u0027 ) {\r\n\t\t\t\t$row[\u0027price\u0027] = $item[\"cost\"];\r\n\t\t\t} elseif ( $field == \u0027line_tax\u0027 ) {\r\n\t\t\t\t$row[\u0027line_tax\u0027] = $taxes;\r\n\t\t\t} elseif ( $field == \u0027tax_rate\u0027 ) {\r\n\/\/hdm\r\n\t\t\t\tif($item[\"cost\"] > 0)\r\n                               {\r\n                                    $row[\u0027tax_rate\u0027] = $item[\"cost\"] ? round($taxes\/$item[\"cost\"] *100 , 2) : 0;\r\n                                   }\r\n\/\/hdm\r\n\t\t\t} elseif ( isset( $static_vals[ $field ] ) ) {\r\n\t\t\t\t$row[ $field ] = $static_vals[ $field ];\r\n\t\t\t} \r\n\t\t}\r\n\t\t$products[] = $row;\r\n\t}\r\n\treturn $products;\r\n}, 10, 5);\r\n\/\/ add empty row after each order,   Excel\/CSV\/TAB formats\r\nadd_filter(\"woe_fetch_order_data\", function($rows) {\r\n\t$rows[] = array_fill(0, count($rows[0]),\"\");\r\n\treturn $rows;\r\n});\r\n\r\n\r\n\r\n\/\/ export ATUM supplier, add meta key \"atum_supplier\"\r\nadd_filter(\u0027woe_get_order_product_value_atum_supplier\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n\tif($product AND  class_exists(\"Atum\\Inc\\Helpers\") ) {\r\n\t\t$product = Atum\\Inc\\Helpers::get_atum_product( $product->get_id() );\r\n\t\t$supplier_id = $product->get_supplier_id();\r\n\t\tif ( $supplier_id ) {\r\n\t\t\t$supplier_post = get_post( $supplier_id );\r\n\t\t\tif ( $supplier_post ) \r\n\t\t\t\t$value = $supplier_post->post_title;\r\n\t\t}\r\n\t}\r\n\treturn $value;\r\n}, 10, 5);\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_atum_purchase_price\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n  if( class_exists(\"Atum\\Inc\\Helpers\") AND $product) {\r\n        $product = Atum\\Inc\\Helpers::get_atum_product( $product->get_id() );\r\n        $value = $product->get_purchase_price();\r\n  }\r\n  return $value;\r\n}, 10, 5);\r\n\r\nadd_filter(\u0027woe_get_order_product_value_PurchaseQuantTax\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n  if( class_exists(\"Atum\\Inc\\Helpers\") AND $product) {\r\n        $product = Atum\\Inc\\Helpers::get_atum_product( $product->get_id() );\r\n        $valueatum = $product->get_purchase_price();\r\n        $subtotal_amount = $item->get_subtotal();\r\n        $subtotal_tax    = $item->get_subtotal_tax();\r\n        $tax_rate = ( $subtotal_amount <> 0 ) ? round( 100 * $subtotal_tax \/ $subtotal_amount) : 0;\r\n  }\r\n\r\n$value = $valueatum*$item[\u0027qty\u0027]*((100+$tax_rate)\/100);\r\nreturn $value;\r\n}, 10, 5);",
        "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_id",
                "label": "Order ID",
                "format": "number",
                "colname": "Order ID"
            },
            {
                "segment": "shipping",
                "key": "shipping_country",
                "label": "Country Code (Shipping)",
                "format": "string",
                "colname": "Shipping to"
            },
            {
                "segment": "common",
                "key": "order_date",
                "label": "Order Date",
                "format": "date",
                "colname": "Order Date"
            },
            {
                "segment": "products",
                "key": "products",
                "colname": "Products",
                "label": "Products",
                "format": "undefined"
            },
            {
                "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 (Netto)"
            },
            {
                "segment": "products",
                "key": "plain_products_item_price_inc_tax",
                "label": "Item Cost (inc. tax)",
                "format": "money",
                "colname": "Item Cost (Brutto)"
            },
            {
                "segment": "coupons",
                "key": "coupons",
                "colname": "Coupons",
                "label": "Coupons",
                "format": "undefined"
            },
            {
                "segment": "products",
                "key": "plain_products_line_total_plus_tax",
                "label": "Order Line Total (include tax)",
                "format": "money",
                "colname": "Items Total (Brutto)"
            },
            {
                "segment": "products",
                "key": "plain_products_line_total",
                "label": "Order Line Total",
                "format": "money",
                "colname": "Items Total (Netto)"
            },
            {
                "segment": "products",
                "key": "plain_products_line_tax",
                "label": "Order Line Tax",
                "format": "money",
                "colname": "Items Total VAT"
            },
            {
                "segment": "products",
                "key": "plain_products_tax_rate",
                "label": "Item Tax Rate",
                "format": "number",
                "colname": "VAT Rate"
            },
            {
                "segment": "totals",
                "key": "order_total",
                "label": "Order Total Amount",
                "format": "money",
                "colname": "Order Total (Brutto)",
                "sum": "1"
            },
            {
                "segment": "totals",
                "key": "order_total_no_tax",
                "label": "Order Total Amount without Tax",
                "format": "money",
                "colname": "Order Total (Netto)",
                "sum": "1"
            },
            {
                "segment": "totals",
                "key": "order_total_tax",
                "label": "Order Total Tax Amount",
                "format": "money",
                "colname": "Order Total VAT",
                "sum": "1"
            },
            {
                "segment": "misc",
                "key": "plain_orders__efe_partitaiva_codicefiscale",
                "label": "_efe_partitaiva_codicefiscale",
                "format": "string",
                "colname": "If sold with VATIN to EU"
            }
        ],
        "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": "Ricevute %m %y.xlsx",
        "summary_row_title": "Total"
    },
    "profiles": [],
    "cron": [],
    "order-action": []
}

right now i have no idea how to get there …. any help highly appreciated.

 

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