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
- Login to your NetSuite account.
- Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.
- On the “Transaction Body Field” page, enter the name in the Label field.
- Select the appropriate field type in the Type drop-down menu.
- In the “Applies To” tab, check the Item Fulfillment checkbox.
- 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
- In NetSuite, in the global search bar, enter Celigo Amazon Fulfillment Export Search.
- From the search results, select the appropriate saved search.
- On the “Celigo Amazon Fulfillment Export Search” page, click Edit this Search.
- Go to the “Results” tab
- 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
- Click Save.
Step 3: Configure the flow mappings
- Sign in to your Integrator.io account.
- Click Amazon - NetSuite Integration App tile.
- Go to Flows > Fulfillment.
- Next to the NetSuite Fulfillment to Amazon Shipment Add flow, click Mapping.
- 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
- Click Save & close.