Articles in this section

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

Naga Sri Hari Gonaboyina
Updated

Contents

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.

Export field (WooCommerce)

Import field (NetSuite)

payment_method_title

paymentmethod.internalid

shipping_lines[*].method_id

Ship Via (InternalId)
  1. Configure the following hard-coded mappings according to your business requirement in Import NetSuite sales orders, before you run the flow.

Export field (WooCommerce)

Import field (NetSuite)

"WooCommerce"

Labs Order Channel (Name)

"Partner Discount"

Discount (Name)

-1"

 Items: Price Level (InternalId)

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.

Export field (NetSuite)

Import field (WooCommerce)

"processing"

status

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.

Export field (NetSuite)

Import field (WooCommerce)

"false"

api_refund

 

Was this article helpful?
0 out of 0 found this helpful

Comments

1 comment
Date Votes
  • Avatar
    Megan Callaghan
    Engaged
    Awesome Follow-up

    Note to users that are using this template -- I worked with support and there are custom NetSuite fields that are in the Template provided by Celigo and are not in the bundle thus you will have to create them yourself.

    If you do not then when you test your flow, it will error.

    Examples are: custentitywoocommerce_customer_id and custentitywoocommerce_order_id.

    I am not sure that this is expected behavior with templates but it threw me off - I thought I had somehow installed an incorrect bundle. Happy flowing!

    0

Please sign in to leave a comment.