Problem:
My Node.js sync server logs show successful product updates in WooCommerce (HTTP 200 responses), but when checking the WooCommerce admin panel:
-
Some price/name changes aren’t actually saved
-
Some Poducts are created and then saved differently?
-
Products occasionally revert to previous states
-
No errors are logged despite the changes not persisting
Evidence from Logs:
2025-04-04T08:57:53.552Z [INFO]: Updated product O-GOSGP6XXZ05 (ID: 58597)
2025-04-04T08:57:54.018Z [DEBUG]: Updated product: Netzbuchsen Lötarbeiten (ID: 62082)
2025-04-04T08:57:54.871Z [INFO]: Updated product O-MOSMGXXXG4 (ID: 31218)
2025-04-04T08:57:55.391Z [DEBUG]: Updated product: Austausch Display-LCD/LED-Einheit (ID: 30612)
But these changes don’t appear in WooCommerce’s admin UI
Current Sync Flow:
- Fetch products from MySQL
- Compare with WooCommerce products
- Batch updates via WooCommerce REST API
- Log successful updates
Heres the part of the codes that correspond to the syncing process:
Core Synchronization Logic (from syncService.js):
async function syncProducts() {
try {
// 1. Fetch products from both sources
const sqlProducts = await fetchProducts(); // From SQL
const wooProducts = await fetchWooCommerceProducts(); // From WooCommerce
// 2. Compare products
const { newProducts, updatedProducts } = compareProducts(sqlProducts, wooProducts);
// 3. Process new products
for (const product of newProducts) {
await createWooCommerceProduct({
name: `${product.device_name} - ${product.repair_type}`,
sku: product.sku,
regular_price: product.price.toString(),
stock_quantity: 10
});
}
// 4. Process updates
for (const product of updatedProducts) {
await updateWooCommerceProduct(product.wooId, {
name: product.repair_type,
regular_price: product.price.toString()
});
}
} catch (err) {
logger.error('Sync failed', {
error: err.message,
response: err.response?.data
});
}
}
WooCommerce API Client (from wooService.js):
const wooCommerce = axios.create({
baseURL: `${process.env.WOOCOMMERCE_URL}/wp-json/wc/v3`,
auth: {
username: process.env.WOOCOMMERCE_CONSUMER_KEY,
password: process.env.WOOCOMMERCE_CONSUMER_SECRET
}
});
// Rate limited to 90 requests/minute
const limiter = new Bottleneck({
minTime: 60000 / 90
});
async function updateWooCommerceProduct(productId, product) {
const response = await limiter.schedule(() =>
wooCommerce.put(`/products/${productId}`, product)
);
return response.data;
}
Tried looking at the SKU format to check if it fits out existing WooCommerce format. Seemed fine, also checked the logic of the comparision between SKUS…. nothing was wrong, it detected the updated devices as well as the new ones easily. I was expecting a simple way of comparing the products, then just the code just using a simple ‘PUT’ Request with the new data to the SKU….
