I have set up inventory management in Xero and now need the Xero stock levels for each product to sync back to WooCommerce whenever there is a change in those stock levels in Xero.
Can anyone assist me with this? I seem to only be able to select sales invoices from Xero which are then not easy to sync back to WooCommerce to “update product” for stock quantity.
Any ideas?
Best answer by SamB
Hey
From what I can tell it looks like inventory adjustments can be made through invoices in Xero:
Integrating with Xero tracked inventory - Inventory adjustments
So it may be that you can trigger on the new invoices that are added to Xero and then update WooCommerce using the product line-item information from the invoice.
I suspect that product information from the invoice would come over from Xero as line items. I’ve not tested this out myself but you might need to use Formatter by Zapier to extract certain information to allow you to update the relevant products in WooCommerce. You can find out more about how to work with line items in the following guides:
I hope this helps to point you in the right direction! :)
+14Hi
Likely the Xero API Webhooks needs to be leveraged: https://developer.xero.com/documentation/guides/webhooks/overview/
Webhooks app: https://zapier.com/apps/webhook/integrations
Consider hiring a Zapier Expert if you need help: https://zapier.com/experts
Hi
I don't see any Xero API webhooks for the inventory management specifically?
Do you have any experience with Xero in terms of which hook it would be?
+11Hey
From what I can tell it looks like inventory adjustments can be made through invoices in Xero:
Integrating with Xero tracked inventory - Inventory adjustments
So it may be that you can trigger on the new invoices that are added to Xero and then update WooCommerce using the product line-item information from the invoice.
I suspect that product information from the invoice would come over from Xero as line items. I’ve not tested this out myself but you might need to use Formatter by Zapier to extract certain information to allow you to update the relevant products in WooCommerce. You can find out more about how to work with line items in the following guides:
I hope this helps to point you in the right direction! :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
