The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "v25.1.1",
"nodes": [
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "consulta",
"value": "={{ $json.consulta }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
384,
2224
],
"id": "c4f85434-4b81-4d69-91be-ce53290b7b53",
"name": "GET Clients",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
320,
3216
],
"id": "82ba8283-b6e5-49b9-8b06-fbaaff519419",
"name": "Respond to Webhook1"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-208,
3088
],
"id": "333b7d5b-3e5a-4ff2-868f-d7d071472318",
"name": "GET Products",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nconst productos = $input.first().json.result.map(producto => ({\n nombre: producto.Producto,\n codigo: producto['C\u00f3digo'],\n modelo: producto.modelo,\n familia: producto.familia,\n grupo: producto.grupo,\n stock: producto.Disponible,\n precio: producto.Precio,\n codigoImpuest: $input.first().json.result[0].codimp,\n porcentajeImpuesto: $input.first().json.result[0].porcentaje,\n idUnidad: $input.first().json.result[0].idunidad\n}))\n\nreturn { productos };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
0,
3088
],
"id": "3e872aee-842a-4efb-a787-5203497a66fc",
"name": "Mapear productos"
},
{
"parameters": {
"httpMethod": "POST",
"path": "pedidos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1808,
4064
],
"id": "a6883ff5-bee4-4a30-9e9f-bae4598c5ae1",
"name": "Crear pedidos"
},
{
"parameters": {
"path": "productos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1616,
3536
],
"id": "0c9f0688-0e0d-4e92-ab28-9014267a1dad",
"name": "Buscar productos"
},
{
"parameters": {
"path": "clientes",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co, http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1392,
2768
],
"id": "354e51f3-9572-4122-9fb3-ea711df734d5",
"name": "Buscar clientes"
},
{
"parameters": {
"jsCode": "const clientes = $input.first().json.result.map(cliente => ({\n nit: cliente.nit,\n razonSocial:cliente.razonsocial,\n sucursal: cliente.sucursal,\n telefono: cliente.telefono1,\n departamento: cliente.departamento,\n direccion: cliente.direccion1\n}))\n\nreturn {\n clientes\n};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
752,
2192
],
"id": "9315171b-b452-4722-b8bd-5923bf723dfd",
"name": "Mapear clientes"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "productos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1696,
3392
],
"id": "ff4e5f45-b1f4-4348-8fd2-bf1f38f7d971",
"name": "Buscar productos options"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
992,
2416
],
"id": "127fab98-50c7-4eb8-8213-ed0c5d31ef0a",
"name": "Respond to Webhook"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "pedidos",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1776,
4256
],
"id": "35afe3e8-9bb2-4f96-ab37-08047a57563d",
"name": "Crear pedidos1"
},
{
"parameters": {
"table": {
"__rl": true,
"value": "pedido",
"mode": "list",
"cachedResultName": "pedido"
},
"dataMode": "defineBelow",
"valuesToSend": {
"values": [
{
"column": "id_estado",
"value": "=1"
},
{
"column": "nit",
"value": "={{ $json.sucursal.nit }}"
},
{
"column": "formaPagoId",
"value": "=1"
},
{
"column": "sucursal",
"value": "={{ JSON.stringify($json.sucursal) }}"
},
{
"column": "email_vendedor",
"value": "={{ $json.vendedor.email }}"
},
{
"column": "id_vendedor",
"value": "={{ $json.vendedor.idVendedor }}"
},
{
"column": "comentario",
"value": "={{ $json.pedido.comentarios }}"
}
]
},
"options": {
"detailedOutput": true
}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
1776,
3968
],
"id": "b1c935ea-c458-41b1-ab30-0c29b73a9bc0",
"name": "Insertar pedido en la tabla",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "// const total = $input.first().json.pedido.items.reduce((acc, value) => acc + value.item.valorBruto, 0 )\n// const iva = $input.first().json.pedido.items.reduce((acc, value) => acc + value.item.iva, 0)\n// const subtotal = $input.first().json.pedido.items.reduce((acc, value) => acc + value.item.subtotal, 0)\n// const baseCalculo = $input.first().json.pedido.items.reduce((acc, value) => acc + value.item.neto, 0)\n// const impuestosPorItem = $input.first().json.pedido.items.reduce((acc, item) => {\n \n// return {\n// base_calculo: totalPedido.baseCalculo,\n// codimp: item.info.codimp,\n// liquida: \"S\",\n// valor: item.item.iva\n// }\n// }, {})\n\nconst totalPedido = $input.first().json.pedido.items.reduce((acc, item) => {\n return {\n total: acc.total + item.item.valorBruto,\n iva: acc.iva + item.item.iva,\n subtotal: acc.subtotal + item.item.subtotal,\n baseCalculo: item.item.neto,\n }\n}, { total: 0, iva: 0, subtotal: 0, baseCalculo: 0 })\n\n\n\nlet pedido = {\n \"encabezado\": {\n \"comentarios\": $input.first().json.pedido.comentarios,\n \"fecha\": new Date().toISOString().split('T')[0],\n \"idsuc\": 1,\n \"idvendedor\": $input.first().json.vendedor.idVendedor,\n \"numero\": $('Insertar pedido en la tabla').first().json.data.insertId,\n \"totalDet\": $input.first().json.pedido.items.length,\n \"nit\": $input.first().json.pedido.nit,\n iva: totalPedido.iva,\n subtotal: totalPedido.subtotal,\n \"total\": totalPedido.total,\n \"usuario\": \"VEND\",\n \"prefijo\": \"PEV\",\n },\n detalle: $input.first().json.pedido.items.map((detail, idx) => ({\n \"cantidad\": detail.item.cantidad,\n \"codimp\": \"IVA01\",\n \"idproducto\": detail.item.idProducto,\n \"idunidad\": detail.info.idunidad,\n \"iva\": detail.item.iva,\n \"neto\": detail.item.neto,\n \"porciva\": detail.item.porciva,\n \"pos\": idx + 1,\n \"precio\": detail.item.precio,\n \"subtotal\": detail.item.subtotal,\n \"unidades\": detail.item.cantidad,\n \"valorbruto\": detail.item.valorBruto,\n \"factor\": 1,\n \"idbodega\": detail.info.idbodega,\n \"operacion\": \"SA\",\n porcdcto: 0,\n vdescuento:0\n })),\n impuesto: [\n {\n base_calculo: totalPedido.subtotal,\n codimp: \"IVA01\",\n liquida: \"S\",\n valor: totalPedido.iva\n }\n ],\n pago: [\n {\n idformapago: 1,\n valor: totalPedido.total\n }\n ],\n sucursal: {\n idsuc: $input.first().json.sucursal.sucursal,\n nit: $input.first().json.pedido.nit\n } \n}\nreturn {\n codigo: 200,\n erpPayload: {\n documento: pedido\n }\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2960,
3536
],
"id": "7981de55-55cb-4f3c-8934-cf6cf834f6c0",
"name": "Constuir el payload del pedido para ERP"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "ca06ff44-1a88-4e5c-9d71-ca9eb4cb0113",
"leftValue": "={{ $json.result }}",
"rightValue": "Exito",
"operator": {
"type": "string",
"operation": "contains"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
3584,
3328
],
"id": "14f492fc-805e-4f2b-a8c0-b866b7aa80a9",
"name": "If"
},
{
"parameters": {
"operation": "update",
"table": {
"__rl": true,
"value": "pedido",
"mode": "list",
"cachedResultName": "pedido"
},
"dataMode": "defineBelow",
"columnToMatchOn": "id",
"valueToMatchOn": "={{ $('Insertar pedido en la tabla').first().json.data.insertId }}",
"valuesToSend": {
"values": [
{
"column": "id_estado",
"value": "4"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
4864,
3104
],
"id": "0a0e80ee-4902-43f2-a25e-eb8809decaf9",
"name": "Actualizar pedido como guardado",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"operation": "update",
"table": {
"__rl": true,
"value": "pedido",
"mode": "list",
"cachedResultName": "pedido"
},
"dataMode": "defineBelow",
"columnToMatchOn": "id",
"valueToMatchOn": "id",
"valuesToSend": {
"values": [
{
"column": "id_estado",
"value": "4"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
4656,
3760
],
"id": "3fa8c2a7-c397-49d5-8225-534b4a37bec8",
"name": "Actualizar pedido con error",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
5136,
3968
],
"id": "fd0b3d47-0db2-4d2e-8fc5-c56af9f61dba",
"name": "Respuesta error pedido"
},
{
"parameters": {
"respondWith": "text",
"responseBody": "={{ $('Pedido completo').item.json }}",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
5776,
3344
],
"id": "3eb4b8c3-2b7f-461b-8646-816005dc5cf4",
"name": "Respuesta ok pedido"
},
{
"parameters": {
"jsCode": "// Loop over input items and add a new field called 'myNewField' to the JSON of each one\nlet items =$('Componer request').first().json.pedido.productos.map( det => ({\n ...det,\n idPedido: $input.first().json.data.insertId,\n}))\nreturn items;"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2144,
3936
],
"id": "a7721dd4-ebf1-4edc-9280-7ef5ef607969",
"name": "Mapear detalle"
},
{
"parameters": {
"jsCode": "let pedido = $input.first().json.body\n\nlet consulta = `select nit, razonsocial, idsuc sucursal, idformapago, telefono1, direccion1, departamento, ciudad from matercerosuc WHERE nit = '` + pedido.nit + \"'\"\nreturn { consulta, pedido }\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-1104,
4304
],
"id": "093b0481-0197-4b5a-84f1-5dfc8ed78f79",
"name": "Mapear pedido"
},
{
"parameters": {
"jsCode": "const consulta = \"select idvendedor from mavendedores where email ='\" + $input.first().json.email + \"'\"\n\nreturn {consulta, vendedor: $input.first().json };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-176,
3856
],
"id": "805114b2-cdcc-43af-a936-1b03e5c3285a",
"name": "QueryVendedor"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
80,
4048
],
"id": "f508b905-eb14-4063-b04c-67248e13ee62",
"name": "Get vendedor id",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "\nreturn { idVendedor: $input.first().json.result[0].idvendedor };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
368,
4112
],
"id": "c13d0a75-c01f-4b26-b9cf-fa0f91cb6c3a",
"name": "Mapear id vendedor"
},
{
"parameters": {
"mode": "combine",
"combineBy": "combineByPosition",
"options": {}
},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
640,
3808
],
"id": "1575901c-a9af-4cff-b376-c393c62a3fe9",
"name": "Componer vendedor info"
},
{
"parameters": {
"options": {
"responseCode": 401
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1824,
3184
],
"id": "a92a1cc9-5166-4ff9-8ebf-1e3153863a24",
"name": "No Authorizado"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-1280,
3344
],
"id": "5830b32e-9ca1-473b-bd94-86a35b15b6ce",
"name": "Call 'GetUserInfo'1",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
},
{
"parameters": {
"jsCode": "let clienteNit = $('Buscar productos').first().json.query.clientenit \nlet sucursalId = $('Buscar productos').first().json.query.sucursalId\nconst search = $('Buscar productos').first().json.query.search\nlet consulta = `SELECT SP.idproducto AS \"C\u00f3digo\", mp.nombreproducto AS \"Producto\", Familia, Grupo, Marca, Modelo, SP.disponible AS \"Disponible\", SP.idunidad AS \"Unidad\", CASE ( SELECT listaprecios FROM matercerosuc WHERE nit = '900339960' AND idsuc = '1' LIMIT 1 ) WHEN 1 THEN mp.lista1 WHEN 2 THEN mp.lista2 WHEN 3 THEN mp.lista3 WHEN 4 THEN mp.lista4 WHEN 5 THEN mp.lista5 WHEN 6 THEN mp.lista6 ELSE NULL END AS \"Precio\", imp.porcentaje, imp.codimp FROM SPSALDOSINVENTARIO (CURRENT_DATE,'N','','','S','JCORTES') SP INNER JOIN maproductos mp ON SP.idproducto = mp.idproducto INNER JOIN vpareto_producto ON SP.idproducto = vpareto_producto.idproducto INNER JOIN maperfilproducto pf ON mp.idperfil = pf.idperfil INNER JOIN maimpuestos imp ON imp.codimp = pf.ivaventa WHERE SP.SALDO > 0 AND mp.activo = 'S'AND SP.idbodega = '${sucursalId}'`\nif(search) {\n consulta += `AND SP.idproducto like '%${search}%` \n}\n\nconsulta += `ORDER BY 1, 2`\n\nreturn ({ clienteNit, sucursalId, consulta }) "
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
-528,
3056
],
"id": "94aa67db-6086-4670-bf6a-bce86c2f595f",
"name": "Extraer cliente y sucursal"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-832,
2832
],
"id": "081a4728-c3d2-4688-a526-e7c5ec2877fc",
"name": "Hay error1"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-816,
3712
],
"id": "dc0708fa-123c-4991-9faf-649e7eeb968a",
"name": "If1"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-1232,
3728
],
"id": "3b2d4672-516e-4454-946c-a343935035a7",
"name": "Call 'GetUserInfo'2",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "clientes",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
-1392,
2576
],
"id": "93cc3160-ea00-47d3-a13a-849d838b4690",
"name": "Buscar clientes options"
},
{
"parameters": {
"mode": "combine",
"combineBy": "combineByPosition",
"options": {}
},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
1440,
4240
],
"id": "85a22bdd-383e-4070-b774-813904cf7a2e",
"name": "Componer request"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3104,
3888
],
"id": "dca63da3-ff0f-4430-bba5-34c0c68ff290",
"name": "GET Products1",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "\nreturn {\n vendedor: {\n ...$input.first().json.vendedor,\n idVendedor: $input.first().json.idVendedor,\n }\n};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1024,
3856
],
"id": "cf5c83c3-7a66-4189-ba4a-f7831b62ebb5",
"name": "Mapear vendedor"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
-592,
4048
],
"id": "4a297b36-738e-4248-8483-779e8ed3441d",
"name": "Get Sucursal info",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "let pedido = $('Mapear pedido').first().json.pedido\nlet sucursal = $input.first().json.result[0]\n\nreturn { pedido, sucursal };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
384,
4656
],
"id": "79b75c92-66d6-429c-9a30-a5f9e984dcf7",
"name": "Componer pedido y sucursal"
},
{
"parameters": {
"jsCode": "const pedidoId = $('Insertar pedido en la tabla').first().json.data.insertId\nconst items = $input.all().map(det => det.json)\nconst { vendedor, pedido, sucursal } = $('Componer request').first().json\n\nreturn {\n vendedor,\n pedido: {\n ...pedido,\n items,\n id: pedidoId,\n productos: undefined\n },\n sucursal,\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2816,
3360
],
"id": "c74503a1-b102-4b81-81e2-b333a4289e97",
"name": "Pedido completo"
},
{
"parameters": {
"jsCode": "const { cantidad, idProducto, idPedido } = $input.first().json\n\nlet consulta = ` SELECT SP.idproducto AS \"C\u00f3digo\", mp.nombreproducto AS \"Producto\", Familia, Grupo, Marca, Modelo, SP.disponible AS \"Disponible\", SP.idunidad, SP.idbodega, CASE ( SELECT listaprecios FROM matercerosuc WHERE nit = '` + $('Componer pedido y sucursal').first().json.sucursal.nit +`' AND idsuc = `+ $('Componer pedido y sucursal').first().json.sucursal.sucursal +` LIMIT 1 ) WHEN 1 THEN mp.lista1 WHEN 2 THEN mp.lista2 WHEN 3 THEN mp.lista3 WHEN 4 THEN mp.lista4 WHEN 5 THEN mp.lista5 WHEN 6 THEN mp.lista6 ELSE NULL END AS \"Precio\", imp.porcentaje, imp.codimp FROM SPSALDOSINVENTARIO (CURRENT_DATE,'N','','','S','JCORTES') SP INNER JOIN maproductos mp ON SP.idproducto = mp.idproducto INNER JOIN vpareto_producto ON SP.idproducto = vpareto_producto.idproducto INNER JOIN maperfilproducto pf ON mp.idperfil = pf.idperfil INNER JOIN maimpuestos imp ON imp.codimp = pf.ivaventa WHERE SP.SALDO > 0 AND mp.activo = 'S'AND SP.idbodega = '1' AND SP.idproducto = '` + idProducto +`' ORDER BY 1, 2 ` \n\nreturn {consulta, cantidad, idProducto, idPedido};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2800,
3840
],
"id": "3471129d-0974-4b20-9c36-ddffacfabb8d",
"name": "item de pedido"
},
{
"parameters": {
"jsCode": "let detailInfo = $input.first().json.result[0]\nlet item = $('Get product info').first().json\nitem.porcentajeImpuesto = detailInfo.porcentaje\nitem.precio = detailInfo.Precio\nitem.subtotal = item.precio * item.cantidad\nitem.neto = item.subtotal\nitem.iva = item.neto * item.porcentajeImpuesto / 100\nitem.codigoImpuesto = detailInfo.codimp\nitem.idPedido = $('Insertar pedido en la tabla').first().json.data.insertId\n\nitem.valorBruto = item.neto + item.iva\n\nreturn { item, detailInfo };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3264,
3936
],
"id": "8f7b4d57-f0c2-456a-8a14-12b8e8696c3a",
"name": "item y detalle info"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
2592,
3760
],
"id": "cded059e-1ad6-44f7-9fa5-2da0fe424e48",
"name": "Get product info"
},
{
"parameters": {
"table": {
"__rl": true,
"value": "detalle_pedido",
"mode": "list",
"cachedResultName": "detalle_pedido"
},
"dataMode": "defineBelow",
"valuesToSend": {
"values": [
{
"column": "pedido_id",
"value": "={{ $input.first().json.item.idPedido }}"
},
{
"column": "id_producto",
"value": "={{ $input.first().json.item.idProducto }}"
},
{
"column": "id_unidad",
"value": "={{ $input.first().json.detailInfo.idunidad }}"
},
{
"column": "unidad",
"value": "={{ $input.first().json.item.cantidad }}"
}
]
},
"options": {
"detailedOutput": true
}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
3456,
3984
],
"id": "bb2dc519-2cd4-460c-93f0-7e895e98ad1a",
"name": "Insertar detalle pedido en la tabla1",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "const itemId = $input.first().json.data.insertId\nconst item = {...$('item y detalle info').first().json.item, id: itemId}\nconst info = $('item y detalle info').first().json.detailInfo\nreturn { item,info };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3648,
4032
],
"id": "1322f0a5-c2de-4b17-a4c4-6a55564ee160",
"name": "set detalle id"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "notExists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-304,
2496
],
"id": "52502eac-5b24-4e09-a4e5-e6a4e457a1b6",
"name": "Sin error"
},
{
"parameters": {
"method": "POST",
"url": "=https://ws.dsnube.co/api/v1/pec",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"sendBody": true,
"specifyBody": "json",
"jsonBody": "={{ JSON.stringify($input.first().json.erpPayload) }}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3200,
3280
],
"id": "11ac6fc1-ff70-4c56-a964-a6b4c84c18c7",
"name": "POST pedido",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3680,
6016
],
"id": "fd3bf581-173e-4520-b5e2-3dd32e65f4bd",
"name": "HTTP Request1",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"respondWith": "allIncomingItems",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
4112,
5440
],
"id": "670655c6-1ca6-42e6-a2f6-a5b8f88fe8b4",
"name": "Respond to Webhook5"
},
{
"parameters": {
"jsCode": "let { fechaini, fechafin} = $('Historial-pedidos').first().json.query\nconst idvendedor = $input.first().json.idVendedor\nconst consulta = \"select tr.fecha, tr.nit, tr.numero, tr.estado, tr.total, ma.razonsocial from trotrosdocinv tr inner join materceros ma on tr.nit = ma.nit where prefijo = 'PEV' and idvendedor = '\"+idvendedor+\"' and fecha BETWEEN '\"+fechaini+\"' and '\"+fechafin+\"' order by 1 desc, nit, numero\"\nreturn { consulta };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3344,
5904
],
"id": "d5305d11-bdc2-41dd-ad1a-4641d0f51b8c",
"name": "Code in JavaScript1"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-944,
5040
],
"id": "b55fb67f-6146-47e4-b631-e78564d80179",
"name": "Call 'GetUserInfo'4",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
-16,
5296
],
"id": "6415544f-bff0-45a9-985e-52dc3ab1d673",
"name": "If2"
},
{
"parameters": {
"options": {
"responseCode": 401
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1632,
5168
],
"id": "70266157-29f4-4e5f-a762-aaf760e03fdd",
"name": "No Authorizado1"
},
{
"parameters": {
"jsCode": "const consulta = \"select idvendedor from mavendedores where email ='\" + $input.first().json.email + \"'\"\n\nreturn {consulta};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1248,
5904
],
"id": "5d148e5c-95a8-4520-9c02-d51b25e8012c",
"name": "QueryVendedor1"
},
{
"parameters": {
"url": "=https://ws.dsnube.co/api/v1/consultasql?consulta={{ $json.consulta }}",
"authentication": "genericCredentialType",
"genericAuthType": "httpBasicAuth",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
2000,
6112
],
"id": "2167bbf9-218a-4c6e-a81a-d1bfc84e9312",
"name": "Get vendedor id1",
"credentials": {
"httpBasicAuth": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "\nreturn {idVendedor: $input.first().json.result[0].idvendedor};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
2688,
6128
],
"id": "55022f53-361f-4b2f-a246-511651b8dd77",
"name": "Mapear id vendedor1"
},
{
"parameters": {
"mode": "combine",
"combineBy": "combineAll",
"options": {}
},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
3136,
6096
],
"id": "fa54661b-80a0-4cb0-b1c8-f528d09bbf8e",
"name": "Componer vendedor info1"
},
{
"parameters": {
"jsCode": "const pedidos = $input.first().json.result.map(pedido => {\n const nuevoPedido = {\n nit: pedido.nit,\n numero: pedido.numero,\n estado: pedido.estado,\n total: pedido.total,\n razonSocial: pedido.razonsocial,\n }\n return nuevoPedido\n})\nreturn pedidos"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
3824,
5760
],
"id": "982a23e7-0bea-492b-90c6-2788ce599a2f",
"name": "Code in JavaScript3"
},
{
"parameters": {
"path": "pedidos",
"responseMode": "responseNode",
"options": {}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2.1,
"position": [
-1760,
4832
],
"id": "2a2f8aa7-8247-4edd-9c7e-d95b71afa40b",
"name": "Historial-pedidos"
},
{
"parameters": {
"mailagent": "74347d727301a3de",
"fromaddress": {
"address": "info@trimon.co"
},
"toaddress": "santiagopenasierra@gmail.com,gabrielsimpsons@gmail.com",
"subject": "We're back on business guys",
"htmlbody": "={{ $json.html }}",
"cc": "monicasierrar@gmail.com",
"attachment": {}
},
"type": "n8n-nodes-zohozeptomail.zohoZeptomail",
"typeVersion": 1,
"position": [
5008,
3424
],
"id": "d28e8615-7ece-4666-b256-279a2b7895f9",
"name": "Send Mail",
"credentials": {
"zohoZeptomailOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {},
"type": "n8n-nodes-base.merge",
"typeVersion": 3.2,
"position": [
5456,
3328
],
"id": "09d656e8-a010-4ed5-b7e4-006565befe87",
"name": "Merge"
},
{
"parameters": {
"html": "<!DOCTYPE html>\n<html lang=\"es\">\n<head>\n <meta charset=\"UTF-8\">\n <title>Orden de Pedido</title>\n <style>\n body {\n font-family: Arial, sans-serif;\n margin: 0;\n padding: 0;\n background: #f5f5f5;\n }\n .container {\n width: 90%;\n max-width: 800px;\n margin: 20px auto;\n background: #fff;\n padding: 20px;\n border: 1px solid #ddd;\n }\n .header {\n margin-bottom: 20px;\n }\n .header-table {\n width: 100%;\n }\n .header-table td {\n vertical-align: top;\n padding: 5px;\n }\n .header img {\n max-width: 120px;\n }\n .header-info {\n text-align: right;\n font-size: 14px;\n line-height: 1.3;\n color: #444;\n }\n .section {\n margin-bottom: 20px;\n }\n .section h2 {\n font-size: 16px;\n border-bottom: 1px solid #ddd;\n padding-bottom: 5px;\n margin-bottom: 10px;\n color: #444;\n }\n .section p {\n line-height: 1.4;\n margin: 2px 0;\n font-size: 14px;\n }\n table {\n width: 100%;\n border-collapse: collapse;\n font-size: 14px;\n }\n th, td {\n border: 1px solid #ddd;\n padding: 6px;\n text-align: center;\n }\n th {\n background: #f0f0f0;\n font-weight: bold;\n }\n .totales {\n margin-top: 20px;\n width: 100%;\n }\n .totales td {\n padding: 6px;\n }\n .totales .label {\n text-align: right;\n font-weight: bold;\n background: #f9f9f9;\n }\n .totales .value {\n text-align: right;\n }\n .footer {\n margin-top: 30px;\n font-size: 12px;\n color: #777;\n text-align: center;\n }\n </style>\n</head>\n<body>\n <div class=\"container\">\n <!-- Encabezado con logo y datos -->\n <div class=\"header\">\n <table class=\"header-table\">\n <tr>\n <td>\n <!-- Logo dummy -->\n <img src=\"https://pedidos.trimon.co/assets/logo-BkBSmhWf.png\" alt=\"Logo Empresa\">\n </td>\n <td class=\"header-info\">\n <strong>BTRES S.A.S</strong><br>\n NIT: 900.587.306-2<br>\n CLL 68 N\u00b087-40<br>\n BOGOTA DC - BOGOTA<br>\n PBX: 4370408 / 9260050 CEL: 317 501 26 42<br>\n www.trimon.co<br>\n Email: Contabilidad@trimon.co\n </td>\n </tr>\n </table>\n <hr>\n <h1 style=\"text-align:center; margin:10px 0;\">Orden de Pedido</h1>\n <p style=\"text-align:center; margin:2px 0;\"><strong>No. Pedido:</strong>{{ $('Pedido completo').item.json.pedido.id }}</p>\n <p style=\"text-align:center; margin:2px 0;\"><strong>Fecha:</strong> {{ $now.format('yyyy-MM-dd') }}</p>\n </div>\n\n <!-- Cliente -->\n <div class=\"section\">\n <h2>Datos del Cliente</h2>\n <p><strong>Raz\u00f3n Social:</strong>{{ $('Pedido completo').item.json.sucursal.razonsocial }}</p>\n <p><strong>NIT:</strong> {{ $('Pedido completo').item.json.sucursal.nit }}</p>\n <p><strong>Sucursal:</strong> {{ $('Pedido completo').item.json.sucursal.sucursal }}</p>\n <p><strong>Direcci\u00f3n:</strong> {{ $('Pedido completo').item.json.sucursal.direccion1 }}, {{ $('Pedido completo').item.json.sucursal.ciudad }}, {{ $('Pedido completo').item.json.sucursal.departamento }}</p>\n </div>\n\n <!-- Productos -->\n <div class=\"section\">\n <h2>Detalle de Productos</h2>\n <table>\n <thead>\n <tr>\n <th>C\u00f3digo</th>\n <th>Cantidad</th>\n <th>Unidad</th>\n <th>Precio Unitario</th>\n <th>Subtotal</th>\n <th>IVA</th>\n <th>Total</th>\n </tr>\n </thead>\n <tbody>\n {{ $json.itemsHtml }}\n </tbody>\n </table>\n </div>\n\n <!-- Totales -->\n <div class=\"section\">\n <h2>Totales</h2>\n <table class=\"totales\">\n <tr>\n <td class=\"label\">Subtotal:</td>\n <td class=\"value\">{{ $json.subtotal.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }}</td>\n </tr>\n <tr>\n <td class=\"label\">IVA:</td>\n <td class=\"value\">{{ $json.iva.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }}</td>\n </tr>\n <tr>\n <td class=\"label\">Total a Pagar:</td>\n <td class=\"value\"><strong>{{ $json.total.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }}</strong></td>\n </tr>\n </table>\n </div>\n\n <!-- Comentarios -->\n <div class=\"section\">\n <h2>Comentarios</h2>\n <p>Comentarios pruebas pedido</p>\n </div>\n\n <!-- Pie -->\n <div class=\"footer\">\n <p>Este documento es generado electr\u00f3nicamente y no requiere firma.</p>\n </div>\n </div>\n</body>\n</html>\n\n"
},
"type": "n8n-nodes-base.html",
"typeVersion": 1.2,
"position": [
4704,
3408
],
"id": "35d274b7-3027-476a-84f3-d9e8ced3f9b8",
"name": "HTML"
},
{
"parameters": {
"jsCode": "\nconst code = $input.first().json.query.code\nreturn { code, redirectUrl: \"https://pedidos-api.trimon.co/webhook/authorize\" };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
480,
320
],
"id": "41109aa1-c005-4798-b937-c37a04e44491",
"name": "Code"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "aadb05bb-87cc-4dad-a992-4bcbc819e0ab",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1056,
192
],
"id": "fd215886-ef97-40b8-8866-d532c06f0703",
"name": "error"
},
{
"parameters": {
"jsCode": "const accessToken = $input.first().json.access_token;\nconst expiresIn = $input.first().json.expires_in;\n\nreturn { accessToken, expiresIn }"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1408,
352
],
"id": "883dbe28-1a29-4d32-af22-b375ad8e84a7",
"name": "Code1"
},
{
"parameters": {
"jsCode": "const error = $input.first().json.error\nreturn { error };"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1536,
128
],
"id": "127c9b9c-5d77-47f5-95e6-b59eea92a3ac",
"name": "Code3"
},
{
"parameters": {
"path": "authorize",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
48,
368
],
"id": "cb176cea-f86a-466a-9bda-943942340d9c",
"name": "Authorize code"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "authorize",
"responseMode": "lastNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
48,
208
],
"id": "19637da6-a07c-4112-831d-151c934ddb19",
"name": "Authorize code options"
},
{
"parameters": {
"method": "POST",
"url": "https://accounts.zoho.com/oauth/v2/token",
"sendBody": true,
"contentType": "form-urlencoded",
"bodyParameters": {
"parameters": [
{
"name": "code",
"value": "={{ $json.code }}"
},
{
"name": "grant_type",
"value": "authorization_code"
},
{
"name": "client_id",
"value": "1000.5U8I460UG3WLLU85J5GLAKUDXLN9WZ"
},
{
"name": "client_secret",
"value": "45a9b1dfc9b716ff3912a2be813b9fb18440256f01"
},
{
"name": "redirect_uri",
"value": "=https://pedidos-api.trimon.co/webhook/authorize"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
784,
320
],
"id": "7197e3c2-e586-46bf-b114-a46ad390d258",
"name": "Get token"
},
{
"parameters": {
"path": "user-info",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co,http://localhost:5173"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
160,
752
],
"id": "7decd825-6db8-4732-8e97-e4c5f562c1e8",
"name": "User info"
},
{
"parameters": {
"jsCode": "const { First_Name, Email, Last_Name, Display_Name } = $input.first().json\nreturn {\n firstName: First_Name,\n email: Email,\n lastName: Last_Name,\n displayName: Display_Name\n}"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1360,
784
],
"id": "21205ccb-fd39-4e08-9b3d-e13265285248",
"name": "Code6"
},
{
"parameters": {
"httpMethod": "=OPTIONS",
"path": "user-info",
"responseMode": "lastNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
160,
880
],
"id": "09c7b03f-d057-4278-a176-d44c113589cf",
"name": "User info options"
},
{
"parameters": {
"respondWith": "redirect",
"redirectURL": "=https://pedidos.trimon.co/auth/callback?access_token={{ $json.accessToken }}&expires_in={{ $json.expiresIn }}",
"options": {
"responseCode": 302
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1616,
432
],
"id": "c754c4ce-4b8f-4872-88f5-e0bf701d5b91",
"name": "Respond to Webhook3"
},
{
"parameters": {
"respondWith": "redirect",
"redirectURL": "https://pedidos.trimon.co/",
"options": {}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1712,
80
],
"id": "f1698d71-2fa2-4da0-a5bf-ebff2acaa8cf",
"name": "Respond to Webhook4"
},
{
"parameters": {
"content": "## Auth0",
"height": 1120,
"width": 1968
},
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"typeVersion": 1,
"id": "765322ae-ad36-4837-a888-4142ae3394a6",
"name": "Sticky Note1"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "ayQ7pITwU67JziRZ",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
448,
656
],
"id": "7dbb9d65-a55d-42de-a86c-f66fed92600f",
"name": "Call 'GetUserInfo'3",
"alwaysOutputData": false
},
{
"parameters": {
"options": {
"responseCode": 401
}
},
"type": "n8n-nodes-base.respondToWebhook",
"typeVersion": 1.4,
"position": [
1184,
480
],
"id": "cd198899-b430-4620-b2be-a3c7156d2bc3",
"name": "Respond to Webhook2"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "a6cc6f6f-fdef-4d1e-9279-8668dcd46ebc",
"leftValue": "={{ $json.error }}",
"rightValue": "",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
976,
576
],
"id": "e1747213-f86c-4dcd-9dbe-f32af54103da",
"name": "Hay error2"
},
{
"parameters": {
"path": "rest/oauth2-credential/callback",
"responseMode": "responseNode",
"options": {
"allowedOrigins": "https://pedidos.trimon.co"
}
},
"type": "n8n-nodes-base.webhook",
"typeVersion": 2,
"position": [
48,
560
],
"id": "3b72881a-71ae-409e-aa24-3a4012be4d8f",
"name": "Authorize code1"
},
{
"parameters": {
"table": {
"__rl": true,
"value": "pedido",
"mode": "list",
"cachedResultName": "pedido"
},
"dataMode": "defineBelow",
"valuesToSend": {
"values": [
{
"column": "id_estado",
"value": "=1"
},
{
"column": "nit",
"value": "={{ $json.sucursal.nit }}"
},
{
"column": "formaPagoId",
"value": "=1"
},
{
"column": "sucursal",
"value": "={{ JSON.stringify($json.sucursal) }}"
},
{
"column": "email_vendedor",
"value": "={{ $json.vendedor.email }}"
},
{
"column": "id_vendedor",
"value": "={{ $json.vendedor.idVendedor }}"
},
{
"column": "comentario",
"value": "={{ $json.pedido.comentarios }}"
}
]
},
"options": {
"detailedOutput": true
}
},
"type": "n8n-nodes-base.mySql",
"typeVersion": 2.5,
"position": [
992,
8624
],
"id": "585c9fcb-7e91-4dd9-80a2-958f77671a02",
"name": "Insertar pedido en la tabla1",
"credentials": {
"mySql": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "const items = $('Pedido completo').first().json.pedido.items\n\nlet subtotal = 0\nlet iva = 0\nlet total = 0\nlet itemsHtml = ``\nfor(const item of items) {\n itemsHtml += `\n <tr>\n <td>${item.item.idProducto}</td>\n <td>${item.item.cantidad}</td>\n <td>${item.info.idunidad}</td>\n <td>$${item.item.precio.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }</td>\n <td>$${item.item.subtotal.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }</td>\n <td>$${item.item.iva.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }</td>\n <td>$${item.item.valorBruto.toLocaleString('es-CO', {\n style: 'currency',\n currency: 'COP',\n minimumFractionDigits: 0, // Colombian Peso is often displayed without cents\n maximumFractionDigits: 0\n}) }</td>\n </tr>\n `\n subtotal += item.item.subtotal\n iva += item.item.iva\n total += item.item.valorBruto\n \n}\n\nreturn [{\n itemsHtml, iva, subtotal, total\n}]"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
4352,
3424
],
"id": "db882148-0267-4bac-8d86-e8ff8fd9f87f",
"name": "Preparar items de factura"
},
{
"parameters": {
"jsCode": "const { search } = $('Buscar clientes').first().json.query\nlet consulta = `select nit,razonsocial,idsuc sucursal,idformapago,telefono1,direccion1,departamento,ciudad from matercerosuc`\nif(search ) {\n consulta += `where razonsocial like '%${search.toUpperCase()}%'` \n}\nconsulta += ` order by razonsocial`\nreturn {\n consulta,\n search\n};"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
80,
2352
],
"id": "377beb56-e9d8-4a2b-b189-d2893971997c",
"name": "extraer parametros"
},
{
"parameters": {
"workflowId": {
"__rl": true,
"value": "lbbPigwzL1zoCCVG",
"mode": "id"
},
"workflowInputs": {
"mappingMode": "defineBelow",
"value": {},
"matchingColumns": [],
"schema": [],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"waitForSubWorkflow": true
}
},
"type": "n8n-nodes-base.executeWorkflow",
"typeVersion": 1.2,
"position": [
-944,
2576
],
"id": "84df88c8-9775-4fa4-b316-221d8457c6ec",
"name": "Call 'Get user info'",
"alwaysOutputData": false,
"onError": "continueRegularOutput"
}
],
"connections": {
"GET Clients": {
"main": [
[
{
"node": "Mapear clientes",
"type": "main",
"index": 0
}
]
]
},
"GET Products": {
"main": [
[
{
"node": "Mapear productos",
"type": "main",
"index": 0
}
]
]
},
"Mapear productos": {
"main": [
[
{
"node": "Respond to Webhook1",
"type": "main",
"index": 0
}
]
]
},
"Crear pedidos": {
"main": [
[
{
"node": "Mapear pedido",
"type": "main",
"index": 0
},
{
"node": "Call 'GetUserInfo'2",
"type": "main",
"index": 0
}
]
]
},
"Buscar productos": {
"main": [
[
{
"node": "Call 'GetUserInfo'1",
"type": "main",
"index": 0
}
]
]
},
"Buscar clientes": {
"main": [
[
{
"node": "Call 'Get user info'",
"type": "main",
"index": 0
}
]
]
},
"Mapear clientes": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
},
"Insertar pedido en la tabla": {
"main": [
[
{
"node": "Mapear detalle",
"type": "main",
"index": 0
}
]
]
},
"Constuir el payload del pedido para ERP": {
"main": [
[
{
"node": "POST pedido",
"type": "main",
"index": 0
}
]
]
},
"If": {
"main": [
[
{
"node": "Actualizar pedido como guardado",
"type": "main",
"index": 0
},
{
"node": "Preparar items de factura",
"type": "main",
"index": 0
}
],
[
{
"node": "Actualizar pedido con error",
"type": "main",
"index": 0
}
]
]
},
"Actualizar pedido como guardado": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Actualizar pedido con error": {
"main": [
[
{
"node": "Respuesta error pedido",
"type": "main",
"index": 0
}
]
]
},
"Mapear detalle": {
"main": [
[
{
"node": "Get product info",
"type": "main",
"index": 0
}
]
]
},
"Mapear pedido": {
"main": [
[
{
"node": "Get Sucursal info",
"type": "main",
"index": 0
}
]
]
},
"QueryVendedor": {
"main": [
[
{
"node": "Get vendedor id",
"type": "main",
"index": 0
},
{
"node": "Componer vendedor info",
"type": "main",
"index": 0
}
]
]
},
"Get vendedor id": {
"main": [
[
{
"node": "Mapear id vendedor",
"type": "main",
"index": 0
}
]
]
},
"Mapear id vendedor": {
"main": [
[
{
"node": "Componer vendedor info",
"type": "main",
"index": 1
}
]
]
},
"Componer vendedor info": {
"main": [
[
{
"node": "Mapear vendedor",
"type": "main",
"index": 0
}
]
]
},
"Call 'GetUserInfo'1": {
"main": [
[
{
"node": "Hay error1",
"type": "main",
"index": 0
}
]
]
},
"Extraer cliente y sucursal": {
"main": [
[
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
httpBasicAuthmySqlzohoZeptomailOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
How this works
This workflow automates the creation and management of orders by integrating client and product data from external APIs into a MySQL database, then sending tailored transactional emails via Zoho Zeptomail. It saves businesses hours of manual data entry and ensures accurate, timely communications for order confirmations or updates, ideal for e-commerce teams or customer service departments handling high volumes. The key step involves mapping fetched client and product details through code nodes before inserting them into MySQL and triggering email dispatches.
Use this workflow when processing inbound webhooks for new orders requires seamless data syncing and automated notifications, such as in online retail platforms with frequent customer interactions. Avoid it for simple static emails without database involvement, or if your setup lacks API access to client and product sources. Common variations include adapting the MySQL schema for inventory tracking or incorporating additional HTTP requests for payment verification.
About this workflow
v25.1.1. Uses httpRequest, mySql, n8n-nodes-zohozeptomail. Webhook trigger; 80 nodes.
Source: https://github.com/monicasierrar/trimon-pedidos-fe/blob/2bcd583c2ae7ea51a42286d616937afc7ecb7d33/n8n/v25.1.1.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This is ideal for agencies, freelancers, SaaS founders, and small sales teams who want every lead recorded and followed up automatically within seconds. The workflow supports two storage options: HubS
HTTP Request, Google Sheets, Slack +1
Real-Time Lead Processing - Captures and processes leads instantly from website forms with zero delay Intelligent Fit Scoring - Automatically scores leads 0-100 based on company size, seniority, and r
Clearbit, HubSpot, HTTP Request +3
A webhook receives a form submission with an email address The email is validated, then Lusha enriches the contact If phone or email is missing, a fallback provider fills the gaps via HTTP request Dat
@Lusha Org/N8N Nodes Lusha, HTTP Request, HubSpot +1
This workflow is built for digital agencies and sales teams that sell services to ecommerce brands. If you prospect Shopify store owners and want a repeatable, automated pipeline from discovery to CRM
HTTP Request, HubSpot
This template enriches HubSpot company records using real-time data from the Bedrijfsdata.nl API. It listens for changes to company properties (e.g., ) and updates records with verified information su
HubSpot, @Bedrijfsdatanl/N8N Nodes Bedrijfsdata