Woocommerce return 500 error magga

hey guys, it is my first time posting here, however i have been following the form for a long time and it did help me so mush, but i have reach a dead end here so i need your help guys.
I am trying to connect my wordpress website to Erpnext , but when i try to setup webhook i keep getting
[Error: Delivery URL returned response code: 500]

and when i checked the URL it showed {},so i am not sure what to do exactly to get it to work.so far i have tried it on two different servers, self hosted and the free trial instance.

any help would be appreciated.

We are having a similar issue while trying to connect our Woocommerce store with ERPNext.

Here are the logs:

2019-10-30T20:42:16+00:00 INFO Array
(
[Webhook Delivery] => Array
(
[Delivery ID] => 2d1def26e832482f5e09fdecb98ad133
[Date] => Oct 30, 2019 @ 20:42
[URL] => https://erp.tecnofood.com.mx/api/method/erpnext.erpnext_integrations.connectors.woocommerce_connection.order
[Duration] => 0.75514
[Request] => Array
(
[Method] => POST
[Headers] => Array
(
[User-Agent] => WooCommerce/3.7.0 Hookshot (WordPress/5.2.4)
[Content-Type] => application/json
[X-WC-Webhook-Source] => https://www.mrwings.com/
[X-WC-Webhook-Topic] => order.created
[X-WC-Webhook-Resource] => order
[X-WC-Webhook-Event] => created
[X-WC-Webhook-Signature] => Q4WGpH1pqgqa5jiJj/GkfC7zH7sQwrUzlBYJIK6Mz6U=
[X-WC-Webhook-ID] => 1
[X-WC-Webhook-Delivery-ID] => 2d1def26e832482f5e09fdecb98ad133
)

            )

        [Body] => Webhook body is not logged unless WP_DEBUG mode is turned on. This is to avoid the storing of personal data in the logs.
        [Response] => Array
            (
                [Code] => 417
                [Message] => Expectation Failed
                [Headers] => Requests_Utility_CaseInsensitiveDictionary Object
                    (
                        [data:protected] => Array
                            (
                                [server] => nginx
                                [date] => Wed, 30 Oct 2019 20:42:16 GMT
                                [content-type] => text/html; charset=utf-8
                                [content-length] => 9841
                                [x-page-name] => message
                                [x-from-cache] => False
                                [set-cookie] => Array
                                    (
                                        [0] => user_image=; Path=/
                                        [1] => user_id=Guest; Path=/
                                        [2] => system_user=yes; Path=/
                                        [3] => full_name=Guest; Path=/
                                        [4] => sid=Guest; Expires=Sat, 02-Nov-2019 20:42:15 GMT; Path=/
                                    )

                            )

                    )

                [Body] => Webhook body is not logged unless WP_DEBUG mode is turned on. This is to avoid the storing of personal data in the logs.
            )

    )

)

Any idea on how to address this?

any updates on this Error: Delivery URL returned response code: 500 ?

worked for me.

1 Like

Did you ever figure out the solution to your particular log output? My log output is very similar and I cannot find anything that is obviously wrong with the setup. I have looked at the Guest user in ERPNext but everything looks fine.

I get the following log

                                    [0] => user_image=; Path=/
                                    [1] => user_id=Guest; Path=/
                                    [2] => system_user=yes; Path=/
                                    [3] => full_name=Guest; Path=/
                                    [4] => sid=Guest; Expires=Sat, 02-Nov-2019 20:42:15 GMT; Path=/

Unlike Jignesh_shah, I do not see anything relating to fields like customer_group or territory, or any other incorrect field.

It seems that the root cause of our problem is that ERPNext feetches the “item_code” from the Wocoomerce Item “woocomerce_id”.

So the solution would seem to be to modify your “item_code” in order to match the “woocommerce_id”.

I believe this is a Bug so I´ve added it to Github: Woocommerce integration requires to modify "item_code" · Issue #111 · frappe/ecommerce_integrations · GitHub

Please like and share so it gets relevant for solution.

1 Like