Skip to content
Documentación

Exportar Datos

Exportar datos en Excel o CSV

Sección titulada «Exportar datos en Excel o CSV»

Los datos de las facturas se pueden exportar en Excel o CSV. Para ello debemos utilizar algún plugin de exportación de pedidos (por ejemplo Advanced Order Export For WooCommerce), y seleccionar las siguientes columnas:

  • Campo Metadata afip_cae: Representa el número de CAE de la factura.
  • Campo Metadata afip_invoice_number: Representa el número de factura.
  • Campo Metadata afip_credit_note_cae: Representa el número de CAE de la nota de crédito si existe.
  • Campo Metadata afip_credit_note_number: Representa el número de la nota de crédito si existe.
  • Campo Metadata afip_document_number: Representa el número de documento del cliente al que se le emitió la factura.
  • Campo Metadata afip_invoice_type: Representa el tipo de factura. Donde:
    • 1: Factura A
    • 6: Factura B
    • 11: Factura C
Configuración de exportación de pedidos

Ejemplo de configuración

Sección titulada «Ejemplo de configuración»
Datos de exportación de pedidos

Este es un ejemplo de configuración para el plugin Advanced Order Export For WooCommerce. Se puede utilizar yendo a WooCommerce > Exportar pedidos > Herramientas, pegando el códigoy haciendo click en Importar Ajustes.

