Amazon - NetSuite Integration App release notes (2017 - 2019)

Gogula R Bhavana
  • Updated

Contents

2019

2018

2017

Release notes v1.19.0, November 2019

What’s new

Support to create journal entries

Journal entries help you track the total amount deposited by Amazon for a given settlement summary report. It automates the last step of the reconciliation process. which is posting the amounts in G/L accounts. It reconciles the Amazon deposits against NetSuite transactions and settles the bank accounts at the end of a settlement period.

The “NetSuite Settlement Summary Record to NetSuite Journal Entry” flow, flow fetches the settlement summary record from NetSuite and creates a journal entry record in NetSuite.

For more information, refer to manage your journal entries.

What’s enhanced

New product category

A new product category “Health” is added for the CA domain.

Reducing page size for “NetSuite Settlement Transaction to NetSuite Payment Add" flow 

The "NetSuite Settlement Transaction to NetSuite Payment Add" flow takes 14+ seconds to process one customer payment record. Because of this, the payment flow takes more time to process the payment records for the default customers. To improve the performance of the flow the page size for this flow is reduced from 50 to 15 or below. 

Release notes v1.18.4, September 2019

What’s new

Add-on feature 

  • Note: The feature is now in the beta phase. If you are interested, please contact Celigo Sales.

Add-on is an optional ability that provides you to customize additional feature(s) to the Integration App. It provides you an opportunity to select a specific use-case as per your business needs. Add-ons require a separate subscription license similar to any Integration App subscription.

In this release, the following add-ons are introduced:

  • FBA Inventory Adjustments
  • Transfer Order - InboundShipments

For more information, refer to Add-Ons.

FBA Inventory Adjustments add-on

The FBA Inventory Adjustments add-on ensures that the lost or damaged inventory is automatically accounted for. This add-on manages, maintains, and tracks your available inventory levels in Amazon. It also categorizes sellable vs damaged inventory based on the disposition provided by Amazon. The flow automatically syncs Amazon (FBA) adjustment data to NetSuite.

For more information, refer to FBA Inventory Adjustments.

Transfer Order - InboundShipments add-on

The Transfer Order - InboundShipments add-on manages the Amazon inbound shipments, inbound shipment plans, and item receipts. This add-on sends a shipment of items from NetSuite to the Amazon FBA Warehouse and tracks back the shipment delivery status in NetSuite.

For more information, refer to Transfer Order - InboundShipments.

Item Receipts

After you group and ship the items to Amazon as per the desired plan, the final step is to mark the status of the transfer orders. You can automate your tracking process with the “Amazon Delivered Shipments to NetSuite Item Receipt” flow. This flow syncs back the item receipts to NetSuite as per the scheduled time.

For more information, refer to Item Receipts.

What’s enhanced

New product categories

For the Amazon UK marketplace, the following two new product categories are added:

  • Grocery
  • Large Appliances

New fields added to product categories

For the US marketplace, Amazon has updated its product category templates. You can now map the below fields in the “NetSuite Item to Amazon Product” flow’s product mappings.

Product Category Name

Field Name

Musical Instruments

Number of strings

Tires and Wheels

UTQG Rating

Shoes 
  • AgeRangeDescription 
  • FootwearSizeSystem
  • ShoeSizeAgeGroup
  • ShoeSizeGender 
  • ShoeSizeClass
  • ShoeSizeWidth
  • ShoeSize
  • ShoeSizeToRange
  • ShoeSizeGenderUnisex
  • ShoeSizeWidthUnisex

What’s fixed

When you import two orders with the same line item in the same batch, the “Amazon FBA Order to NetSuite Order” flow will now assign the Inventory Detail correctly. The invoice or cash sale is imported successfully to NetSuite without any error.

Release notes v1.17.6, July 2019 (hotfix release)

What’s enhanced

Manage ignored records in the settlement report

When you try to import the settlement report, the “Amazon Settlement Report to NetSuite Add” flow is enhanced to handle the ignored transaction records in the settlement report. To manage the similar transaction records at distance in the settlement report, you have to sort the total report based on “order-id” and later with “posted-date-time”, and then import to NetSuite. The Integration App handles these transaction records in the backend by adding a suffix to “posted-date-time” and imports the report to NetSuite, so that no transaction records are ignored. 

For more information, refer to how to sort a settlement report.

Example: The table below shows a sample settlement report:

