BigCommerce Default Product Sync Mappings for NetSuite

Streamline product synchronization with default mappings between BigCommerce fields and NetSuite's item records.

·2 min read·View Oracle Docs

BigCommerce integration with NetSuite simplifies product synchronization, ensuring that key product information from your storefront is accurately reflected in your NetSuite account. The default field mappings help ensure that data flows seamlessly between the two systems, enhancing operational efficiency.

How Does the Sync Work?

The mapping between BigCommerce fields and NetSuite fields ensures that product data, such as availability, pricing, and descriptions, are synchronized accurately. Below are the default mappings to facilitate this synchronization:

Storefront FieldNetSuite Field
availabilitycustitem_fa_bc_avail
availability_descriptioncustitem_fa_bc_availdesc
brand_idcustitem_fa_bc_brand
categoriesclass
conditioncustitem_fa_bc_condition
cost_pricecustitem_fa_bc_costprice
custom_fieldscustitem_fa_bc_custfld#
depthcustitem_fa_bc_depth
descriptionstoredetaileddescription
fixed_cost_shipping_pricecustitem_fa_bc_fixedshpprc
heightcustitem_fa_bc_height
inventory_trackingcustitem_fa_bc_invtrack
inventory_warning_levelcustitem_fa_bc_invwarnlvl
is_condition_showncustitem_fa_bc_condshown
is_featuredcustitem_fa_bc_featured
is_free_shippingcustitem_fa_bc_freeship
is_price_hiddencustitem_fa_bc_prchidden
is_visibleisonline
meta_descriptioncustitem_fa_bc_metadesc
meta_keywordscustitem_fa_bc_metakwds
namestoredisplayname
other-image-url#custitem_fa_oth_img_url#
page_titlecustitem_fa_bc_pagetitle
preorder_release_datecustitem_fa_bc_pordrldt
price_hidden_labelcustitem_fa_bc_prchdlbl
related_productscustitem_fa_bc_rltdprods
retail_pricecustitem_fa_bc_retailprice
sale_pricecustitem_fa_bc_saleprice
search_keywordssearchkeywords
skuitemid
sort_ordercustitem_fa_bc_sortorder
tax_class_idcustitem_fa_bc_taxclsid
typecustitem_fa_bc_prodtype
upcupccode
warrantycustitem_fa_bc_warranty
weightweight
widthcustitem_fa_bc_width

By properly mapping these fields, you ensure efficient data linkage and minimize the risk of errors during product synchronization.

Who This Affects

  • Developers: They need to understand the mappings for proper implementation of the integration.
  • Administrators: They will manage the synchronization process and validate data accuracy.
  • eCommerce Managers: They require accurate data to manage inventory and sales metrics effectively.

Key Takeaways:

  • Accurate field mappings between BigCommerce and NetSuite are crucial for seamless integration.
  • Mapping includes vital information such as price, availability, and product descriptions.
  • Proper synchronization helps reduce errors and improve operational efficiency.

Frequently Asked Questions (4)

What are the default mappings for availability between BigCommerce and NetSuite?
The availability field in BigCommerce is mapped to the 'custitem_fa_bc_avail' field in NetSuite.
How can I ensure that the custom fields from BigCommerce sync properly with NetSuite?
Custom fields in BigCommerce are mapped to 'custitem_fa_bc_custfld#' in NetSuite, where # correlates with specific custom fields.
Do I need any special permissions to manage the BigCommerce and NetSuite product sync?
While the article doesn't specify permissions, typically, administrators and developers involved would require access to integration settings and item records.
Can the synchronization settings be customized beyond the default field mappings?
The article lists default field mappings, but it doesn't detail customization options. Contact your NetSuite consultant for custom mapping needs.
Source: BigCommerce 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 →