Best Practice for Product Sync
Product sync applies to both Full Product Sync and Price and Quantity sync.
Flag Field
NetSuite Connector doesn't sync all items to the storefront using Product Sync. It uses a flag field on each item to let you choose which ones to sync to the storefront. This also gives you control over which items sync to each connector or account. This means you can have different sets of items for different connectors or accounts, giving you more flexibility
SKU Values
Storefronts use an SKU value to identify items. NetSuite Connector uses the SKU value to match items in NetSuite, so it can determine the source and target items during product sync. You designate a field on the NetSuite item record to hold the SKU value in the Product Mappings. When NetSuite Connector retrieves an item from NetSuite, it uses the value in the mapped SKU field to find a matching item in the storefront. This means the SKU values must match exactly, one-to-one, between the storefront and NetSuite.
Consider the following:
-
It's best to use the Item Name/Number field as the SKU field.
-
NetSuite Connector requires unique SKUs for all storefronts, even if the storefront allows duplicates.
-
NetSuite SKU values must be unique across all item types, including active and inactive items.
-
SKU values are case-sensitive.
-
If you're using Order Sync, use the same SKU field for both Order Sync and Product Sync, or you might sync products that aren't being sold in orders.
Mapping Logic
Handle complex logic for determining field values in NetSuite using a formula field, script, or automation. NetSuite Connector works best with simple mappings. NetSuite Connector either syncs data directly from NetSuite to the storefront or uses a simple translation to create output for the storefront field. Creating complex mapping logic in NetSuite Connector makes it harder to troubleshoot, and you might need support to edit or view your mappings. Keeping complex logic in NetSuite gives you full control and visibility. If an unexpected value appears in a storefront field, it's easier to figure out where it came from if you keep complex logic in NetSuite.