The ERPNext WooCommerce product sync in CAZ WooSync is SKU-based. The ERPNext item_code maps to the WooCommerce product SKU. This unique identifier is the bridge between both systems — every product match, update, and price sync relies on consistent SKUs. Setting up clean SKUs before enabling sync is the single most important preparation step for a successful ERPNext WooCommerce product sync.

ERPNext WooCommerce product sync — Item to Product mapping, Item Template to Variable Product, price list sync, and auto-create from WooCommerce by CodeAtoZ

A standard ERPNext Item maps to a WooCommerce simple product in the ERPNext WooCommerce product sync flow. The sync carries the item name, description, SKU (item_code), price (from the configured Item Price list), and stock quantity. The push trigger is configurable per store: On Save (immediate), Scheduled (via the 15-minute cron), or Manual (via the Queue Dashboard).

The reverse direction — WooCommerce product to ERPNext Item — is controlled by the “Create Items from Woo” setting on the Caz Woo Store record. When enabled, new WooCommerce products automatically create ERPNext Items with the product SKU as the item_code, assigned to the default Item Group configured on the store record. This makes ERPNext WooCommerce product sync work cleanly for merchants who manage their product catalogue in WooCommerce rather than ERPNext.

Variable product handling is the most complex part of ERPNext WooCommerce product sync. In ERPNext, variable products map to Item Templates with Item Variants. Each WooCommerce product variation (e.g. Size: Small / Colour: Red) becomes an ERPNext Item Variant with the matching attribute values. CAZ WooSync handles this mapping automatically — you do not need to manually create variants in ERPNext for products synced from WooCommerce.

• WooCommerce variable product → ERPNext Item Template
• WooCommerce product variation → ERPNext Item Variant (e.g. T-Shirt-S-Red)
• WooCommerce product attributes (Size, Colour) → ERPNext Item Attributes
• Variation SKU → ERPNext Item Variant item_code
• Variation price + stock sync → ERPNext Item Variant price + Bin quantity

Price sync in the ERPNext WooCommerce product sync flow uses ERPNext’s Item Price doctype. Each store record can be configured to use a specific Price List — Standard Selling is the default. When a price changes in ERPNext Item Price, it pushes to WooCommerce as the regular price on the next sync cycle. WooCommerce sale prices map back to ERPNext Item Price records with the discount flag.

The push trigger setting on each Caz Woo Store record controls when ERPNext WooCommerce product sync runs. “On Save” is the most responsive — any ERPNext Item save immediately queues a sync. “Scheduled” batches syncs with the 15-minute cron, reducing API calls for bulk price updates. “Manual” gives full control for bulk operations. Refer to the CAZ WooSync documentation for the full push trigger configuration guide. For ERPNext Item Price configuration, see the ERPNext Item Price documentation. For WooCommerce product REST API details, refer to the WooCommerce REST API reference.

For complex product catalogue setups — custom attributes, product bundles, or integration with other Frappe apps — our WooCommerce development team can extend the ERPNext WooCommerce product sync to meet your specific requirements. We also offer WooCommerce developer hire for ongoing product catalogue management projects.