When synching products from a source system into NetSuite, every item must have a unique identifier which Patchworks can use for record matching. Typically, this identifier is known as the ExternalID.
When synching products to NetSuite, some preparation is required to ensure that this unique identifier has been configured. Before products can be synced to NetSuite:
With this setup in place, the for any required services.
Often, SKUs used on the associated eCommerce site are designated as ExternalIDs but any unique, common reference can be used.
In NetSuite, the item name/number field is an obvious choice to store the ExternalID for an item however, it doesn't matter which NetSuite field is used, provided that the same field is used consistently.
NetSuite must be configured so it knows which item field must be used as the ExternalID for syncing products/items.
This task should be completed by a NetSuite administrator, as part of the onboarding process for Patchworks.
In Patchworks, are used to define which source data field correlates to the ExternalID in NetSuite - for example: