Articles in this section

Sync Walmart orders to NetSuite

Saikumar Rachamalla
Updated

The Walmart - NetSuite integration app imports your seller-fulfilled Walmart orders, and the customers who placed them, into NetSuite as sales orders, and then acknowledges each order in Walmart. This article explains how the order flow processes an order, how customers are matched, which order settings you can change, and how to import specific orders on demand. It's for integrator.io users who run the order flows day to day.

How the order flow works

The Walmart order to NetSuite order Add flow runs on a schedule. For each released seller-fulfilled order in Walmart, it runs these steps:

  • Get orders from Walmart: Retrieves released seller-fulfilled orders from Walmart.
  • Post Walmart customers to NetSuite: Creates or updates the customer record in NetSuite.
  • Post Walmart Seller Fulfilled orders to NetSuite: Creates the sales order in NetSuite from the Walmart order details.
  • Acknowledge order in Walmart: Confirms to Walmart that the order was received, and the order status in Walmart changes to Acknowledged.

Each sales order includes the line items, shipping, billing, customer, and tax information, the Walmart order identifiers, and the other details NetSuite needs for later order processing. You can find the orders in the Orders section of Walmart Seller Center and follow each run on the integration app's Dashboard.

When a Walmart order line has a quantity of more than one, NetSuite receives it as separate lines of the same item, each with a quantity of 1. This is how Walmart sends the order data, and it can't be changed.

The flow replaces three wrapper-based flows labeled (Deprecating on Sep 30, 2026): Walmart Order to NetSuite Order Add, Walmart Customer to NetSuite Customer Add, and Order Acknowledgement to Walmart. To switch to it, see Migrate the Walmart - NetSuite integration app to OAuth.

How customers are matched

The order flow brings the customer of each order into NetSuite:

  • If Default NetSuite customer for all Walmart orders has a value, every Walmart order is assigned to that NetSuite customer.
  • If it's empty, the flow checks for an existing NetSuite customer with the same identifiers, such as the email address. It attaches the order to the existing customer, or creates a new customer if there's no match.

New customers get a NetSuite customer ID based on the customer name. If NetSuite's auto-generated numbering for customers is off, a new customer with the same name as an existing one can't be created, and the order fails. For the fix, see Customer ID already exists error.

Order settings

These settings are under Settings > Order:

  • Ship Method Mapping (on Shipping): Maps Walmart ship methods to NetSuite ship methods. For details, see Map ship methods between Walmart and NetSuite.
  • On-demand order sync (on Orders): Up to 10 Walmart purchase order numbers, separated by commas. Saving runs the on-demand order flow.
  • Auto Acknowledge On Demand Orders: When selected, the integration app acknowledges the orders you import with On-demand order sync. Keep this cleared before you go live, and select it once you're live in production.
  • Add orders created after: Only orders created in Walmart after this date are imported into NetSuite.
  • Default NetSuite customer for all Walmart orders (on Customers): The internal ID of a NetSuite customer record to assign to all Walmart orders. Use it if you prefer to skip creating a new NetSuite customer record for each new Walmart order. Remove the ID to stop assigning orders to a default customer.

For the sales tax settings, see Configure sales tax for Walmart orders.

Import specific orders on demand

  1. In the integration app, go to Settings > Order > Orders.
  2. In On-demand order sync, enter up to 10 Walmart purchase order numbers, separated by commas.
  3. Select Save.

Saving runs the Walmart order to NetSuite order Add (on-demand sync) flow, which imports the orders. This flow runs only when you save order numbers; you can't schedule it. Its mappings follow the Walmart order to NetSuite order Add flow.

Exclude WFS orders from the on-demand sync

If you enter Walmart Fulfillment Services (WFS) order numbers in On-demand order sync, the on-demand flow imports them as well. To import only seller-fulfilled orders, add an input filter to the flow's order import:

  1. Open the Walmart order to NetSuite order Add (on-demand sync) flow.
  2. On the import that posts orders to NetSuite (walmart-order-import-adaptor), select Define options, and then select Input filter.
  3. In Rules, select record.shipNode.type. If it isn't available, add "shipNode": { "type": "WFSFulfilled" } to the record object in Input, and then select it.
  4. Select not equals, and enter WFSFulfilled.
  5. Select Save & close.

To import WFS orders, use the WFS flows. For details, see Sync Walmart Fulfillment Services orders to NetSuite.