WooCommerce-Google Sheets Sync Plugin Development
Publicada el 2026-07-27
Descripción de la oferta
am looking for an experienced WordPress and WooCommerce plugin developer to build a premium Google Sheets synchronization plugin completely from scratch. The plugin should synchronize WooCommerce products and Google Sheets in both directions, allowing me to manage my WooCommerce store directly from Google Sheets. This is a long-term project. I need clean, scalable, well-documented code built using WordPress and WooCommerce best practices. Do not use or copy code from any commercial plugins. The plugin must include the following features: * Google Service Account authentication using JSON credentials. * Test Connection feature. * Secure storage of Google credentials. * Google Sheets API v4 integration. * Automatic token refresh and token caching. Export Features: * Export all WooCommerce products. * Export simple products. * Export variable products. * Export every variation as a separate row. * Export SKU, Product ID, Variation ID, Product Name, Attributes, Regular Price, Sale Price, Stock Quantity, Stock Status, Categories, Tags, Images, Product URL, and Last Modified Date. Import Features: * Import updates from Google Sheets. * Update prices. * Update sale prices. * Update stock quantity. * Update stock status. * Update product status. * Update SKU. * Update categories and tags. * Support both simple and variable products. * Update variations individually without affecting other variations. Synchronization Features: * Manual Sync. * Automatic Sync. * Sync every minute, every 5 minutes, every 15 minutes, hourly, and daily. * Two-way synchronization between WooCommerce and Google Sheets. * Prevent synchronization loops. * Conflict resolution based on last modified time. * Resume interrupted synchronization. Performance: * Batch processing. * Pagination. * Background processing using Action Scheduler. * Optimized for stores with thousands of products and variations. * No unnecessary database queries. * Memory efficient. Reliability: * Retry failed Google API requests. * Duplicate detection. * Detailed logging. * Backup before import. * Restore previous backup. * Dry Run mode to preview changes before applying them. * Synchronization lock to prevent multiple sync jobs running at the same time. Dashboard: * Google connection status. * Scheduler status. * Last successful synchronization. * Last failed synchronization. * Number of exported products. * Number of imported products. * Queue status. * Error logs. Security: * WordPress nonce verification. * Capability checks. * Prepared SQL statements where required. * Input sanitization. * Output escaping. * Secure handling of Google credentials. Code Requirements: * PHP 8.3+ * WordPress Coding Standards * WooCommerce CRUD API * Object-Oriented Programming * Well documented code * Modular architecture * No obfuscated or encrypted code Deliverables: * Complete plugin source code. * Fully functional WordPress plugin. * Installation guide. * Documentation. * Full ownership of the source code. The plugin should be production-ready, reliable, scalable, and easy to maintain. Preference will be given to developers with proven experience in WooCommerce plugin development and Google Sheets API integration.
Skills
Fuente original: freelancer