Skip to main content

Connector settings explained

[missing screenshot: confluence_logo_new.png]


All the connector's settings are present at System>NetSuite>Settings


General settings

Setting nameExample valueDescription
Enable integrationYesTurn the entire integration on/off
NetSuite Hosthttps://webservices.na1.netsuite.comDifferent between sandbox and production
NetSuite Endpoint2015_1
NetSuite account idTSTDRV1050922
NetSuite account emailwebuser@rocketweb.com
NetSuite account passwordTEST
NetSuite role id3
NetSuite Base urlhttps://system.na1.netsuite.com/Used to build direct links to NetSuite, different between sandbox and production.
Soap Request timeout1800
Lock file postfixTESTFill in this field if you have multiple NetSuite connectors on the same server


Import connection settings

Setting nameExample valueDescription
Same as default connection?Yes
NetSuite account emailwebuser@rocketweb.com
NetSuite account passwordTEST
NetSuite role id3


Export connection settings

Setting nameExample valueDescription
Same as default connection?Yes
NetSuite account emailwebuser@rocketweb.com
NetSuite account passwordTEST
NetSuite role id3

Stock connection settings

Setting nameExample valueDescription
Same as default connection?Yes
NetSuite account emailwebuser@rocketweb.com
NetSuite account passwordTEST
NetSuite role id3

Enable/Disable Features

Setting nameExample valueDescription
Enable sending orders to NetSuiteYes
Enable sending invoices NetSuiteYes
Enable getting order changes from NetSuiteYes
Enable getting fulfillment data from NetSuiteYes
Enable getting cash sale/invoice data from NetSuiteYes
Enable getting stock updates from NetSuiteYes
Enable getting product data from NetSuiteYes

Enable importing returns from NetSuite

Yes


Enable importing credit memos from NetSuite

Yes


Enable sending customers changes to NetSuiteYes

Product synchronization

Setting nameExample valueDescription
Field mapping
Product field mapping
Price level to grab the price from1The price level to import prices from
New product default visibilityCatalog,search
New product default statusEnabled
New product default tax classTaxable goods
New product default web site idsMain website
New product default store idsMain store
New product default attribute set idDefault
Imported tier price customer groupGeneralThe default customer group to be used for tiers
Imported tier price websiteAll websitesThe default customer group to be used for tiers
Cache lists and custom records for3600 (seconds)
Push line items with fixed price bundles
Note that if this is set to yes, it is possible that stock will be deduced twice for the line items - once for the bundle and once for the separate line items

Related Products Field Name

1,2,3


Upsells Field Name

1,2,3


Stock options

Setting nameExample valueDescription
Location Internal Id2The location stocks will be pulled from/pushed to
Stock stored at location level?Yes
Quantity field namequantityOnHand
Quantity field typeStandard
Standard quantity field namequantityOnHand
Update the stocks every N minutes30
Saved stock search internal id727
Page size for the saved search query500500 is the maximum

Tax rates

Setting nameExample valueDescription
Customer tax class for Netsuite-imported sale taxesRetail CustomerNot used at the moment
Product tax class for Netsuite-imported sale taxesTaxable goodsNot used at the moment
"Not Taxable" code internal NetSuite id-8
Tax item internal NetSuite id1509

Order settings

Setting nameExample valueDescription
Default order statusPending fulfillmentThe status a new order will have when pushed to NetSuite
Location IdLocation id to push to
Custom fields that are to be synched between Magento and NetSuite

Default discount item internal id1461
Status Mapping
Status map between NetSuite and Magento

Return Authorizations

Setting nameExample valueDescription

Refund Reason Field

field_name


Exchange Reason Field

field_name


Shipping methods

Setting nameExample valueDescription
Mapping between Magento and NetSuite shipping methods

If none of the rules above match, use this NetSuite shipping item internal id2
Default tracking number carrier
Used to display the proper carrier tracking link in Magento
Mapping between Magento Tracking number types and NetSuite shipping methods
Used to display the proper carrier tracking link in Magento
Send tracking information when receiving tracking numbers from NetSuiteYesThe information is sent via the standard "Shipping update" Magento email.

Payment methods

Setting nameExample valueDescription
Mapping between Magento and NetSuite payment methods
Maps Magento payment methods to NetSuite payment methods
Mapping between Magento payment methods and NetSuite payment processors
Maps Mageto payment methods to NetSuite payment processors

Queue processing settings

Setting nameExample valueDescription
Export message limit100
Import message limit500
Timeout0In case processing an element fails, the element is added back to the queue. The timeout specifies the number of seconds that needs to pass so the item is considered for re-processing. Useful to make sure a single error does not block the entire queue.
Import items updated in last N minutes1140The import queue will consider only items updated in at most this number of minutes. Any older information is ignored.

Developer


Setting nameExample valueDescription
Enable api logYesIt is not recommended to have the API log enabled in production, it uses a lot of database storage space
Aggregated error log lifetime(days)100For how long to keep the error logs
Developer E-mailfoo@bar.comWarning emails will be sent to this email address. You can add multiple addresses and separate them by comma.
E-mail errors and exceptionsYesE-mail will be sent to the configured developer email above.
Export queue threshold100If the export queue has more elements than defined here, an email is sent to the developer. An ever-growing queue is a sign of processing being stuck. Set to zero to disable.
Clean API call log after (days)30
Import queue threshold100If the import queue has more elements than defined here, an email is sent to the developer. An ever-growing queue is a sign of processing being stuck. Set to zero to disable.