Join Product Data from MySQL Databases for Label Printing - n8n Workflow | Neura Market
Join Product Data from MySQL Databases for Label Printing
This workflow receives a product grade ID via webhook, queries and joins detailed product, grade, tissue, and composition data from multiple MySQL databases, unifying it for label generation.
The workflow starts with a webhook trigger named 'emitirEtiqueta' that accepts POST requests containing an 'id_produto_grade'. It then executes a complex MySQL query in the 'dadosProduto' node using CTEs to fetch data: 'pg' for product grade details, 'p' for active product info, 't' for tissue width extracted from JSON in a dynamic reporting database, and 'cp' for aggregated composition using JSON_TABLE to parse array data.
This unifies disparate data sources—product tables and dynamic 'i_objet
Platform
n8n
Category
Lifestyle
Price
$14.99
Creator
Jordi Faber
MySQL
Databases
SQL Joins
Product Data
Label Printing
Webhook
JSON Parsing
CTE Queries
Inventory
Manufacturing
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.