Note: The name “SmartConnector” has changed to the “Integration App” as they are built on our Integration Platform as a Service (iPaaS), integrator.io.
Amazon Settlement Report Processing Integration Flows
The Celigo Amazon Integration App helps you import settlement report from Amazon into NetSuite and automatically generate reports that help you analyze most profitable items, Amazon fees, net profit, and so on. The Integration App eliminates the need for manually calculating the settlements and provides an automated way to generate settlement reports, drill down up to an Item level. The Amazon Integration App leverages Celigo proprietary integration technology to import and export data between Amazon and NetSuite.Note: You can only leverage these flows with the premium (previously "enterprise") edition of the Amazon - NetSuite Integration App. As part of this enhancement, the following new flows have been added in the Settlement section of the Integration App:
- Amazon Settlement Report to NetSuite Add
- NetSuite Settlement Transaction to NetSuite Payment Add
- NetSuite Settlement Transaction to NetSuite Refund Add
- NetSuite Settlement Summary Report Update
Support for Token-Based Authentication (TBA)
The Amazon-NetSuite Integration App now supports token-based authentication. Once you have configured your NetSuite Account Credentials using the Basic authentication type, you can go to the Connections option, locate the NetSuite Connection and click the Edit icon. The connection page is displayed. From this page, select the Authentication type value as Token and enter the required information.
New Advanced Settings settings have been added to Order(MFN and FBA) > Customer tab:
Remove phone number if invalid on Amazon order: Lets you define a business rule where invalid phone numbers on Amazon order are automatically removed before the order is added to NetSuite. This prevents any manual intervention to import orders with invalid phone no.s (<7 digits or alphanumeric format).
Trim customer name if invalid on Amazon order: Lets you define a business rule where an invalid first name and last name on Amazon order are automatically trimmed to first 32 characters before the order is added to NetSuite. This prevents order import failures when the buyer enters more than 32 char for first name and/or last name fields in Amazon.
Support for importing shipping discounts
Prior to this release, the order import was not taking any shipping discounts into account on the Amazon order and this resulted in shipping variance. The shipping price was being imported as it is from Amazon to NetSuite without considering shipping discount. With this enhancement, in case there is a shipping discount on the Amazon Order, the net shipping cost on the NetSuite order is imported as Shipping Cost - Shipping Discount.