WooCommerce ERPNext Connector – Entities and Fields being Synced

Entities and Fields being Synced

ERPNext WooCommerce
Item Products
item_group “Products”
item_code _sku Primary Key
item_name post_title
name post_title
description post_content
standard_rate _regular_price
standard_rate _price
Customer Customer (from Billing)
customer_name billing_first_name billing_last_name
customer_group ‘Individual’
customer_type ‘Individual’
territory ‘All Territories’
first_name billing_first_name
last_name billing_last_name
email_id billing_email
phone billing_phone
Contact (for Customer) Contact (from Billing)
first_name billing_first_name
last_name billing_last_name
email_id billing_email
phone billing_phone
Billing Address (for Customer) Billing Address (from Billing)
address_title billing_first_name billing_last_name
address_type ‘Billing’
address_line1 billing_address_1
address_line2 billing_address_2
city billing_city
country billing_country
Sales Order Order
po_no order->ID Primary Key
naming_series “SO-“
transaction_date order->post_date
delivery_date order->post_date
customer billing_first_name billing_last_name
po_date order->post_date
items
item_code _sku OR product->post_title
item_name product->post->post_title
description product->post->post_content
uom Nos
quantity quantity
rate (total/quantity)
amount total
conversion_factor 1