WooCommerce Plugin

[Yogan Naidoo]

Hi Community,

Please see our contribution: https://wiki.idempiere.org/en/WooCommerce_to_iDempiere

Any feedback will be welcomed. 

[Norbert Bede]

thanks for your contribution!

norbert bede

cloudempiere.com

[Ole Hoppe]

It looks like this plugin only replicates orders and customers from WooCommerce to iDempiere. Does this plugin also replicate product information, stock levels and prices from iDempiere to WooCommerce? Thanks!

[Yogan Naidoo]

No, only one way from WooCommerce to iDempiere.

[Christian Gealone]

Hello Yogan. I am trying to use your plugin but I encountered an error after running WooCommerce (It did output "**Synchronisation from WooCommerce initiated"):

Exception in thread "Thread-68" java.lang.RuntimeException: Error retrieving results from http request- Status Code: 401
 Response: HttpResponseProxy{HTTP/1.1 401 Unauthorized [Date: Wed, 07 Sep 2022 11:06:11 GMT, Server: Apache, X-Robots-Tag: noindex, Link: <https://192.168.1.4/wp-json/>; rel="https://api.w.org/", X-Content-Type-Options: nosniff, Access-Control-Expose-Headers: X-WP-Total, X-WP-TotalPages, Link, Access-Control-Allow-Headers: Authorization, X-WP-Nonce, Content-Disposition, Content-MD5, Content-Type, Vary: Origin, Keep-Alive: timeout=2, max=100, Connection: Keep-Alive, Transfer-Encoding: chunked, Content-Type: application/json; charset=UTF-8] ResponseEntityProxy{[Content-Type: application/json; charset=UTF-8,Chunked: true]}}
at com.icoderman.woocommerce.DefaultHttpClient.getEntityAndReleaseConnection(DefaultHttpClient.java:127)
at com.icoderman.woocommerce.DefaultHttpClient.get(DefaultHttpClient.java:46)
at com.icoderman.woocommerce.WooCommerceAPI.getAll(WooCommerceAPI.java:46)
at za.co.ntier.processes.WooCommerce$MyRunnable.run(WooCommerce.java:57)
at java.base/java.lang.Thread.run(Thread.java:829)

Here are my Woocommerce defaults:

I have followed the documentation but still couldn't get this to work. Anything or any help from anyone is greatly appreciated.

[Yogan Naidoo]

Hi, Looks like you have a security/authorisation issue with the WooCommerce site.

To verify this, perhaps use a rest api client like Postman and do a basic query to the site.

[Christian Gealone]

Thank you for the quick response. 

I have followed the documentation on Generating Rest API Keys -  WooCommerce REST API - WooCommerce.

I have also checked that my consumer key and secret are valid by retrieving the data that I need via Postman -  https://192.168.1.4/wp-json/wc/v3/orders?consumer_key=XXXX&consumer_secret=XXXX (XXXX are changed with the consumer key and secret) as was instructed in the documentation for checking if consumer key and secret is valid. 

I also retrieved the value of securedUrl from WooCommerceAPI.java, which is http://192.168.1.4/wp-json/wc/v3/orders?per_page=100&oauth_nonce=11cdf5ae-dc70-4999-ae00-d5846f5847ed&offset=0&oauth_signature=d4vqeoCKmnX21m/R8e7ftFD/uwgjilNmuMDclo9SLcE=&meta_value=no&oauth_consumer_key=ck_a65b94228f38173fe30c5e8c44bea1e26692e241&oauth_timestamp=1662555197&oauth_signature_method=HMAC-SHA256&meta_key=syncedToIdempiere&status=completed 

and ran it via Postman which gave me the result:

{

"code": "woocommerce_rest_authentication_error",

"message": "Invalid signature - provided signature does not match.",

"data": {

"status": 401

}

}

[Ken Longnan]

In Wordpress -> Settings, make sure the configuration for "Site Address (URL)" is https://192.168.1.4

Hope it helps.

Thanks & BR,

Ken

[Christian Gealone]

Hi, Ken! 

The link on my Site Address is  http://192.168.1.4.  I am already using another test site (Domain is expired, but been issued a self-signed certificate by fast comet), but encountered another error: 

Error retrieving results from HTTP request - Status Code: 404

Initial research points to my domain being expired. Can you concur? 

Cheers to you,

Christian

[Ken Longnan]

Hi Christian,

I tested with HTTPS (via proxy) and HTTP (direct connection to wordpress), both are worked for me. The key is to make sure "Site Address" is as same as the URL in "WooCommerce Defaults".

Thanks & BR,

Ken

[Christian Gealone]

I tried again with my locally hosted WordPress site   which does not have an SSL and Domain Name: http://192.168.1.4, but still got the same issue: 

Here are my WooCommerce Defaults:

And here is my site URL:

Maybe I'm missing something here (although I followed the documentation, along with my mates with their own VMs).

 Any insight is appreciated.

- Christian

[Ken Longnan]

Have you try HTTPS, maybe works. (For me, I am using HTTP/HTTPS both are working, but according to some google search, you have to use HTTPS)

I have encountered 401 issue like yours, the only change I did is keep URL same for "Site Address" and "Woocommerce Defaults" (avoid to use 'localhost')

You can see below logs from iDempiere backend, after change, Status from 401 NOK to OK by running Woocommerce Job in Plugin

[Christian Gealone]

 I'm now gonna find out how to make my http://192.168.1.4 into http://wordpress/wp (I'm new to WordPress). I'll give an update later

Thank you, Ken!

- Christian

[Christian Gealone]

Hi, Ken! 

I am yet to try your fix for my localhost WordPress site but I already have a successful get request (Status code 200) using my other test site (with HTTPS, self-signed SSL), You are right that I should use what's indicated in the site URL in WordPress as URL in Idempiere.

But I ran again in another pinch. It returns a list that was empty when in fact it should reflect the orders (We created mock orders). We also test it on PostMan and it returns this:

Thanks again!

[Ken Longnan]

please to have a check for the Woocommerce order in Wordpress with following information:

meta_key=syncedToIdempiere

meta_value=no

status=completed

I think you don't have order with above filters. What's why you get empty list return from Woocommerce API.

[Christian Gealone]

Hello, Ken! 

I already pulled some data after trying again. I haven't changed anything in the above filters but waited, and somehow it worked.

Thank you all for the help!

- Christian

[Christian Gealone]

Hello, Community!

May I ask for your insight about these errors?

And here are my WooCommerce Defaults (I based them on the documentation):

I am currently finding solutions to this and I appreciate any suggestions.

Cheers to you all!

[Solutions Ocean.]

You are not setting organization on order

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/20aa01f7-700b-4b57-bbee-ed71b7e6dfcdn%40googlegroups.com.

[Christian Gealone]

Can you elaborate more on your answer, "You are not setting the organization on order" and thank you for your reponse.

UPDATE:

I got the error WarehouseOrgConflict with HQ set on my Organization. I was advised to try using "*"  as it was displayed in my role info.

Role Info:

But when I set the Organization to "*", it then gave me the error WarehouseOrgConflict, so I tried again switching it back to HQ and the error was gone. I ended up with the same configuration, but without the error WarehouseOrgConflict.

[Yogan Naidoo]

Can you do the order manually on iDempiere (payment rule: mixed pos payment rule) and see if you get the same error?

[Christian Gealone]

Hello, Yogan!

I created an order manually with a payment rule: mixed pos payment rule, and I didn't get the same error.

We are currently attempting to do bi-directional syncing of iDempiere and WooCommerce, and are going to update the community on our progress, any insight is appreciated.

Thank you, Yogan, Ken, and the community for the help.

[Christian Gealone]

Hello, Community!

May I confirm, if I create a GET request from WooCommerce and it stores the order in sales order. In the next Get request (by running WooCommerce), will it store the same order in the sales order even when it is duplicated? 

For example, I got two sales orders with id = 234 in the sales order, even when an error about the duplicate order appears in the console.