settlement-id

transaction-type

order-id

posted-date-time

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:10 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

After you sort the total settlement report with “order-id” and later with “posted-date-time”, the report looks like:

settlement-id

transaction-type

order-id

posted-date-time

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:10 UTC

The Integration App handles the similar transaction records in the backend by adding a suffix to “posted-date-time” and imports the sorted report to NetSuite as below:

settlement-id

transaction-type

order-id

posted-date-time

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09.001 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09.002 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:09.003 UTC

AMZNS-1042_Test_1

other-transaction

vj4fjBM822

2019-05-02 17:07:10 UTC

Release notes v.1.17.0, May 2019

What’s new

  • In NetSuite, in the settlement transaction report, the gift wrap and the gift wrap tax amounts were specified in the MISC AMOUNT field. These amounts are now specified separately in the newly added GIFTWRAP and GIFTWRAP TAX fields.
  • A new check box, Split GST/VAT from the settlement report amount is introduced in the Settings > Settlement > Advanced Settings > Refund tab.  If you enable this check box, the principal amount below the settlements transaction custom record (in NetSuite - open settlement transaction report - Prices sub-tab) is split to report the item price, item price tax, shipping, shipping tax, gift wrap, and gift warp tax amounts separately. Similarly, a credit memo generated by the “NetSuite Settlement Transaction to NetSuite Refund” flow, reports the above-mentioned tax amounts and the order amount separately. This way you can maintain the GST/VAT amounts in the credit memo similar to the invoice.

    Notes:

    • This check box is applicable for the GST/VAT defined countries.
    • If you already have the settlement transaction report generated in NetSuite and you wish to correct your historical transactions, delete the customer refund and credit memo. Open the already generated settlement report and in the “Transaction Summary” section, uncheck the EXPORTED TO IO check box, and run the “NetSuite Settlement Transaction to NetSuite Refund” flow to generate the report again.
  • The following product categories are added: 

    Domain

    Category

    DE

    Kitchen

    DE

    Lawn and Garden

    DE

    Lightning

    DE

    Home Improvement

    UK

    Home and Garden

    UK

    Lightning

    IT

    Home and Garden

    IT

    Kitchen

    IT

    Lawn and Garden

    IT

    Lightning

    ES

    Home and Garden

    ES

    Kitchen

    ES

    Lawn and Garden

    ES

    Lightning

    FR

    Lawn and Garden

    FR

    Lightning

    FR

    ToysBaby

What’s enhanced

The following are enhanced in the Amazon - Netsuite Integration App:

  • The Discard If Empty check box on the Field Mappings > Settings page is now managed by the Amazon-NetSuite Integration App and is selected by default. When this check box is selected, the product mappings (on the Smart Mappings UI) are discarded if they are empty. This is to ensure that the adapter request size does not exceed the set limit.
    Note: If you manually add any new mapping, by default, the Discard If Empty check box is selected.
  • The Amazon Item Aliases check box is now renamed as Item aliases are configured in NetSuite. The tooltip description for this check box is updated as “Use this check box if you have configured item aliases in NetSuite that links multiple Amazon SKUs with a single SKU in NetSuite”. For more information, refer Item Aliases
  • During the On-Demand order import, the "Amazon Order (MFN/FBA) to NetSuite Order" flow now verifies the marketplace ID. If you try to import an order from another marketplace ID, the flow displays an error message - “Unable to sync order#XXXX. This order belongs to Amazon Marketplace ID: XXX, country code: XX. To sync this order, in the Integration App's "Settings" page, select the Amazon account to which the order belongs.”
  • The following product category templates are updated: 

    Domain

    Category

    DE

    Consumer Electronics

    UK

    Consumer Electronics

    UK

    Small Domestic Appliances (Kitchen)

    UK

    Lawn and Garden

    UK

    Home Improvement

    FR

    Consumer Electronics

    FR

    Home
  • As per Amazon’s recent notice, effective from June 15th, 2019, it is mandatory to have value for the compatible_phone_models field of the WIRELESS_ACCESSORY PT template. The Wireless category in the US domain is enhanced to comply with this change.
    Note: This change does not require you to download the new client libraries.

