{"product_id":"sync-wordpress-woocommerce-to-pinecone-with-openai-embeddings-n8n","title":"Sync WordPress \u0026 WooCommerce to Pinecone with OpenAI Embeddings (n8n)","description":"\u003ch3\u003eKeep your Pinecone search fresh with WordPress + WooCommerce content synced via OpenAI embeddings (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically syncs your WordPress pages and blog posts (via WooCommerce\/WordPress REST API endpoints) into a Pinecone vector index using OpenAI embeddings—updating changed content and removing deleted items.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand or on a schedule\u003c\/strong\u003e: manual trigger or daily cron.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches published content in batches\u003c\/strong\u003e: pulls up to 100 published WordPress pages and up to 100 published posts (IDs and \u003cem\u003emodified timestamps\u003c\/em\u003e) via the REST API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects new or changed items\u003c\/strong\u003e: compares live IDs\/modified dates against the \u003ccode\u003eindexed_wc_blog_v1\u003c\/code\u003e n8n Data Table, then selects up to \u003ccode\u003estaticBatchSize\u003c\/code\u003e items that need indexing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads full content\u003c\/strong\u003e: retrieves the complete page\/post data for the selected batch, combines results, and strips HTML before processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmbeds + indexes into Pinecone\u003c\/strong\u003e: for each page\/post, it prepares metadata, deletes any existing Pinecone vectors for the same \u003ccode\u003efileId\u003c\/code\u003e, splits text into chunks, generates \u003cstrong\u003eOpenAI embeddings\u003c\/strong\u003e, and inserts chunk vectors into your Pinecone index.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeeps track of what’s indexed\u003c\/strong\u003e: upserts the page\/post \u003ccode\u003efileId\u003c\/code\u003e and \u003ccode\u003edateModified\u003c\/code\u003e into \u003ccode\u003eindexed_wc_blog_v1\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeletes stale vectors\u003c\/strong\u003e: finds entries present in \u003ccode\u003eindexed_wc_blog_v1\u003c\/code\u003e but missing from WordPress, deletes their Pinecone vectors, and removes their rows from the Data Table.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePower semantic search or RAG over your WordPress site content with a Pinecone-backed index.\u003c\/li\u003e\n  \u003cli\u003eEnsure WooCommerce\/WP changes propagate automatically to your vector database after publishing or updates.\u003c\/li\u003e\n  \u003cli\u003ePrevent “ghost” results by automatically removing deleted or unpublished pages\/posts from Pinecone.\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: WordPress\/WooCommerce REST API, \u003cstrong\u003eOpenAI\u003c\/strong\u003e embeddings API, \u003cstrong\u003ePinecone\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ building blocks\u003c\/strong\u003e: set, code, no op, data table, sticky note, http request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eState management\u003c\/strong\u003e: uses the \u003ccode\u003eindexed_wc_blog_v1\u003c\/code\u003e n8n Data Table to track indexed IDs and \u003ccode\u003edateModified\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154093199539,"sku":"N8N-20047","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/iUmvIETA43cNNpY3atLnV_HsZ79vL3.png?v=1790933620","url":"https:\/\/buyflowscripts.com\/products\/sync-wordpress-woocommerce-to-pinecone-with-openai-embeddings-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}