Articles in this section

Map item aliases and case pack quantities on transfer orders

Balasubramanian Mahadevan
Updated

The Transfer Order - InboundShipments add-on for the Amazon MCF - NetSuite integration app can send two extra kinds of item detail with your transfer orders: item aliases, which link one NetSuite item to the Amazon SKUs it's sold under, and case pack quantities, which tell Amazon how many units are in each case. Both need a NetSuite custom field, a change to the add-on's saved searches, and new mappings in the add-on's flows. This article is for NetSuite administrators and integrator.io users who already run the add-on, as described in Sync NetSuite transfer orders to Amazon inbound shipments.

Map item aliases

With item aliases, you keep a single item in NetSuite with several variations or aliases. When you select the parent item on a transfer order line, all its aliases are populated. While it processes an item receipt, the integration app looks for the item ID first. If it finds no match, it looks for the item alias in the alias record.

Add Parent SKU to the saved searches

  1. In NetSuite, create a custom transaction column field named Parent SKU.
  2. Search for Celigo Amazon Transfer Order Export Search, and on the results page, select Edit this Search.

  3. Under Results > Columns, add a column:

    • Field: Parent SKU (Custom Column)
    • Custom Label: ParentSKU(Item Field)
  4. Select Save.
  5. Repeat steps 2 to 4 for the Celigo Amazon Child Transfer Order Export Search saved search.

Map aliases in the shipment plan flow

  1. Open the Amazon MCF - NetSuite integration app, and go to Flows > Shipments (TO).
  2. For NetSuite Transfer Order to Amazon Inbound Shipment Plan, select Edit mapping, and then select Create Child Transfer Orders in NetSuite.
  3. For the mapping of Items[*].SellerSKU to Items: Item (InternalId), select Settings, set Action to take if unique match not found to Use empty string as default value, and then select Save & close.
  4. Add a mapping of Items[*].SellerSKU to Items: Parent SKU (Name), and save the mappings.

Map aliases in the item receipt flow

  1. In the integration app, go to Flows > Shipments (TO).
  2. For Amazon Delivered Shipments to NetSuite Item Receipt, select Edit mapping, and then select Post Item Receipt to NetSuite.
  3. For the mapping of lineItems[*].SellerSKU to item[*].item.internalid, select Settings, set Action to take if unique match not found to Use empty string as default value, and then select Save & close.
  4. Add a mapping of lineItems[*].SellerSKU to Items: Parent SKU (Name), and save the mappings.

Select aliases on a transfer order

  1. In NetSuite, open the transfer order, and select Edit.
  2. Under Items, for each line, select the Amazon SKU for the item in Parent SKU.
  3. Save the transfer order.

Sync case pack quantity

To send the number of units per case to Amazon with your inbound shipment plans, store it in a custom field on the transfer order lines.

Create the case pack field in NetSuite

  1. In NetSuite, go to Customization > Lists, Records, & Fields > Transaction Line Fields > New.
  2. Enter a Label, such as Units Per Pack.
  3. For Type, select Free-Form Text or Integer Number.
  4. Under Applies To, select Transfer Order.
  5. Select Save & Apply to Forms.
  1. Search for Celigo Amazon Transfer Order Export Search, open the saved search, and select Edit this Search.

  2. Under Results > Columns, add a column:

    • Field: The custom field you created, for example Units Per Pack (Custom Column)
    • Custom Label: QtyPerCase(Item Field)
  3. Select Save.

Map the case pack quantity

  1. Open the Amazon MCF - NetSuite integration app, and go to Flows > Shipments (TO).
  2. For NetSuite Transfer Order to Amazon Inbound Shipment Plan, select Edit mapping, and then select Post InboundShipment Plan to Amazon.
  3. Add a mapping of Items[*].QtyPerCase to Items[*].QuantityInCase, and then select Save & close.
  4. Run NetSuite Transfer Order to Amazon Inbound Shipment Plan.