1. Home
  2. Docs
  3. Woo-NetSuite Integration
  4. Order sync & conditional mapping

Order sync & conditional mapping

Order settings:

Orders are synced when created, updated or deleted. Orders can be manually or automatically synced to NetSuite.This settings also gives an additional feature of CONDITIONAL MAPPING similar to customer mapping.

Options in order settings:

  1. Sync Product’s internal ID’s: Note This is only needed when you inventory sync is disabled. This will speed up the order sync process
  2. Enable order sync: This feature syncs the orders automatically when created on wordpress to NetSuite.
  3. NetSuite Auto Sync Order Status: The feature enables the user to automatically sync orders with a particular status of the order such as processing, on hold, complete etc.
  4. Auto sync orders to NetSuite when order status changes to: This feature sync orders when the status of the order is changed, it is a multi select field such as processing to complete, processing to on hold, pending to complete etc.
  5. Order delete on NetSuite on WC delete: If an order is deleted on wordpress it gets automatically removed from NetSuite as well.
  6. Re-Create NS order on restore from trash: If an order is restored back on wordpress then a new order gets created automatically on NetSuite.
  7. Order shipping Line Item internal ID: with the help of this feature we can send an additional product on NetSuite with any order mentioning the internal id of the product in the settings.
  8. Enable coupon sync: coupon can be synced through this feature, it’s just you need to mention NS Promo Custom Form ID or NS Promo Discount ID.
    NOTE: Coupon name and discount type should be the same on WordPress and NetSuite.
  9. Enable order tracking email: This feature triggers email to customers mailing address whenever an order tracking number is generated.
  10. Complete WC order when order fulfilled on NetSuite: When an order status is changed to fulfilled on NetSuite, the order status changes automatically on wordpress to Complete.

Conditional mapping feature:

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.

Operation
  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.
WC field source

This field contains customer and order related fields which are used to map the values to NetSuite. It provides us a predefined list of customers and orders that can be mapped and also the options to insert meta keys to get customer and order related data.

Customer/Order field

Select the WC field from the drop down based on which you want to set a condition for mapping.

Customer/Order meta field

Enter the meta key of the value for which you want to set a condition for mapping.

Where

Here you can select the condition type.

We have 4 types of condition:
  • IS
  • IS NOT
  • CONTAINS
  • DOES NOT CONTAINS
WC field value

Enter the value that you want to check corresponding to the customer/order Field or the customer/order meta field.

Attribute Type

Select an option for the field type you have on NetSuite to which you want to sync the value such as Default NetSuite Field or Custom NetSuite Field.

NS field type

For Custom NetSuite field please select the type of the custom field such as string, boolean, select or any of the types.

NS field

Select the NetSuite field ID from the drop down list or enter the NetSuite field ID if it’s a custom field to which you want to map the fixed value based on WC field value.

NS field value

Enter the fixed value that you want to sync on NetSuite.

2.Map NetSuite field to fixed value
In this operation you can send any fixed value to NetSuite field.

Attribute type

Select an option for the field type you have on NetSuite to which you want to sync the value such as default NetSuite field or Custom NetSuite Field.

NS field type
for custom NetSuite field please select the type of the custom field such as string, boolean, select or any of the types.

NS field

Select the NetSuite field ID from the drop down list or enter the NetSuite field ID if it’s a custom field to which you want to map the fixed value based on WC field value.

NS field value

Enter the fixed value that you want to sync on NetSuite.

3. Map NetSuite Field to WC Field
In this operation you can map any WC field value to NetSuite field. also you can add a prefix to append with WC value.

WC field source

This field contains customer and order related fields which are used to map the values to NetSuite. It provides us a predefined list of customers and orders that can be mapped and also the options to insert meta keys to get customer and order related data.

NS Field

Select the NetSuite Field ID from the drop down list or enter the NetSuite Field ID if it’s a custom field to which you want to map the fixed value based on WC field value.

Prefix to append

Prefix could be added to WC value synced to NetSuite through this field.

Customer field

Select the WC Field whose value you want to sync to NetSuite.

Was this article helpful to you? Yes No

How can we help?