Amazon Seller Central Product Sync...

TL;DR Opening

Amazon Seller Central product sync mappings facilitate the integration of product data between Amazon and NetSuite by aligning specific storefront fields to their corresponding NetSuite fields. This mapping is essential for ensuring that product information is accurately maintained across both platforms, leading to a more efficient management process.

Overview of Default Mappings

NetSuite provides a series of default field mappings that correspond to key product attributes in Amazon Seller Central. Understanding these mappings is crucial for developers and administrators who are integrating product data between Amazon and NetSuite.

Default Field Mappings

The following table outlines the default mappings between Amazon Seller Central fields and their corresponding NetSuite fields:

Storefront Field	NetSuite Field
asin	custitem_fa_amz_asin
brand	manufacturer
bullet-point#	custitem_fa_amz_bullet_#
colormap	custitem_fa_amz_color_map
condition-note	custitem_fa_amz_cond_note
condition-type	custitem_fa_amz_cond_type
currency	custitem_fa_currency
Department	custitem_fa_amz_dept
description	storeDetailedDescription
fulfillment-center-id	custitem_fa_amz_fba
is-discontinued-by-manufacturer	custitem_fa_amz_discontinu
is-gift-message-available	custitem_fa_amz_gift_msg
is-giftwrap-available	custitem_fa_amz_gift_wrap
item-package-quantity	custitem_fa_amz_pkg_qty
item-type	custitem_fa_amz_item_type
leadtime-to-ship	custitem_fa_amz_leadtime
main-image-url	storeDisplayImage.internalId
manufacturer	manufacturer
mfr-part-number	mpn
model	custitem_fa_amz_model_name
other-image-url#	custitem_fa_oth_img_url#
other-item-attributes#	custitem_fa_amz_other_#
product-tax-code	A_GEN_TAX (taxable)
ProductCategory	custitem_fa_amz_category
product_type	custitem_fa_amz_prod_type
restock-date	custitem_fa_amz_restock_dt
sale-end-date	custitem_fa_amz_sale_end
sale-start-date	custitem_fa_amz_sale_start
search-terms#	searchkeywords
sku	itemId
standard-product-id	custitem_fa_amz_asin
subject-content#	custitem_fa_amz_subject_#
target-audience#	custitem_fa_amz_targaud_#
title	storeDisplayName
update-delete	custitem_fa_amz_flag
used-for#	custitem_fa_amz_used_for_#
weight	weight

Importance of Mappings

Accurate field mappings are critical for maintaining product data integrity across different sales channels. Proper synchronization minimizes discrepancies and streamlines the fulfillment process, making it easier for businesses to manage inventory and orders effectively.

Who This Affects

Administrators: Manage integration settings and field mapping configurations.
Developers: Implement and customize integration solutions between Amazon and NetSuite.
eCommerce Managers: Ensure product data is accurate and up-to-date across platforms.

Key Takeaways

The default field mappings provide a clear structure for syncing product data between Amazon Seller Central and NetSuite.
Understanding these mappings is essential for effective data management in eCommerce.
Proper synchronization enhances operational efficiency and reduces the risk of discrepancies.

Source: This article is based on Oracle's official NetSuite documentation.

Frequently Asked Questions (4)

Do I need to configure any settings to use the default Amazon Seller Central product sync mappings in NetSuite?

The default field mappings are pre-configured in NetSuite to align Amazon Seller Central fields with corresponding NetSuite fields. Administrators need to ensure these mappings are enabled within their integrations for them to be functional.

What specific NetSuite field is mapped to the Amazon ASIN field?

The Amazon ASIN field is mapped to the NetSuite field 'custitem_fa_amz_asin' within the default sync mappings.

How are multiple image URLs managed between Amazon Seller Central and NetSuite?

In the default field mappings, Amazon 'main-image-url' is mapped to 'storeDisplayImage.internalId', while 'other-image-url#' fields have corresponding custom field mappings like 'custitem_fa_oth_img_url#'.

Are these default mappings applicable to customised NetSuite implementations?

Default mappings provide a baseline structure for data synchronization. However, customized NetSuite implementations may require additional configuration or customization of mapping fields to meet specific business needs.

Amazon Seller Central Product Sync Mappings in NetSuite