Create/Update QuickBooks Online Item from NetSuite Item

This integration selects new NetSuite items and imports them to QuickBooks Online. Each task loads data from a specific NetSuite Item to the corresponding QuickBooks Online Item. The integration includes tasks for the following objects:

InventoryItem > Item
NonInventorySaleItem > Item
NonInventoryPurchaseItem > Item
NonInventoryResaleItem > Item
ServiceSaleItem > Item
ServicePurchaseItem > Item
ServiceResaleItem > Item

Notes:

• If items with such name already exist, the existing ones are updated. The integration does not create duplicates.

• It does not import pre-existing NetSuite items to QuickBooks Online.

How to Set Up

1. Select or create connections: NetSuite connection for Source and QuickBooks Online connection for Target.

2. Provide the necessary information for the integration execution on the Mapping Definition tabs of the following tasks:

   • In the InventoryItem > Item task:
     • for the IncomeAccountRefId field, replace the Enter your Income Account name... placeholder with your income account name
     • for the ExpenseAccountRefId field, replace the Enter your Expense Account name... placeholder with your expense account name
     • for the AssetAccountRefId field, replace the Enter your Asset Account name... placeholder with your asset account name
     • for the QtyOnHand field, replace the 123 placeholder with your inventory item quantity
     • for the InvStartDate field, replace the 01/01/2025 placeholder with your inventory item start date
       
   • In the NonInventorySaleItem > Item task:
     • for the IncomeAccountRefId field, replace the Enter your Income Account name... placeholder with your income account name
   • In the NonInventoryPurchaseItem > Item task:
     • for the ExpenseAccountRefId field, replace the Enter your Expense Account name... placeholder with your expense account name
   • In the NonInventoryResaleItem > Item task:
     • for the IncomeAccountRefId field, replace the Enter your Income Account name... placeholder with your income account name
     • for the ExpenseAccountRefId field, replace the Enter your Expense Account name... placeholder with your expense account name.
       
   • In the ServiceSaleItem > Item task:
     • for the IncomeAccountRefId field, replace the Enter your Income Account name... placeholder with your income account name
   • In the ServicePurchaseItem > Item task:
     • for the ExpenseAccountRefId field, replace the Enter your Expense Account name... placeholder with your expense account name
   • In the ServiceResaleItem > Item task:
     • for the IncomeAccountRefId field, replace the Enter your Income Account name... placeholder with your income account name
     • for the ExpenseAccountRefId field, replace the Enter your Expense Account name... placeholder with your expense account name

3. Specify the schedule, on which the integration will run automatically.

Tips

• To create QuickBooks Online items from specific NetSuite items, configure more filters in the task editor.

• If you don't want to migrate data from all the available objects, just disable or delete unnecessary tasks. To do this, point to the task and click Disable or Delete. Consider that some tasks may depend on other tasks (have relation mapping involving objects from other tasks), and thus, you may need to fix their mapping if you disable or delete their "parent" tasks.