Xero connect to woocommerce

Status: Closed · Asked by GOH PEI LI on · 0 views

zaoyao2016 — Question ·

How I update the product quantity of the woocommerce if I create the bill in Xero

Pabblymember11 — Reply ·

Hey @zaoyao2016

As we can see from your workflow, you haven't configured WooCommerce accordingly.

Please check the following thread to add the Basic Auth plugin to your WordPress.

https://forum.pabbly.com/threads/wordpress-error-rest_cannot_create_user-sorry-you-are-not-allowed-to-create-new-users-401.813/

Then, please use the "WooCommerce: Retrieve a Product by Name or Slug" to retrieve the product id which you can later pass in the Product Id field of "Update Product".

zaoyao2016 — Reply ·

hI, May I know how I do if I credit notes in the Xero, the woocomeercee will update the quantity of product.

Pabblymember11 — Reply ·

Hey @zaoyao2016

If you are trying to update the product in the line item manner then it is not possible to retrieve individual products and cannot pass with line item quantity from Xero.

Further, you can only update products from Xero one by one to WooCommerce.

zaoyao2016 — Reply ·

Hi if return the product to the supplier in the xero, woocommerce Will automatically update the product quantity.it possible to do this

Pabblymember11 — Reply ·

Hey @zaoyao2016

To update the product in WooCommerce, you need to check first whether the product is present in your WooCommerce or not.

So, kindly try to use the exact name of the product in your Xero and on WooCommerce.

zaoyao2016 — Reply ·

Currently My quantity of product a is 5
But I had create a new bills in the xero which is added product a with 3 quntity
Why the quantity product in the woocommerce will become the 3 when i select the updated product
How I make the quantity of product become 5+3=8?

Pabblymember11 — Reply ·

Can you please elaborate on your concern briefly with the help of a short recorded video?

zaoyao2016 — Reply ·

The scenario is I create bills in Xero, and the quantity of the product will update
On initially of the yam is 10 in the woocommerce, I had to create a bill that added 3 new yam in the Xero, When click send the test request in the pabbly the quantity product in the woocommerce becomes 3. Actually, I want 10 (initial) +3 (new)=13

youtube.com/watch?v=vrWzDanIVZQ

Pabblymember11 — Reply ·

Hey @zaoyao2016

Why the quantity product in the woocommerce will become the 3 when i select the updated product
How I make the quantity of product become 5+3=8?

Regarding your concern to update the overall quantity from your Xero along with WooCommerce's retired product quantity, you can use the "Number Formatter by Pabbly: Perform Math Operation".

Kindly give this a try and let us know if that works for you.

zaoyao2016 — Reply ·

Hi, I had planned to do this when I create an invoice in Xero, the woocommerce will automatically create the order?
The scenario on my site is correct?
May I know what is the difference create an order and create an order (with line item)?

Pabblymember11 — Reply ·

Hey @zaoyao2016

Yes, with the help of this workaround, you can change the number of your products dynamically.

Please give it a try and let us know how it works for you.

zaoyao2016 — Reply ·

Hi, I had create a bill with 3 item, but 2 item is broken , So i will create a credit note .
My woocommerce also will decrease the quantity of product after credit note
How i do it because I just see credit note only in the action.
How i connect it

Pabblymember11 — Reply ·

Hey @zaoyao2016

The workaround we have shows you will only work for a single line item, it wouldn't get support on multiple line items.

zaoyao2016 — Reply ·

Hi May I know if create a invoice with ten product in the xero
After do the connection, They will help me create 10 product in the woocommerce?

Pabblymember11 — Reply ·

Hey @zaoyao2016

I don't think that a reverse procedure to create 10 products in WooCommerce will work.

zaoyao2016 — Reply ·

May I know if I created multiple products in the xero for example 10product per invoice ,they will help me automatically added how many product

Pabblymember11 — Reply ·

Hey @zaoyao2016

May I know if I created multiple products in the xero for example 10product per invoice ,they will help me automatically added how many product

You can use the "WooCommerce: Create a Product " action step to pass all the supported line items in the product.

Before passing the line Item data in the action step you can process the JSON array with the help of "Line Itemizer "

youtube.com/watch?v=GqaiQO_ekUQ

Le Rouge Sdn Bhd Alex — Reply ·

Hi The data i had map is room fresh and chid but why finally only show me product-6

Attachments

1676025066184.png
1676025121080.png
Pabblymember11 — Reply ·

Hey @zaoyao

They will automatically map products depending on how many products have been created in the Xero bill. Right?

Using Line Itemizer, all your products will get mapped in number as it is coming.

Le Rouge Sdn Bhd Alex — Reply ·

Hi The data i had map is room fresh and chid but why finally only show me product-6

Attachments

1676025121080.png
1676025066184.png
Pabblymember11 — Reply ·

Please share the name of the workflow, which you have tried.

As we can see from your screenshot you have passed the multiple line item in the incorrect way. Please check the video tutorial again you will see the manner in which the data should be forwarded.

Le Rouge Sdn Bhd Alex — Reply ·

My web flow name is Xero create bill, woo-commerce create product
I had to check a lot of times. I really don't which are the wrong item
Please help me thanks

zaoyao2016 — Reply ·

Let me know if i doing any wrong thanks

Pabblymember11 — Reply ·

Hey @zaoyao

You are supplying numerous product data in the Product Slug and Product Name columns of the Create Product action step of WooCommerce, which WooCommerce does not permit.

Attachments

1676264919425.png
zaoyao2016 — Reply ·

Hi, I have a question, in regards of the task of Pabbly.

We noticed that the tasks are picked up concurrently and causes the product quantity to be updated incorrectly.

ie:
1. We have a product "happy" with a quantity of 6.
2. Task 1 - Created a bill which will increase the product count -> product from 6 -> 9. (webflow name=Create bill , update product)
3. Task 2 - Created an invoice that deducted the product (the product quantity picked up here is 6 instead of 9 due to the increase by Task 1) from 6 -> 5.(webflow name=Create Invoice credit note)

Kindly check on the above issue, what is the cause of it and how do we resolve?
Thanks

Pabblymember11 — Reply ·

Can you please explain the situation with the help of a short recorded video?

zaoyao2016 — Reply ·

Hi all, based on video 1,

the quantity of product is 6 (beginning)and after the process of updating product it becomes 9

In video 2, the quantity of the product also is 6. (I think the quantity of the product should be 9 because it already run task 1 in video 1)

youtube.com/watch?v=KjwQz4aviFE

(video 1)

youtube.com/watch?v=0NtwxXFaXzQ(video

2)

Pabblymember11 — Reply ·
Why the quantity product in the woocommerce will become the 3 when i select the updated product
How I make the quantity of product become 5+3=8?

As per your initial condition what you were looking for is exactly to begin processing in the automation.

https://www.screenpresso.com/=C1Lzc

Back to all forum threads · Log in to reply