1. Home
  2. Docs
  3. WooCommerce 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: Note This is only needed when your inventory sync is disabled. This will speed up the order sync process
  2. Enable order sync: By enabling this feature new orders will be automatically from WordPress to NetSuite
  3. NetSuite Auto Sync Order Status: TBy enabling this feature, users will be able to automatically sync with orders status such as on-hold, complete etc.
  4. Auto-sync orders to NetSuite when order status changes: By enabling this feature, it will sync orders when the status of the order is changed, it is a multi-select field such users can select multiple options.
  5. Order delete on NetSuite on WC delete: If you delete an order from WordPress then it will also be deleted automatically from NetSuite
  6. Re-Create NS order on restore from trash: If an order is restored in WordPress then it will be automatically restored in NetSuite.
  7. Order shipping Line Item internal ID: By enabling this feature you can send an additional product in NetSuite with any order mentioning the internal id of the product in the settings.
  8. Enable coupon sync: Coupons 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 an email to customers’ mailing addresses 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:

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.

Articles

Was this article helpful to you? Yes No

How can we help?