Does anyone know if there’s a 2-Ways WooCommerce Connector that actually works existed, even the paid one.
I have been tested various ERP systems. And I really love what ERPNext offers both scalability and simplicity of the workflow.
Since I’m currently running a retail business using WooCommerce. That would be best If we have a really good connector that actually work out of the box with WooCommerce.
I am having the same trouble with shopify integration. Not sure who actually is using this in production. I am working on a sidecar nodejs application which does a two way sync with shopify. Can you summarize, what the actual Items are, that you want to have synced and mapped in both directions? What is important to you? I am just thinking of running this nodejs application hourly and map:
Contacts, Addresses, Customers: Shopify → ERPNext
Open Orders not already synced: Shopify → ERPNext
Canceled Shopify Order from already synced orders: Shopify → ERPNext
Shipment and Tracking updated: ERPNext → Shopify
Canceled ERPNext Order: ERPNext → Shopify
Does this also match on woocommerce? But this will definetly take some time as I am still busy with first bullet point
Look’s like the flow is the same. But, I agree that It will take a long time. Because the architect between Shopify and Woo is not the same.
Between, I currently use Quickbooks Online with sync connector from OneSaas, and it is very reliable to sync from my WooCommerce store. But, Will definitely switch back to ERPNext in the future, If there is a production-ready connector is available sometime in the future.
Hey @Muzzy - Thanks for sharing. Does it work with V13? Stable/Recommend for Production use?
Also for new online customers - sales
orders and credit card payments in Woo - are the corresponding new customers, sales orders, sales invoice and payment entries created in Erp? Appreciate a clarification on capabilities. Have been looking for something like this for a while. Thanks again.
I think it will work with V13. Am using V12. Haven’t tested paid Woo invoice as I am yet to get the settings for card payment from local financial institution. It creates Guest customer on Cash on delivery sales and makes sales order against it. Tax is working fine if mapped correctly
There are settings for making sales invoices and original developer has said it makes sales invoice. When Item is synced with Woo it remains in draft mode. You also need to add images on Woo.
Make item on ERPNext. Properly set warehouse and price list before marking items syncing with woo.
Don’t enable items syncing from woo to ERPNext. It will go in loop.
Don’t enable core woo app, it messes up the information.
@Muzzy Hey man thank you for what you have done with this connector. I have tried to tweak my settings. I can sync to the woocommerce site but it keeps creating duplicates of existing product after every sync i.e. an existing product gets recreated on the woocommerce site but kept in draft.
So here are my question…
How do i get the connector to stop creating duplicate product
Do I need to install your fork of the connector before I can get it to work well?
Which URL will i use to install your fork of the connector?
Has your fork of the connector and the changes you made been merged?
Can you please do a guide on installing and configuring your fork of the connector?
Thank you very much for your time, I really appreciate. Looking forward to hearing from you.
All changes have been merged. The git url is in my earlier post. Before you use our version do the following
Disable the core WooCommerce app. Better to remove all settings as well.
Remove the other WooCommerce app which you maybe using.
Delete all products in WooCommerce
Install my version of app but enable it. Just use the settings propely.
Use sync items one way only. ERPNext to WooCommerce, don’t use it other way around. This can send it in loop hence duplicate items on every sync.
Before using the tick on items master to sync to WooCommerce create the WooCommerce warehouse a and Item price if different than the standard selling price. Use Naming Series for items, it is populated in SKU field of WooCommerce.
Tick both WooCommerce settings after you have done all proper settings.
Once sync is done product will always be in Draft. You need to add pictures and other properties on WooCommerce website before publishing it.
I think two way connector need a lot of time and efforts
on the other side I think the default connector on erpnext is good only to get the items on your woocomerce after that I believe the right decision is an integration from woocomerce to the erpnext
Our team develop integration from woocomerce to erpnext with these features include these features:
create sales invoice
create payment entry when user pay
create delivery note when the product shipped
create return invoice and return payment and return delivery note when refund happened
provide links for the document of delivery
log errors for any issue happened and retry with exponential delay
Products stock sync.
Products prices sync.
Support any woocommerce payment gateway, bank payment and COD
Log for every documents creation
if you need more information please contact me on email@example.com
really I was not see this before looks great but I can not find any document talk about the features in clear way if you can provide a feature list I will happy to see
on the other side a lot of features I mentions I can not imagine how it can be done without any woocomerce effort so I will invest some time checking the details
Could you help to confirm? If currently, the Connector is able to Create Sale Invoice and Payment Entry in ERPNext. I have been testing in the last few days in row. But, It only create the Sale Order even though the payment status has been made on WooCommerce side.
Hi. Which fork are you using? We have not yet added the payment gateway. We may be doing next week. However, I think it should make sales invoice and payment entry irrespective of which fork you are using.
Did you check your Woocommerce config? It is different than core WooCommerce settings.