volcomjon
Forum Replies Created
-
quite possibly – but knowing this now allows me to check for the string of “NaN” rather than trying to format it. thanks for helping identify this.
interestingly – it appears that the value inserted into the field in the database is actually “NaN” – so its not PHP which is returning this, but simply the value in the database.
this is still returning NaN:
add_filter('woe_get_order_product_value_Course_Date', function ($value, $order, $item, $product,$item_meta) { $Course_Date = get_field('date_start', $item->get_product_id(), false, false); if ( !empty($Course_Date)) { $value =$Course_Date; } else { $value = "NA"; }; return $value; }, 10, 5);Export Settings:
{ "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": "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, "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", "line_delimiter": "\\n", "group_by": "product" }, "coupons": { "repeat": "rows", "max_cols": "10", "line_delimiter": "\\n", "group_by": "product" } }, "summary_report_by_customers": 0, "order_fields": [ { "label": "Order Number", "format": "string", "segment": "common", "colname": "Order Number", "default": 1, "key": "order_number" }, { "label": "Order Status", "format": "string", "segment": "common", "colname": "Order Status", "default": 1, "key": "order_status" }, { "label": "Order Date", "format": "date", "segment": "common", "colname": "Order Date", "default": 1, "key": "order_date" }, { "label": "Customer Note", "format": "string", "segment": "common", "colname": "Customer Note", "default": 1, "key": "customer_note" }, { "label": "First Name (Billing)", "format": "string", "segment": "billing", "colname": "First Name (Billing)", "default": 1, "key": "billing_first_name" }, { "label": "Last Name (Billing)", "format": "string", "segment": "billing", "colname": "Last Name (Billing)", "default": 1, "key": "billing_last_name" }, { "label": "Company (Billing)", "format": "string", "segment": "billing", "colname": "Company (Billing)", "default": 1, "key": "billing_company" }, { "label": "Address 1&2 (Billing)", "format": "string", "segment": "billing", "colname": "Address 1&2 (Billing)", "default": 1, "key": "billing_address" }, { "label": "City (Billing)", "format": "string", "segment": "billing", "colname": "City (Billing)", "default": 1, "key": "billing_city" }, { "label": "State Code (Billing)", "format": "string", "segment": "billing", "colname": "State Code (Billing)", "default": 1, "key": "billing_state" }, { "label": "Postcode (Billing)", "format": "string", "segment": "billing", "colname": "Postcode (Billing)", "default": 1, "key": "billing_postcode" }, { "label": "Country Code (Billing)", "format": "string", "segment": "billing", "colname": "Country Code (Billing)", "default": 1, "key": "billing_country" }, { "label": "Email (Billing)", "format": "string", "segment": "billing", "colname": "Email (Billing)", "default": 1, "key": "billing_email" }, { "label": "Phone (Billing)", "format": "string", "segment": "billing", "colname": "Phone (Billing)", "default": 1, "key": "billing_phone" }, { "label": "First Name (Shipping)", "format": "string", "segment": "shipping", "colname": "First Name (Shipping)", "default": 1, "key": "shipping_first_name" }, { "label": "Last Name (Shipping)", "format": "string", "segment": "shipping", "colname": "Last Name (Shipping)", "default": 1, "key": "shipping_last_name" }, { "label": "Address 1&2 (Shipping)", "format": "string", "segment": "shipping", "colname": "Address 1&2 (Shipping)", "default": 1, "key": "shipping_address" }, { "label": "City (Shipping)", "format": "string", "segment": "shipping", "colname": "City (Shipping)", "default": 1, "key": "shipping_city" }, { "label": "State Code (Shipping)", "format": "string", "segment": "shipping", "colname": "State Code (Shipping)", "default": 1, "key": "shipping_state" }, { "label": "Postcode (Shipping)", "format": "string", "segment": "shipping", "colname": "Postcode (Shipping)", "default": 1, "key": "shipping_postcode" }, { "label": "Country Code (Shipping)", "format": "string", "segment": "shipping", "colname": "Country Code (Shipping)", "default": 1, "key": "shipping_country" }, { "label": "Products", "repeat": "rows", "max_cols": 10, "segment": "products", "colname": "Products", "default": 1, "key": "products" }, { "label": "Coupons", "repeat": "rows", "max_cols": 10, "segment": "coupons", "colname": "Coupons", "default": 1, "key": "coupons" }, { "label": "Payment Method Title", "format": "string", "segment": "cart", "colname": "Payment Method Title", "default": 1, "key": "payment_method_title" }, { "label": "Cart Discount Amount", "format": "money", "segment": "cart", "colname": "Cart Discount Amount", "default": 1, "key": "cart_discount" }, { "label": "Order Subtotal Amount", "format": "money", "segment": "cart", "colname": "Order Subtotal Amount", "default": 1, "key": "order_subtotal" }, { "label": "Shipping Method Title", "format": "string", "segment": "ship_calc", "colname": "Shipping Method Title", "default": 1, "key": "shipping_method_title" }, { "label": "Order Shipping Amount", "format": "money", "segment": "ship_calc", "colname": "Order Shipping Amount", "default": 1, "key": "order_shipping" }, { "label": "Order Refund Amount", "format": "money", "segment": "totals", "colname": "Order Refund Amount", "default": 1, "key": "order_refund" }, { "label": "Order Total Amount", "format": "money", "segment": "totals", "colname": "Order Total Amount", "default": 1, "key": "order_total" }, { "label": "Order Total Tax Amount", "format": "money", "segment": "totals", "colname": "Order Total Tax Amount", "default": 1, "key": "order_total_tax" }, { "label": "SKU", "format": "string", "colname": "SKU", "default": 1, "key": "plain_products_sku", "segment": "products" }, { "label": "Item #", "format": "number", "colname": "Item #", "default": 1, "key": "plain_products_line_id", "segment": "products" }, { "label": "Item Name", "format": "string", "colname": "Item Name", "default": 1, "key": "plain_products_name", "segment": "products" }, { "label": "Quantity", "format": "number", "colname": "Quantity", "default": 1, "key": "plain_products_qty", "segment": "products" }, { "label": "Item Cost", "format": "money", "colname": "Item Cost", "default": 1, "key": "plain_products_item_price", "segment": "products" }, { "label": "Coupon Code", "format": "string", "colname": "Coupon Code", "default": 1, "key": "plain_coupons_code", "segment": "coupons" }, { "label": "Discount Amount", "format": "money", "colname": "Discount Amount", "default": 1, "key": "plain_coupons_discount_amount", "segment": "coupons" }, { "label": "Discount Amount Tax", "format": "money", "colname": "Discount Amount Tax", "default": 1, "key": "plain_coupons_discount_amount_tax", "segment": "coupons" } ], "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" } ] }, "profiles": { "1": { "version": "2.0", "mode": "profiles", "title": "TCA Data Export 1", "skip_empty_file": true, "log_results": false, "from_status": [], "to_status": [], "change_order_status_to": "", "statuses": [ "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": "CSV", "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", "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": "add_filter(\u0027woe_get_order_value_recipients_included\u0027,function ($value, $order,$fieldname) {\r\n$recipient_check = get_post_meta( $order->ID, \u0027List of recipients\u0027, true );\r\nif ( !empty($recipient_check)) {\r\n$value = \"1\";\r\n} else {\r\n$value = \"0\";\r\n};\r\nreturn $value;\r\n},10,3);\r\n\r\n\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_Course_Date\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_Date = get_field(\u0027date_start\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_Date)) {\r\n$value =$Course_Date;\r\n} else {\r\n$value = \"NA\";\r\n};\r\n\r\nreturn $value;\r\n}, 10, 5);\r\n\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_course_start_time\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_start = get_field(\u0027hour_start\u0027, $product->id, false, false) .\":\".get_field(\u0027minute_start\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_start)) {\r\n$start =$Course_start;\r\n} else {\r\n$start = \"NA\";\r\n};\r\n\r\nreturn $start;\r\n}, 10, 5);\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_course_end_time\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_end = get_field(\u0027hour_end\u0027, $product->id, false, false) .\":\".get_field(\u0027minute_end\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_end)) {\r\n$end =$Course_end;\r\n} else {\r\n$end = \"NA\";\r\n};\r\n\r\nreturn $end;\r\n}, 10, 5);\r\n\r\n\r\n", "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": "inside_one_cell", "max_cols": "10", "group_by": "product", "line_delimiter": "," } }, "summary_report_by_customers": "0", "order_fields": [ { "segment": "common", "key": "order_number", "label": "Order Number", "format": "string", "colname": "Order Number" }, { "segment": "common", "key": "order_date", "label": "Order Date", "format": "date", "colname": "Order Date" }, { "segment": "billing", "key": "billing_last_name", "label": "Last Name (Billing)", "format": "string", "colname": "Surname" }, { "segment": "billing", "key": "billing_first_name", "label": "First Name (Billing)", "format": "string", "colname": "Forename" }, { "segment": "billing", "key": "billing_address_1", "label": "Address 1 (Billing)", "format": "string", "colname": "Address 1" }, { "segment": "billing", "key": "billing_address_2", "label": "Address 2 (Billing)", "format": "string", "colname": "Address 2" }, { "segment": "billing", "key": "billing_city", "label": "City (Billing)", "format": "string", "colname": "City" }, { "segment": "billing", "key": "billing_postcode", "label": "Postcode (Billing)", "format": "string", "colname": "Postcode" }, { "segment": "billing", "key": "plain_orders__billing_phone", "label": "_billing_phone", "format": "string", "colname": "Phone" }, { "segment": "billing", "key": "billing_email", "label": "Email (Billing)", "format": "string", "colname": "Email" }, { "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": "misc", "key": "plain_orders_recipients_included", "label": "recipients_included", "format": "string", "colname": "Recipients Included" }, { "segment": "products", "key": "products", "colname": "Products", "label": "Products", "format": "undefined" }, { "segment": "products", "key": "plain_products_Course_Date", "label": "Course_Date", "format": "string", "colname": "Course Date" }, { "segment": "products", "key": "plain_products_course_start_time", "label": "course_start_time", "format": "string", "colname": "Course Start Time" }, { "segment": "products", "key": "plain_products_course_end_time", "label": "course_end_time", "format": "string", "colname": "Course End Time" }, { "segment": "products", "key": "plain_products_product_id", "label": "Product Id", "format": "number", "colname": "Product Id" }, { "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" } ], "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": 1, "post_type": "shop_order", "export_rule_field": "date", "export_filename": "orders-%y-%m-%d-%h-%i-%s.csv" }, "2": { "version": "2.0", "mode": "profiles", "title": "TCA Data Export - one off exports", "skip_empty_file": true, "log_results": false, "from_status": [], "to_status": [], "change_order_status_to": "", "statuses": [ "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": "CSV", "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", "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": "add_filter(\u0027woe_get_order_value_recipients_included\u0027,function ($value, $order,$fieldname) {\r\n$recipient_check = get_post_meta( $order->ID, \u0027List of recipients\u0027, true );\r\nif ( !empty($recipient_check)) {\r\n$value = \"1\";\r\n} else {\r\n$value = \"0\";\r\n};\r\nreturn $value;\r\n},10,3);\r\n\r\n\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_Course_Date\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_Date = get_field(\u0027date_start\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_Date)) {\r\n$value =$Course_Date;\r\n} else {\r\n$value = \"NA\";\r\n};\r\n\r\nreturn $value;\r\n}, 10, 5);\r\n\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_course_start_time\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_start = get_field(\u0027hour_start\u0027, $product->id, false, false) .\":\".get_field(\u0027minute_start\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_start)) {\r\n$start =$Course_start;\r\n} else {\r\n$start = \"NA\";\r\n};\r\n\r\nreturn $start;\r\n}, 10, 5);\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_course_end_time\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_end = get_field(\u0027hour_end\u0027, $product->id, false, false) .\":\".get_field(\u0027minute_end\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_end)) {\r\n$end =$Course_end;\r\n} else {\r\n$end = \"NA\";\r\n};\r\n\r\nreturn $end;\r\n}, 10, 5);\r\n\r\n\r\n", "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": "inside_one_cell", "max_cols": "10", "group_by": "product", "line_delimiter": "," } }, "summary_report_by_customers": "0", "order_fields": [ { "segment": "common", "key": "order_number", "label": "Order Number", "format": "string", "colname": "Order Number" }, { "segment": "common", "key": "order_date", "label": "Order Date", "format": "date", "colname": "Order Date" }, { "segment": "billing", "key": "billing_last_name", "label": "Last Name (Billing)", "format": "string", "colname": "Surname" }, { "segment": "billing", "key": "billing_first_name", "label": "First Name (Billing)", "format": "string", "colname": "Forename" }, { "segment": "billing", "key": "billing_address_1", "label": "Address 1 (Billing)", "format": "string", "colname": "Address 1" }, { "segment": "billing", "key": "billing_address_2", "label": "Address 2 (Billing)", "format": "string", "colname": "Address 2" }, { "segment": "billing", "key": "billing_city", "label": "City (Billing)", "format": "string", "colname": "City" }, { "segment": "billing", "key": "billing_postcode", "label": "Postcode (Billing)", "format": "string", "colname": "Postcode" }, { "segment": "billing", "key": "plain_orders__billing_phone", "label": "_billing_phone", "format": "string", "colname": "Phone" }, { "segment": "billing", "key": "billing_email", "label": "Email (Billing)", "format": "string", "colname": "Email" }, { "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": "misc", "key": "plain_orders_recipients_included", "label": "recipients_included", "format": "string", "colname": "Recipients Included" }, { "segment": "products", "key": "products", "colname": "Products", "label": "Products", "format": "undefined" }, { "segment": "products", "key": "plain_products_Course_Date", "label": "Course_Date", "format": "string", "colname": "Course Date" }, { "segment": "products", "key": "plain_products_course_start_time", "label": "course_start_time", "format": "string", "colname": "Course Start Time" }, { "segment": "products", "key": "plain_products_course_end_time", "label": "course_end_time", "format": "string", "colname": "Course End Time" }, { "segment": "products", "key": "plain_products_product_id", "label": "Product Id", "format": "number", "colname": "Product Id" }, { "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" } ], "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": 2, "post_type": "shop_order", "export_rule_field": "date", "export_filename": "orders-%y-%m-%d-%h-%i-%s.csv" } }, "cron": { "1": { "version": "2.0", "mode": "cron", "title": "TCA Data Export", "skip_empty_file": "on", "log_results": "", "from_status": [], "to_status": [], "change_order_status_to": "", "statuses": [ "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": "CSV", "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", "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": "add_filter(\u0027woe_get_order_value_recipients_included\u0027,function ($value, $order,$fieldname) {\r\n$recipient_check = get_post_meta( $order->ID, \u0027List of recipients\u0027, true );\r\nif ( !empty($recipient_check)) {\r\n$value = \"1\";\r\n} else {\r\n$value = \"0\";\r\n};\r\nreturn $value;\r\n},10,3);\r\n\r\n\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_Course_Date\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_Date = get_field(\u0027date_start\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_Date)) {\r\n$value =$Course_Date;\r\n} else {\r\n$value = \"NA\";\r\n};\r\n\r\nreturn $value;\r\n}, 10, 5);\r\n\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_course_start_time\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_start = get_field(\u0027hour_start\u0027, $product->id, false, false) .\":\".get_field(\u0027minute_start\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_start)) {\r\n$start =$Course_start;\r\n} else {\r\n$start = \"NA\";\r\n};\r\n\r\nreturn $start;\r\n}, 10, 5);\r\n\r\n\r\nadd_filter(\u0027woe_get_order_product_value_course_end_time\u0027, function ($value, $order, $item, $product,$item_meta) {\r\n$Course_end = get_field(\u0027hour_end\u0027, $product->id, false, false) .\":\".get_field(\u0027minute_end\u0027, $product->id, false, false);\r\n\r\nif ( !empty($Course_end)) {\r\n$end =$Course_end;\r\n} else {\r\n$end = \"NA\";\r\n};\r\n\r\nreturn $end;\r\n}, 10, 5);\r\n\r\n\r\n", "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": "inside_one_cell", "max_cols": "10", "group_by": "product", "line_delimiter": "," } }, "summary_report_by_customers": "0", "order_fields": [ { "segment": "common", "key": "order_number", "label": "Order Number", "format": "string", "colname": "Order Number" }, { "segment": "common", "key": "order_date", "label": "Order Date", "format": "date", "colname": "Order Date" }, { "segment": "billing", "key": "billing_last_name", "label": "Last Name (Billing)", "format": "string", "colname": "Surname" }, { "segment": "billing", "key": "billing_first_name", "label": "First Name (Billing)", "format": "string", "colname": "Forename" }, { "segment": "billing", "key": "billing_address_1", "label": "Address 1 (Billing)", "format": "string", "colname": "Address 1" }, { "segment": "billing", "key": "billing_address_2", "label": "Address 2 (Billing)", "format": "string", "colname": "Address 2" }, { "segment": "billing", "key": "billing_city", "label": "City (Billing)", "format": "string", "colname": "City" }, { "segment": "billing", "key": "billing_postcode", "label": "Postcode (Billing)", "format": "string", "colname": "Postcode" }, { "segment": "billing", "key": "plain_orders__billing_phone", "label": "_billing_phone", "format": "string", "colname": "Phone" }, { "segment": "billing", "key": "billing_email", "label": "Email (Billing)", "format": "string", "colname": "Email" }, { "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": "misc", "key": "plain_orders_recipients_included", "label": "recipients_included", "format": "string", "colname": "Recipients Included" }, { "segment": "products", "key": "products", "colname": "Products", "label": "Products", "format": "undefined" }, { "segment": "products", "key": "plain_products_Course_Date", "label": "Course_Date", "format": "string", "colname": "Course Date" }, { "segment": "products", "key": "plain_products_course_start_time", "label": "course_start_time", "format": "string", "colname": "Course Start Time" }, { "segment": "products", "key": "plain_products_course_end_time", "label": "course_end_time", "format": "string", "colname": "Course End Time" }, { "segment": "products", "key": "plain_products_product_id", "label": "Product Id", "format": "number", "colname": "Product Id" }, { "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" } ], "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": 1, "post_type": "shop_order", "export_rule_field": "date", "export_filename": "orders-%y-%m-%d-%h-%i-%s.csv", "destination": { "type": [ "email" ], "email_from": "", "email_from_name": "", "email_subject": "TCA Order Export", "email_body": "", "email_recipients": "[email protected],[email protected]", "email_recipients_cc": "", "email_recipients_bcc": "", "ftp_server": "", "ftp_port": "", "ftp_user": "", "ftp_pass": "", "ftp_path": "", "ftp_conn_timeout": "", "ftp_max_retries": "", "sftp_server": "", "sftp_port": "", "sftp_user": "", "sftp_pass": "", "sftp_private_key_path": "", "sftp_path": "", "sftp_conn_timeout": "", "sftp_max_retries": "", "http_post_url": "", "http_post_conn_timeout": "", "http_post_max_retries": "", "path": "\/home\/coac\/web\/thecookingacademy.co.uk\/public_html\/", "zapier_export_order_product_columns": "10", "zapier_export_order_coupon_columns": "10" }, "export_rule": "this_year", "schedule": { "type": "schedule-3", "times": "Sun 09:00,Sun 14:00,Mon 09:00,Mon 14:00,Tue 09:00,Tue 14:00,Wed 09:00,Wed 14:00,Thu 09:00,Thu 14:00,Fri 09:00,Fri 14:00,Sat 09:00,Sat 14:00", "date_times": "", "last_run": 1652955323, "last_report_sent": 1652955323, "next_run": 1652968800 }, "export_rule_custom": "3" } }, "order-action": [] }- This reply was modified 2 years, 4 months ago by Yui. Reason: formatting
in all cases where I have referenced the key, I am using the one WITHOUT the _ including the raw data (this was only for output to see what was being pulled through)
here is the FULL custom php script :
add_filter('woe_get_order_value_recipients_included',function ($recipient, $order,$fieldname) { $recipient_check = get_post_meta( $order->ID, 'List of recipients', true ); if ( !empty($recipient_check)) { $recipient = "1"; } else { $recipient = "0"; }; return $recipient; },10,3); <!--------- THIS IS THE PART GETTING THE COURSE DATE -----------> add_filter('woe_get_order_product_value_Course_Date', function ($prod, $order, $item, $product,$item_meta) { $Course_Date = get_field('date_start', $product->id, false, false); if ( !empty($Course_Date)) { $prod =$Course_Date; } else { $prod = "NA"; }; return $prod; }, 10, 5); <!--------- THIS IS THE PART GETTING THE COURSE DATE -----------> add_filter('woe_get_order_product_value_course_start_time', function ($start, $order, $item, $product,$item_meta) { $Course_start = get_field('hour_start', $product->id, false, false) .":".get_field('minute_start', $product->id, false, false); if ( !empty($Course_start)) { $start =$Course_start; } else { $start = "NA"; }; return $start; }, 10, 5); add_filter('woe_get_order_product_value_course_end_time', function ($end, $order, $item, $product,$item_meta) { $Course_end = get_field('hour_end', $product->id, false, false) .":".get_field('minute_end', $product->id, false, false); if ( !empty($Course_end)) { $end =$Course_end; } else { $end = "NA"; }; return $end; }, 10, 5);here you can see the preview results of the export:
https://snipboard.io/4iemuY.jpg
there are 3 types of products:
course (which returns the course date)
a voucher (which has no start date)
a product (which returns no start date).in the screenshot above, you can see order ID 19198 and 19196 both have voucher products, one is returning “field_54204715de01b” (no data), yet the other is returning NaN. both products are setup the same. again, order 19179 also says NaN
further down, a physical product (order 19173) is also returning NaN where other physical products are returning the empty field.
products do not show this data in order items, so no need to send screenshots of these.
for the products in 19198 and 19196, both course_date fields are blank as dates do not apply to these products, the same is said for the physical products (19173)
can you be more specific please. where do you mean “items”
I have now updated to woocommerce 4.0 and this appears to be working.
also – your ticket system does not work, it does not verify the recaptcha
Hi – we have now upgraded woocommerce to 2.4, and now receive a different error with the export plugin:
Fatal error: Uncaught Error: Call to a member function get_product() on array in /home/coac/web/thecookingacademy.co.uk/public_html/wp-content/plugins/woo-order-export-lite/classes/core/class-wc-order-export-data-extractor.php:1570 Stack trace: #0 /home/coac/web/thecookingacademy.co.uk/public_html/wp-content/plugins/woo-order-export-lite/classes/core/class-wc-order-export-data-extractor.php(1701): WC_Order_Export_Data_Extractor::fetch_order_products(Object(WC_Order), Object(WC_Order_Export_Labels), Array, Array, Object(WC_Order_Export_Order_Fields)) #1 /home/coac/web/thecookingacademy.co.uk/public_html/wp-content/plugins/woo-order-export-lite/classes/core/class-wc-order-export-engine.php(485): WC_Order_Export_Data_Extractor::fetch_order_data('19484', Array, Array, Array, Array) #2 /home/coac/web/thecookingacademy.co.uk/public_html/wp-content/plugins/woo-order-export-lite/classes/admin/tabs/ajax/trait-wc-order-export-admin-tab-abstract-ajax-export.php(25): WC_Order_Export_Engine::build_file(Array, 'preview', 'browser', 0, in /home/coac/web/thecookingacademy.co.uk/public_html/wp-content/plugins/woo-order-export-lite/classes/core/class-wc-order-export-data-extractor.php on line 1570please advise.
how would I go about that (even if bad) – simply add that function to the functions.php?
is there any way around it without upgrading WC?