What’s fixed

  • The error message is not displayed when you try to save the Tax setting without entering the VAT percentage in the GST/VAT rate field in the Settings > General > Tax tab.
  • When you run the "Amazon (MFN) Order to NetSuite Order" flow with shipping added as a separate line item and you try to cancel the same order, the shipping line item does not get canceled. The shipping item is now marked as canceled, along with the other line items of the order.
  • The "Amazon Settlement Report to NetSuite" flow allows you to import an SKU value that has only numerics. The SKU value in the Amazon Settlement Report will now match with the SKU value in the settlement transaction records in NetSuite.

Release notes v1.16.2, April 2019

What's new

  • For Amazon's US domain, we now support new fields that Amazon introduced for Auto Accessory, Auto Parts, Baby, Clothing, Home, and Sports categories.
  • For Amazon's US domain, we now support Gift cards and Video categories.

What's fixed

  • The Automatically assign Lot/Serialized numbers checkbox now retains the checkmark on page refresh.
  • The Automatically assign Lot/Serialized numbers checkbox will stay checked after you refresh the page.
  • The settlement report format issue for Amazon's Japan domain is now resolved.
  • The issue pertaining to duplicate transaction lines in the settlement report is now resolved.

Release notes v1.14.0, January 2019

What's new

When syncing Amazon orders to NetSuite you can,

  • now assign Lot/Serialized numbers automatically in NetSuite using the Automatically assign Lot/Serialized numbers check box.
  • Also, the Select inventory location present in NetSuite drop-down list box lets you select the inventory location for Invoice, Cash Sale, and Sales Order.

These settings are available under Settings > Integration Flows > Order (FBA) > Advanced Settings > General.

1.png

  • You can now select the Exclude Tax if Marketplace Tax Collection applies check box if you do not want to bring the tax details into NetSuite for the states where Amazon collects and remits taxes on your behalf. The check box is available under Settings > General > Tax.
2.png

What's enhanced

The Celigo eTail SmartConnectors role's SuiteScript permission is changed from View to Full. For more information, refer to Celigo eTail SmartConnectors.

Release notes v1.13.1, November 2018

What's new

The NetSuite secondary connection feature for the Amazon-NetSuite Integration App allows you to run flows parallelly. The secondary connection is sort of a separate channel that you can utilize to sync the data being generated from your flows. For more information, refer to NetSuite Secondary Connection.

What's enhanced

  • The Amazon Integration App now supports the following categories for Amazon Australia.
    • Auto Accessory
    • Tires And Wheels
  • Amazon Template has been updated to include the following categories.
    • Sports - Mack Sports
    • Outdoors
    • Home
    • Clothing - Mack Sports
    • Shoes
    • Wireless - Balaji Trading Inc.
    • AutoAccessory

Release notes v1.12.0, October 2018

What's new

  • Refund flows have been enhanced to handle the following scenarios in an order where:
    • Item substitute (Serialized/Lot/Bin) is present as a line item.
    • Shipping Cost is present as a line item.
    • Gift Wrap is a present as a line item.
    • The shipping cost is present as a line item.

Release notes v1.11.0, September 2018

What's new

On the Mapping window, we have certain fields that will be uneditable for the source application, target application, or both. The uneditable fields are denoted with the help of a lock icon.

1.11.png

Release notes v1.10.0, August 2018

What's new

  • Amazon - NetSuite Integration App now supports Amazon AU (premium (previously "enterprise") edition).
  • All the transaction fields related to the Amazon - NetSuite Integration App will now appear under the eTail > Amazon. However, a few fields will also be present under the eTail tab.
  • We have introduced Out-Of-The-Box support for Amazon Prime orders. The IS AMAZON PRIME checkbox (eTail > Amazon) gets selected in NetSuite if the order received is an Amazon Prime order.
    Note: You will have to manually fulfill Amazon Prime orders.
  • Improved Error Handling.

Release notes v1.9.3, July 2018

What's new

  • The Exclude Canceled Items checkbox under Settings > Integration Flows > Settlement > Orders now lets you exclude/ignore the import of a canceled item from Amazon that has 0 as quantity.
  • On the Mapping screen of the Pricing flow, you will now see MinimumSellerAllowedPrice and MaximumSellerAllowedPrice fields available for mapping.
  • While configuring the order flows for the shipping address or billing address, it no longer matters whether the state's name is written in the abbreviated form or expanded the order import will run without generating any errors.

Release notes v1.9.0, July 2018

What's new

New mappings parameter for the Order flow

