Effective SKU Management in NetSuite...

SKUs (Stock Keeping Units) are critical for identifying items in storefronts. When syncing products, the NetSuite Connector employs the SKU as a unique identifier to align items in the storefront with their corresponding entries in NetSuite. It is essential that the SKU values match one-to-one between the storefront and NetSuite to ensure smooth operations.

Importance of SKU Configuration

For both product and order sync, the SKU field in NetSuite must be correctly set up. Any discrepancies can result in errors during product updates or order placements. Thus, best practices recommend ensuring that SKU fields are consistent across both product mappings and order mappings.

The default mapping for SKU is to the itemId field, but several other fields can also be utilized, including:

Field Name	Description
`displayName`	User-friendly name for the item
`upcCode`	Universal Product Code for the item
`vendorName`	Name of the vendor supplying the item
`ProductID`	Identifier given by the vendor
`mpn`	Manufacturer Part Number
`externalId`	Custom external identifier
`NsExternalId`	Native external identifier specific to NetSuite
`SKU`	Standard Stock Keeping Unit identifier

These field configurations can be customized as per organizational needs.

Setting the SKU Field

For Order Sync:

To set the SKU field for order synchronization:

Log in to app.farapp.com.
Select the connector and then choose the relevant account.
Navigate to Settings > Orders.
Input the field ID of the field used for matching items.

Note: By default, the Item Name/Number field (field ID itemId) is utilized for SKU value in NetSuite Connector.

For Product Sync:

To configure the SKU field for product synchronization:

Log in to app.farapp.com.
Select the connector and then choose the relevant account.
Go to Mappings > Products.
- The sku in the Shopify Field column denotes the SKU field, while the NetSuite Field ID column reveals the related NetSuite SKU field for product sync.
Click Add Mapping to create a new entry at the bottom of the Product Mappings screen.
Input the field ID for matching items as required.

Verifying SKU Matches

Verifying that the NetSuite SKU aligns with the storefront SKU is crucial. Determine which field is set as the main SKU in the NetSuite Connector for both order sync and product sync. Maintaining the same SKU field across both sync processes is vital to prevent potential errors and delays. By default, Item Name/Number (field ID itemId) is used, but you can opt for different fields as per the requirements of each connector and account, although standardization is advisable for ease of management.

Conclusion

Proper SKU management within the NetSuite Connector not only enhances operational efficiency but is also fundamental in preventing synchronization errors. Ensuring that these configurations and verifications are routinely checked can result in smoother transaction processes and improved data accuracy.

Frequently Asked Questions (4)

Does SKU management in NetSuite Connector apply to both products and orders?

Yes, SKU management is crucial for both product and order synchronization in NetSuite Connector. The SKU field must be set up correctly in both sync processes to avoid errors.

Can I use a field other than `itemId` as the SKU identifier in NetSuite?

Yes, apart from the default `itemId`, you can use other fields like `displayName`, `upcCode`, `vendorName`, `ProductID`, `mpn`, `externalId`, and `NsExternalId` as SKU identifiers according to your needs.

What steps are involved in configuring the SKU field for order synchronization using NetSuite Connector?

To configure the SKU field for order sync, log into [app.farapp.com](https://app.farapp.com), select your connector and account, go to Settings > Orders, and input the field ID for matching items. By default, the `itemId` field is used.

Is it necessary to use the same SKU field for both order and product syncs?

While it is possible to use different fields for order and product syncs, maintaining the same SKU field across both processes is advised to prevent errors and ensure smooth operations.

Effective SKU Management in NetSuite Connector