Default Mappings for Magento 2 Connector
This section lists the default mappings for the Magento 2 connector product sync and order sync.
Magento 2 Default Product Sync Mappings
Storefront Field |
NetSuite Field |
---|---|
backorders |
custitem_fa_mag_backorders |
cost |
cost |
country_of_manufacture |
countryofmanufacture |
custom_design |
custitem_fa_mag_cust_des |
custom_design_from |
custitem_fa_mag_cust_desfr |
custom_design_to |
custitem_fa_mag_cust_desto |
custom_layout_update |
custitem_fa_mag_cust_layou |
description |
storedetaileddescription |
enable_googlecheckout |
custitem_fa_mag_enbl_gglco |
enable_qty_increments |
custitem_fa_mag_enblqtyinc |
gift_message_available |
custitem_fa_mag_gift_msg |
has_options |
custitem_fa_mag_hasoptions |
image |
storeDisplayImage.internalId |
image_label |
storedisplayimagedescripi |
is_decimal_divided |
custitem_fa_mag_is_dec_div |
is_qty_decimal |
custitem_fa_mag_is_qty_dec |
Magento Flag Field |
custitem_fa_magento_flag |
manage_stock |
isdropshipitem |
manufacturer |
manufacturer |
max_sale_qty |
custitem_fa_mag_maxsaleqty |
meta_description |
custitem_fa_mag_meta_desc |
meta_keyword |
searchkeyworks |
meta_title |
custitem_fa_mag_meta_title |
min_qty |
minimumquantity |
min_sale_qty |
minimumquantity |
msrp |
custitem_fa_msrp |
msrp_display_actual_price_type |
custitem_fa_mag_show_price |
msrp_enabled |
custitem_fa_mag_msrp_enbld |
name |
storedisplayname |
news_from_date |
custitem_fa_mag_new_fm_dt |
news_to_date |
custitem_fa_mag_new_to_dt |
notify_stock_qty |
reorderpoint |
options_container |
storeitemtemplate |
page_layout |
custitem_fa_mag_pagelayout |
qty_increments |
custitem_fa_mag_qty_incs |
required_options |
custitem_fa_mag_rqd_opts |
short_description |
salesdescription |
sku |
itemid |
small_image |
storeDisplayImage.internalId |
small_image_label |
SPECIAL CASE |
special_from_date |
custitem_fa_mag_spcl_fm_dt |
special_to_date |
custitem_fa_mag_spcl_to_dt |
status |
isinactive |
tax_class_id |
istaxable |
thumbnail |
storeDisplayImage.internalId |
thumbnail_label |
SPECIAL CASE |
url_key |
urlcomponent |
url_path |
custitem_fa_mag_url_path |
use_config_backorders |
custitem_fa_mag_use_cfg_bo |
use_config_enable_qty_inc |
custitem_fa_mag_cenbqtyinc |
use_config_manage_stock |
custitem_fa_mag_cfgmngstk |
use_config_max_sale_qty |
custitem_fa_mag_cmaxsalqty |
use_config_min_qty |
custitem_fa_mag_cfgminqty |
use_config_min_sale_qty |
custitem_fa_mag_minsaleqty |
use_config_notify_stock_qty |
custitem_fa_mag_ntfystkqty |
use_config_qty_increments |
custitem_fa_mag_cfgqtyincr |
visibility |
isonline |
weight |
weight |
_attribute_set |
custitem_fa_mag_attr_set |
_category |
sitecategorylist |
_product_websites |
custitem_fa_mag_prod_sites |
_store |
custitem_fa_mag_store |
Magento 2 Order Sync Default Mappings
Storefront Field |
NetSuite Field |
---|---|
billtoaddress1 |
addr1 |
billtoaddress2 |
addr2 |
billtocity |
city |
billtocountry |
country |
billtophone |
addrPhone |
billtostate |
state |
billtozip |
zip |
buyerfullname |
addressee |
clientaddressbookid |
internalId |
clientcustid |
internalId |
clientorderid |
internalId |
orderid |
custbody_fa_channel_order |
ordertotal |
custbody_fa_order_total |
shiptoaddress1 |
addr1 |
shiptoaddress2 |
addr2 |
shiptocity |
city |
shiptocountry |
country |
shiptofullname |
addressee |
shiptophone |
addrPhone |
shiptostate |
state |
shiptozip |
zip |
status |
orderStatus |
taxtotal |
taxtotal |