Proposal summary
This proposal describes the details of implementing NetSuite connector to integrate NetSuite with BigCommerce.
Requirement
The client would like to implement the NetSuite connector to do the following sync between NetSuite and BigCommerce.
- Order sync (BigCommerce to NetSuite)
- Fulfillment sync (NetSuite to BigCommerce)
- Product sync (NetSuite to BigCommerce)
- Customer sync(BigCommerce to NetSuite)
- Refund sync (NetSuite to BigCommerce)
Our Solution
We have checked the features of NetSuite connector and current setup in NetSuite and NetSuite connector.
Analysis Report
We will remove partner and support users and create new JJ user for our use and do the following syncs between BigCommerce and NetSuite.
Product sync
We will test the product sync from NetSuite to BigCommerce through following steps:
- We will enable Product sync in NetSuite connector.
- Create test item in NetSuite.
- Sync the test item to BigCommerce
- Check the mapping in Product sync.
Note:
- We will be enabling full product sync. Price field in BigCommerce will be sourced from Base price field in the item record. Along with that, we will enable quantity-based pricing in NetSuite.
- Tax calculations are not considered
Customer sync
We will create test customer in BigCommerce and test the sync by following steps:
- Enable the Customer sync to NetSuite in NetSuite connector.
- Create test customer in BigCommerce
- Run the sync and create test customer in NetSuite.
- Check the mapping in Customer sync.
Order sync
After the successful completion of customer sync, we will create test orders in BigCommerce and test the sync by following steps:
- We will enable order sync in the NetSuite connector.
- Create test orders in BigCommerce for test customers.
- Run the sync and create a test order in NetSuite.
- Check the mapping of order sync.
Notes:
- Pick, pack, and Ship processes will not be considered.
Item fulfillment sync
After the successful completion of order sync, we will create item fulfillment for the order in NetSuite and test the sync by following steps:
- We will enable the fulfillment sync in the NetSuite connector.
- Create test item fulfillment in NetSuite for test orders.
- Run the sync and create an Item fulfillment in BigCommerce.
- Check the mapping of the Fulfillment sync.
Refund sync
Currently, the refund sync is enabled in the NetSuite connector. We will check the sync by following the steps:
- Create a cash refund or credit memo in NetSuite.
- Sync the refund record to BigCommerce
- Check the mapping of the refund sync.
Setup Auto generated number
The allow override feature is not enabled in NetSuite.
So, we cannot override the autogenerated sales order number with the BigCommerce order number in NetSuite. So, we will set the BigCommerce order number in PO# field in the NetSuite sales order. We need to enable the feature in the production.
Assumption
- We will go with the current tax setup in NetSuite and will not update the tax setup.
- Payment methods will be Paypal and credit card in NetSuite.
- The unique sales order number from BigCommerce will be set to NetSuite sales order in the PO# field.
- We will set mandatory fields in the initial setup and update the custom fields in coming developments.
- No need to consider shipping methods.
- The default sales order status will be approved.
- We will not consider the pick/pack and ship feature
- Not using gift certificates
- We will migrate historical data from January 2023 from BigCommerce to NetSuite after the testing.
- We will not set product images in NetSuite and Bigcommerce.
- Multiple currency feature is not enabled in the NetSuite. We will use only the base currency.
- Applicable only to inventory items
Risk
- NetSuite Connector is a standard connector offered by NetSuite and we cannot make any alterations to the script or logic they used. In other words, we cannot make any changes to the NetSuite connector suite app.
- We will create test records in NetSuite and Bigcommerce.