1 About This Recipe
Use this recipe to synchronize Oracle NetSuite items with products in QuickBooks.
Note:
This recipe is available as Oracle NetSuite — QuickBooks | Sync Items and Products in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.
Overview
This recipe synchronizes inventory and sales service items in Oracle NetSuite with products in QuickBooks, according to a schedule specified in Oracle Integration.
To use the recipe, you must install the recipe package and configure the connections and other resources within the recipe. Subsequently, you can activate and run the integration flow of the recipe manually or specify an execution schedule for it.
- Oracle NS ServiceItem QB Product Sync: When triggered, the integration flow fetches the sales service items from Oracle NetSuite and creates corresponding products in QuickBooks.
- Oracle NSInventoryItem QBProduct Sync: When triggered, the integration flow fetches the inventory items from Oracle NetSuite and creates corresponding products in QuickBooks.
Subsequently, the recipe updates the Oracle NetSuite item record with the QuickBooks product ID in the Quickbook ProductItem Id
field. If the recipe fails to do so, the corresponding QuickBooks product is marked as inactive. Basic data, such as account and unit price are synchronized between the two platforms.
Note:
The recipe creates products in QuickBooks only for Oracle NetSuite item records in which the Quickbook ProductItem Id
field is empty.