{"product_id":"index-woocommerce-products-in-pinecone-with-openai-embeddings","title":"Index WooCommerce Products in Pinecone with OpenAI Embeddings","description":"\u003ch3\u003eIndex your WooCommerce catalog in Pinecone using OpenAI embeddings—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow syncs your \u003cstrong\u003eWooCommerce products\u003c\/strong\u003e into \u003cstrong\u003ePinecone\u003c\/strong\u003e by generating \u003cstrong\u003eOpenAI embeddings\u003c\/strong\u003e, so your product data is ready for semantic search, recommendations, and AI-powered retrieval. It runs on a \u003cstrong\u003emanual trigger\u003c\/strong\u003e or on a \u003cstrong\u003edaily schedule at 03:00\u003c\/strong\u003e, keeping your Pinecone index up to date.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches changes:\u003c\/strong\u003e Retrieves a paginated list of published WooCommerce products (product \u003cem\u003eID\u003c\/em\u003e and \u003cem\u003emodified date\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates with an n8n Data Table:\u003c\/strong\u003e Loads previously indexed entries from an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e, compares them to WooCommerce, and selects a limited batch of \u003cstrong\u003enew or changed\u003c\/strong\u003e products.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls full product details:\u003c\/strong\u003e Requests full product details for the selected batch in one WooCommerce API call.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches each product:\u003c\/strong\u003e For variable products, fetches \u003cstrong\u003evariations\u003c\/strong\u003e, and retrieves up to \u003cstrong\u003e10 WooCommerce reviews\u003c\/strong\u003e per product.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate vectors:\u003c\/strong\u003e Builds a clean text representation (product details, variants, and selected reviews), then deletes existing Pinecone vectors for the same \u003cstrong\u003efileId\u003c\/strong\u003e before re-indexing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates embeddings and indexes:\u003c\/strong\u003e Splits the text into chunks, generates \u003cstrong\u003eOpenAI embeddings\u003c\/strong\u003e, and inserts vectors into \u003cstrong\u003ePinecone\u003c\/strong\u003e under the configured \u003cstrong\u003enamespace\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeeps data consistent:\u003c\/strong\u003e Upserts the product’s latest modified date into the Data Table; removes Pinecone vectors and Data Table entries for products no longer in WooCommerce.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSearch and chat experiences that answer questions with \u003cstrong\u003eaccurate product context\u003c\/strong\u003e from Pinecone.\u003c\/li\u003e\n  \u003cli\u003eAI storefront enhancements for SaaS operators managing frequently updated WooCommerce catalogs.\u003c\/li\u003e\n  \u003cli\u003eIncremental indexing pipelines that only process \u003cstrong\u003echanged WooCommerce products\u003c\/strong\u003e daily.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e WooCommerce REST API → OpenAI embeddings → Pinecone index\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003edata table\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003eHTTP Request\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Add \u003cstrong\u003eWooCommerce API credentials\u003c\/strong\u003e with REST API access and set your store base URL in the workflow.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123102109875,"sku":"N8N-20139","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/O4Oi_z2qEurPx0-yAC022_Ct1JwZXr.png?v=1790672442","url":"https:\/\/buyflowscripts.com\/products\/index-woocommerce-products-in-pinecone-with-openai-embeddings","provider":"N8N Commerce","version":"1.0","type":"link"}