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:

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.

Related Topics

General Notices