Articles in this section

Configure NetSuite custom fields to support Amazon Fulfillment API changes

Starting January 1, 2021, online marketplaces are responsible for charging and collecting VAT for sales to the UK from overseas selling partners to comply with the new VAT regulation announced by the UK government. As per the UK marketplace tax changes, Amazon MWS has updated the Amazon Fulfillment API to determine a selling partner's “Ship from address” information when confirming seller-fulfilled orders. If an order is shipped outside the UK marketplace, Amazon collects and remits taxes on their behalf. The Integration App is enhanced and updated to sync data to NetSuite as per the Amazon Fulfillment API changes.  

To support the Amazon Fulfillment API changes, you have to create the following custom fields in NetSuite:

  • Name
  • Address 1
  • Address 2 (Optional) 
  • Address 3 (Optional)
  • City
  • County (Optional)
  • State or Region
  • Postal Code
  • Country Code

Note: The names provided for the custom fields are just an example. You can provide field names as per your business needs.

Step 1: Create custom fields for the above-mentioned fields

  1. Login to your NetSuite account.
  2. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.
  1. On the “Transaction Body Field” page, enter the name in the Label field.
  2. Select the appropriate field type in the Type drop-down menu.
  3. In the “Applies To” tab, check the Item Fulfillment checkbox.
  4. Click Save.

Note: Repeat steps 1- 6 to create all the above-mentioned custom fields. Provide appropriate names in the Label fields.

Step 2: Configure the fulfillment saved search to add the new fields

  1. In NetSuite, in the global search bar, enter Celigo Amazon Fulfillment Export Search.
  2. From the search results, select the appropriate saved search.
  3. On the “Celigo Amazon Fulfillment Export Search” page, click Edit this Search.
  4. Go to the “Results” tab
  5. Click Add to add the newly-added custom fields as following:
    Note: The names provided for the custom fields are just an example. You can provide field names as per your business needs. 

    Field name

    Custom Label

    Address Name (Custom Body)

    Name

    Address1  (Custom Body)

    Address1

    Address2 (Custom Body)

    Address2 

    Address3 (Custom Body)

    Address3

    City (Custom Body)

    City

    County (Custom Body)

    County

    StateOrRegion (Custom Body)

    StateOrRegion 

    PostalCode (Custom Body)

    PostalCode

    CountryCode (Custom Body)

    CountryCode

  6. Click Save.

Step 3: Configure the flow mappings

  1. Sign in to your Integrator.io account.
  2. Click Amazon - NetSuite Integration App tile.
  3. Go to Flows  > Fulfillment
  4. Next to the NetSuite Fulfillment to Amazon Shipment Add flow, click Mapping.
  5. Add the following mappings in the specified order:

    Export field (NetSuite)

    Import field (Amazon MWS)

    Name

    Name

    Address1

    Address1

    Address2 

    Address2 

    Address3

    Address3

    City

    City

    County

    County

    StateOrRegion 

    StateOrRegion 

    PostalCode

    PostalCode

    CountryCode

    CountryCode

  6. Click Save & close.