Appending Set Values to Order Numbers in NetSuite Connector

The ability to append a prefix or suffix to order numbers in NetSuite Connector is essential for maintaining order integrity, particularly when syncing from platforms like Shopify that often use prefixes. This process ensures that order numbers are consistent and meet business requirements when imported into NetSuite.

How to Append a Set Value to Order Numbers

This section covers the steps required to append a set value before or after order numbers in the NetSuite Connector.

Step-by-Step Instructions

1. Log into the NetSuite Connector: Visit app.farapp.com and log in.
2. Select Connector and Account: Choose the relevant connector and select the associated account.
3. Access Mappings: Navigate to Mappings > Orders.
4. Add Mapping:
   • Click on the Order tab.
   • Click Add Mapping. The Add NetSuite Mapping popup will appear.
5. Choose NetSuite Field: From the NetSuite Field dropdown, select PO #.
6. Confirm Mapping: Click Add Mapping to add it to your list and then Close the popup.
7. Set Logic Mapping:
   • Locate the newly added row in the mapping list. Set the Mapping Type to Logic from the dropdown.
   • Click the Logic Mapping - Click to View/Edit link for further configuration.
8. Configure Logic Mapping: In the Edit Logic Mapping window, follow these sub-steps:
   • Value Type: Select Set Value.
   • Set Value To: Choose Fixed Value and enter the desired prefix text.
   • Click Append Value to expand additional settings.
   • Optional Suffix Configuration: If a suffix is preferred, reverse the values before clicking Append Value.
     • Set Value Type to Set Value and select Order Header Value followed by Order ID.
9. Save Changes: Click Save Changes once all adjustments are done.
10. Final Save: Ensure to click Save at the bottom of the mappings screen to finalize your changes.

Conclusion

Appending prefixes or suffixes to order numbers in the NetSuite Connector is a straightforward process that enhances order management capabilities across platforms. Properly configuring these mappings can significantly improve order synchronization validity and ensure compliance with business processes.

Key Benefits of Appending Values

• Maintains order number integrity.
• Customizes orders based on source platform requirements.
• Enhances clarity and traceability in order management processes.

Who This Affects

• Administrators: who manage order integrations.
• Developers: implementing or troubleshooting order mappings.
• E-commerce Managers: needing accurate order tracking.

Key Takeaways

• Appending values to order numbers helps integrate platforms like Shopify with NetSuite.
• The procedure involves setting mappings in NetSuite Connector.
• Proper configuration enhances order synchronization accuracy.