(ASC) FBM to Amazon Fulfillment Update
Table of Contents
Description
When FBM Order Item Fulfillment Record are Create in NetSuite, there is a Script that will Run on Schedule, based on a Search, to find the Item Fulfillments and Send an update to Amazon to set the Shipping and Tracking Data.
Below are the Sections that are working together to make this happen.
Requirements
FBM Shipping Methods mapped
Script Scheduled
FBM Shipping Methods
In Order to successfully Update Amazon with the Shipping and Tracking, the NetSuite Shipping Methods that will be used on the Item Fulfillments must be mapped. So the Sync can set the needed Values for the fields below:
This is so the update to Amazon can set the desired Shipping data in Amazon:
Shipping Service
Shipping Carrier
Tracking Number
The following Document supplied by Amazon on what the Shipping Service can be and the Shipping Carrier needs to be is in the following Link:
https://sellercentral.amazon.com/help/hub/reference/G641 (Requires being logged in to Seller Central to view)
Requirements
Shipping Service:
Shipping Carrier:
Carrier MUST be one that Amazon Lists in the Doc:
Recommend to NOT use other.
4PX, A-1, AAA Cooper, ABF, Asendia, Best Buy, Blue Package, Canada Post, CEVA, China Post, Conway, DHL, DHL eCommerce, Estes, FedEx, Fedex Freight, FedEx SmartPost, First Mile, Hongkong Post, Hunter Logistics, India Post, JCEX, Lasership, Newgistics, Old Dominion, OnTrac, OSM, Pilot Freight, R+L, Roadrunner, Royal Mail, Saia, SF Express, SFC, StreamLite, UPS, UPS Freight, UPS Mail Innovations, Urban Express, USPS, XPO Freight, Yanwen, Yellow Freight, Yun Express, Other |
Tracking Number:
NetSuite Mapping:
Under Setup Tab > Amazon Seller Central > FBM Shipping Methods
Map the NetSuite Shipping Item (Method) to the Amazon Shipping Carrier Code and Amazon Shipping Service, per the Marketplace needed.
All Fields are REQUIRED
Script
The Script handling the update from NetSuite to Amazon is “In8 Amazon Fulfillment MR”
The Script when it runs will be referencing the Saved Search "In8 Amazon Fulfillment Sync"
Located in the Menu:
Setup Tab > Amazon Seller Central > Order Queue Scripts
Script Deployment marked as Scheduled should have the Following Schedule and be scheduled:
Once the fulfillment is updated to Amazon, the field “In8 Amazon Synced” will get checked so it is no qualified to Sync again.
This field is under the Amazon SubTab on the Item Fulfillment.
Re-Send update
To send the Item Fulfillment again to Amazon, the field “In8 Amazon Synced” would have to get unchecked in order for the Item Fulfillment to be listed in the Saved Search result for the script to Send again on the next run.
Saved Search
Saved Search "In8 Amazon Fulfillment Sync" used as reference for the Script Above to know what FBM Item Fulfillment to send to update Amazon Qualifies the records by:
RecordType = itemfulfillment
Merchant Fulfilled = T
Amazon Order ID = isnotempty
In8 Amazon Setting = isnotempty
In8 Amazon Synced = F
If Ship Status is enabled, the Fulfillment must be Shipped (handled in code)