Created
March 11, 2024 18:31
-
-
Save NazarenkoDenis/652fc57ed9da9b8c6a1d80d961dc3bd2 to your computer and use it in GitHub Desktop.
This file contains 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
{ | |
"id": "009400b7-e20e-41ad-a0ba-c0f3eee75cb8", | |
"title": "pxq v4", | |
"group": "My Reports", | |
"description": "Each order is in a new row. You can find out the order with the biggest amount, show orders from a specific customer or orders containing a specific product.", | |
"tags": [ | |
"Orders", | |
"Detailed" | |
], | |
"hiddenFields": [ | |
"customers.name", | |
"orders.source_name", | |
"orders.fulfillment_status", | |
"orders.total_line_items_price", | |
"refunds.total_gross_amount", | |
"orders.total_net_sales", | |
"orders.total_shipping_amount", | |
"orders.total_tax_amount", | |
"orders.total_sales_amount", | |
"payout_transactions.source_type", | |
"orders.tipo", | |
"orders.is_out_sell_order", | |
"orders.tags", | |
"orders.url_boleta_28844", | |
"orders.billing_address_zip", | |
"orders.shipping_address_zip", | |
"orders.financial_status", | |
"orders.note_attributes", | |
"orders.shopify_payout", | |
"payouts.status", | |
"transactions.x_account_id", | |
"orders.source_identifier", | |
"orders.processing_method", | |
"payout_transactions.type", | |
"transactions.x_message", | |
"payout_transactions.payout_status", | |
"transactions.x_gateway_reference", | |
"transactions.x_auth_code", | |
"transactions.x_signature", | |
"fulfillments.tracking_numbers", | |
"transactions.payment_details", | |
"orders.billing_address_company", | |
"locations.province", | |
"transactions.id", | |
"payout_transactions.id", | |
"transactions.payment_id", | |
"orders.shipping_address_company", | |
"orders.quantity" | |
], | |
"fieldLabels": { | |
"locations.province": "Departamento de Facturacion", | |
"order_items.price": "Precio por unidad", | |
"order_items.product_name": "Nombre", | |
"order_items.sku": "Sku", | |
"order_items.total_price": "Fila Total", | |
"orders.billing_address_address2": "Provincia Facturacion", | |
"orders.billing_address_city": "Distrito de Facturacion", | |
"orders.billing_address_company": "DNI de Facturacion", | |
"orders.billing_address_first_name": "Nombre de Facturacion", | |
"orders.billing_address_last_name": "Apellido de Facturacion", | |
"orders.billing_address_phone": "Telephone de Envío", | |
"orders.billing_address_province": "Departamento de Facturación", | |
"orders.billing_address_zip": "Departamento de Facturacion", | |
"orders.discount_code": "Código de cupón", | |
"orders.email": "Correo electrónico", | |
"orders.financial_status_customized": "Estado", | |
"orders.gateway": "Metodo Pago", | |
"orders.name": "Número de pedido", | |
"orders.note": "Consideraciones Adicionales", | |
"orders.processed_at": "Fecha", | |
"orders.quantity": "Cant.", | |
"orders.razon_social": "Razón Social", | |
"orders.ruc": "Ruc Empresa", | |
"orders.shipping_address_address": "Dirección de Envío", | |
"orders.shipping_address_address2": "Provincia Envio", | |
"orders.shipping_address_city": "Distrito de Envío", | |
"orders.shipping_address_company": "DNI de Envío", | |
"orders.shipping_address_first_name": "Nombre de Envío", | |
"orders.shipping_address_last_name": "Apellido de Envío", | |
"orders.shipping_address_phone": "Telephone de Facturacion", | |
"orders.shipping_address_province": "Departamento de Envío", | |
"orders.shipping_address_zip": "Departamento de Envío", | |
"orders.shipping_method_title": "Método de Envio", | |
"orders.total_discounts": "Descuento", | |
"orders.total_quantity": "Cant.", | |
"orders.total_shipping_price": "Importe del Envío", | |
"orders.total_weight": "Peso", | |
"sales.location": "Ver Tienda", | |
"transactions.x_message": "Consideraciones adicionales" | |
}, | |
"displayMode": "table", | |
"visualizationType": "line", | |
"toolbar": { | |
"dimensions": [], | |
"filters": [ | |
"orders.processed_at" | |
] | |
}, | |
"visualization": { | |
"graphFields": [ | |
"orders.total_quantity" | |
], | |
"pieFields": [ | |
"orders.source_name", | |
"orders.total_sales_amount", | |
"sales.location", | |
"orders.total_weight", | |
"orders.total_quantity" | |
], | |
"scalarFields": [], | |
"cumulative": false, | |
"frozenFields": [], | |
"columnWidths": {} | |
}, | |
"query": { | |
"model": "shopify", | |
"explore": "orders", | |
"fields": [ | |
"orders.id", | |
"sales.location", | |
"orders.processed_at", | |
"orders.name", | |
"orders.billing_address_company", | |
"orders.dni_de_faturacion", | |
"orders.billing_address_first_name", | |
"orders.billing_address_last_name", | |
"orders.billing_address_address", | |
"orders.billing_address_city", | |
"orders.billing_address_zip", | |
"orders.shipping_method_title", | |
"orders.billing_address_address2", | |
"locations.province", | |
"orders.billing_address_province", | |
"orders.shipping_address_phone", | |
"orders.email", | |
"orders.shipping_address_company", | |
"orders.dni_de_envio", | |
"orders.shipping_address_first_name", | |
"orders.shipping_address_last_name", | |
"orders.ruc", | |
"orders.razon_social", | |
"orders.shipping_address_address", | |
"orders.shipping_address_city", | |
"orders.shipping_address_address2", | |
"orders.shipping_address_province", | |
"orders.shipping_address_zip", | |
"orders.billing_address_phone", | |
"orders.total_quantity", | |
"orders.quantity", | |
"orders.total_kgs", | |
"order_items.sku", | |
"order_items.product_name", | |
"orders.gateway", | |
"payout_transactions.source_type", | |
"payout_transactions.payout_status", | |
"orders.financial_status_customized", | |
"orders.discount_code", | |
"orders.codigo_Bebe", | |
"orders.total_shipping_price", | |
"order_items.price", | |
"order_items.total_price", | |
"orders.total_discounts", | |
"transactions.x_message", | |
"orders.is_out_sell_order", | |
"orders.url_boleta_28844", | |
"orders.tipo", | |
"payout_transactions.type", | |
"payouts.status", | |
"orders.note", | |
"orders.processing_method", | |
"orders.tags", | |
"orders.note_attributes", | |
"orders.source_identifier", | |
"orders.shopify_payout", | |
"transactions.x_account_id", | |
"transactions.x_gateway_reference", | |
"transactions.x_auth_code", | |
"transactions.x_signature", | |
"fulfillments.tracking_numbers", | |
"transactions.payment_details", | |
"orders.financial_status", | |
"orders.fulfillment_status", | |
"transactions.id", | |
"payout_transactions.id", | |
"transactions.payment_id" | |
], | |
"pivotFields": [], | |
"sorts": [ | |
{ | |
"field": "orders.processed_at", | |
"direction": "desc" | |
} | |
], | |
"filter": { | |
"condition": "and", | |
"groups": [], | |
"filters": [ | |
{ | |
"field": "orders.total_net_sales", | |
"condition": "gt", | |
"value": "0", | |
"group": "", | |
"disabled": false | |
}, | |
{ | |
"field": "orders.financial_status_customized", | |
"condition": "eq", | |
"value": "Complete", | |
"group": "", | |
"disabled": false | |
}, | |
{ | |
"field": "transactions.status", | |
"condition": "eq", | |
"value": "success", | |
"group": "", | |
"disabled": false | |
}, | |
{ | |
"field": "orders.processed_at", | |
"condition": "named", | |
"value": "today", | |
"group": "A", | |
"disabled": false | |
} | |
] | |
}, | |
"parameters": [], | |
"limit": 50, | |
"offset": 0, | |
"crossFilters": [] | |
}, | |
"meta": { | |
"userDefined": true | |
}, | |
"isShared": false | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment