Articles in this section

Sync Walmart inbound shipments and item receipts

Balasubramanian Mahadevan
Updated

The Sync Walmart inbound shipments add-on for the Walmart - NetSuite integration app sends the items you plan to ship to Walmart's fulfillment network from NetSuite, and tracks their delivery back into NetSuite. It sends NetSuite transfer orders to Walmart as inbound shipment plans, and creates NetSuite item receipts when Walmart receives the shipments. The add-on needs its own subscription. This article explains how the two flows work, what to prepare in NetSuite, and how to configure and run the flows.

Prerequisites:

  • Install the add-on from the integration app's Add-ons. For details, see Understand integration app add-ons.

  • In NetSuite, add these permissions to the Celigo eTail SmartConnectors role, or to the custom role the integration app uses:

    • Item Receipt
    • Transfer Order
    • Transfer Order Approval
    • Adjust Inventory, for the item receipts flow

How the add-on works

Inbound shipment plans

When you create transfer orders in NetSuite to move inventory to Walmart, you send Walmart a shipment plan with information such as the type of product, quantity, from and to shipping addresses, label preferences, and special instructions for fragile and sharp items. The NetSuite transfer orders to Walmart inbound shipments (add) flow sends the transfer orders to Walmart and requests an inbound shipment plan.

Walmart can split one shipment plan into several shipments for different fulfillment centers. The flow writes the shipment IDs back to NetSuite:

  • If Walmart returns a single shipment, the original transfer order stays open, and the flow updates it with the inbound shipment details.
  • If Walmart returns more than one shipment, the original transfer order is closed, and a child transfer order is created for each shipment, with its shipment ID and fulfillment center ID.

You then group and ship the items to Walmart according to the plan. The same flow syncs the item fulfillments of the child transfer orders that have the Fulfilled status.

In NetSuite, after the flow runs:

  • The child transfer orders are linked to the original transfer order and listed on its Custom subtab. They appear there only if the transfer order's Custom Form is Standard Transfer Order.
  • On the eTail > Walmart subtab of a child transfer order, the shipment ID and fulfillment center ID are filled in, and Celigo Walmart Received Shipment Plan and Celigo Walmart Shipment Exported are selected.
  • When you search for a CELIGO WALMART INBOUND SHIPMENT ID in the NetSuite global search, the result shows the transfer order with (null) after it, for example Transfer Order: TRO00000068 (null).

Item receipts

As Walmart receives the inventory, the shipment status in Walmart changes from Working to Receiving, and then to Delivered when all items arrive. The Walmart delivered shipments to NetSuite item receipts (add) flow runs on a schedule and creates item receipts in NetSuite for partially or fully delivered shipments. It can create one or more item receipts per shipment, each linked to its child transfer order on the Related Records subtab. When a shipment is fully delivered, the transfer order status changes to Received.

Until item receipts are created for a transfer order, its inventory stays in the transit account. NetSuite imports partial item receipts only if the Advanced Bin/Numbered Inventory Management feature is enabled on the NetSuite Enable Features page.

Supported items and accounts

These item types are supported:

  • Inventory items
  • Matrix items
  • Serialized items
  • Lot numbered items
  • Assembly items

Kit items (a NetSuite limitation) and item aliases aren't supported.

The NetSuite transfer orders to Walmart inbound shipments (add) flow isn't supported for ICC-enabled or Box-enabled Walmart accounts, because Walmart doesn't make the PO API, the Preview External API, or inbound shipment creation through the WFS API available to Box-enabled accounts.

Prepare transfer orders in NetSuite

When you create a transfer order for Walmart:

  • For Custom form, select Standard Transfer Order.
  • For Status, select Pending Fulfillment. Transfer orders with the Pending Approval status don't meet the criteria of the Celigo Walmart Transfer Order Export Search.
  • Select the eTail channel and the Walmart Account.
  • Add the expected delivery date.

Each item on the transfer order needs:

  • A 12-digit product ID (UPC code) on the item record
  • An item description of up to 450 characters
  • An item name that matches the SKU

Configure and run the flows

  1. In the integration app, go to Settings > Shipments (TO) > Transfer Order.
  2. In NetSuite locations to pick up transfer orders, select one or more locations for Walmart to get the transfer orders from, and then select Save.
  3. Go to Flows > Shipments (TO), and turn on NetSuite transfer orders to Walmart inbound shipments (add) and Walmart delivered shipments to NetSuite item receipts (add).

  4. Select Run for each flow. The first time you run a flow, a prompt lets you sync historical records:

    • Automatic: Syncs data from the last flow run time.
    • Custom: Syncs data from a start date and time you choose.

Check the runs on Dashboard.

Related to