Unable to Transfer my Google sheets orders into woocommerce

[Olamide01]

I am trying to integrate my orders inserted in google sheets into Woocommerce, however I keep getting HTTP Status Code 500 error when trying to pass the data from google sheets to woocommerce. “The application processed the request but returned a blank response. Refer to the HTTP status code above for details.” Please how do i i go about this. Also please kindly note that i also need solution that could work for including multiple products related to an order.

You can kindly see attached screenshot for details.



Hope to get a reply soonest. Thank you.

 

[PabblyMember4]

Hey @Olamide01

You are getting the response correctly in the Woocommerce action. Please check the below screenshot:-

Thanks
Kunal

 

[Olamide01]

Thank you so much for your quick response, However i still get this data status code error 400 "woocommerce_rest_invalid_fee_item" with a message "Fee name is required". I really don't know what the fee name is... Please kindly also view attached for clarity. I am just havig difficulty in trying to transfer google sheet orders including single orders with multiple items in subsequent rows into woocommerce. I really hope to get a reply soonest again. Thank you.

 

[Pabblymember11]

Hey @Olamide01

In the "WooCommerce: Update an Order (With Line Items)" action step you need to mention the Fee Name as it is mandatory from WooCommerce.

 

[Olamide01]

Yes, I understand that, but i still don't have an idea what the Fee Name is or where to locate it. It is not coming up as one of the options from the drop down from both the google sheets and woocommerce for me to select. Will appreciate if you can help with this

 

[Pabblymember11]

Hey @olaminde

You can name anything in the Fee name in the action step. Further, you can search the Fee name in the tax section of your WooCommerce.

 

[Olamide01]

Thank you so much for your time.
Please i am still having difficulty in correctly sending my ggogle sheets orders with multiple items into Woocommerce. Can you just help with a complete workflow that will make this easier for me. Tried following these steps through: Google sheets (New/Update row) ----Woocommerce (Retrieve Orders) -----Router-----Wocommerce(update order with line items). But still didnt get it. Please help. Been on this for w while

 

[Pabblymember11]

Hey @Olamide01

As we can see from your workflow(Shared - [google sheet > woocommerce]) the webhook response you have captured doesn't contain complete order details.