Articles in this section

Sync item aliases to NetSuite transfer order

Balasubramanian Mahadevan
Updated

The Transfer Order - InboundShipments add-on supports item aliases. When you create a transfer order, select an item alias associated with the Amazon SKU for each line item. You can have a single item in NetSuite and have multiple variations or aliases for the same. When you select the parent item, all the associated aliases are populated.

Configure item aliases on the transfer order

  1. Login to your NetSuite account.

  2. In the global search, enter "Page: Transfer orders"

  3. On the "Transfer Orders" page, click Edit next to the appropriate transfer order.

  4. Go to "Items" tab and scroll right.

  5. In the Parent SKU field, select the Amazon SKU for the particular item. While processing the item receipt, the integration app checks for the Item ID. If no match is found, then check for the item alias in the alias record.

Item alias Transfer order.jpg

Configure NetSuite saved search

  1. Login to your NetSuite account.

  2. In the global search, enter “Celigo Amazon Transfer Order Export Search.”

  3. On the “Celigo Amazon Transfer Order Export Search: Results” page, click Edit this Search.

  4. Go to the Results > Columns tab and add a new column.

  5. Add new entry as follows:

    Field

    Custom Label

    Parent SKU (Custom Column)

    Notice

    Create a custom field as “Parent SKU” and select from this list

    ParentSKU(Item Field)

  6. Click Save.

Note

Repeat steps 1-6 for the “Celigo Amazon Child Transfer Order Export Search” saved search.

Item_Alias_Transfer_Order_Step2.jpg

Configure new mappings in the integration app

  1. Login to your integrator.io account.

  2. Click Amazon - NetSuite integration app.

  3. Go to the Shipments (TO) section.

  4. Next to the NetSuite Transfer Order to Amazon Inbound Shipment Plan flow, click Edit mapping (mapping.svg).

  5. Select Create Child Transfer Orders in NetSuite.

  6. On the Edit mapping: Create Child Transfer Orders in NetSuite pane, edit or configure the following mappings:

Export field (NetSuite)

Import field(NetSuite)

Action

Items[*].SellerSKU

Items : Item (InternalId)

Before you run the flow, ensure to perform the following:

  1. Next to this mapping, click Settings (settings_gear.svg​).

  2. On the Settings pane, choose Use empty string as default value in the Action to take if unique match not found setting.

  3. Click Save & close to exit the Settings pane.

Items[*].SellerSKU

Items : Parent SKU (Name)

Add a new mapping.

  • Click Save & close to exit the Edit mapping: Create Child Transfer Orders in NetSuite pane.

Read more about related solutions: