Last active
December 22, 2025 12:54
-
-
Save dimaspante/494a44b00c21913ecc5665e077e7e740 to your computer and use it in GitHub Desktop.
Padrão para exportação de pedidos Woocommerce
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "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": "2021-12-01", | |
| "to_date": "2021-12-01", | |
| "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_auto_height": "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_order_having_excluded_products": "0", | |
| "skip_refunded_items": "0", | |
| "skip_suborders": "0", | |
| "export_refunds": "0", | |
| "export_matched_items": "0", | |
| "exclude_free_items": "0", | |
| "date_format": "Y-m-d", | |
| "time_format": "H:i", | |
| "sort_direction": "DESC", | |
| "sort": "order_id", | |
| "format_number_fields": "0", | |
| "export_all_comments": "0", | |
| "export_refund_notes": "0", | |
| "strip_tags_product_fields": "0", | |
| "strip_html_tags": "0", | |
| "round_item_tax_rate": "0", | |
| "cleanup_phone": "0", | |
| "convert_serialized_values": "0", | |
| "enable_debug": "0", | |
| "billing_details_for_shipping": "0", | |
| "custom_php": "0", | |
| "custom_php_code": "", | |
| "mark_exported_orders": "0", | |
| "export_unmarked_orders": "0", | |
| "summary_report_by_products": "0", | |
| "duplicated_fields_settings": { | |
| "products": { | |
| "repeat": "rows", | |
| "populate_other_columns": "1", | |
| "max_cols": "10", | |
| "group_by": "product", | |
| "line_delimiter": "\\n" | |
| }, | |
| "coupons": { | |
| "repeat": "rows", | |
| "max_cols": "10", | |
| "group_by": "product", | |
| "line_delimiter": "\\n" | |
| } | |
| }, | |
| "summary_report_by_customers": "0", | |
| "destination": { | |
| "zapier_export_type": "order_items" | |
| }, | |
| "order_fields": [ | |
| { | |
| "segment": "common", | |
| "key": "order_number", | |
| "label": "Order Number", | |
| "format": "string", | |
| "colname": "Pedido" | |
| }, | |
| { | |
| "segment": "common", | |
| "key": "order_status", | |
| "label": "Order Status", | |
| "format": "string", | |
| "colname": "Status" | |
| }, | |
| { | |
| "segment": "common", | |
| "key": "order_date", | |
| "label": "Order Date", | |
| "format": "date", | |
| "colname": "Data" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_full_name", | |
| "label": "Full Name (Billing)", | |
| "format": "string", | |
| "colname": "Nome (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "plain_orders__billing_persontype", | |
| "label": "_billing_persontype", | |
| "format": "string", | |
| "colname": "Tipo (1 - PF \/ 2 - PJ)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "plain_orders__billing_cpf", | |
| "label": "_billing_cpf", | |
| "format": "string", | |
| "colname": "CPF (cobran\u00e7a PF)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "plain_orders__billing_cnpj", | |
| "label": "_billing_cnpj", | |
| "format": "string", | |
| "colname": "CNPJ (cobran\u00e7a PJ)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "plain_orders__billing_ie", | |
| "label": "_billing_ie", | |
| "format": "string", | |
| "colname": "Inscri\u00e7\u00e3o Estadual (cobran\u00e7a PJ)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_company", | |
| "label": "Company (Billing)", | |
| "format": "string", | |
| "colname": "Empresa (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_address_1", | |
| "label": "Address 1 (Billing)", | |
| "format": "string", | |
| "colname": "Endere\u00e7o (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "plain_orders__billing_number", | |
| "label": "_billing_number", | |
| "format": "string", | |
| "colname": "N\u00famero (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_address_2", | |
| "label": "Address 2 (Billing)", | |
| "format": "string", | |
| "colname": "Complemento (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "plain_orders__billing_neighborhood", | |
| "label": "_billing_neighborhood", | |
| "format": "string", | |
| "colname": "Bairro (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_city", | |
| "label": "City (Billing)", | |
| "format": "string", | |
| "colname": "Cidade (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_state", | |
| "label": "State Code (Billing)", | |
| "format": "string", | |
| "colname": "Estado (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_postcode", | |
| "label": "Postcode (Billing)", | |
| "format": "string", | |
| "colname": "CEP (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_country", | |
| "label": "Country Code (Billing)", | |
| "format": "string", | |
| "colname": "Pa\u00eds (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_email", | |
| "label": "Email (Billing)", | |
| "format": "string", | |
| "colname": "E-mail (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "billing", | |
| "key": "billing_phone", | |
| "label": "Phone (Billing)", | |
| "format": "string", | |
| "colname": "Telefone (cobran\u00e7a)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "shipping_full_name", | |
| "label": "Full Name (Shipping)", | |
| "format": "string", | |
| "colname": "Nome (envio)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "shipping_address_1", | |
| "label": "Address 1 (Shipping)", | |
| "format": "string", | |
| "colname": "Endere\u00e7o (envio)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "plain_orders__shipping_number", | |
| "label": "_shipping_number", | |
| "format": "string", | |
| "colname": "N\u00famero (envio)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "shipping_address_2", | |
| "label": "Address 2 (Shipping)", | |
| "format": "string", | |
| "colname": "Complemento (envio)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "plain_orders__shipping_neighborhood", | |
| "label": "_shipping_neighborhood", | |
| "format": "string", | |
| "colname": "Bairro (envio)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "shipping_city", | |
| "label": "City (Shipping)", | |
| "format": "string", | |
| "colname": "Cidade (envio)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "shipping_state", | |
| "label": "State Code (Shipping)", | |
| "format": "string", | |
| "colname": "Estado (envio)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "shipping_postcode", | |
| "label": "Postcode (Shipping)", | |
| "format": "string", | |
| "colname": "CEP (envio)" | |
| }, | |
| { | |
| "segment": "shipping", | |
| "key": "shipping_country", | |
| "label": "Country Code (Shipping)", | |
| "format": "string", | |
| "colname": "Pa\u00eds (envio)" | |
| }, | |
| { | |
| "segment": "cart", | |
| "key": "payment_method_title", | |
| "label": "Payment Method Title", | |
| "format": "string", | |
| "colname": "M\u00e9todo de pagamento" | |
| }, | |
| { | |
| "segment": "cart", | |
| "key": "order_subtotal", | |
| "label": "Order Subtotal Amount", | |
| "format": "money", | |
| "colname": "Subtotal do pedido" | |
| }, | |
| { | |
| "segment": "ship_calc", | |
| "key": "shipping_method_title", | |
| "label": "Shipping Method Title", | |
| "format": "string", | |
| "colname": "M\u00e9todo de envio" | |
| }, | |
| { | |
| "segment": "ship_calc", | |
| "key": "order_shipping", | |
| "label": "Order Shipping Amount", | |
| "format": "money", | |
| "colname": "Valor do frete" | |
| }, | |
| { | |
| "segment": "totals", | |
| "key": "order_total", | |
| "label": "Order Total Amount", | |
| "format": "money", | |
| "colname": "Valor total do pedido" | |
| }, | |
| { | |
| "segment": "common", | |
| "key": "customer_note", | |
| "label": "Customer Note", | |
| "format": "string", | |
| "colname": "Observa\u00e7\u00f5es do cliente" | |
| }, | |
| { | |
| "segment": "common", | |
| "key": "order_notes", | |
| "label": "Order Notes", | |
| "format": "string", | |
| "colname": "Notas do pedido" | |
| }, | |
| { | |
| "segment": "products", | |
| "key": "products", | |
| "colname": "Products", | |
| "label": "Products", | |
| "format": "undefined" | |
| }, | |
| { | |
| "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": "Nome do item" | |
| }, | |
| { | |
| "segment": "products", | |
| "key": "plain_products_qty", | |
| "label": "Quantity", | |
| "format": "number", | |
| "colname": "Quantidade" | |
| }, | |
| { | |
| "segment": "products", | |
| "key": "plain_products_product_variation", | |
| "label": "Order Item Metadata", | |
| "format": "string", | |
| "colname": "Dados do item" | |
| }, | |
| { | |
| "segment": "products", | |
| "key": "plain_products_item_price", | |
| "label": "Item Cost", | |
| "format": "money", | |
| "colname": "Valor do item" | |
| }, | |
| { | |
| "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", | |
| "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": "pedidos-%y-%m-%d-%h-%i-%s.xlsx", | |
| "display_summary_row": "0", | |
| "summary_row_title": "Total" | |
| }, | |
| "profiles": [], | |
| "cron": [], | |
| "order-action": [] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment