Index WooCommerce products in Pinecone with OpenAI embeddings
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 23 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Embeddings OpenAI and Pinecone Vector Store.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Set API Settings (Edit Fields (Set)): sets 6 fields: wooBaseUrl, wooCurrency, pineconeIndexName…
- Fetch All Products (HTTP Request): calls an HTTP API
- Fetch Deduplication Entries (Data table): get
- Select Batch for Processing (Code): runs custom JavaScript code
- Identify Deleted Products (Code): runs custom JavaScript code
- Collect Product IDs (Code): runs custom JavaScript code
- Batch Delete Removed Products (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch Batch Product Data (HTTP Request): calls an HTTP API
- Remove Product Vector (HTTP Request): calls an HTTP API (POST)
- Batch Process Products (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Data table
n8n-nodes-base.dataTable - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone
From the author
Quick overview This workflow runs on a manual or daily schedule to sync WooCommerce products into Pinecone by fetching changed items, enriching them with variations and reviews, generating OpenAI embeddings, and tracking indexed products in an n8n Data Table…