Articles in this section

Sync Walmart orders to NetSuite orders

Overview

The Walmart order to NetSuite order Add flow imports Walmart orders and associated customer information into NetSuite. When a seller-fulfilled order is created in Walmart, integrator.io retrieves the order, creates or updates the corresponding NetSuite customer record, creates a NetSuite Sales Order, and then acknowledges the order in Walmart.

During processing, the integration evaluates the customer information associated with the order. If a matching customer record already exists in NetSuite, the existing record is used. If no matching customer is found, a new customer record is created before the order is created in NetSuite.

Order flow process

Whenever an order is created in Walmart, the integration app automatically transfers the order information into NetSuite. The following steps describe how the integration processes the order.

  • Get orders from Walmart: Retrieves released seller-fulfilled orders from Walmart.
  • Post Walmart customers to NetSuite: Creates or updates the corresponding customer record in NetSuite.
  • Post Walmart Seller Fulfilled orders to NetSuite: Creates the Sales Order in NetSuite using the Walmart order details.
  • Acknowledge order in Walmart: Confirms that the order has been received and processed in NetSuite.

You can monitor the flow status in the integrator.io dashboard and view the transferred order information in NetSuite.

Flow_details_WALNS.png

Order information imported into NetSuite

The integration transfers order details from Walmart to NetSuite. The following information is typically imported as part of the order flow.

  • Line items
  • Shipping information
  • Billing information
  • Customer information
  • Tax information
  • Order identifiers and metadata
  • Any other information required for subsequent order processing in NetSuite

Receive an Order in Walmart

Orders placed in Walmart Seller Center are retrieved by the integration flow and processed before being acknowledged. The orders are visible in the Orders section of Walmart Seller Center.

Walmart_Dashboard.png

Set up flow in integrator.io

Before importing an order from Walmart to NetSuite, the integration app enables you to set up the criteria for import (what type of orders you would like to import). For example, you can filter orders based on order status, start date, date range, etc.  You can also bring in specific orders based on order IDs. Provide a comma-separated list of orders in the Advanced Settings text box. The integration app also imports customer information associated with the orders into NetSuite. All orders are assigned to a default customer.

Flow schedule and settings

The integration app has options to control and configure the order flow. The flow is prebuilt, but you can modify the flow schedule or revise the mapping between the fields in Walmart and NetSuite.

Flows can be triggered manually using the Run button. The Settings option allows you to configure flow properties.

  1. order import data flow
  2. turn on or turn off data flow
  3. run data flow (click ‘Play’ button)
  4. schedule flow
  5. modify field mappings
  6. advanced settings

Data Flow Dashboard

The status of the flow can be monitored in the integrator.io dashboard.

The dashboard provides visibility into the execution status of the flow and displays any processing errors.

Options:

  1. status of flow is displayed (using color codes)
  2. displays the number of successful data exports
  3. displays the number of errors

Errors can be reviewed and resolved directly from the dashboard. Click on an error entry to view detailed information and available resolution options.

Settings for Walmart Order to NetSuite Order Add Flow

  • Map Ship Method Mappings: Refer to the topic Ship Method Mappings.
  • Walmart Order IDs: Provide up to 10 purchase order numbers separated by a comma (,). Click Save to perform an on-demand sync of orders from Walmart to NetSuite. 
  • Auto-acknowledge On-Demand Orders: If checked, the integration app auto-acknowledges orders that are imported using the 'Walmart Order Id(s)'. The recommended approach is to keep this box unchecked before you go live with the integration app & keep it checked once live in Production.
  • Add Orders Created After Lets you define the order creation date in Walmart, only after which the orders should be imported into NetSuite.
  • Enter default NetSuite customer (internal ID): Provide the internal ID of the default NetSuite customer record to be assigned to all the Walmart orders imported into NetSuite. To disable this defaulting behavior, simply remove the customer ID from the text box.