NetSuite Changelog
Inventory ManagementIntegrationHow-ToeCommerce

Setting SKU Field for Product Sync in NetSuite

Set the SKU field for product sync in NetSuite to ensure accurate order matching and maintain data integrity.

·2 min read·View Oracle Docs

The SKU field is crucial for ensuring that products sync correctly between your eCommerce platform and NetSuite. Proper configuration helps maintain data integrity and accurate order matching.

How to Set the SKU Field for Product Sync

Follow these steps to configure the SKU field for product synchronizations:

  1. Log In: Access the FarApp connector at app.farapp.com.
  2. Select Connector: Choose the appropriate connector and select the relevant account.
  3. Navigate to Mappings: Go to Mappings > Products. On the Product Mappings page, find the row with sku in the Shopify Field column, which denotes the SKU field. The corresponding value in the NetSuite Field ID column reflects the NetSuite SKU field used for product syncing.
  4. Add Mapping: Click Add Mapping. This will create a new row at the bottom of the Product Mappings screen.
  5. Enter Field ID: In the NetSuite Field ID of the new row, specify the field ID used for linking items on orders to corresponding items in NetSuite. Note: By default, the NetSuite Connector utilizes the Item Name/Number field for SKU values, which has a field ID of itemId.
  6. Save Changes: Click Save to implement the changes.

Important: Once the synchronization goes live, avoid altering the SKU field value to prevent data mismatches.

By following these steps, you can effectively set the SKU field for product sync, ensuring that the inventory remains consistent and order fulfillment processes are seamless.

Frequently Asked Questions (4)

Do I need to create a new mapping for the SKU field every time I set up a new eCommerce connector?
Yes, you must add a new mapping for the SKU field in the Product Mappings each time you configure a new eCommerce connector. This ensures that the SKU is properly synced between your platform and NetSuite.
What is the default NetSuite Field ID used for SKU synchronization?
The default NetSuite Field ID for SKU synchronization is the 'Item Name/Number' field, which has a field ID of 'itemId'.
Can I change the SKU field value after synchronization is live?
No, you should avoid changing the SKU field value once the synchronization is live to prevent data mismatches and ensure consistent data integrity.
Where do I find the row with the SKU field on the Product Mappings page?
On the Product Mappings page, locate the row with 'sku' listed in the 'Shopify Field' column to identify the NetSuite SKU field used for product syncing.
Source: Setting the SKU Field for Product Sync — Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in Inventory Management

View all Inventory Management articles →