Main/WordPress Fullstack/Blueprints/WooCommerce/High-Speed Batch Price & Inventory Sync for 30,000+ Products via Action Scheduler & WP-CLI
Back to «WooCommerce» cardsWooCommerce(ТЗ 44 из 54)
Spec: High-Speed Batch Price & Inventory Sync for 30,000+ Products via Action Scheduler & WP-CLIТрудозатраты~16 рабочих часов
Фриланс вилка~$720 – $1,200 (€640 – €1120)
Оценка веб-студии~$1,520 – $2,560 (€1440 – €2400)
ТЗ заказчика (исходный бриф):
Our external ERP updates prices and stock levels three times daily for 35,000 products. Syncing via standard REST API takes 4 hours and crashes our server. We need high-speed batch synchronization that finishes in under 5 minutes.
Ключевые требования:
- •High-speed batch import architecture processing 30,000+ SKU updates in under 5 minutes
- •Asynchronous background worker orchestration using WooCommerce Action Scheduler
- •Direct database bulk upsert queries targeting wp_postmeta, wc_product_meta_lookup, and HPOS tables
- •Automatic regeneration of product lookup tables to ensure catalog filters remain accurate
- •Dedicated WP-CLI command: 'wp catalog sync --file=feed.json' with progress bar and memory profiling
Ограничения проекта:
- •Zero site slowdown or checkout locking during batch import execution
- •Memory consumption must remain strictly under 256MB on CLI processes
Критерии приёмки (KPI):
- Full 30,000 SKU price & stock sync completes in < 5 minutes
- 0 PHP fatal errors or database deadlocks during execution
- Immediate frontend reflection of updated stock and prices
Пошаговое практическое руководство по ТЗ
Подробный разбор архитектуры, код реализации и советы эксперта по каждому этапу: