Product not sync in woocommerce

Status: Open · Asked by Le Rouge Sdn Bhd Alex on Aug 28, 2026 · 0 views

Le Rouge Sdn Bhd Alex — Question · Aug 28, 2026

Hi team, refer back on our discussion in email ticket #TCK-211196

Following up on my previous case regarding the Xero → Google Sheets → WooCommerce workflow ("Create Bill, Update Quantity(+)").

A new item was received in Xero on 27 Aug 2026. The task appears in History but did not create the product in WooCommerce.

Details:

- Xero item: Evian Sparkling Natural Mineral Water (Can) 330ml

- Bill reference: shopee/INV0008261 — issue date 27 Aug 2026, qty +48

- WooCommerce: SKU not found (0 products)

The workflow is the one your team assisted with previously — trigger set to "Bill Created (Instant)" with Advanced response format, 2nd Iterator on the LineItems array, and an "ItemCode Is Not Empty" filter before the Google Sheets lookup.

Could you please review the task log and advise what is causing this step to fail?

Thank you.

Pabbly Support — Reply · Aug 28, 2026

Hello Alex,

Thank you for following up on your workflow issue regarding the Xero to WooCommerce synchronization.

Based on your description, it seems the task history for the "Create Bill, Update Quantity(+)", despite appearing in the history, did not successfully create the product in WooCommerce. Here are a few things to check:

1. ItemCode Check: Ensure that the SKU for the Xero item (Evian Sparkling Natural Mineral Water) is correctly entered in your Google Sheets lookup. The SKU needs to match exactly for WooCommerce to recognize it.
2. Workflow Configuration: Verify that the trigger is properly set to "Bill Created (Instant)" and that the Advanced response format is enabled. Ensure that the iterator is set to process the LineItems array correctly as well.
3. Task Log Review: Review the logs for any errors that might indicate why the WooCommerce product was not created. Look for any messages related to mapping or missing data that could prevent the SKU from being found.

If you continue to experience issues, sharing the specific task ID from the history will allow us to dig deeper into the problem.

Thanks & Regards,

Adeel Akhtar
🌐 Pabbly.com

Back to all forum threads · Log in to reply