AutomationFlowsAI & RAG › Sync Adobe Commerce Customer Data to Klicktipp with Value-based Tagging

Sync Adobe Commerce Customer Data to Klicktipp with Value-based Tagging

ByKlickTipp @KlickTipp on n8n.io

Community Node Disclaimer: This workflow uses KlickTipp community nodes.

Cron / scheduled trigger★★★★☆ complexity16 nodesN8N Nodes KlicktippMagento2
AI & RAG Trigger: Cron / scheduled Nodes: 16 Complexity: ★★★★☆ Added:
Sync Adobe Commerce Customer Data to Klicktipp with Value-based Tagging — n8n workflow card showing N8N Nodes Klicktipp, Magento2 integration

This workflow corresponds to n8n.io template #9469 — we link there as the canonical source.

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 →

Download .json
{
  "id": "mCtnv1ABd7XoeEJI",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Sync Adobe Commerce Customer Data to KlickTipp with Value-Based Tagging",
  "tags": [
    {
      "id": "15wrq9sti6wyqr6J",
      "name": "TEMPLATE",
      "createdAt": "2025-01-08T16:34:30.163Z",
      "updatedAt": "2025-01-08T16:34:30.163Z"
    }
  ],
  "nodes": [
    {
      "id": "bdd6c077-4637-4a1b-abde-5a71f5a90eda",
      "name": "Tag contact for high-value order",
      "type": "n8n-nodes-klicktipp.klicktipp",
      "position": [
        1648,
        -128
      ],
      "parameters": {
        "email": "={{ $json.email }}",
        "tagId": [
          "13548739"
        ],
        "resource": "contact-tagging"
      },
      "credentials": {},
      "typeVersion": 3
    },
    {
      "id": "aad62cd5-8160-4573-b8c3-0ade16c952a1",
      "name": "Tag contact for clothing purchase",
      "type": "n8n-nodes-klicktipp.klicktipp",
      "position": [
        1648,
        64
      ],
      "parameters": {
        "email": "={{ $json.email }}",
        "tagId": [
          "13548800"
        ],
        "resource": "contact-tagging"
      },
      "credentials": {},
      "typeVersion": 3
    },
    {
      "id": "038a339e-323d-4829-a0fc-1da5b24df7bd",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        176,
        176
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "bdfafcfb-e780-42d0-9b84-1c6c957d8aae",
      "name": "Route by SKU and total amount",
      "type": "n8n-nodes-base.switch",
      "position": [
        1344,
        -48
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "Order Value \u2265 100",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "60e8a476-a06c-4d95-9bc2-e8c621bd9a1a",
                    "operator": {
                      "type": "number",
                      "operation": "gte"
                    },
                    "leftValue": "={{ $('Get Adobe Commerce orders').item.json.grand_total }}",
                    "rightValue": 100
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "Order contains clothing",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "c42480ed-b454-4604-a4d3-28c5c120497f",
                    "operator": {
                      "type": "boolean",
                      "operation": "true",
                      "singleValue": true
                    },
                    "leftValue": "={{\n  ($('Get Adobe Commerce orders').item.json.items ?? []).some(it => (it.sku ?? '') === 'TEST-002')\n}}",
                    "rightValue": "TEST-002"
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {
          "allMatchingOutputs": true
        }
      },
      "typeVersion": 3.2
    },
    {
      "id": "d8262afb-d24e-484c-9132-9985fa325b75",
      "name": "Get Adobe Commerce orders",
      "type": "n8n-nodes-base.magento2",
      "position": [
        368,
        -48
      ],
      "parameters": {
        "options": {},
        "resource": "order",
        "operation": "getAll",
        "returnAll": true,
        "filterJson": "={\n  \"search_criteria\": {\n    \"filter_groups\": [\n      {\n        \"filters\": [\n          {\n            \"field\": \"created_at\",\n            \"condition_type\": \"gteq\",\n            \"value\":\"{{ $now.toUTC().minus({ minutes: 6 }).toFormat('yyyy-LL-dd HH:mm:ss') }}\"\n          }\n        ]\n      }\n    ],\n    \"sortOrders\": [\n      { \"field\": \"created_at\", \"direction\": \"ASC\" }\n    ]\n  }\n}",
        "filterType": "json"
      },
      "credentials": {},
      "typeVersion": 1
    },
    {
      "id": "f499199f-ec8d-4985-a5ff-90938b02f96f",
      "name": "Documentation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        -240
      ],
      "parameters": {
        "width": 688,
        "height": 752,
        "content": "Community Node Disclaimer: This workflow uses KlickTipp community nodes.\n\n## Introduction\nThis workflow monitors orders and customers in Adobe Commerce, automatically creating or updating contacts in KlickTipp, enriching profiles for segmentation and automated messaging. Tags are applied dynamically: high-value orders (\u2265100) receive a \"Premium Customer\" tag, and purchases with certain SKUs (e.g., clothing) are assigned product-based tags. Perfect for e-commerce businesses, online retailers, and digital shops that want to eliminate manual data entry and ensure every buyer and customer receives the right messages.\n\n## Setup Instructions\n1. **KlickTipp Preparation**\n      - Prepare **custom fields**\n       - `Payment ID`\n       - `Total`\n       - `Receipt URL`\n       - `Products`\n      - Prepare **tags**:\n       - `Premium customer`\n       - `Clothing buyer`\n\n2. **Credential Configuration**\n     - Connect your Magento account using an **Access Token/Base URL** from the Magento Admin Dashboard (System \u2192 Extensions \u2192 Integrations).\n     - Authenticate your KlickTipp connection with **username/password** credentials (API access required).\n\n## Customization\n- **Trigger options:** If your Commerce edition supports **webhooks**, you can replace polling with a **Webhook** trigger.  \n- **Cadence & overlap:** 1\u201330 min are typical; a 1\u20132 min overlap in the filter to avoid gaps.  \n- **Routing variants:** Change the SKU list, switch to category checks, or add more value tiers."
      },
      "typeVersion": 1
    },
    {
      "id": "cce7e8d3-7b57-4565-8335-70002f341046",
      "name": "5. Contact tagging",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1568,
        -240
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 952,
        "content": "## 5. Contact tagging"
      },
      "typeVersion": 1
    },
    {
      "id": "2a7aadec-0257-4fad-9e06-870eafff054f",
      "name": "4. Routing for tagging",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1248,
        -240
      ],
      "parameters": {
        "color": 7,
        "width": 304,
        "height": 952,
        "content": "## 4. Routing for tagging"
      },
      "typeVersion": 1
    },
    {
      "id": "6c2240fa-9841-4126-b5e0-2f9a5db40c27",
      "name": "3. Data saving",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        912,
        -240
      ],
      "parameters": {
        "color": 7,
        "width": 320,
        "height": 952,
        "content": "## 3. Data saving"
      },
      "typeVersion": 1
    },
    {
      "id": "1ccf8c40-8133-4240-a38a-423ed598633c",
      "name": "Get Adobe Commerce customers",
      "type": "n8n-nodes-base.magento2",
      "position": [
        368,
        384
      ],
      "parameters": {
        "options": {},
        "operation": "getAll",
        "returnAll": true,
        "filterJson": "={\n  \"search_criteria\": {\n    \"filter_groups\": [\n      {\n        \"filters\": [\n          {\n            \"field\": \"updated_at\",\n            \"condition_type\": \"gteq\",\n            \"value\":\"{{ $now.toUTC().minus({ minutes: 6 }).toFormat('yyyy-LL-dd HH:mm:ss') }}\"\n          }\n        ]\n      }\n    ],\n    \"sortOrders\": [\n      { \"field\": \"updated_at\", \"direction\": \"ASC\" }\n    ]\n  }\n}",
        "filterType": "json"
      },
      "credentials": {},
      "typeVersion": 1
    },
    {
      "id": "c4dbb9ba-8709-4a0b-bc48-bf6987269464",
      "name": "1. Data reception",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        -240
      ],
      "parameters": {
        "color": 7,
        "width": 428,
        "height": 952,
        "content": "## 1. Data reception"
      },
      "typeVersion": 1
    },
    {
      "id": "9a45101d-d4bb-4d53-b6da-48a6716a79ae",
      "name": "2. Check for contact",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        -240
      ],
      "parameters": {
        "color": 7,
        "width": 320,
        "height": 952,
        "content": "## 2. Check for contact"
      },
      "typeVersion": 1
    },
    {
      "id": "f11421c2-5b0b-4a25-90ea-b56d4be7439a",
      "name": "Check if customer exists as contact",
      "type": "n8n-nodes-klicktipp.klicktipp",
      "onError": "continueErrorOutput",
      "position": [
        688,
        384
      ],
      "parameters": {
        "resource": "subscriber",
        "operation": "get",
        "lookupEmail": "={{ $json.email }}"
      },
      "credentials": {},
      "typeVersion": 3
    },
    {
      "id": "e569a7a0-2ce3-442f-90b1-973d03dc6d92",
      "name": "Transfer order data to KlickTipp with DOI",
      "type": "n8n-nodes-klicktipp.klicktipp",
      "onError": "continueRegularOutput",
      "position": [
        1008,
        -48
      ],
      "parameters": {
        "email": "={{ $json.customer_email }}",
        "fields": {
          "dataFields": [
            {
              "fieldId": "fieldFirstName",
              "fieldValue": "={{ $json.customer_firstname }}"
            },
            {
              "fieldId": "fieldLastName",
              "fieldValue": "={{ $json.customer_lastname }}"
            },
            {
              "fieldId": "fieldCountry",
              "fieldValue": "={{ $json.billing_address.country_id }}"
            },
            {
              "fieldId": "fieldCity",
              "fieldValue": "={{ $json.billing_address.city }}"
            },
            {
              "fieldId": "fieldStreet1",
              "fieldValue": "={{ $json.billing_address?.street?.[0] || '' }}"
            },
            {
              "fieldId": "fieldZip",
              "fieldValue": "={{ $json.billing_address.postcode }}"
            },
            {
              "fieldId": "fieldPhone",
              "fieldValue": "={{ $json.billing_address.telephone }}"
            },
            {
              "fieldId": "field223236",
              "fieldValue": "={{ $json.payment.last_trans_id }}"
            },
            {
              "fieldId": "field223239",
              "fieldValue": "={{ $json.grand_total }}"
            },
            {
              "fieldId": "field223245",
              "fieldValue": "=https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_view-a-trans&id={{ $json.payment.last_trans_id }}"
            },
            {
              "fieldId": "field223237",
              "fieldValue": "={{ \n  ($json.items ?? [])\n    .map(i => i.name)\n    .filter(Boolean)\n    .join(', ')\n}}"
            }
          ]
        },
        "listId": "358895",
        "resource": "subscriber",
        "operation": "subscribe"
      },
      "credentials": {},
      "typeVersion": 3
    },
    {
      "id": "b2330c7d-0210-4568-885b-abb46edc2c14",
      "name": "Transfer customer to KlickTipp with SOI",
      "type": "n8n-nodes-klicktipp.klicktipp",
      "position": [
        1008,
        496
      ],
      "parameters": {
        "email": "={{ $('Get Adobe Commerce customers').item.json.email }}",
        "fields": {
          "dataFields": [
            {
              "fieldId": "fieldFirstName",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.firstname }}"
            },
            {
              "fieldId": "fieldLastName",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.lastname }}"
            },
            {
              "fieldId": "fieldCountry",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].country_id }}"
            },
            {
              "fieldId": "fieldState",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].region.region }}"
            },
            {
              "fieldId": "fieldCity",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].city }}"
            },
            {
              "fieldId": "fieldStreet1",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].street[0] }}"
            },
            {
              "fieldId": "fieldZip",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].postcode }}"
            },
            {
              "fieldId": "fieldPhone",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].telephone }}"
            }
          ]
        },
        "listId": "364353",
        "resource": "subscriber",
        "operation": "subscribe"
      },
      "credentials": {},
      "typeVersion": 3
    },
    {
      "id": "efc181df-6578-40dc-ba31-60391c3ac10e",
      "name": "Update customer in KlickTipp",
      "type": "n8n-nodes-klicktipp.klicktipp",
      "position": [
        1008,
        288
      ],
      "parameters": {
        "email": "=",
        "fields": {
          "dataFields": [
            {
              "fieldId": "fieldFirstName",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.firstname }}"
            },
            {
              "fieldId": "fieldLastName",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.lastname }}"
            },
            {
              "fieldId": "fieldCountry",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].country_id }}"
            },
            {
              "fieldId": "fieldState",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].region.region }}"
            },
            {
              "fieldId": "fieldCity",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].city }}"
            },
            {
              "fieldId": "fieldStreet1",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].street[0] }}"
            },
            {
              "fieldId": "fieldZip",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].postcode }}"
            },
            {
              "fieldId": "fieldPhone",
              "fieldValue": "={{ $('Get Adobe Commerce customers').item.json.addresses[0].telephone }}"
            }
          ]
        },
        "resource": "subscriber",
        "operation": "update",
        "lookupEmail": "={{ $('Get Adobe Commerce customers').item.json.email }}"
      },
      "credentials": {},
      "typeVersion": 3
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "e227cdf1-e1dc-4b93-ad1f-ebe810b3b048",
  "connections": {
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Adobe Commerce orders",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Adobe Commerce customers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Adobe Commerce orders": {
      "main": [
        [
          {
            "node": "Transfer order data to KlickTipp with DOI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Adobe Commerce customers": {
      "main": [
        [
          {
            "node": "Check if customer exists as contact",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route by SKU and total amount": {
      "main": [
        [
          {
            "node": "Tag contact for high-value order",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Tag contact for clothing purchase",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check if customer exists as contact": {
      "main": [
        [
          {
            "node": "Update customer in KlickTipp",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Transfer customer to KlickTipp with SOI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Transfer order data to KlickTipp with DOI": {
      "main": [
        [
          {
            "node": "Route by SKU and total amount",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Community Node Disclaimer: This workflow uses KlickTipp community nodes.

Source: https://n8n.io/workflows/9469/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Master Agent - Orchestrator. Uses httpRequest, telegram, telegramTrigger. Scheduled trigger; 46 nodes.

HTTP Request, Telegram, Telegram Trigger
AI & RAG

Reputation Engine — Content Research Agent. Uses httpRequest. Scheduled trigger; 45 nodes.

HTTP Request
AI & RAG

Master Agent - Orchestrator. Uses httpRequest, telegram, telegramTrigger. Scheduled trigger; 43 nodes.

HTTP Request, Telegram, Telegram Trigger
AI & RAG

Linkedin Workflow. Uses httpRequest, googleSheets. Scheduled trigger; 39 nodes.

HTTP Request, Google Sheets
AI & RAG

I prepared a detailed guide that shows the whole process of building an AI tool to analyze Instagram Reels using n8n.

HTTP Request, Airtable, Execute Workflow Trigger