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 |