NetSuite Changelog
CommerceIntegrationeCommerceAPISuiteCommerceNew FeatureRelease Notes

Magento 2 Default Product Sync Mappings in NetSuite

Magento 2 product sync mappings to NetSuite field mappings streamline data integration for efficient inventory management.

·3 min read·View Oracle Docs

Starting with Magento 2 integration, the default product sync mappings align various storefront fields with corresponding NetSuite fields. This synchronization ensures that inventory and product information is consistent across both platforms, enhancing operational efficiency and reducing manual data entry errors.

How Does Product Sync Work?

The synchronization between Magento 2 and NetSuite allows data fields to map effectively to ensure seamless updates and management. Below is a table detailing the default product sync mappings:

Storefront FieldNetSuite Field
backorderscustitem_fa_mag_backorders
costcost
country_of_manufacturecountryofmanufacture
custom_designcustitem_fa_mag_cust_des
custom_design_fromcustitem_fa_mag_cust_desfr
custom_design_tocustitem_fa_mag_cust_desto
custom_layout_updatecustitem_fa_mag_cust_layou
descriptionstoredetaileddescription
enable_googlecheckoutcustitem_fa_mag_enbl_gglco
enable_qty_incrementscustitem_fa_mag_enblqtyinc
gift_message_availablecustitem_fa_mag_gift_msg
has_optionscustitem_fa_mag_hasoptions
imagestoreDisplayImage.internalId
image_labelstoredisplayimagedescripi
is_decimal_dividedcustitem_fa_mag_is_dec_div
is_qty_decimalcustitem_fa_mag_is_qty_dec
manage_stockisdropshipitem
manufacturermanufacturer
max_sale_qtycustitem_fa_mag_maxsaleqty
meta_descriptioncustitem_fa_mag_meta_desc
meta_keywordsearchkeyworks
meta_titlecustitem_fa_mag_meta_title
min_qtyminimumquantity
min_sale_qtyminimumquantity
msrpcustitem_fa_msrp
msrp_display_actual_price_typecustitem_fa_mag_show_price
msrp_enabledcustitem_fa_mag_msrp_enbld
namestoredisplayname
news_from_datecustitem_fa_mag_new_fm_dt
news_to_datecustitem_fa_mag_new_to_dt
notify_stock_qtyreorderpoint
options_containerstoreitemtemplate
page_layoutcustitem_fa_mag_pagelayout
qty_incrementscustitem_fa_mag_qty_incs
required_optionscustitem_fa_mag_rqd_opts
short_descriptionsalesdescription
skuitemid
small_imagestoreDisplayImage.internalId
small_image_label
special_from_datecustitem_fa_mag_spcl_fm_dt
special_to_datecustitem_fa_mag_spcl_to_dt
statusisinactive
tax_class_idistaxable
thumbnailstoreDisplayImage.internalId
thumbnail_label
url_keyurlcomponent
url_pathcustitem_fa_mag_url_path
visibilityisonline
weightweight
_attribute_setcustitem_fa_mag_attr_set
_categorysitecategorylist
_product_websitescustitem_fa_mag_prod_sites
_storecustitem_fa_mag_store

These mappings are essential for creating a coherent sync process between Magento 2 and NetSuite, facilitating smoother operational workflows.

Who This Affects

  • Developers: Those integrating Magento 2 with NetSuite.
  • Administrators: Individuals managing product data and inventory across systems.
  • Inventory Managers: Users who rely on accurate product data for stock management.

Key Takeaways

  • The default product sync mappings streamline data management between Magento 2 and NetSuite.
  • Accurate mapping enhances operational efficiency and reduces errors in data entry and synchronization.
  • Understanding these mappings is crucial for developers and administrators involved in eCommerce integration.

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

Frequently Asked Questions (4)

Do I need to manually configure field mappings for Magento 2 and NetSuite integration?
The default product sync mappings provided align Magento 2 storefront fields with NetSuite fields, eliminating the need for additional manual configuration.
How does the default synchronization affect existing product data between Magento 2 and NetSuite?
The default synchronization ensures that inventory and product information is consistent across both platforms, reducing manual data entry errors and enhancing operational efficiency.
Is it necessary to have custom fields in NetSuite for the Magento 2 synchronization to work?
Yes, certain fields like 'custitem_fa_mag_backorders' and 'custitem_fa_mag_cust_des' appear to be custom, indicating that specific custom fields need to be available in NetSuite for synchronization.
Will the integration process impact stock management workflows in NetSuite?
The integration streamlines data management, thus facilitating smoother workflows for inventory managers, but the exact impact will depend on how these mappings are utilized in stock management processes.
Source: Magento 2 Default Product Sync Mappings — 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 Commerce

View all Commerce articles →