Below, you will find a new chapter of our guide to connecting Magento 2 to Oracle NetSuite ERP. Being a part of the ‘Exploring Magento 2 Oracle NetSuite ERP Integration’ series, this article sheds light on the Transactions section of the ERP’s admin as well as describes how to synchronize the corresponding data with your e-commerce website. Scroll down, and you will see how the Transactions section of Oracle NetSuite looks. After exploring the backend, we will teach you how to synchronize the flow of transactions between Magento 2 and Oracle NetSuite ERP.'
Meet NetSuite Integration Add-on for Magento 2. With this add-on you can connect your NetSuite ERP with your Magento 2 via API. The add-on features:
- Product inventory sync
- Category sync
- Order sync
- Pricing adjustment
- Customer data and addresses sync
- Advanced mapping settings
More information can be found at add-on product page.
Table of contents
- 1 Exploring Magento 2 Oracle NetSuite ERP Synchronization: Transactions
- 2 How to Synchronize Magento 2 and Oracle NetSuite ERP
- 3 Improved Import & Export Magento 2 Extension Features
- 3.1 Automated Import & Export
- 3.2 Advanced Mapping Features
- 3.3 Extended Connectivity Options
- 4 Final Words
Exploring Magento 2 Oracle NetSuite ERP Synchronization: Transactions
Hover over the Transactions tab, and you will see a large dropdown with Transactions Overview and multiple transactions divided into groups: Bank, Purchases, Payables, Sales, Billing, Customers, Employees, Inventory, Manufacturing, Quotas/Forecast, Financial, and management.
Let’s explore Transactions Overview first. When on the page, you can switch to one of 4 available layout options (1), personalize the page content (2), or create a custom tab (3).
As for the available tabs, you can view and edit Recent Transactions (1), use custom search (2), or view all transactions divided into groups (3). Note that NetSuite lets you expand or collapse all groups.
Scroll down to see two more tabs on the left (depending on your layout, their position can be changed): Transaction Search (1) and Settings (2). Use the first one to find any transactions as fast as possible. The second tab lets you proceed to the more in-depth configuration of the Transactions tab.
Transaction -> Bank
Let’s explore the Bank section of the Transactions tab. It lets you write checks, make deposits, transfer funds, reconcile a bank statement, reconcile credit card statement, import online banking data, reconcile account statement, confirm transaction matches, manage reconciliation matching rules, as well as pay sales tax. As you can see, some options introduce additional opportunities. For instance, Write Checks lets you proceed to List or Search.
If you click ‘Write Checks,’ the system redirects you to a section where a new check can be added.
The List section contains a grid with all checks. Note that it is possible to apply filters and customize the page view. Besides, you can print the selection of records as well as export them via CSV, Excel, or PDF.
As for the Search page, it is quite complex. You have two main tabs here: Criteria and Results.
The Criteria tab looks as follows:
In Results, you can apply various sorting options as well as manage different columns.
Note that other elements of the Bank section of the Transactions tab are almost identical: you can add new transactions, view the existing ones, or apply advanced search.
Furthermore, the same logic is used in other interface elements of the Transactions tab. Oracle NetSuite divides all transactions into multiple groups letting you find and manage particular records in the most user-friendly way.
If you want to know more about other elements of the NetSuite Transactions tab, feel free to explore them since you are already familiar with the logic behind them. Now, we’d like to draw your attention to how to integrate Magento 2 with Oracle NetSuite and transfer transactions between the two systems.
How to Synchronize Magento 2 and Oracle NetSuite ERP
To synchronize the exchange of transactions between Magento 2 and Oracle NetSuite, use the Improved Import & Export extension with NetSuite Integration add-on installed. While the default tools are useless in this situation, our module lets you leverage APIs connections to establish a data flow between the two platforms.
The NetSuite Integration Add-on can move ALL transactions between the two systems. With our module, you can seamlessly integrate Magento 2 with Oracle NetSuite ERP, transferring data from the following sections of the Transactions tab:
Let’s explore how to do that!
Magento 2 NetSuite API Synchronization: Transactions
To transfer transactions from NetSuite ERP to Magento 2, follow the steps below:
- Go to your Magento 2 admin and create a new import job under System -> Improved Import / Export -> Import Jobs.
- The job includes the following tabs: General Settings, Import Settings, Import Behavior, and Import Source. Configure them as shown below:
- In General Settings, specify a job title and configure a schedule of updates to transfer transactions from Oracle to Magento 2 automatically;
- In Import Settings, enable API transfers: set ‘Use API’ to ‘Yes.’ Choose an entity you want to import from NetSuite to Magento 2. Select a specific type of Transactions that you want to move to your store;
- In Import Behavior, switch to an import behavior option and a validation strategy that suite the Magento 2 Oracle NetSuite ERP integration. Specify separators necessary for the transfer;
- Next, go to Import Source and choose an import file type there. It can be either XML or JSON. As for an import source, you can rely on REST or SOAP. Configure other parameters and validate the data file.
- Apply mapping to match attributes used in NetSuite to the corresponding ones suitable for Magento 2 to enable the import of transactions.
- In General Settings, specify a job title and configure a schedule of updates to transfer transactions from Oracle to Magento 2 automatically;
- Create a similar export job to provide NetSuite with the Magento 2 data.
Don’t forget to create import/export jobs for transactions types necessary for the integration. For further information, contact our support here:
Improved Import & Export Magento 2 Extension Features
To describe the Magento 2 Oracle NetSuite ERP integration in more detail, we’d like to draw your attention to the features of our module that simplify the procedure. With the Improved Import & Export extension, you can completely revamp the default import and export functionality of the platform avoiding many basic inconveniences and enabling possibilities that are not available by default.
The module lets you transfer any information between Oracle NetSuite ERP and Magento 2 including Transactions. Also, note that Improved Import & Export enables you to match different external attributes and their values to ones used internally, supports multiple file formats for other integrations, as well as transfers all entities.
Automated Import & Export
Automated data transfers are a mandatory requirement when you want to synchronize Magento 2 with Oracle NetSuite ERP. With the Improved Import & Export extension, you can quickly achieve this goal due to schedules and event-based triggers.
With schedules, you get the most intuitive and straightforward way of automation which can be applied to transfers of NetSuite Transactions between Magento 2 and Oracle. Being based on cron, schedules allow creating fully independent import and export jobs that connect your e-commerce store to Oracle NetSuite ERP.
The Improved Import & Export Magento 2 module offers several options in this direction. You can create custom intervals, select customizable predefined update schemes, use profiles with no schedules, and apply asynchronous data transfers (launch every scheduled profile manually whenever you want). The following gif image shows how to configure a plan:
Alternatively, it is possible to leverage event-based triggers to transfer Transactions between Magento 2 and Oracle NetSuite automatically. Use the following algorithm to create a bridge between the two platforms:
- Create a trigger;
- Connect it to an event;
- Combine an action with a trigger to launch it automatically.
Thus, transferring Transactions data to Oracle NetSuite ERP and importing the corresponding output back can be based on both specific events or selected time intervals. Follow the link below for further information: How to Run Magento 2 Import or Export After Specific System Event or Process.
Advanced Mapping Features
If data from Oracle NetSuite ERP contains third-party attributes, you can easily map them to ones used in Magento 2 to automate the transfer of Transactions. If you don’t do that, you won’t import any data to Magento 2 due to the inability to work with external attributes.
As for the default Magento tools, data transfers based on them take lots of time and effort since it is necessary to apply changes in a file editor repeating the same actions every time a new update is required. But the Improved Import & Export Magento 2 extension, it radically simplifies the integration of Oracle NetSuite ERP and Magento 2 in general and the synchronization of Transactions in particular with the help of the following features:
Use our module to solve the problem of different attribute standards without headaches and synchronize the transfer of Transactions data between Magento 2 and Oracle NetSuite ERP with mapping presets– predefined mapping schemes that eliminate manual attributes matching most intuitively.
To apply all the necessary changes automatically, it analyzes the input data file transferred from Oracle NetSuite ERP, discovers third-party attributes in all transactions, and matches them to the ones used in Magento. You only need to select a matching scheme suitable for your migration as shown below:
Importing Transactions data from Oracle NetSuite ERP to Magento 2 can also be enabled by mapping external attributes to the corresponding internal ones manually right in the Magento admin! With the Improved Import & Export module, you get a unique matching interface which provides full control over the process. Map external attributes to the corresponding internal ones in a particular grid enabling the transfer of Transactions. This feature lets you forever forget about doing the same things in a data file. Do the following minimum instead:
As for the “Default Value” column, it plays an essential role in attributes matching when you transfer any data from Oracle NetSuite ERP including Transactions. The column is designed for values, which are provided to all items of a corresponding attribute automatically, replacing the old ones.
Export mapping is possible as well when you transfer Transactions from Magento 2 to Oracle NetSuite. If you want to provide Oracle with data modified according to specific requirements, map native Magento 2 designations to them creating entirely suitable output.
Attribute Values Mapping
Attribute values can also be mapped, when you transfer data between Magento 2 and Oracle NetSuite. The Improved Import & Export Magento 2 extension offers a separate interface that provides the ability to simplify the Magento 2 Oracle NetSuite ERP integration and the synchronization of Transactions. With our module, external designations will no longer interrupt the transfer.
It is only necessary to choose an external value from Oracle NetSuite ERP and specify the internal one from Magento 2 as a replacement. Repeat the procedure until all third-party designations are mapped to ones utilized in the new one. Note that the created mapping schemes will be saved and applied for further updates automatically. You can find more details in this article: Attribute Values Mapping.
Attribute Values Editing
In addition to attribute values mapping, you can also streamline attribute values editing while transferring Transactions data between Oracle NetSuite ERP and your Magento 2 store. It is another feature of the Improved Import & Export module that dramatically simplifies the synchronization. To modify attribute values in bulk, use the following rules:
- Add a prefix to multiple attribute values;
- Add a suffix to multiple attribute values;
- Split multiple attribute values;
- Merge multiple attribute values.
Combine them and create conditions to increase the efficiency of the applied changes. For further information, follow this link: How to Modify Attribute Values During Import and Export in Magento 2.
Category mapping is a feature that significantly simplifies the transfers of product data to Magento 2. It lets merchants match external categories to ones used internally. As a result, much fewer difficulties occur while products are transferred from any external systems to the exact place where you want them to appear. The Improved Import & Export module allows mapping external product categories to ones used in your catalog as shown below:
It is even possible to create new categories in the import job. Choose a parent category and specify a new one to enable the extension to link products to it during the import. You can find more information about this feature here: Category Mapping.
Attributes On The Fly
And if an external data file with Transactions lacks attributes, the Improved Import & Export Magento 2 extension provides the ability to create them on the fly via the following general form:
You can find more information about this feature here: Product attributes import.
Extended Connectivity Options
As for the extended connectivity options, they improve all data transfers between your e-commerce website and external systems as well as enable the Magento 2 Oracle NetSuite ERP integration. Improved Import & Export provides the ability to leverage new file formats and two alternative ways of transferring data between the systems. Thus, it makes the transfer of Transactions between Magento 2 and Oracle NetSuite possible. Besides, our extension can move all Magento 2 entities and NetSuite data, while the default Magento are useless when it comes to the synchronization with the ERP.
Multiple File Standards
Our plugin supports data transfer on the basis of CSV, XML, JSON, ODS, and Excel files. Note that they can be compressed! The Improved Import & Export knows how to unpack them automatically while the default tools work with uncompressed CSVs only! As a result, you can eliminate multiple procedures including the necessity to unpack archives and convert data into CSV.
Multiple File Sources
The following file sources can be leveraged to import and export data files between Magento 2 and external systems:
- FTP/SFTP. Transfer data files using a local or remote server.
- Dropbox. Use a Dropbox account to establish a connection between the two systems. Alternatively, you can rely on Box, OneDrive, Google Drive, iCloud, and Amazon Drive.
- URL. A direct URL can be used to import a data file as well.
Alternative Ways of Import & Export
Alternative ways of import and export are not represented in Magento 2. And since you can work with CSV files only, it is not possible to Magento 2 with NetSuite. Consequently, transferring Transactions becomes a quite problematic procedure. Luckily, Improved Import & Export supports direct API connections, and intermediary services enable multiple new possibilities.
To connect Magento 2 to Oracle NetSuite ERP and import/export Transactions data, the Improved Import & Export extension provides the ability to leverage APIs. Our module supports REST, SOAP, and GraphQL. All API connections are fully compatible with the extension’s features, so you can streamline mapping, schedules, and attributes on the fly, entirely automating the integration.
What are the intermediary services our extension works with? Improved Import & Export supports Google Sheets, Office 365 Excel, and Zoho Sheet. Although they cannot be utilized in the Magento 2 Oracle NetSuite ERP integration, you can leverage them for transfers to/from other systems. The following image shows how to use Google Sheets to move data to Magento 2:
Watch the video below to see our extension in action:
Our second exploration of Oracle NetSuite (read the first one here) shows that it is a vast system but not as complicated as you might have thought, visiting it for the first time. Don’t let its powerful features and interfaces delude you: the system is designed with end users in mind so that you can master it without any serious efforts.
Furthermore, it is also possible to integrate Magento 2 with NetSuite transferring all ERP data to Magento 2 and back including Transactions. Follow the link below and contact our support to get more information:'