Hi @Muzzy,
I really appreciate your time to respond. So you mean you are able to create Sale Invoice on your side? Actually, I try both from Lasalesi and also from your fork.
I did check all the required options as per my screenshots below:
I have been trying and testing the whole weeks and different ERPNext versions (12 and 13), trying to figure out the code as well (I have some basic PHP knowledge, not Phyton actually ). But, I couldn’t find what was wrong or get it to work.
Maybe If you can see what is wrong with my configuration?
In my use case. There’re still a few things not functional or need improvement.
A.Need to Fix
Product Image are not sync from WooCommerce to ERPNext.
B. Additional Features
Ability to map Deposit Account based on WooCommerce Payment Method.
Map any Shipping Fee directly to an exact account in ERPNext. Not based on Shipping Title (i.e. In my case, I have lot of difference shipping titles based on shipping location or even dynamic shipping title. Then, The order won’t be imported if the title is not match.)
Or maybe other issues that we still may not found yet.
Since my ability is limited, I will try to hire someone who can manage to implement this and will contribute back to the community once everything is done.
As per code the default image is t be set to ERPNext from Woo. It will not set if the image is already present. We dont use it as we have set all images on Woo. We dont need images in ERPNext.
BTW have you ticked this? Sync items from WooCommerce to ERPNext
The image won’t be sent to ERPNext at all on my installation. Also no logs, Just no image was sent at all. And I’m not sure why too.
Here’s my configuration.
In my use case. I need to export products from Woo to ERPNext. I install the app directly from lasalesi’s branch. Since, Currently WooCommerce is my main selling channel.
Right now I’m using QuickBooks Online with Woo and use OneSaas to synchronize the data.
I always want to switch to ERPNext, But because of the lack of connector. I’m still staying with QuickBooks for temporary.
How manage delivery charges as an item which also has VAT. Currently in ERPNext I am getting VAT of item plus full delivery charges without VAT as a sum in VAT. So my delivery charge is actually part of VAT not as income. No tax was charged on delivery charges.
In WooCommerce I have defined it as $1. And set ot as set Tax Status as taxable. Even then ERPNext doesn’t understand. Am sure am making some mistake but can’t find where.
AS far as I understand, shipping charges should not be an item (as it is often done in only-ERPNext configurations), but be part of the “Sales Taxes and Charges” section in ERPNext and Shipping Charges in WooCommerce. Select type “Actual” for both lines in ERPNext.
Hello @Muzzy,
I tried your fork.
I had issue with image sync because the image URL is malformed.
On ERPnext if the images of item is a link to external CDN website url.
Then while making API call to WP, the ERP domain name is appended to the external image link. This result to mal-formed image link.
The ERP hostname is appended to the remote Image url.
eg https://woocommercedomain.com/wp-json/wc/v3/products/12307: {'code': 'woocommerce_product_image_upload_error', 'message': "Error getting remote imagehttps://erpnextdomain.comhttps://remoteimage-res.cloudinary.com/w_auto,f_auto,fl_lossy,dpr_auto,q_auto/media/catalog/product/N/T/158298_1564659190.jpg. Error: cURL error 60: SSL: no alternative certificate subject name matches target host name 'erpnextdomain.comhttps'", 'data': {'status': 400}}
I can see the error location, \woocommerceconnector\sync_products.py one line 786 image_info["images"][0]["src"] = ( "https://" + cstr(frappe.local.site) + img_details[1] ) image_info["images"][0]["position"] = 0 post_request("products/{0}".format(item.woocommerce_product_id), image_info)
I want to ask if you can update the repo because I don’t write python, I do PHP. But I think an if statement to check img_detail variable contains http string then no need to append the "https://" + cstr(frappe.local.site)
I believe the issue is with your software running this plugin. It’s a WordPress plugin, and I understand that it should function correctly, but it seems that even such can sometimes be pretentious. I think it’s worth pointing out that there are better ways to improve your analytics and time management. For instance, you can use and get some excellent business advice. I hope it will be optimistic for your website and that you will not find compatibility issues; I guarantee you!
Does the integration works with V15? We have started to integrate ERPNext right now and was a bit surprised that the original integration was depricated.
). But, I couldn’t find what was wrong or get it to work.
