Field name

Description

How would you like to bring sales tax into NetSuite?

You can select either of the following values.

Overwrite taxes with Magento 2 tax amounts: When syncing orders to NetSuite, this value lets you use the Magento 2 tax configuration for calculating taxes.

NetSuite calculate taxes using its own tax engine: When syncing orders to NetSuite, this value lets you use NetSuite's tax configuration for calculating taxes. NetSuite uses its own tax engine.

Add total tax against a single line item on the order: When syncing orders to NetSuite, this value lets you can include all your taxes against a single item in Sales Order. Note: To get the required value in this drop-down, you will have to create a separate non-inventory item for resale in NetSuite. The created item will then appear at Sales Order > Items when the order is synced to NetSuite.

Per-line taxes on transaction enabled in NetSuite

Select this check box if Per-line taxes on transaction is enabled in NetSuite at Setup > Accounting > Taxes > Setup Taxes.

If Per-line taxes on transaction is selected, the total tax is calculated for every item in an order, and an individual tax code and the tax rate are displayed for every line item. Otherwise, the total tax is calculated for the entire sales order.

NetSuite item to track Magento 2 tax amount as a line item

This drop-down box contains a list of NetSuite non-inventory items. You can select a non-inventory item to track all the taxes present in your sales order as a single line item.

Note: You need to create a non-inventory item for resale in NetSuite.

Default tax code when no match is found in NetSuite

Enter the internal ID of the tax code to be assigned to the order or line item.  When the Integration App is unable to identify and apply a valid tax code for an order, the value specified here is used to calculate taxes.  You can either create a new tax code or use an existing one configured in your NetSuite account at Setup > Accounting > Taxes > Tax Codes.

Notes:

•  This is a mandatory field.
• This field does not impact the tax code applied on an order when NetSuite’s native tax engine is able to find and apply a tax code for an order.
• Avoid using -7 as it is the internal id of the “Not Taxable” code in NetSuite.
• The tax rate is always calculated based on the total order cost coming from Magento 2.

Assign the default tax code to all orders

Select this check box if you want to apply the tax code specified in the Default tax code when no match is found in NetSuite field to all Magento 2 orders. 

Notes:

• Even when the NetSuite is able to identify a tax code to be applied for an order, the Integration App will force apply the default tax code to all orders.
• In a case when there is no tax information present in the order, the sales order record in NetSuite is still updated with the default tax code and the tax rate will always be updated as Zero.

Select Tax Inclusive Stores

This multi-select area will contain all your Magento stores. You can select the stores where you have configured the product prices to be inclusive of the tax amount. By default, products in Magento stores are considered to be tax-exclusive.

Field name

Description

Fail record

Select this option if you want to abort the syncing of a sales order if the mapping configured above does not match.

Use empty string as default value

Select this option if you want to use an empty string for the shipping method.

Use NULL as default value

Select this option if you want to use a NULL value for the shipping method.

Use custom default value

Select this value if you have shipping methods configured only in NetSuite. The Default lookup value will contain values obtained from shipping methods configured in NetSuite.

Field name

Description

Fail record

Select this option if you want to abort the syncing of a sales order if the payment method mapping configured above does not match.

Use empty string as default value

Select this option if you want to use an empty string for the payment method.

Use NULL as default value

Select this option if you want to use a NULL value for the payment method.

Use custom default value

Select this value if you have payment methods configured only in NetSuite. The Default lookup value will contain values obtained from payment methods configured in NetSuite.

Field name

Description

Bring Magento cart level discounts into NetSuite as

You can select either of the following values.

Promotion: Select this option if you want to bring the cart level discount as a promotion. This discount appears at the body level of the sales order. 

Coupon Code: Select this option if you want to bring the cart level discount as a coupon code. This discount appears at the body level of the sales order.

Discount Item: Select this if you want the sales order discounts to appear at the body level of the sales order.

Note: You should create a corresponding promotion record in Netsuite for the promotion or coupon code that you are using in Magento. In NetSuite, search for the Promotion page and create the required promotion record.

