Robust NetSuite Integrator app: Fields Mapping Page Overview

Robust NetSuite Integrator app: Fields Mapping Page Overview


If you want to (map OR edit) additional fields between your Shopify store and NetSuite account, then this is the place where you should be, as our Fields Mapping page can help you (map OR edit) both standard and custom fields for a transaction (Order) OR an entity (Customer / User).

Transaction Custom Fields Mapping:





Add Custom Field:

If you want to configure a new custom field between your NetSuite account and Shopify store, click on the Add Custom Field button. Post click, you will be seeing this below-displayed pop-up menu.


Marketplace Field OR Shopify Custom Field:

From, this drop-down menu, select a transaction Shopify Marketplace field that you are interested in mapping with a NetSuite Custom field. For example, let's say that you want to map your Shopify order's sources, so from this drop-down menu, select "order_source", and in the Custom field box, enter its respective NetSuite Custom field value. Note: This NetSuite custom field must start with "cust_body___".

Custom Field OR NetSuite Custom Field:

In this field, you must enter a NetSuite Custom field that belongs OR you want to map with a transaction Shopify Marketplace field. Note: This custom field must start with "cust_body___".

Prefix:

In this box, enter a prefix value, that you want to see in the result of a custom field mapping. For example, let's say that "online" is the source of your Shopify orders and in Shopify, you are storing it at this "order_source" Marketplace field value, further, have mapped it with this "cust_body_source_identifier" NetSuite Custom field, so to result, this mapping into "onlineOrder" you must enter this "online" in the empty prefix box, further hit the Submit button.

Suffix:

In this box, enter a suffix value, that you want to see in the result of a custom field mapping. For example, let's say that "PayPal" is the payment source of your Shopify orders and in Shopify, you are storing it at this "order_paymentGateway" Marketplace field value, further have mapped it with this "cust_body_payment_source" NetSuite Custom field, so to result, this mapping into "Payment_MethodPayPal" you must enter this "PayPal" in the empty suffix box, further hit the Submit button.

Add Custom Fields Static:

Click on this button if you want to map a NetSuite Custom field with a static transaction Shopify Marketplace field. Note: This mapping doesn't support Prefix OR Suffix functionality.

Transaction Standard Fields Mapping:


Add Standard Field:

If you want to configure a new standard transaction field between your NetSuite account and Shopify store, click on the Add Standard Field button. Post click, you will be seeing this below-displayed pop-up menu.


Standard Field:

From, this drop-down menu, select a transaction Shopify standard field that you are interested in mapping with a NetSuite Internal ID. For example, let's say that you want to map your Shopify orders with NetSuite purchase orders, so from this standard field drop-down menu, select "po", and leave the marketplace field blank.

Marketplace Field:

In this field, you must enter a NetSuite internal ID corresponding to a transaction standard Shopify Marketplace field value. Note: This field will only hold numeric values.

Note: Please make sure to hit the Submit button after (adding / updating) any changes.

Entity Custom Fields Mapping:



Add Custom Field:

If you want to configure a new entity field between your NetSuite account and Shopify store, click on the Add Custom Field button. Post click, you will be seeing this below-displayed pop-up menu.


Marketplace Field OR Shopify Custom Field:

From, this drop-down menu, select an entity Shopify Marketplace field that you are interested in mapping with a NetSuite Custom field. For example, let's say that you want to map a Shopify customer's first name, so from this drop-down menu, select "Customer fName", and in the Custom field box, enter its respective NetSuite Custom field value. Note: This NetSuite custom field must start with "cust_body___". 

Custom Field OR NetSuite Custom Field:

In this field, you must enter a NetSuite Custom field that belongs OR you want to map with an entity Shopify Marketplace field. Note: This custom field must start with "cust_body___". 

Prefix:

In this box, enter a prefix value, that you want to see in the result of a custom field mapping. For example, let's say that "online" is the source of your Shopify orders and in Shopify, you are storing it at this "order source" Marketplace field value, further, have mapped it with this "cust_body_source_identifier" NetSuite Custom field, so to result, this mapping into "onlineOrder" you must enter this "online" in the empty prefix box, further hit the Submit button.

Suffix:

In this box, enter a suffix value, that you want to see in the result of a custom field mapping. For example, let's say that "PayPal" is the payment source of your Shopify orders and in Shopify, you are storing it at this "order_paymentGateway" Marketplace field value, further have mapped it with this "cust_body_payment_source" NetSuite Custom field, so to result, this mapping into "Payment_MethodPayPal" you must enter this "PayPal" in the empty suffix box, further hit the Submit button.

Add Custom Fields Static:

Click on this button if you want to map a NetSuite Custom field with a static entity Shopify Marketplace field. Note: This mapping doesn't support Prefix OR Suffix functionality.

Entity Standard Fields Mapping:



Add Standard Field:

If you want to configure a new standard entity field between your NetSuite account and Shopify store, click on the Add Standard Field button. Post click, you will be seeing this below-displayed pop-up menu. 


Standard Field:

From, this drop-down menu, select an entity Shopify standard field that you are interested in mapping with a NetSuite Internal ID. For example, let's say that you want to map your Sales rep with their respective NetSuite internal IDs, so from this standard field drop-down menu, select "salesRep", and in the marketplace field box, enter its respective NetSuite Internal ID, further hit the Submit button. 

Marketplace Field:

In this field, you must enter a NetSuite internal ID corresponding to an entity standard Shopify Marketplace field value. Note: This field will only hold numeric values.

Note: Please make sure to hit the Submit button after (adding / updating) any changes.

In case, you have any questions OR suggestions, feel free to reach out to us at help@webbeglobal.com.

    • Related Articles

    • Robust NetSuite Integrator app: Configuration Page Overview

      Our configuration page contains 3 sections: NetSuite Settings App Settings Point of Sale Settings NetSuite Settings The section holds mandatory credentials such as Account ID, Consumer Key, Consumer Secret, Token ID, and Token Secret that our app ...
    • Robust NetSuite Integrator app demonstration, pricing & how to get started

      Demonstration video Take a walkthrough of the two most important features we offer in our Robust NetSuite Integrator app. What's included in this video? How the order and inventory sync works between your NetSuite account and Shopify store using our ...
    • Robust NetSuite Integrator app: Products Linking Page Overview

      Our products linking page contains: One drop-down menu: 1) Filter. Two search fields: 1) Shopify SKU. 2) NetSuite SKU. Sync Items Manually Button, Submit Button, Archive Button, and Export Item CSV button. Drop-down menu: Filter: From, here you can ...
    • Robust NetSuite Integrator app: Order Log Page Overview

      Our order log page contains: One drop-down menu: Order Status. Two search fields: NS ID, Order ID. Order Status: From, here you can filter your orders that are either: Pending, Accepted By NetSuite, Rejected By NetSuite, Error, Archived, Canceled, ...
    • Walkthrough to configure Robust NetSuite Integrator App

      DASHBOARD PAGE Order Sync:  Enable order sync for smooth Order processing (Time taken- Real time). This will import orders automatically from Shopify to NetSuite IMPORTANT: By disabling the order sync button, You can validate orders before sending ...