As an Amazon FBA (Fulfillment by Amazon) merchant, providing Amazon with accurate information about the items you plan to ship to their FBA warehouses is crucial. If you use NetSuite to manage and track your inventory, creating Transfer Orders (TO) is essential for moving stock between your inventory locations and Amazon’s fulfillment centers.
You can use the Transfer Order (TO) - Shipmentadd-on to simplify and automate this process. This tool streamlines your workflow by automating inbound shipments, shipment plans, and item receipts.
Here’s how the add-on works:
-
Create a Transfer Order: When you generate a Transfer Order in NetSuite to send items to the Amazon FBA warehouse, the add-on handles the transfer details and submits the necessary information to Amazon automatically.
-
Automate Shipment Tracking: Once the shipment leaves Amazon's FBA warehouse, the add-on continuously tracks the shipment's delivery status. This ensures real-time updates in NetSuite, allowing you to monitor the progress without manual follow-ups.
-
Manage Item Receipts: NetSuite automatically updates item receipts upon delivery, confirming that Amazon has received the shipment. This helps you maintain an accurate inventory count and ensures smoother warehouse operations.
Using the TO - Shipment add-on saves time, reduces manual effort, and ensures your inventory management processes remain efficient and up-to-date. This helps you keep track of your stock and improves the accuracy and speed of your shipments to Amazon's fulfillment centers.
Understand the add-on
To efficiently manage your shipments from NetSuite to Amazon's FBA warehouses, the Transfer Order (TO) - Shipment add-on automates the creation of shipment plans and item receipts. Here’s a detailed guide on how the add-on works and integrates with Amazon.
Step 1: Create Amazon inbound shipment plans and packing options from NetSuite
First, you'll need to create a shipment plan by specifying key details like the product type, quantity, shipping addresses (from and to), and label preferences. After creating the transfer orders in NetSuite, the shipment plans are sent to Amazon.
In the NetSuite Transfer Orders to Amazon Inbound Shipment Plan flow, the process involves several key steps to ensure accurate data transfer between NetSuite and Amazon:
-
Get Transfer Orders from NetSuite (Export): This step retrieves the transfer orders from NetSuite, gathering the necessary details for shipment.
-
Post Inbound Shipment Plan to Amazon (Import): Once the transfer orders are retrieved, this import sends the transfer order data to Amazon, triggering a request for Amazon to create an Inbound Shipment Plan.
-
Generate Packing Options (Import): After the shipment plan is requested, this import generates packing options within Amazon, ensuring that the correct packing instructions are followed for each item.
-
Write Back Inbound Plan ID to NetSuite (Import): This step writes back the Amazon Inbound Shipment Plan ID to the corresponding transfer order in NetSuite, ensuring proper tracking within the system.
Step 2: Sync packing information from NetSuite transfer orders to Amazon inbound shipment plan
The NetSuite Packing Information to Amazon Inbound Shipment Plan flow synchronizes packing details from items in NetSuite transfer orders to Amazon's inbound shipment plan, ensuring accurate data transfer for proper packaging.
-
Get Packing Information from NetSuite Transfer Orders (Export): This export retrieves packing information, such as pack type, dimensions, and weight, from transfer orders in NetSuite that are part of an Amazon inbound shipment plan.
-
Lookup Packing Options for Inbound Shipment Plan from Amazon (Export Lookup): The export references the Amazon inbound shipment plan using the Amazon Inbound Shipment Plan ID (received in Step 1) to retrieve available packing options for the items in the transfer order.
Note
Amazon currently generates only one packing option, which may include one or more pack groups.
-
Get Pack Group Items: This lookup retrieves and populates packing information from Amazon for both single and multi-pack group scenarios.
-
Post Packing Information to Amazon Inbound Shipment Plan (Import): This import sends the packing information (pack type, dimensions, and weight) from NetSuite transfer orders to Amazon's inbound shipment plan, ensuring that Amazon has the correct packaging details for each item.
Step 3: Sync Amazon shipments and labels to NetSuite
The Amazon Shipments to NetSuite Item Shipments flow ensures that shipping labels and shipment details from Amazon are synced with NetSuite, providing accurate tracking and management of shipments.
-
Get Confirmed Transfer Orders from NetSuite (Export): This step retrieves the confirmed transfer orders from NetSuite that are ready for shipment.
-
Get Inbound Plan Information from Amazon (Export): The inbound plan information associated with the confirmed transfer orders is retrieved from Amazon.
-
Get Shipment Information from Amazon (Export): Shipment information is pulled from Amazon, ensuring that NetSuite has updated shipment statuses and details.
-
Get Shipment Items from Amazon (Export): The flow retrieves detailed item-level shipment information from Amazon, including which items were shipped and their respective quantities.
-
Get Label Information from Amazon (Export): Shipping label information is fetched from Amazon, ensuring that the correct labels are available for the corresponding shipments.
-
Sync Item Shipments to NetSuite (Import): This step synchronizes item shipment information from Amazon back into NetSuite, ensuring that NetSuite reflects the latest shipment status.
-
Attach Shipment Labels to NetSuite Shipments (Import): Shipment labels retrieved from Amazon are downloaded and attached to the corresponding transfer orders in NetSuite, ensuring that each shipment is accurately linked to its label for proper tracking.
This flow automates the synchronization of shipment details and labels between Amazon and NetSuite, ensuring all shipment data is up-to-date and correctly linked.
Step 4: Sync NetSuite tracking details to Amazon shipments
Do not run this flow, if you are using Amazon partnered carriers.
This flow ensures that tracking details from item shipments in NetSuite are synced with Amazon shipments, maintaining accurate shipment tracking across both platforms.
-
Get Item Shipments with Tracking Details from NetSuite (Export): This step retrieves the item shipments along with their tracking details from NetSuite, ensuring that all relevant shipment information is ready for synchronization.
-
Post Tracking Details to Amazon Shipments (Import): The retrieved tracking details are synced from NetSuite to Amazon, ensuring that Amazon has up-to-date tracking information for the associated shipments.
The NetSuite Tracking Details to Amazon Tracking Details flow automates the transfer of tracking information, including the tracking ID, package tracking number, freight bill number, bill of lading number, and more, from NetSuite to Amazon. This ensures accurate and consistent shipment tracking across both systems.
Step 5: Item receipts are created
After the shipment reaches Amazon, the Amazon fulfillment network processes the received items. Whether partial or full shipments are delivered, Item Receipts are automatically generated in NetSuite, confirming the receipt of the items at Amazon.
As an FBA merchant, tracking the status of items you ship to Amazon is crucial. The Amazon Delivered Shipments to NetSuite Item Receipt flow automates this process by syncing item receipts back to NetSuite at the scheduled time, ensuring accurate and timely tracking of your shipments. For more information, refer to Item Receipts.
Supported and unsupported items in this add-on
-
Supported:
-
Inventory items
-
Matrix items
-
Serialized items
-
Lot Numbered items
-
Item aliases
-
Assembly items
-
-
Not Supported:
-
Kit items (NetSuite limitation)
-
Prerequisites
Add permissions in NetSuite
Before you configure or install the add-ons, add the following permissions to the native Celigo eTail SmartConnectors role or any other appropriate custom role in NetSuite:
-
Item Receipt
-
Transfer Order
-
Transfer Order Approval
Update fields for transfer order record in NetSuite
When a transfer order record is created in NetSuite, perform the following actions:
-
In the Custom form field, select Standard Transfer Order.
-
In the Status field, select the status as Pending Fulfillment.
Note: Do not select the status as Pending Approval, as it is not eligible for the Celigo Amazon Shipment Plan Export Search criteria.
-
Select the appropriate “eTail channel” and “Amazon Account.
Enable custom fields in NetSuite
Before you install the add-on, enable NetSuite custom fields for the record types: Transfer Order, Items, Item Fulfillment, and Item Receipt.
In the Transfer Order:
-
Celigo Amazon Inbound Plan Id
-
One-Box Packing (All Items will fit into one box)
-
Celigo packing options generated
-
One-Box Dimension Unit
-
One-Box Length
-
One-Box Width
-
One-Box Height
-
One-Box Weight Unit
-
One-Box Weight
-
Celigo Amazon Inbound Shipment Id
In the Items:
-
Case pack dimension unit
-
Case pack length
-
Case pack width
-
Case pack height
-
Case pack weight unit
-
Case pack weight
-
Prep Owner
-
Label Owner
-
Quantity In Case
In the Item Fulfillment:
-
Celigo Amazon Inbound Shipment Id
In the Item Receipt:
-
Celigo Amazon Inbound Shipment Id
Install the add-on
You can install this add-on from the Subscriptions section of your integration app. For more details on installing add-ons, refer to add-ons.
Currently, the flows are sorted alphabetically. To ensure proper operation, configure and run the flows in the following sequence:
-
NetSuite Transfer Orders to Amazon Inbound Shipment Plan
-
NetSuite Packing Information to Amazon Inbound Shipment Plan
-
Amazon Shipments to NetSuite Item Shipments
-
NetSuite Tracking Details to Amazon Tracking Details
-
Amazon Delivered Shipments to NetSuite Item Receipt
The Transfer Order (TO) - Shipment add-on uses scheduled data flows to automatically fetch transfer orders from NetSuite and create Inbound Shipments and Inbound Shipment Plans in Amazon. This automation saves time and reduces the risk of errors when managing shipments between NetSuite and Amazon's FBA network.
By following the above-mentioned flow sequence, you ensure each step is completed in the correct order, enabling smooth synchronization between NetSuite and Amazon.
Configure the flows in the add-on
Configure and run the InboundShipment Plan flow
Prerequisites
Before proceeding, ensure that a shipment plan has been created. This involves specifying essential details such as product type, quantity, shipping addresses (both origin and destination), label preferences, and any special handling instructions for fragile or sharp items. After creating the transfer orders in NetSuite, the shipment plans are sent to Amazon for processing.
To configure and run the flow:
-
In integrator.io, click the integration app tile.
-
Enable the NetSuite Transfer Orders to Amazon Inbound Shipment Plan flow.
-
Click Save.
-
Run the NetSuite Transfer Orders to Amazon Inbound Shipment Plan flow.
After the flow is completed, the Celigo Amazon Shipment Plan Exported checkbox on the NetSuite transfer order record is automatically selected to prevent the same plan from being processed multiple times by the flow.
Saved search details
The Celigo Amazon Shipment Plan Export Search saved search is utilized during the export process to fetch all the required details from NetSuite, including:
-
Items and quantities
-
Shipping addresses (from and to)
-
Phone numbers
-
Prep owner and prep instructions
-
Label owner and other relevant information
This ensures that all necessary data is transferred accurately to Amazon for seamless shipment planning and execution.
Tip: To find specific transfer orders in NetSuite, you can use the CELIGO AMAZON INBOUND SHIPMENT ID in the NetSuite global search. The results will display as “Transfer Order ID (null),” for example Transfer Order: TRO00000068 (null).
Configure and run the Packing Information flow
Prerequisites
-
To ship all items and quantities in a single box, make sure to select the One-Box Packing (All items will fit into one box) option under Transactions > Transfer Order record > eTail tab. Additionally, provide the box details, including length, width, height, and weight unit. These details will be retrieved using the Amazon Inbound Shipment Plan ID, which is received after running the NetSuite Transfer Orders to Amazon Inbound Shipment Plan flow.
-
To ship items with multiple boxes, the dimension of each box is defined depending on the item record fields. Provide the required details for each box, including length, width, height, and weight unit, as specified by the item.
-
To ship items in multiple boxes, the dimensions of each box are determined based on the item record fields. You must provide the details for each box, including length, width, height, and weight unit, as specified by the item.
Important
-
The integration app does not support shipping multiple boxes that contain more than one unique item per box.
-
The integration app does not support Bin items due to a restriction within NetSuite.
To configure and run the flow:
-
In integrator.io, click the integration app tile.
-
Enable the NetSuite Packing Information to Amazon Inbound Shipment Plan flow.
-
Click Save.
-
Run the NetSuite Packing Information to Amazon Inbound Shipment Plan flow.
After the flow is completed, the Celigo Packing Options Generated checkbox on the NetSuite transfer order record is automatically selected to prevent the same packing information from being processed multiple times by the flow.
Saved search details
The Celigo Amazon Transfer Order Packing Information Export Search saved search is used to gather all the necessary packing details from NetSuite transfer orders, ensuring accurate synchronization with Amazon for seamless shipment processing.
Configure and run the Inbound Shipment flow
Prerequisites
In Amazon
Before running the Amazon Shipments to NetSuite Item Shipments flow, perform the following actions:
-
Ensure you configure the mapping for the folderId field in the Attach Shipment Labels to NetSuite Shipments import as shown in the screenshot. With this configuration, the app wcandownload the shipment labels PDF, store them in the specified NetSuite folder, and attach them to the corresponding NetSuite shipments.
-
Confirm and process each shipment plan in Amazon (Shipments > Send to Amazon tab). Be sure to provide the ship date, select the shipping mode, choose the shipping carrier, and specify the delivery window.
In NetSuite
-
Ensure that the page type, page size, and label type fields are specified in the Transactions > Transfer Order record > eTail tab.
-
Page type: Submit the page type value. Refer to enum (PageType) for standard field values.
-
Page size: Submit the page size value. Refer to integer (Page Size) for standard field values.
-
Label type: Submit the page type value. Refer to enum (LabelType) for standard field values.
-
-
Set the Status field to Pending Fulfillment. Do not select Pending Approval. If the Pending Approval status is selected, the Sync Item Shipments to NetSuite (Import) will result in an error stating: "Failed to create item shipment because the transfer order ID# transferOrderId is not in 'Pending Fulfillment' status. Please ensure the transfer order is approved and ready for fulfillment before running the flow."
-
Ensure that the Inventory Detail is configured for serialized, lot, serialized assembly, and lot-numbered assembly items.
To configure and run the flow:
-
In integrator.io, click the integration app tile.
-
Enable the Amazon Shipments to NetSuite Item Shipments flow.
-
Click Save.
-
Run the Amazon Shipments to NetSuite Item Shipments flow.
If you are using case pack shipments for your FBA orders, certain adjustments in NetSuite are required to accommodate this setup. To know the details of the changes to be made in NetSuite, see Manage case pack shipments in NetSuite.
After the flow is completed, the Celigo Amazon Confirmed Transfer Order Exported checkbox on the NetSuite transfer order record is automatically selected to prevent the same transfer order from being processed multiple times by the flow.
Configure and run the Tracking Details flow
Important: Do not run this flow, if you are using “Amazon partnered carriers”.
Prerequisites
In NetSuite
Before running the NetSuite Tracking Details to Amazon Tracking Details flow, perform the following actions:
-
For SPD (small parcel delivery) - ensure that you provide the package tracking number in the Package Tracking Number custom field.
-
For LTL and FTL (less than truck load/ full truck load delivery) - ensure that you provide the freight bill number and bill of lading number in the Freight Bill Number and Bill of Lading Number custom fields. In the Freight Bill Number field, you can add multiple values separated by a comma.
In Amazon
-
In the Shipments tab > Send to Amazon > open the shipment plan, enusre that you click Proceed to enter tracking details.
To configure and run the flow:
-
In integrator.io, click the integration app tile.
-
Enable the NetSuite Tracking Details to Amazon Tracking Details flow.
-
Click Save.
-
Run the NetSuite Tracking Details to Amazon Tracking Details flow.
After the flow is completed, the Celigo Amazon Tracking Details Exported checkbox on the NetSuite item shipment record is automatically selected to prevent the same tracking details from being processed multiple times by the flow.
Configure additional mappings
Accounts in different marketplaces within the same region
If you manage accounts in different marketplaces within the same region, and you have a different home address and you need to sync the inbound shipment plans to another marketplace address, you need to configure additional mappings while creating inbound shipment plans.
Example: In the North America region, if you have accounts in the US and CA marketplaces, if your home address is US and you want to sync the inbound shipment plans to CA, it is required to configure additional mappings.
It is recommended that you configure the below additional mappings to sync the inbound shipment plans to the respective marketplace account within the same region.
-
In integrator.io, click the integration app tile.
-
Go to Flows > Shipment (TO) section.
-
Next to the NetSuite Transfer Orders to Amazon Inbound Shipment Planflow, click Edit mapping.
-
In the Edit mapping pane, click Post InboundShipment Plan to Amazon.
-
Add the following mappings:
|
Source record field (NetSuite) |
Destination record field (Amazon Seller Central) |
|
“CA” |
ShipToCountryCode |
|
Enter the exact value or Map the custom field internal ID here |
ShipToCountrySubdivisionCode |
Notes:
-
The values in the Source record field (NetSuite) section should match the Amazon values. To understand more about these Amazon mappings and their values, refer to Create inbound shipment plan.
-
For the ShipToCountryCode mapping, you need not edit the saved search results, as the field already exists in NetSuite.
-
For the ShipToCountrySubdivisionCode and LabelPrepPreference mappings, create custom fields in NetSuite and update the saved search results respectively.
-
You can configure either the ShipToCountryCode or ShipToCountrySubdivisionCode mapping. If you configure both the mappings, the NetSuite Transfer Orders to Amazon Inbound Shipment Planflow displays an error message “Cannot define both ShipToCountryCode and ShipToCountrySubdivisionCode” in the integration app Dashboard tab.
-
You can add the LabelPrepPreference field for creating an inbound shipment plan.
-
Provide the values for the ShipToCountrySubdivisionCode mapping as per the prescribed format by Amazon MWS.
Troubleshooting Transfer Order (TO) - Shipment add-on errors
|
Flow |
Error code/message |
Reason |
Resolution |
|
NetSuite Transfer Orders to Amazon Inbound Shipment Plan |
Amazon cannot provide prep and labeling services for items that do not have a single scannable barcode (GCID, UPC, EAN, JAN, or ISBN) that corresponds to an ASIN in Amazon\\u2019s catalog. For more information, go to FBA Label Service. |
Due to incorrect prepOwner or labelOwner |
Modify to provide the correct prepOwner or labelOwner value. |
|
Amazon Shipments to NetSuite Item Shipments |
Failed to create item shipment because the transfer order Id# transferOrderId is not in 'Pending Fulfillment' status. Please ensure the transfer order is approved and ready for fulfillment before running the flow |
Transfer Order is not in Pending Fulfillment status |
In the NetSuite transfer order, set the Status field to Pending Fulfillment. |
|
Amazon Delivered Shipments to NetSuite Item Receipt |
Failed to add Item Receipt for FBA Shipment Id# FBA***, the required Shipment Id is missing from the transfer order (old workflow) or item shipment (Send To Amazon) in NetSuite. Ensure the 'Celigo Amazon Inbound Shipment Id' field contains the Shipment Id |
Due to a missing Transfer Order or Item Shipment for that shipment. |
Ensure that the Transfer Order or Item Shipment are populated |
Comments
When will the new searches be published in NetSuite accounts for new flows? Or are any updates required to set up the searches manually?
Best, Mina
Hi Saikumar Rachamalla ,
The flows have been updated and created automatically in the Celigo account. However, the saved searches are not configured. Should we set them up manually? Additionally, regarding the custom fields, do we need to update the bundle in NetSuite manually?
Best regards,
Sanju
Hi Sanju S ,
Could you please create a support ticket? Our product team has a tailored solution that should work effectively for your issue.
Thank you!
Please sign in to leave a comment.