Finalize Sinalite API WooCommerce Integration

Job ID: 39838087

Budget: $30 – $250 CAD

My WooCommerce store already connects to the Sinalite API, but the feed is far from production-ready. At the moment product descriptions are not importing at all—that’s the first pain point I need solved. Once descriptions flow correctly, I want the same script to finish pulling images and any remaining attributes without timing out.

Here’s the current situation:

• I have the Sinalite endpoint credentials in place and a partially working PHP script inside a custom plugin.
• We’re pushing several hundred variable products per call, so the import routinely hits the WordPress execution limit and dies.
• Images queue but never appear in the media library, and the description field stays blank in the product editor.

What I need from you:

1. Diagnose why the description field is empty and get it populating every time.
2. Refactor or replace the import routine so that large batches process safely—whether that’s pagination, background queues, or WooCommerce’s built-in CRUD with WP-CLI/cron is up to you.
3. Ensure image URLs from Sinalite download, attach to the product, and set a featured image where provided.
4. Provide clear comments in the code (PHP/JS) so I can maintain it later and, ideally, a short read-me that explains how to trigger future syncs.

You’ll be working in a staging copy of the site with full FTP, phpMyAdmin, and WP admin access. Core stack: WordPress 6.x, WooCommerce 8.x, custom plugin written in PHP 8.2 using cURL for the REST calls.

If you’ve handled high-volume external catalogs before and know your way around timeouts, transients, and batch processing, I’d love to get this wrapped up quickly. Let me know your approach and an estimated timeframe to complete the tasks above.