With this release, the following are the new parameters that have been added to the available field mapping option associated with the Order flow:

  • IsGift

    The IsGift parameter indicates whether an item is a gift. This is to prevent you from contacting the buyer when the recipient of an FBA gift item returns the item.
    1.jpg

  • TaxCollection

    The TaxCollection parameter allows you to define whether Amazon or you are responsible for collecting the tax for an order. The following table shows the elements of the TaxCollection datatype:
    Name Description Values

    Model

    The tax collection model applied to the item.

    Model value: MarketplaceFacilitator - Tax is withheld and remitted to the taxing authority by Amazon on behalf of the seller.

    ResponsibleParty

    The party is responsible for withholding the taxes and remitting them to the taxing authority.

    ResponsibleParty value: Amazon Services, Inc.

Support to switch fulfillment type from FBA to MFN and vice versa

At times you may face a situation where you may want to switch the fulfillment type for an item listed on Amazon from Fulfillment by Amazon (FBA) to Merchant Fulfilled Network (MFN) and vice versa. By updating the following parameters in the Inventory flow > Field Mappings and the Celigo Amazon Inventory Export Search saved search in NetSuite, you can enable this functionality for your Integration App:

  • Parameters required to Switch Fulfillment from AFN to MFN:
    SwitchFulfillmentTo: "MFN"                     
    Fulfillment Center ID: "DEFAULT"
    Lookup: "FulfillmentNetwork"
    Quantity: Numeric Value (that signifies quantity)
  • Parameters required to Switch Fulfillment from MFN to AFN:
    SwitchFulfillmentTo: "AFN"
    Fulfillment Center ID: "AMAZON_NA"
    FulfillmentLatency: Numeric Value (that signifies a time in a number of days)

For more information see, Switch fulfillment type from FBA to MFN and vice versa.

Support for VAT for the Amazon EU domains

Amazon EU domain uses VAT, where the VAT is inclusive in Item and Shipping prices. On the other hand, in NetSuite, taxes are exclusive of item price and are added on the top item price.

This requires changes in

  • Order Import -  to subtract the tax amount
  • Pricing Export - to add tax amount in item price as per VAT
  • Item Export - to add tax amount in item price as per VAT

To handle this issue, the following advanced setting has been introduced in this release:

  • General > Tax > GST/VAT rate
  • Order > Advanced Settings> Orders > Deduct GST/VAT from order total
  • Pricing > Advanced Settings > Add GST/VAT to item price
  • Product > Advanced Settings > Add GST/VAT to item price

For more information, see VAT support for the Amazon EU domains.

Release notes v1.7.11, April 2018

What's new

Support for Virtual Variations (parent/child relationship without using matrix item feature)

To support this feature, the NetSuite Item to Amazon Product Add/Update flow has been enhanced to accommodate creating virtual variation items. This feature allows you to leverage the virtual variation functionality by Celigo to setup the parent-child relationship between the Inventory (Matrix & Non-Matrix), Assembly (Matrix & Non-Matrix), and Kit Items without using the matrix item feature in NetSuite.

As part of this enhancement, you are no longer required to use NetSuite's native Matrix Item functionality to set up a parent-child relationship instead you can use simple items and a custom field to create a virtual parent-child relationship between their SKUs.

For more information see, Setup parent-child relationship without NetSuite's Matrix Item functionality.

Support for uninstalling the Amazon-NetSuite Integration App

The Amazon-NetSuite Integration App is enhanced to allow you to uninstall the Integration App from your integrator.io account. If you uninstall all or the only store associated with your Integration App, the Integration App tile is also removed from your integrator.io account and all associated information with the Integration App is deleted from your integrator.io account. After uninstalling you can reinstall from the marketplace as long as you have a valid subscription

For more information, see How to uninstall the store from the Integration App?

How to apply date in settlement report to update Settlement Deposit Date and Reconciliation Date

We have added a workaround to handle this issue and to update the Settlement Deposit Date and Reconciliation Date as per the date mentioned in the settlement report. For more information on this workaround, see Change Refund 'Date (trandate)' to Settlement transaction Posted date or Settlement deposit date.

New Advanced Settings in Order (MFN and FBA) flow

