Real-Time Sheets-WP Sync
Publicada el 2026-07-27
Descripción de la oferta
I need a custom WordPress plugin that keeps my Google Sheets and WooCommerce store perfectly in step. Whenever I edit prices, stock levels, or any order detail in the sheet, the change must appear on the site immediately; likewise, every new or updated order on the site should populate the sheet in real time. Scope of sync • Data points: Prices, Inventory, Orders (these three are essential; nothing else needs to move). • Direction: Both directions—Google Sheets ⇄ WordPress—so edits from either side remain authoritative and never conflict. Core expectations 1. Real-time or near real-time communication (seconds, not minutes). 2. Stable handling of high-volume updates without time-outs. 3. Transparent error logging inside WP Admin. 4. Simple authentication flow that doesn’t expose API keys in the codebase. 5. A settings panel where I can map sheet columns to WooCommerce fields and toggle individual sync features. 6. Deliverable: an installable, production-ready plugin plus a concise setup document. Suggested stack (feel free to propose alternatives): WordPress REST API or webhooks for outbound calls, Apps Script or Cloud Functions on the Sheets side, and queued processing (Action Scheduler, WP-Cron, or Redis) to keep performance smooth. I’ll sign off once I can: – Change a price in the sheet and watch it live on product pages in seconds. – Adjust stock in WooCommerce and see the sheet update just as quickly. – Receive an order on the site and have every line item and total appear in the sheet automatically, ready for reporting. If you have live examples or code snippets that prove you’ve done similar two-way integrations, include them in your proposal.
Skills
Fuente original: freelancer