NetSuite Connector: 5 Mapping Types for SuiteProjects Pro
The NetSuite Connector offers advanced mapping capabilities beyond standard field-to-field mappings. Advanced mappings allow organizations to determine how data is transferred between NetSuite and SuiteProjects Pro, helping to accommodate business needs and reduce manual data entry between systems.
Below are some of the most commonly used mapping types, when to leverage each, and practical examples of how they can be applied.
| Mapping Type | When It’s Used | Example |
| Field-to-Field Mapping | Used to transfer data directly between corresponding fields in the two systems. | Mapping the Project Start Date from NetSuite to SuiteProjects Pro. |
| IF STATEMENT / Conditional Mapping | Used when you want to populate data in a field differently depending on conditions. | Automatically populate a user’s classification based on their user type. For example, if the user is an employee, assign the classification “Employee.” If the user is a vendor, assign the classification “Contractor.” |
| LOOKUP Mapping |
Used when you need to retrieve a value from a related record. | When mapping a project’s Department, a LOOKUP function can be used to identify the Department’s corresponding ID and populate the appropriate value in the destination field. |
| Concatenation | Used when you need to combine two or more pieces of information into one field. | Combining the Project ID and Project Name from NetSuite into one field in SuiteProjects Pro. |
| Hard-Coded Value |
Used when every record should be set to the same, pre-defined value. | Assigning a default project stage for all newly integrated projects from NetSuite to SuiteProjects Pro. |
Advanced mappings are a powerful way to tailor the NetSuite Connector to your organization’s specific business requirements. Understanding when and how to use these capabilities can help maximize your investment in NetSuite and SuiteProjects Pro while improving operational efficiency.