The following are the two new Advanced Settings added in the order (MFN and FBA) section:

  • NetSuite item to track Amazon Gift Wrap amounts and taxes
    It allows you to select a NetSuite item to track gift wrap amounts/taxes for Amazon orders. Create an item of "Non-Inventory" type in NetSuite and select the same in this drop-down list. When you now run the order flow, the Integration App will create an order line in the Sales order record with this item to display total gift wrap amounts and taxes.
  • NetSuite item to track Amazon Shipping amounts and taxes
    Allows you to select a NetSuite item to track shipping amounts/taxes for Amazon orders. Create an item of "Non-Inventory" type in NetSuite and select the same in this drop-down list. When you now run the order flow, the Integration App will create an order line in the Sales order record with this item to display shipping amounts and taxes.
    20.jpg

Release notes v1.7.8, April 2018

What's new

Support for removing Amazon category

Prior to this release, the Integration App only supported adding new categories to the Product Mappings page in the Product section. 

With this release, the support for removing categories and associated sub-categories have been added as well. When you remove a category and sub-category from the Integration App, the associated category and subcategory record is deleted from NetSuite as well.

1.jpg

What's enhanced

Extended category template support for new categories

More category templates have been added to the list of supported categories for the DE, ES, FR, and IT domain. The list of supported categories and domain are as follows:

Domain

Category
DE Sports
DE Home
ES Sports
ES Home
ES Consumer Electronics
FR Home
IT Sports
IT Home
IT Consumer Electronics

To know more about all the supported categories in each domain, see Product.

Release notes v1.7.4, February 2018

What's new

Ability to overwrite order sales tax in NetSuite with Amazon's tax amounts

A new tab, Tax in the General section, has been added which contains new fields.

2.jpg

These fields enable you to specify your preference for mapping tax totals between NetSuite and Amazon. The primary field, How would you like to bring sales tax into NetSuite, consist of the following option:

  • Overwrite taxes with Amazon tax amounts

  • NetSuite calculates taxes using its own tax engine

  • Add total tax against a single line item on the order

To know more in detail about these settings and the feature, see Handling order taxes in NetSuite.

What's enhanced

Enhanced Amazon category templates to support more images, bullet points, and search terms

Prior to this release, the Amazon category template supported exporting up to 3 images, 2-5 bullet points (depending on the template), and 1 search term from NetSuite to Amazon.

With this release, the Integration App now allows you to export up to 8 images, up to 5 Bullet points can be added for all supported templates, and up to 5 search terms can be added for an item.

Extended category template support for new categories

More category templates have been added to the list of supported categories for the UK, FR, MX, and DE domain. The list of supported categories and domain are as follows:

Domain

Category

UK

Consumer Electronics

UK

Sports

DE

Consumer Electronics

FR

Consumer Electronics

MX

Consumer Electronics


To know more about all the supported categories in each domain, see Product.

Release notes v1.7.0, February 2018

What's new

Support for importing ASIN into NetSuite’s item record

A new flow, Amazon Product ASIN to NetSuite Item Add, with the following advanced settings have been added in the Product section of the Integration App which allows you import ASINs from Amazon against your item catalog in NetSuite:

  • NetSuite field for item ASIN
  • Sync ASIN for item aliases
  • NetSuite field for item alias ASIN
1.jpg

This flow is only available to customers on the standard (previously "premium") and premium (previously "enterprise") edition of the Amazon - NetSuite Integration App.  For more information, see Product > Amazon Product ASIN to NetSuite Item Add.

NetSuite sandbox refreshes no longer corrupts the integration

Prior to this release, the Amazon - NetSuite integration use to break when the NetSuite sandbox was refreshed. This use to happen due to distributed records stored in NetSuite Sandbox by the Integration App that would get removed. The Integration App no longer stores these records in NetSuite now and these distributed records are stored in the integrator.io directly.

Note that any saved searches and custom record entries relevant to the Integration App in the customer's sandbox account do get replaced with the data in NetSuite production so there will be configuration changes required in UI to restore the integration. You are required to update the lookup mappings and advanced settings for NetSuite saved searches with the new records.

Capability to use ASIN in NetSuite global search to find the item

With this enhancement, you can now use ASIN in NetSuite’s global search to find the associated Item record in NetSuite.

Release notes v1.6.8, January 2018

What's new

Support for tracking tax only refunds

Amazon settlement report contains a refund for the tax amount with no principal amount details associated with it. In this case, when the Integration App tries to create a refund in NetSuite, an error is generated as NetSuite always requires a line item against an order for which a refund is being created.

