Automated Label Generation for Product Grade and Rolls
detail.loadingPreview
This n8n workflow automates the process of generating product labels by retrieving detailed product information, including grade specifics and associated fabric roll data. It streamlines inventory management and ensures accurate labeling for outgoing products.
About This Workflow
This n8n workflow is designed to automate the creation of product labels, primarily for items categorized by product grade and associated fabric rolls. Upon receiving a webhook request to 'emitirEtiqueta', the workflow first fetches printing configuration settings. It then queries a MySQL database to retrieve comprehensive product details, including grade information, product descriptions, brand, size variants (gradex, gradey), fabric width, and composition. Simultaneously, it processes an input containing fabric roll IDs and queries a PostgreSQL database to retrieve data for these specific rolls. Finally, it merges the product and roll data to consolidate all necessary information for label generation, ensuring accurate and efficient product identification and tracking within the inventory system.
Key Features
- Automated Webhook Trigger: Initiates the label generation process via a POST request to the 'emitirEtiqueta' endpoint.
- Dynamic Data Fetching: Retrieves product and fabric roll information from both MySQL and PostgreSQL databases based on provided identifiers.
- Data Consolidation: Merges product attributes with fabric roll specifics for a complete labeling dataset.
- Configuration Management: Dynamically fetches printing configurations from a local API endpoint.
- Real-time Information: Includes current date and fabric width in the generated product data.
How To Use
- Set up the Webhook Node (
emitirEtiqueta): Configure the 'emitirEtiqueta' webhook to listen for incoming POST requests. Thebodyof the request should includeid_produto_grade,id_movimentacao_detalhe, and an array ofroloswithobjectIdproperties. - Fetch Printing Configuration (
PegarConfiguracaoImpressao): Configure the HTTP Request node to connect to your local Parse server athttp://localhost:1337/parse/configwith theX-Parse-Application-Idheader set to 'iwms'. - Process Roll IDs (
trataRetorno): Use the Function node to extractobjectIds from therolosarray in the webhook payload and pass them to the next node. - Retrieve Fabric Roll Data (
dadosRolo): Configure the PostgreSQL node to query yourtecido_rolotable using the extractedidRolosfrom the previous step. - Fetch Product Details (
dadosProduto): Configure the MySQL node with the provided SQL query. Ensure the database credentials are set up correctly. The query dynamically usesid_produto_gradefrom the webhook andbancoRelatoriofrom the printing configuration. - Merge Data (
roloProduto): Configure the Merge node to 'mergeByKey' usingid_movimentacao_detalheas the primary key to combine the product details and fabric roll data.
Apps Used
Workflow JSON
{
"id": "c610e93a-1dcf-49b4-ba1a-8b42da48f959",
"name": "Automated Label Generation for Product Grade and Rolls",
"nodes": 21,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: c610e93a-1dcf...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.