Tools

n8n for syncing orders and catalog in e-commerce

An open review of how n8n is used to build synchronization of orders, stock, and product cards between marketplaces, warehousing, and ERP with AI-powered description enrichment. Breakdown by go-to

Our clients

Clients and partners

Capital Group
FSK Group
SMLT
Tochno
Dogma
Sber City
FM Logistic
Danone
+10clients · View cases →

Multi-channel retail loses money at a single point: product and stock data live in different systems and do not match. An order comes in from a marketplace, the warehouse does not know about it for half an hour, the card on the second channel still shows “in stock” - and the store sells something it does not have. Below is an open review of what can be built for this task in n8n: not a KT.Team case, but an overview based on the platform’s official templates and public community materials, with source links.

n8n is an open-source orchestration engine with a visual editor, JavaScript/Python nodes, and more than 500 native integrations (n8n.io). For e-commerce, this means Shopify, WooCommerce, marketplaces, warehousing, and ERP can be linked into one graph that runs on events or schedules, without building a separate integration service from scratch.

What is synchronized and why

The basic pain point of multichannel retail is stock mismatch. One order can contain multiple SKUs, and each one must be deducted across all channels. In n8n, this is handled by the Loop Over Items node pattern: the workflow receives an order event from Shopify, iterates through the line items one by one, and updates stock for each SKU separately - if a customer buys three different products, all three are deducted correctly (Medium, Dejan Markovic). The process result is that storefront stock reflects the physical warehouse almost in real time, instead of lagging behind a manual export.

Order -> warehouse -> ERP in one graph

Public materials describe a typical orchestration chain: Shopify -> stock check in the database -> low-stock alert in Slack -> supplier order generation in ERP -> confirmation back to Shopify (Contabo Blog). This is the core of “less manual data transfer”: the operator does not copy the order number from the marketplace dashboard into the accounting system, the graph does it automatically and logs the operation.

A deeper example is the official n8n template “AI-driven inventory management with OpenAI forecasting & ERP integration.” This is a 12-step workflow: a Schedule Trigger every 6 hours, fetching live stock and sales velocity via API, merging everything into a single JSON, demand forecasting with OpenAI GPT, filtering items for reorder, generating a supplier order with quantities and cost, sending the PO to the supplier via API, writing to ERP (SAP, Oracle, NetSuite), saving to PostgreSQL/MySQL, and notifying the team (n8n.io, template 10531). The template’s business outcome is stated plainly: an end-to-end procurement process that balances product availability while minimizing both stockouts and overstock.

AI enrichment of product cards

The other half of the task is product cards. Creating and rewriting descriptions manually for each channel is expensive and slow. The official n8n template “Generating SEO-optimized product descriptions for Shopify and Google Shopping using AI” shows a working setup: the workflow reads product data from Google Sheets (name, image URL, optionally tone of voice and target market), downloads the image with an HTTP Request node, runs it through the GPT-4o-mini vision model to extract objective features - materials, colors, attributes, structure. Then come two specialized AI agents: the first writes the title and description for Shopify, the second produces separate SEO copy for Google Merchant Center. The final texts are automatically written back to the same spreadsheet (n8n.io, template 5617).

The important part here is logic that matches the engineering approach of “minimal custom code, mature standards”: the Shopify core and the source spreadsheet are not modified, and the AI logic lives in the n8n graph alongside the systems. Vision analysis extracts verifiable attributes from the photo, not invented characteristics, which reduces the risk of hallucinations in the product card. For a catalog with hundreds or thousands of SKUs, enrichment that would take weeks manually is processed in batches.

What this changes in the process

By combining the two halves - transaction synchronization and content enrichment - a retailer gets a setup where a new or changed product is entered once in the source, automatically receives SEO descriptions for each channel, and is distributed across storefronts, while orders and stock flow back into ERP without manual transfer. As an open-source tool, n8n lets you keep these graphs in-house, version them, and hand them over to another team without rewriting - the coupling between systems stays loose and portable.

Limitations to keep in mind

Open sources also clearly show the boundaries. Demand forecasting with an LLM is a probabilistic estimate with a confidence level, not a deterministic calculation; such recommendations must be validated by business rules before automatic ordering. The reliability of the graph depends on error handling and idempotency: a repeated marketplace webhook must not deduct stock twice. Self-hosted n8n requires its own operations - monitoring, retries, queues. It is not an out-of-the-box product, but a builder that must be assembled for a specific stack of channels and ERP.

Takeaway for order and catalog management

The main measurable result is eliminating manual data transfer between marketplaces, warehousing, and ERP and reducing stock mismatches to near real time, plus batch AI enrichment of product cards for each channel. n8n acts here as an open orchestration layer on top of existing systems, not as a replacement for the accounting system: the core tools stay untouched, business logic lives in adjacent graphs, and the integration remains portable and transferable.

Sources

Sales channels

Processing

n8n orchestration

Channels and endpoints

Order -> Loop Over Items by SKU -> stock check in DB -> stock deduction across all channels -> write to ERP (SAP/Oracle/NetSuite) -> confirmation back to the channel
Schedule Trigger 6h -> fetch stock and sales velocity -> merge into JSON -> OpenAI GPT forecast -> reorder filter -> PO to supplier -> log in ERP + PostgreSQL -> notification
Google Sheets (name, photo) -> HTTP Request downloads the image -> GPT-4o-mini vision analyzes features -> AI agent 1 (Shopify product card) + AI agent 2 (SEO for Google Merchant Center) -> write back to the source -> publish to channels
the core tools are not modified, business logic lives in adjacent n8n graphs, the integration is portable

Which business process it improves

The order and catalog management process is reworked like this: a product is entered once in the source system, n8n automatically enriches it with SEO descriptions for each channel (photo vision analysis + AI agents), synchronizes stock across all SKUs in near real time, and passes orders into ERP without manual transfer - manual work and stock mismatches disappear, while the integration remains open and transferable between teams.

Discuss n8n for syncing orders and catalog in...

Send via: