Configure and run the flows in WooCommerce – NetSuite quickstart integration template

Contents

• Overview: Understanding the WooCommerce - NetSuite quickstart integration template
• Install the WooCommerce - NetSuite quickstart integration template
•  Configure and run the flows in the WooCommerce - NetSuite integration template
  • WooCommerce v2 customers to NetSuite customers
  • WooCommerce v2 products to NetSuite items
  • WooCommerce v2 orders to NetSuite sales orders
  • NetSuite order status to WooCommerce v2 order status
  • NetSuite cash refunds to WooCommerce v2 refunds

Additional record mapping is required to integrate the template’s exports and imports with your WooCommerce and NetSuite apps.

Note that all of your flows are disabled when first installed. After configuring the flows, you may enable them in your Flows dashboard or in Flow Builder with the Off/On toggle button. Then run or schedule each flow.

Run Flow

Understand and configure the integration flows

WooCommerce v2 customers to NetSuite customers

This flow syncs WooCommerce customers as NetSuite customers. When new customers are added/updated in WooCommerce, this integration flow exports customers from WooCommerce to NetSuite.

Flow details

• Export source: WooCommerce 
• Built-in export: Get WooCommerce customers – This export syncs all customers from WooCommerce that have been modified since this flow last ran.
• Import destination: NetSuite
• Built-in import: Import NetSuite customers – This import add/update customers into NetSuite with the configured custom field as the lookup identifier.

Import mapping: Import NetSuite customers

WooCommerce v2 products to NetSuite items

This flow syncs WooCommerce products as NetSuite items. When new products are created in WooCommerce, this integration flow exports products from WooCommerce to NetSuite items.

Flow details

• Export source: WooCommerce 
• Built-in export: Get WooCommerce products – This export syncs all products from WooCommerce that have been modified since this flow last ran.
• Import destination: NetSuite
• Built-in import: Import NetSuite items – This import add/update items into NetSuite with Item name/number as the lookup identifier.

Import mapping: Import NetSuite items

WooCommerce v2 orders to NetSuite sales orders

This flow syncs WooCommerce orders as NetSuite sales orders. When new orders are added/updated in WooCommerce, this integration flow exports orders from WooCommerce to NetSuite sales orders.

Flow details

• Export source: WooCommerce
• Built-in export: Get WooCommerce orders - This export syncs all orders from WooCommerce that have been created since this flow last ran.
• Import destination: NetSuite
• Built-in lookup: Get WooCommerce v2 customer by ID - This lookup syncs a customer from WooCommerce by ID.

Results mapping: Get WooCommerce v2 customer by id

• Built-in import: Import NetSuite customers - This import add/update customers into NetSuite with the configured custom field as the lookup identifier.

Response mapping: Import NetSuite customers

Import mapping: Import NetSuite customers

• Built-in import: Import NetSuite customers (Guest) - This import add/update customers into NetSuite with customer id as the lookup identifier.

Response mapping: Import NetSuite customers(Guest)

Import mapping: Import NetSuite customers(Guest)

• Built-in import: Import NetSuite sales orders -This import add/ignore sales orders into NetSuite with the configured custom field as the lookup identifier.

Import mapping: Import NetSuite sales orders

Before you begin

1. The WooCommerce item SKU must match the NetSuite item name.

Setup instructions

1. Configure the following static mappings according to your business requirement in Import NetSuite sales orders, before you run the flow.

2. Configure the following hard-coded mappings according to your business requirement in Import NetSuite sales orders, before you run the flow.

NetSuite order status to WooCommerce v2 order status

This flow syncs NetSuite order status as WooCommerce order status in real time. When an order status is updated in NetSuite, the integration flow exports order status from NetSuite to WooCommerce (import) order status.

Flow details

• Export source: NetSuite
• Built-in export: Get NetSuite sales orders - This export syncs all sales orders from NetSuite that have satisfied the qualification criteria.
• Import destination: WooCommerce 
• Built-in import: Import WooCommerce v2 orders - This import updates order status into WooCommerce with configured custom field as the lookup identifier.

Import mapping: Import WooCommerce v2 orders

Before you begin

1. The WooCommerce orders must sync with NetSuite sales orders and WooCommerce order ID must store in custbody_labs_order_channel_number” as a custom field value in NetSuite orders.

Setup instructions

1. Configure the following hard-coded mapping according to your business requirement in Import WooCommerce v2 orders, before running the flow.

NetSuite cash refunds to WooCommerce v2 refunds

This flow syncs NetSuite cash refunds as WooCommerce refunds in real time. When a cash refund is raised or completed in the NetSuite, this integration flow exports cash refund from NetSuite to WooCommerce (import) refund.

Flow details

• Export source: NetSuite
• Built-in export: Get NetSuite cash refunds - This export syncs all cash refunds that have satisfied the qualification criteria.
• Import destination: WooCommerce 
• Built-in import: Import WooCommerce v2 refunds - This import adds a refund to WooCommerce.

Import mapping: Import WooCommerce v2 refunds

Before you begin

1. Make sure to configure the flow WooCommerce orders to NetSuite sales orders. WooCommerce orders must sync with NetSuite sales orders and WooCommerce order ID must store in custbody_labs_order_channel_number as a custom field value in NetSuite orders.

Setup instructions

1. Configure the following hard-coded mapping according to your business requirement in Import WooCommerce v2 refunds, before running the flow.