Articles in this section

Sync transfer orders from NetSuite as inbound shipments to Walmart

Balasubramanian Mahadevan
Updated

Contents

As a Walmart merchant, you have to send key information to Walmart about the list of items you want to ship to the warehouse. To manage and track your inventory, you have to create transfer order records in NetSuite to move inventory between locations. You can manage your inbound shipment, inbound shipment plan, and item receipt automatically with the Sync Walmart inbound shipments add-on. This add-on sends a shipment of items from NetSuite to the Walmart Warehouse and tracks back the shipment delivery status in NetSuite.

Understand the flow

You have to create a shipment plan by specifying information such as type of product, quantity, shipping address (from and to), label preferences, and special instructions for fragile and sharp items. After you create your transfer orders in NetSuite, you have to send the shipment plans to Walmart.

Step 1: Inbound shipment plans are requested

The NetSuite transfer orders to Walmart inbound shipments (add) flow syncs the transfer orders to Walmart. This is a once-export flow.

The flow sends a request to Walmart to create an inbound shipment plan. Walmart may split a single shipping plan into multiple shipments to redirect to different fulfillment centers. Based on the received shipment plan, the inbound shipment details are updated or child transfer order(s) are created in NetSuite with the ShipmentID and Fulfilment Center ID details. 

The flow writes shipment IDs back to NetSuite. You will now group and ship the items to Walmart as per the desired plan. 

  • When Walmart returns a single shipment: the parent transfer order is kept open and the flow updates the inbound shipment details.
  • When Walmart returns more than one account: the parent transfer order is closed, and child transfer order(s) are created for each of the inbound shipments. 

You can find all the child transfer order details on the original transfer order. Simultaneously, the child transfer orders are also linked to the original transfer order. The original transfer order is marked as “Closed”.

The “Item Fulfillment” records of the child transfer order(s) with the status “Fulfilled” are synced using the NetSuite transfer orders to Walmart inbound shipments (add) flow. 

Note: You can search for specific transfer orders with the shipment ID in the NetSuite global search. When you enter the CELIGO WALMART INBOUND SHIPMENT ID in the NetSuite global search, the search result is displayed as “Transfer Order ID (null)”. Example: Transfer Order: TRO00000068 (null).

Step 2: Item receipts are created

The Walmart fulfillment network receives partial or full shipments. For the delivered shipments, the Item Receipts are generated in NetSuite. For more information, refer to Sync delivered shipments from Walmart as item receipts to NetSuite.

Supported and unsupported items in this add-on

  • Supported: 
    • Inventory items
    • Matrix items
    • Serialized items
    • Lot Numbered items
    • Assembly items
  • Not Supported: 
    • Kit items (NetSuite limitation)
    • Item aliases

Install the add-on

You can install this add-on from the “Subscriptions” section of your Integration App. For more information on how to install add-ons, refer to add-ons.

Before you set up the flow

Before you configure or install the add-ons, in NetSuite, add the following permissions to the native “Celigo eTail SmartConnectors” role or to any other appropriate custom role:

  • Item Receipt  
  • Transfer Order
  • Transfer Order Approval

In NetSuite, while you create your transfer order record, ensure to perform the following:

  • 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 Walmart Transfer Order Export Search” criteria.

  • Select the appropriate “eTail channel” and “Walmart Account.

Preconditions before you run the flow

  • The product ID should be 12 digits(UPC code) and it should be present on the respective Item
  • Item description
  • The item name and SKU should match
  • The expected delivery date should be present on the transfer order
  • Item description should not exceed 450 characters. If the description exceeds 450 characters, the following error is displayed:
    {"status":"FAIL","errors":[{"code":"ERR_EXT_DATA_0021001","field":"orderItems[5].itemDesc","description":"The payload structure is not valid. Please correct the payload.","info":"itemDesc length cannot be greater than 450 chars","severity":"ERROR","category":"DATA"},{"code":"ERR_EXT_DATA_0021001","field":"orderItems[4].itemDesc","description":"The payload structure is not valid. Please correct the payload.","info":"itemDesc length cannot be greater than 450 chars","severity":"ERROR","category...

Configure flow setting

  1. Log in to your integrator.io account
  2. Go to Settings > Shipments (TO).
  3. In the NetSuite locations to pick up transfer orders setting, choose one or more locations for Walmart to get the transfer orders from.
  4. Click Save.

Run the flow

  1. Go to Flows > Shipments (TO).
  2. Next to the NetSuite transfer orders to Walmart inbound shipments (add) flow, use the toggle button to enable the flow.
  3. If you run the flow for the first time, a delta flow pop-up window is displayed. This helps you to sync the historical transfer orders.
    1. Automatic: Choose this option to process and sync data from the last flow run time OR
    2. Custom: Choose this option to select a custom start date and time from when you wish to process and sync data.
  4. Click Run.

You can see the flow status in the integrator.io Dashboard.

Understand the transfer order and inbound shipment records in Walmart and NetSuite

After you run the NetSuite transfer orders to Walmart inbound shipments (add) flow, in NetSuite:

  • The child transfer orders are created.
  • The child transfer orders are linked to the original transfer order.
  • The original transfer order consists of the list of child transfer orders in the "Custom" tab.

    Note: The child transfer orders are visible on the "Custom" tab of the original transfer order only if the "Custom Form" is selected as Standard Transfer Order.

  • The original transfer order is marked as “Closed”.
  • In the transfer order, go to eTail > Walmart tab,
    • The original transfer order is linked to the child transfer order. 
    • The child transfer order is updated with Shipment ID and Fulfillment Center ID details.
    • The “Celigo Walmart Received Shipment Plan” box is checked.
    • The  “Celigo Walmart Shipment Exported” box is checked.

Related to