The order sync setting is used to sync the order from WooCommerce to NetSuite. Orders are synced when created, updated or deleted. Orders can be synced manually or automatically. Along with default settings, there is a feature for Conditional Mapping as well. With Conditional Mapping, you can map all NetSuite Order’s default and custom fields. Like SalesRep, Location, Class or any other custom field.

Order Settings

General Settings

• Enable Order Sync: Enable for Order Sync.
• Sync Orders Status (Default: Processing): Select the WooCommerce Order status on which the order will sync to NetSuite.
  • Note ** if left empty, order syncs on Processing status by default.
• Order Delete on NetSuite on WC Delete: If enabled, orders will be deleted from NetSuite when deleted on WooCommerce

• Re-Create NS Order on Restore From Trash: if enabled, orders will be restored/recreated on NetSuite when restored in WooCommerce.

• Order Shipping Line Item Internal ID: Using this feature, you can send the Shipping Cost as an Order Item. You will need to specify the Shipping Item Internal ID from NetSuite.

• Send Order Line Item Location: Using this, you can send the location with order line items. You can select the default item location or set a custom location for the items.

• Enable Coupon Sync: with this option, you can sync coupons WooCommerce to NetSuite. Please make sure to select NS Promo Custom Form ID and NS Promo Discount ID.
• Order Item Price Level Name: If enabled, the price level will be sent with order items. Select the Price Level from the dropdown list.

Refund Settings

• NetSuite to Woo: If enabled, the refunded orders will sync from NetSuite to WooCommerce.
• Woo to NetSuite: If enabled, the refunded orders will sync from Woocommerce to NetSuite.

Fulfilment Sync

• Fulfilment Sync: By enabling this option, you can sync the fulfil order from NetSuite to WooCommere. If you enable this option then further options will be displayed.
• Mark Order as Completed: With this option, fulfil/billed orders will be marked as “Completed” in WooCommerce.
• Send Order Tracking Email to Customer: With the help of this option, an email including the tracking number will be sent to the customer on fulfilment.
• Order Field with Order Meta Key Field:
  • Tracking Number: In the Tracking number field, enter the value (for example – tracking_number) you want to save for the store tracking number.
  • Shipping Courier: In the Shipping Courier field, enter the value (for example – shipping) you want to save for the store shipping courier name
  • Pickup date: In the Pickup date field, enter the value (for example – pickupDate) you want to save for the store pickup date.

The value you enter for the “order meta key” will be stored in the database to save the value of these three fields. These filed values will be sent to the customer when an auto email is sent to them after getting the tracking number from NetSuite.

Conditional mapping feature:

This feature allows you to map NetSuite data like classes, tax code, shipping method, payment method or any other NetSuite field from WC be it a fixed value or a value of a WC field without any help from the support team.

Operation:

This is the first field you will see when you commence mapping the fields to NetSuite. The operation can be any of the following based on your requirements.

1. Map NetSuite Field to Fixed Value Based on WC Field Value :

With this operation, you can set a condition that if a WC Field has a certain value then you can send a fixed value to NetSuite Field. And if you choose this operation the fields further will be visible as follows –

• WC Field Source
  This contains orders related fields that are used to map the values to NetSuite. It provides us with a pre-defined list of orders that can be mapped and also the option to insert a meta key to get order-related data.
• Order Field
  Select the WC field from the drop-down based on which you want to set a condition for mapping.
• Where
  Here you can select the condition type. We offer 4 types of conditions:
  • IS
  • IS NOT
  • CONTAINS
  • DOES NOT CONTAINS
• WC Field Value
  Enter the value that you want to check corresponding to the Order field or Order meta field.
• Attribute Type
  Here you can choose whether the field you are mapping is a Default NetSuite field or Custom NetSuite Field.
• NS Field Type
  Select the type of custom field such as String, Boolean etc.
  Note*- You will only see this field for your custom NetSuite fields and not for the default ones.
• NS Field
  Select the name of the field from the dropdown list if it’s a default field or enters the NetSuite Field name if it’s a custom field.
• NS Field Value
  This needs to be selected record’s internal ID from NetSuite. For example, if you need to set up your subsidiary, navigate to Setup > Company > Departments
  

2. Map NetSuite Field to Fixed Value :

In this operation, you can send any Fixed Value to the desired Netsuite Field. And if you choose this operation the fields further will be visible as follows –

• Attribute Type
  Here you can choose whether the field you are mapping is a Default NetSuite field or Custom NetSuite Field.
• NS Field
  Select the name of the field from the dropdown list if it’s a default field or enters the NetSuite Field name if it’s a custom field.
• NS Field Value
  This needs to be selected record’s internal ID from NetSuite. For example, if you need to setup your subsidiary, navigate to Setup > Company > Departments

3. Map NetSuite Field to WC Field :

In this operation, you can send any Fixed Value to the desired Netsuite Field. And if you choose this operation the fields further will be visible as follows –

• WC Field Source
  This contains orders related fields that are used to map the values to NetSuite. It provides us with a pre-defined list of orders that can be mapped and also the option to insert a meta key to get order-related data.
• Attribute Type
  Here you can choose whether the field you are mapping is a Default NetSuite field or Custom NetSuite Field.
• NS Field
  Select the name of the field from the dropdown list if it’s a default field or enters the NetSuite Field name if it’s a custom field.
• Prefix to append
  Here you can enter any value to want to sync with the respected field. Leave blank if none.
• Order Field
  Select the WC field from the drop-down based on which you want to set a condition for mapping.

Note* – Refer to the screenshots attached in the next articles.