Feasibility of Amazon Integration using different methods

Requirement

The Client requires to integrate the Orders which are ‘Fulfillment By Amazon’(FBA) to Netsuite. Also, they want to record the Fees from Amazon (such as Storage Fee, Advertisement Fee, etc) as a Journal in NetSuite.

Introduction 

The Integration of Orders and Fees with Netsuite from Amazon can be achieved by following methods:

  • Amazon – NetSuite integration app built by Celigo Connector
  • Amazon SP-API to Netsuite using Coding
  • Using Oracle in-built Netsuite Connector

Amazon – NetSuite integration app By Celigo Connector

Order Sync

Using the Amazon – Netsuite Integration App, the orders and customer data related to each order  can be Synced from Amazon to Netsuite. For integrating this, first a flow will be created  and running for exporting the customer data from Amazon to Netsuite as shown below.

The integration can be achieved as a real time one or a scheduled one. In other words, we can schedule the order creation in Netsuite for every order created in the last 30 minutes or so.

It is also possible to export the fulfillment data from Netsuite to Amazon with the same app.

Two flows will be created :

  • Amazon (FBA) Customer to NetSuite Customer 
  • Amazon (FBA) order to NetSuite Sales order

Amazon (FBA) Customer to NetSuite Customer 

Amazon (FBA) order to NetSuite Sales order

After that another flow will be created for each FBA orders to send the data from Amazon to Netsuite

Dashboard 

The figure below shows the dashboard of the Amazon – Netsuite Integrator.  Here we can see the active flows, their statuses and errors if any. It will also show the duration to run the flow and actions done related to one flow. It is better as we can see the errors in the dashboard view itself and correct it timely.

Notifications

We can see one notifications tab in the dashboard where we can define how the user to be notified when an error occurs

Audit Log

The Audit tab will display all changes made in the app including the fields connected and its new value as well as the old value.

Settlement Report Sync

All fees such as the Storage Fee, Advertisement Fee will be available as a settlement report in Amazon and which will be entered as a Journal Entry in the Netsuite.

Settlement report Sync can be done in two ways:

  • Subscribe to the Premium Edition of Amazon- Netsuite Integrator and connection will be made by our in house team
  • Do a customisation for settlement report to be synced from Amazon to Netsuite in the standard Edition by our in house team

Direct Amazon SP-API to Netsuite (NetSuite Customisation)

Order Sync

The Order Integration from Amazon to Netsuite can be achieved by Deploying a script to Netsuite which will be developed by by our in house team

Every order created in the Amazon will be integrated with a sales order in the Netsuite. The script will be running every 30 minutes or so.

Create Custom records 

  • To store the Amazon API Details.
  • To handle the error notification for all Amazon orders integration to Netsuite

 Amazon synchronization tab will be created in the Sales order and item fulfillment  all custom record details will be accessible from the sales order and item fulfillment record. The Amazon API response details will be saved in the custom record for viewing the order details in the Netsuite itself which will be helpful in sorting out the errors if any.

Create a Customer record

  • Customer billing and shipping address in the order will be using to create or update customer record
  • Customer Email address will be used as a unique key to identify the customer record in Netsuite
  • Any updates in the customer data while creating an order in Amazon will be reflected in the customer record.

Create a sales order

A sales order should be created for every order retrieved from Amazon Third Party Logistics or by Amazon  with shipped status every hour by adding a date filter to obtain the most recently placed order.  If the sales order already  exists in the Netsuite, we will not be updating any details in the order.

  • Every orders will be created with ‘Pending fulfilment ‘ Status 
  • Document Number will be the Order ID in the Amazon order ID.
  • Item records will be available in the Netsuite and if any item is not available, we will be throwing an error in the custom record and the sales order will not be created. 
  • Item SKU will be used as a unique identifier to identify the item record in the Netsuite

Email Notification for Order Sync

  • For all orders, the error while creating a sales order or customer record will be updated in the order Sync custom record
  • If any of the item records are not existing record, we will be updating it in the custom record
  • A saved search will be created and scheduled to send email notification to the administrator or any specific roles for any errors created in the custom record

Settlement Report Sync

The report will be generated on a monthly basis. First the script will be requesting a report from Amazon every month and the script will be scheduled to run accordingly. After getting confirmation from Amazon as the report processing has been completed, we will be retrieving the data from the Amazon API and will be creating a Journal Entry in Netsuite.

 Request a report

Request a report by specifying the report type and marketplaces that you are requesting, along with the start date and end date

Confirm that report processing has completed

After the createReport operation step, Amazon receives the request and begins processing the report. We will be  passing the reportId value from the previous step, until the processingStatus value in the response indicates that processing has ended. Here are the processingStatus values that confirm that processing has ended can be

  • CANCELLED – The report was cancelled. 
  • DONE – The report has completed processing 
  • FATAL – The report was aborted due to a fatal error 
  • IN_PROGRESS – The report is being processed.
  • IN_QUEUE – The report has not yet started processing.

Note: The report fetching operation only serves information for on-demand or scheduled report requests that were created within the last 90 days.

We can schedule requests for reports so that they are submitted periodically and fetch the report and generate journal entries in the Netsuite.

Using Oracle in-built Netsuite Connector – FarApp

NetSuite Connector allows you to automate the transfer of order data between Amazon and Netsuite. 

The below diagram shows the dashboard view of a Netsuite Connector

Order Sync

First we have to do the mapping from Amazon to Netsuite using the FarApp Connector as shown in the diagram below

For retrieve an order, click on the ‘retrieve; button in the Dashboard and enter the amazon order number to retrieve it to the FarApp Dashboard

After retrieving the order, click on the edit button to view the order details including items, billing data and shipping details.

After selecting the ‘Post to Netsuite’ option, we can sync the order to Netsuite. This is how we are doing it manually through the UI. This Sync can be automated after connecting the Amazon and Netsuite through FarApp

Settlement Sync

Automating repetitive tasks allows for more timely, accurate reporting and greater control of financial assets. By using the FarApp, we can sync the settlement reports to Netsuite.  There are different tiers of price options available for FarApp Connectors and we are not sure whether these features are enabled only on the higher price-tier of FarApp.

Leave a comment

Your email address will not be published. Required fields are marked *