NetSuite discount item to track Magento cart discounts

This drop-down list contains a list of NetSuite discount items. You can use an item from the list to track cart level discounts. After the order is synced to NetSuite, the discount appears at the body level of the sales order.

Bring Magento line-level discounts into NetSuite as

You can select either of the following values.

Adjustments to item list price: The discounts are adjusted against the line item's price.

New line below the original line: A new discount line item is added below the line item based on the discount item that you selected in NetSuite discount item to track.

This field works in coordination with the NetSuite discount item to track Magento line discounts field to track line level discounts.

NetSuite discount item to track Magento line discounts

This drop-down list contains a list of NetSuite discount items. You can use an item from the list to track line item discounts.

Field name

Description

Magento Order Id(s)

The Magento order's ID that you want to sync to NetSuite Sales Order. Generally, this field is used only when you want to sync a single order from Magento to NetSuite.

Add Magento orders with status

This field contains a list of possible Magento order statuses. The order sync to NetSuite is triggered when the order status changes to the ones selected. You can select one or more statuses that the Integration App can use to sync Magento orders to NetSuite.

Add Magento orders with custom statuses

You can use a comma separated list to enter one or more Magento custom order statuses. The order sync to NetSuite is triggered when the order status changes to the ones entered here.

Add orders created after

Enter a specific date and time that can be used as a reference to sync Magento orders to NetSuite. All Magento orders created after the specified date and time get synced to NetSuite.

NetSuite item to track Magento shipping cost as a line item

This drop-down box will contain a list of non-inventory items. You can select an item to track the sales order's shipment cost as a line item.

Note: You will have to create a non-inventory item for resale in NetSuite.

NetSuite item to track Magento gift card redemption as a line item

This drop-down box will contain a list of non-inventory items. You can select an item to track the gift card redemption amount as a line item in a sales order.

Note: You will have to create a non-inventory item for resale in NetSuite.

NetSuite item to track Magento store credit redemption as a line item

This drop-down box will contain a list of non-inventory items. You can select an item to track the store credit amount as a line item in a sales order.

Note: You will have to create a non-inventory item for resale in NetSuite.

Add Magento bundle products to NetSuite sales order as

You can select either of the following values.

Parent SKU only: Select this value if you want only the parent product of the bundle product to appear in the NetSuite sales order.

Child SKUs only: Select this value if you want all child products of the bundle product to appear in the NetSuite sales order.

Both parent and child SKUs: Select this value if you want both the parent and child products of a bundle product to appear in the NetSuite sales order.

Bundle products in Magento have dynamic SKU

Select this check box if Dynamic SKU is enabled for a bundle product in Magento at Catalog > Products > [select the desired bundled product].

NetSuite item to track the variance adjustments as a line item

This drop-down box will contain a list of non-inventory items. You can select an item to track the discrepancy (variance) between Magento order and NetSuite sales order. The variance item will be present as a line item in the NetSuite sales order.

Note: You will have to create a non-inventory item for resale in NetSuite.

{{#compare items[*].celigo_line_item_type_id "==" "Celigo_ShippingItem"}} {{subtract items[*].original_price items[*].tax_amount}} {{else}} {{items[*].original_price}}{{/compare}}

Field name

Description

Default NetSuite customer for Magento guest orders

Enter the internal ID of the NetSuite customer record that will act as a default customer for guest checkouts in Magento.

Add all orders against the default NetSuite customer

Select this check box if you want to assign the customer specified in Default NetSuite customer for Magento guest orders for all the Magento orders.

Trim customer name if invalid on Magento order

Select this check box so that Magento customer names that are greater than 32 characters are trimmed to maintain 32 characters. This lets you avoid errors during customer sync.

Remove phone number if invalid on Magento order

Select this check box so that Magento customer's phone numbers that contain alphanumeric characters or if the number of digits is less than seven get discarded.

Multi-Currency customers enabled in NetSuite

Select this check box if your NetSuite account has multiple currencies enabled at Setup > Company > International > Multiple currencies.

Assign the first customer if multiple customers exist with the same email