To work around this use case within NetSuite, the Advanced Settings > NetSuite item to track tax only refunds from Amazon field in the Settlement section allows you to import tax only refunds from Amazon into NetSuite. Once you select a default item of your choice in this field, the Integration App identifies the item within NetSuite and creates a credit memo against this item as a line item.

1.jpg

For more information see, How to track tax only refunds from Amazon?

Release notes v1.6.5, December 2017

What's new

Substitute Item for Amazon SKUs corresponding to Serialized/Bin/Lot Item in NetSuite during Refund Import from Amazon to NetSuite

Prior to this release, the Integration App generated the following error every time settlement flows were executed to process Serialized, Bin, or Lot Item. To handle this issue a new field, Substitute Item for Serialized/Bin/Lot Item in NetSuite, has been added in Advanced Settings.

1.jpg

You can use this field to set a single default item from NetSuite that should be used for by settlement refund flow to create refunds in NetSuite for Amazon SKUs that correspond to Serialized/ Bin/  Lot Item in NetSuite. The item mentioned in this field is used, instead of the default item for which order is created, for creating a credit memo with an amount matching the refund amount in Amazon Settlement Report. For more information see Substitute Item for Serialized, Bin, or Lot Item in NetSuite to execute settlement flows.

Release notes v1.6.4, November 2017

What's enhanced

Support for importing Amazon Promotions or Discounts

Prior to this release, the order import was not taking any Amazon Promotions or Discounts into account on the Amazon order and this resulted in the order being imported with variance amount showing in the ETAIL DISCOUNT TOTAL VARIANCE field in NetSuite. With this enhancement, in case there is an Amazon promotion or discount on the Amazon Order, the net discounted amount against an order is imported against a single discount item in the NetSuite sales order. For more information see, Handling discounts in order import (FBA and MFN).

Support for importing NetSuite Matrix Item in Amazon

The NetSuite Item to Amazon Product Add/Update flow has been enhanced to also provide support for exporting NetSuite Matrix Items as Amazon Product and Variations from NetSuite to Amazon. Note that this functionality is only available to customers on the standard (previously "premium") and premium (previously "enterprise") edition of the Amazon - NetSuite Integration App. For more information, see Export NetSuite Matrix Item as Amazon Product and Variations.

Release notes v1.5.5, September 2017

What's new

Test Mode run for Settlement Flows

As part of this release, a new Test Mode feature has been introduced with the integration app that allows you to test and verify if the functionality is set up as per your own requirement. Before you can actually start uploading Settlement Reports downloaded from Amazon with multiple lines of transaction records that in turn creates multiple types of settlement records in NetSuite, it is advisable to test the functionality and the mappings associated with the flows using few orders from a settlement report.

From a settlement report that may contain hundreds of transactions, you can use up to 10 orders id (of type Refund, order, and other transactions) to test this functionality. When you run settlement flows with the specific orders mentioned in the Amazon order Id(s) field in the Amazon-NetSuite Integration App, only the specified orders are processed and the remaining order from the settlement report is ignored.

For more information see, Test Mode run for Settlement Flows.

Multi-Domain support for the Product flow

With this release, the NetSuite Item to Amazon Product Add/Update has been enhanced to support adding the product to the Amazon UK and Amazon CA platform in addition to the US platform that was already supported. The Product Mappings page which allows you to map categories specific mapping will only display categories supported with the configured domain.

When you configure the Integration App to use the UK Platform, you can see the supported categories as shown in the following image:

5.jpg

When you configure the Integration App to use the Amazon CA Platform, all the supported categories by the Amazon US platform are also supported by the Amazon CA platform.

For more information on the Product flow, see Product.

Change Amazon account name

The Integration App assigns a random name to each Amazon account during the Integration App installation process. This enhancement provides you with the opportunity to change the Amazon account name in the Integration App to reflect the appropriate account name of your own choice in simple steps.

For more information see, How to update Amazon account name post Integration App installation

4.jpg

Release notes v1.5.0, August 2017

What's new

Amazon Settlement Report Processing Integration Flows

The Celigo Amazon Integration App helps you import settlement reports from Amazon into NetSuite and automatically generate reports that help you analyze the 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's 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
3.jpg

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.

4.jpg

  • 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: This Lets you define a business rule where an invalid first name and last name on Amazon order are automatically trimmed to the first 32 characters before the order is added to NetSuite. This prevents order import failures when the buyer enters more than 32 char for the first name and/or last name fields in Amazon.

      2.jpg

