WooCommerce Integration is Spotty about freescout HOT 7 CLOSED

The only way to figure it out is to debug on your server. Try https://github.com/freescout-helpdesk/freescout/wiki/Debugging

from freescout.

This is the error in the logs, are you looking for more detail than this?

[WooCommerce] HTTP Status Code: 0 (Store not found at the specified URL) | Requested resource: https://impactsoundworks.com/wp-json/wc/v2/orders

I am 100% sure this is the correct endpoint. I have just used Postman and tested it for myself - it is correct and returning data as expected with a simple GET request.

from freescout.

#4017 (comment)

from freescout.

Unfortunately we can't tell what can be the reason of the problem from here. The only way to do it is for someone to investigate it on your server.

from freescout.

By "your server" do you mean the server hosting Freescout? If so, as I showed in the logs, the only error is that HTTP Status Code 0. But that doesn't make sense as, like I said, every other application that uses my store's API (there are dozens) work perfectly, including Postman running on my computer. Is the WooCommerce module open source? Can I open it up and see if I can debug this myself?

EDIT: I've done this and spent awhile testing. The problem seems to be a cURL timeout... Our WooCommerce store db is quite large as we have many hundreds of thousands of orders. Requesting the orders on-demand like this takes about 40 seconds when going through the WP/Woo application layer. (A direct MySQL query is much much faster.)

I was looking into how Helpscout handles this, and it seems like rather than on-demand grabbing orders when you first open an email, it uses a store server-side plugin possibly in combination with caching data on the Freescout side.

I'm curious if this module is being used by any other stores in the 400k+ order range and how it performs for them.

In the short term perhaps I can adjust the cURL timeout manually.

from freescout.

@freescout-helpdesk I have just rewritten some aspects of the WooCommerce integration.

The retrieval time has gone from 40s to less than 1 second.

I did this by working with Automattic to create a new endpoint via WC plugin that is orders of magnitude faster. I then added an integration via a separate plugin on the Orders page for customers allowing them to submit a ticket easily. See screenshots.

The plugins are not really polished but they do work and makes the functionality equivalent to Helpscout.

Are you interested in taking a look at our work?

from freescout.

You can send the code to [email protected]
We'll take a look.

from freescout.