Title: Exporting based off custom fields
Last modified: October 24, 2024

---

# Exporting based off custom fields

 *  [td1389](https://wordpress.org/support/users/td1389/)
 * (@td1389)
 * [1 year, 7 months ago](https://wordpress.org/support/topic/exporting-based-off-custom-fields/)
 * I have a bit of a specific usecase here.
   I’m using Advanced Checkout Fields to
   generate some additional fields for the user to enter ‘Names of submissions/Entry
   title’ at the checkout.I would ideally like to be able to export the data having
   a new row for each one of these submission names.It works like this, for example;
   1. User adds 5 tickets to their cart.2. At checkout, user enters a name for each
   ticket (submission)3. Data is then exported and each row will be based on the
   quantity (5 in this example)4. Columns would then be, (First Name / Last Name/
   Quantity / Entry Title)Currently I’m getting it to export, but all 5 titles are
   in each row, whereas I would like a row for each entry title.The metakey for 
   each entry is unique and generates as (for example, in the case of 5 entries);
   order_entrytitle_1_0order_entrytitle_2_0order_entrytitle_3_0order_entrytitle_4_0order_entrytitle_5_0Could
   anybody assist with a way I could get this to export based on the above?Thanks
   in advance

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [1 year, 7 months ago](https://wordpress.org/support/topic/exporting-based-off-custom-fields/#post-18094999)
 * hello
 * please, share your settings .
 * visit tab “Tools” to get them.
 *  Thread Starter [td1389](https://wordpress.org/support/users/td1389/)
 * (@td1389)
 * [1 year, 7 months ago](https://wordpress.org/support/topic/exporting-based-off-custom-fields/#post-18095016)
 * No problem. Please see below
 *     ```wp-block-code
       {"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": "1","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": "add_filter( \"woe_fetch_order\", function($row, $order ){\r\n foreach($order->get_meta() as $item) {\r\n $key = $order[\u0027order_entrytitle_1_0\u0027];\r\n if( isset($row[$key]))\r\n $row[$key] = $item[\u0027order_entrytitle_1_0\u0027];\r\n }\r\n return $row;\r\n},10,2);","mark_exported_orders": "0","export_unmarked_orders": "0","summary_report_by_products": "0","duplicated_fields_settings": {"products": {"repeat": "rows","populate_other_columns": "1","max_cols": "10","group_by": "product","line_delimiter": "\n"},"coupons": {"repeat": "rows","max_cols": "10","group_by": "product","line_delimiter": "\n"}},"summary_report_by_customers": "0","order_fields": [{"segment": "common","key": "order_number","label": "Order Number","format": "string","colname": "Order Number"},{"segment": "billing","key": "billing_first_name","label": "First Name (Billing)","format": "string","colname": "First Name (Billing)"},{"segment": "billing","key": "billing_last_name","label": "Last Name (Billing)","format": "string","colname": "Last Name (Billing)"},{"segment": "billing","key": "billing_email","label": "Email (Billing)","format": "string","colname": "Email (Billing)"},{"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": "misc","key": "plain_orders_order_entrycategory","label": "order_entrycategory","format": "string","colname": "Category"},{"segment": "misc","key": "plain_orders_order_entrytitle_1_0","label": "order_entrytitle_1_0","format": "string","colname": "Entry Title"},{"segment": "misc","key": "plain_orders_order_entrytitle_2_0","label": "order_entrytitle_2_0","format": "string","colname": "Entry Title"},{"segment": "coupons","key": "coupons","colname": "Coupons","label": "Coupons","format": "undefined"}],"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 (- Refund)","format": "number","colname": "Quantity (- Refund)","default": 1,"key": "qty_minus_refund"},{"label": "Item Cost","format": "money","colname": "Item Cost","default": 1,"key": "item_price"}],"order_coupon_fields": [{"label": "Coupon Code","format": "string","colname": "Coupon Code","default": 1,"key": "code"},{"label": "Discount Amount","format": "money","colname": "Discount Amount","default": 1,"key": "discount_amount"},{"label": "Discount Amount Tax","format": "money","colname": "Discount Amount Tax","default": 1,"key": "discount_amount_tax"}],"id": 0,"post_type": "shop_order","export_rule_field": "date","export_filename": "orders-%y-%m-%d-%h-%i-%s.xlsx","summary_row_title": "Total"},"profiles": [],"cron": [],"order-action": []}
       ```
   
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [1 year, 7 months ago](https://wordpress.org/support/topic/exporting-based-off-custom-fields/#post-18095065)
 * Do you use paid [https://aceplugins.com/plugin/advanced-checkout-fields-woocommerce/](https://aceplugins.com/plugin/advanced-checkout-fields-woocommerce/)??
 * Please, submit this plugin (zip file) as new tcket to [https://algolplus.freshdesk.com/](https://algolplus.freshdesk.com/)
   
   OR review examples in [https://docs.algolplus.com/algol_order_export/add-product-rows/](https://docs.algolplus.com/algol_order_export/add-product-rows/)
   and code script yourself.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Exporting based off custom fields’ is closed to new replies.

 * ![](https://ps.w.org/woo-order-export-lite/assets/icon-256x256.png?rev=1365554)
 * [Advanced Order Export For WooCommerce](https://wordpress.org/plugins/woo-order-export-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-order-export-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-order-export-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-order-export-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-order-export-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-order-export-lite/reviews/)

## Tags

 * [checkout fields](https://wordpress.org/support/topic-tag/checkout-fields/)
 * [custom field](https://wordpress.org/support/topic-tag/custom-field/)
 * [export](https://wordpress.org/support/topic-tag/export/)

 * 3 replies
 * 2 participants
 * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/)
 * Last activity: [1 year, 7 months ago](https://wordpress.org/support/topic/exporting-based-off-custom-fields/#post-18095065)
 * Status: not resolved