{
"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": "CSV",
"format_xls_use_xls_format": "0",
"format_xls_sheet_name": "Pedidos",
"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": "N\u00famero de pedido",
"format": "string",
"colname": "N\u00famero de pedido"
},
{
"segment": "common",
"key": "order_status",
"label": "Estado del pedido",
"format": "string",
"colname": "Estado del pedido"
},
{
"segment": "common",
"key": "order_date",
"label": "Fecha del pedido",
"format": "date",
"colname": "Fecha del pedido"
},
{
"segment": "common",
"key": "customer_note",
"label": "Nota del cliente",
"format": "string",
"colname": "Nota del cliente"
},
{
"segment": "billing",
"key": "billing_first_name",
"label": "Nombre (facturaci\u00f3n)",
"format": "string",
"colname": "Nombre (facturaci\u00f3n)"
},
{
"segment": "billing",
"key": "billing_last_name",
"label": "Apellidos (facturaci\u00f3n)",
"format": "string",
"colname": "Apellidos (facturaci\u00f3n)"
},
{
"segment": "billing",
"key": "billing_company",
"label": "Empresa (facturaci\u00f3n)",
"format": "string",
"colname": "Empresa (facturaci\u00f3n)"
},
{
"segment": "billing",
"key": "billing_address",
"label": "Direcci\u00f3n lineas 1 y 2 (facturaci\u00f3n)",
"format": "string",
"colname": "Direcci\u00f3n lineas 1 y 2 (facturaci\u00f3n)"
},
{
"segment": "billing",
"key": "billing_city",
"label": "Ciudad (facturaci\u00f3n)",
"format": "string",
"colname": "Ciudad (facturaci\u00f3n)"
},
{
"segment": "billing",
"key": "billing_state",
"label": "C\u00f3digo de provincia (facturaci\u00f3n)",
"format": "string",
"colname": "C\u00f3digo de provincia (facturaci\u00f3n)"
},
{
"segment": "billing",
"key": "billing_postcode",
"label": "C\u00f3digo postal (facturaci\u00f3n)",
"format": "string",
"colname": "C\u00f3digo postal (facturaci\u00f3n)"
},
{
"segment": "billing",
"key": "billing_country",
"label": "C\u00f3digo del pa\u00eds (facturaci\u00f3n)",
"format": "string",
"colname": "C\u00f3digo del pa\u00eds (facturaci\u00f3n)"
},
{
"segment": "cart",
"key": "payment_method_title",
"label": "T\u00edtulo del m\u00e9todo de pago",
"format": "string",
"colname": "T\u00edtulo del m\u00e9todo de pago"
},
{
"segment": "cart",
"key": "cart_discount",
"label": "Importe de descuento del carrito",
"format": "money",
"colname": "Importe de descuento del carrito"
},
{
"segment": "cart",
"key": "cart_discount_inc_tax",
"label": "Cantidad de descuento en el carrito (impuestos incluidos)",
"format": "money",
"colname": "Cantidad de descuento en el carrito (impuestos incluidos)"
},
{
"segment": "cart",
"key": "order_subtotal",
"label": "Importe de subtotal del pedido",
"format": "money",
"colname": "Importe de subtotal del pedido"
},
{
"segment": "ship_calc",
"key": "shipping_method_title",
"label": "T\u00edtulo del m\u00e9todo de env\u00edo",
"format": "string",
"colname": "T\u00edtulo del m\u00e9todo de env\u00edo"
},
{
"segment": "ship_calc",
"key": "order_shipping",
"label": "Importe de env\u00edo del pedido",
"format": "money",
"colname": "Importe de env\u00edo del pedido"
},
{
"segment": "totals",
"key": "order_refund",
"label": "Importe reembolsado del pedido",
"format": "money",
"colname": "Importe reembolsado del pedido"
},
{
"segment": "totals",
"key": "order_total",
"label": "Importe total del pedido",
"format": "money",
"colname": "Importe total del pedido"
},
{
"segment": "totals",
"key": "order_total_tax",
"label": "Importe total de impuestos del pedido",
"format": "money",
"colname": "Importe total de impuestos del pedido"
},
{
"segment": "products",
"key": "products",
"colname": "Productos",
"label": "Productos",
"format": "undefined"
},
{
"segment": "products",
"key": "plain_products_sku",
"label": "SKU",
"format": "string",
"colname": "SKU"
},
{
"segment": "products",
"key": "plain_products_line_id",
"label": "Art\u00edculo #",
"format": "number",
"colname": "Art\u00edculo #"
},
{
"segment": "products",
"key": "plain_products_name",
"label": "Nombre del art\u00edculo",
"format": "string",
"colname": "Nombre del art\u00edculo"
},
{
"segment": "products",
"key": "plain_products_qty_minus_refund",
"label": "Cantidad (- reembolso)",
"format": "number",
"colname": "Cantidad (- reembolso)"
},
{
"segment": "products",
"key": "plain_products_item_price",
"label": "Coste de art\u00edculo",
"format": "money",
"colname": "Coste de art\u00edculo"
},
{
"segment": "coupons",
"key": "coupons",
"colname": "Cupones",
"label": "Cupones",
"format": "undefined"
},
{
"segment": "coupons",
"key": "plain_coupons_code",
"label": "C\u00f3digo de cup\u00f3n",
"format": "string",
"colname": "C\u00f3digo de cup\u00f3n"
},
{
"segment": "coupons",
"key": "plain_coupons_discount_amount",
"label": "Importe de descuento",
"format": "money",
"colname": "Importe de descuento"
},
{
"segment": "misc",
"key": "plain_orders_afip_cae",
"label": "afip_cae",
"format": "",
"colname": "ARCA - N\u00famero CAE de factura"
},
{
"segment": "misc",
"key": "plain_orders_afip_invoice_number",
"label": "afip_invoice_number",
"format": "",
"colname": "ARCA - N\u00famero de factura"
},
{
"segment": "misc",
"key": "plain_orders_afip_credit_note_cae",
"label": "afip_credit_note_cae",
"format": "",
"colname": "ARCA - N\u00famero CAE de nota de cr\u00e9dito"
},
{
"segment": "misc",
"key": "plain_orders_afip_credit_note_number",
"label": "afip_credit_note_number",
"format": "",
"colname": "ARCA - N\u00famero de nota de cr\u00e9dito"
},
{
"segment": "misc",
"key": "plain_orders_afip_document_number",
"label": "afip_document_number",
"format": "",
"colname": "ARCA - N\u00famero de documento facturado"
},
{
"segment": "misc",
"key": "plain_orders_afip_invoice_type",
"label": "afip_invoice_type",
"format": "",
"colname": "ARCA - Tipo de factura"
}
],
"order_product_fields": [
{
"label": "SKU",
"format": "string",
"colname": "SKU",
"default": 1,
"key": "sku"
},
{
"label": "Art\u00edculo #",
"format": "number",
"colname": "Art\u00edculo #",
"default": 1,
"key": "line_id"
},
{
"label": "Nombre del art\u00edculo",
"format": "string",
"colname": "Nombre del art\u00edculo",
"default": 1,
"key": "name"
},
{
"label": "Cantidad (- reembolso)",
"format": "number",
"colname": "Cantidad (- reembolso)",
"default": 1,
"key": "qty_minus_refund"
},
{
"label": "Coste de art\u00edculo",
"format": "money",
"colname": "Coste de art\u00edculo",
"default": 1,
"key": "item_price"
}
],
"order_coupon_fields": [
{
"label": "C\u00f3digo de cup\u00f3n",
"format": "string",
"colname": "C\u00f3digo de cup\u00f3n",
"default": 1,
"key": "code"
},
{
"label": "Importe de descuento",
"format": "money",
"colname": "Importe de descuento",
"default": 1,
"key": "discount_amount"
},
{
"label": "Importe de impuestos del descuento",
"format": "money",
"colname": "Importe de impuestos del descuento",
"default": 1,
"key": "discount_amount_tax"
}
],
"id": 0,
"post_type": "shop_order",
"export_rule_field": "date",
"export_filename": "orders-%y-%m-%d-%h-%i-%s.csv",
"display_summary_row": "0",
"summary_row_title": "Total"
},
"profiles": [],
"cron": [],
"order-action": []
}