Sync Amazon MCF unit case packing quantity to NetSuite transfer order

Gogula R Bhavana

Updated October 11, 2024 15:23

To sync the unit case packing quantity to NetSuite transfer orders, configure the following additional steps.

Create a custom field in NetSuite

Login to your NetSuite account.
Go to Customization > Lists, Records, & Fields > Transaction Line Fields > New .
Enter a label for the custom field.
In the Type field, either select Free-Form Text or Integer Number .
In the “Applies To” tab, check the Transfer Order checkbox.
Click Save & Apply to Forms .

In NetSuite, in the global search, enter “Celigo Amazon Transfer Order Export Search.”
From the search options, select the appropriate saved search.
Click Edit this Search .
Go to Results tab > Columns sub-tab.

Add a new column as follows:

Field	Custom Label
Select the custom field created in the previous step. Notice If Units Per Pack is the custom field created in NetSuite, create a column in saved search as shown in the image below.	QtyPerCase(Item Field)

Login to your integrator.io account
Select the Amazon - NetSuite integration app.
Go to Flows > Shipments (TO) .
Next to the “NetSuite Transfer Order to Amazon Inbound Shipment Plan” flow, click Mappings .
On the “Edit mapping” window, Select Post InboundShipment Plan to Amazon .
Add a new mapping as follows:

Export field (NetSuite)

Import field (Amazon MWS)

Items[*].QtyPerCase

Items[*].QuantityInCase
Click Save & Close .
Run the “NetSuite Transfer Order to Amazon Inbound Shipment Plan” flow.

Export field (NetSuite)	Import field (Amazon MWS)
Items[*].QtyPerCase	Items[*].QuantityInCase