What's enhanced

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 a 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.

Release notes v1.4.0, July 2017

What’s new

Item Alias support for the Order, Inventory, and Pricing data flows

This enhancement allows you to link multiple SKUs on Amazon (aliases) to a single SKU in NetSuite. Listing one SKU from NetSuite in multiple categories on Amazon allows you to attain broader product visibility and customer reach on Amazon.  This also enhances the sale prospect for an item on Amazon. To leverage this functionality you are required to manually set up aliases in NetSuite by setting up a new custom record "Amazon Alias".  

To support this feature for Order (MFN and FBA), Inventory, and Pricing data flows, a new checkbox, Amazon Item Aliases, has been added in the advanced settings section for all supported flows. Use this check box if you have configured item aliases in Amazon and NetSuite to link multiple Amazon SKUs with a single SKU in NetSuite.

Amazon_item_alias.png

Note: The enhancement is supported with:

  • Both FBA and MFN items
  • Simple Item and Kit Items

Support for additional Amazon categories in Item Export

Prior to this enhancement, the integration app only supported the following Amazon item categories:

  • Auto Accessory
  • Beauty
  • Camera and Photo
  • Clothing
  • Coins
  • Consumer Electronics
  • Health
  • Home
  • Home Improvements
  • Industrial
  • Office
  • Outdoors
  • Sports
  • Toys

With this enhancement, the following Amazon item categories have been added to the supported categories list:

  • Food and Beverages
  • Jewelry
  • Lightning
  • Shoes
  • Book Loader

Import MFN order cancellations from Amazon into NetSuite

Prior to this enhancement, The Order Status drop-down list in the Advanced Setting of the  Order (MFN) section allowed you to only import orders with the status Shipped and Unshipped from Amazon to NetSuite.

As part of this enhancement, the Order Status drop-down list has been now replaced with a multi-select field, Sync orders when order status is, that allows you to also import canceled MFN orders from Amazon into NetSuite. Using this field, you can import orders with the status Shipped, Unshipped, and Cancelled. This multi-select field lets you select the order statuses and only the order with status matching your selection are synced with NetSuite. The leading practice is to set this field as 'Unshipped' and 'Canceled' once you are live.

Amazon.png

Note:

  • This feature is only supported with MFN orders because FBA orders are imported into NetSuite only once they are shipped on Amazon.
  • Partial Cancellations are not supported (When an order is partially canceled after it has been imported into NetSuite).

Support for automating the billing of NetSuite orders as Cash Sale/Invoices

This feature allows you to automate the generation of cash sales/invoices from orders imported from Marketplaces or webstores into NetSuite. By leveraging this feature you are no longer needed to manually bill these orders in NetSuite as they are already paid for on the Marketplaces or webstores.

Two new integration flow, NetSuite Order to NetSuite CashSale Add and NetSuite Order to NetSuite Invoice Add, have been added in the Billing section that generates a cash sale or invoice respectively for the corresponding order in NetSuite.

The Billing section also allows you to specify when you want to bill orders. i.e when the status is pending fulfillment or pending billing. When you bill an order in NetSuite, whether an order will be billed as Cash Sale/Invoice is actually determined by the fact whether the "Payment Method" field on the sales order is empty or not (NetSuite native behavior). If it's empty, it transforms into an invoice. If it's non-empty, it transforms into a cash sale.

2017-07-12_15-19-34.png

Note: Billing of partially fulfilled orders is not supported with this enhancement.

What’s enhanced

Import FBA order with “zero” quantity in NetSuite

Prior to this enhancement, it was not possible to import orders from Amazon to NetSuite which has a line item with a quantity as Zero. An error used to be generated whenever the order with Zero line item quantity was imported using the Amazon (FBA) Order to NetSuite Order Add or Amazon (MFN) Order to NetSuite Order Add flow.

With this enhancement, the Amazon (FBA) Order to NetSuite Order Add and Amazon (MFN) Order to NetSuite Order Add flow has been enhanced to enable importing an order in NetSuite which has a line item quantity as Zero. When you import an order with multiple line items among which a line item quantity is Zero, the order is added in NetSuite with the status of a line item with zero quantity marked as “Closed”.

 

Related articles

Comments

0 comments

Please sign in to leave a comment.