Configure settings for Walmart Fulfillment Services orders

Contents

• General
• Shipping
• Orders
• Customers

Before running data flows, you may want to set up the data flow and save the settings.

You can customize the order settings as described below:

• Filter orders based on the time of their creation, duration in days, or order status.
• Map the shipping methods between the systems.
• Configure how you can import the orders and customer information from Walmart to NetSuite before you run the data flow.

General

The General tab present under Settings > Order (WFS) contains the following fields that let you control the way orders are synced to NetSuite from Walmart.

• Sync Walmart Fulfillment Services orders as: Syncs the Walmart Fulfillment Services orders with the NetSuite transaction type selected in this setting. The Walmart Fulfillment Services orders with the delivered status are synced to NetSuite. You can sync orders as:
  • Cash sale: Sync orders as a cash sale when the sales order is fully paid.
    If you select this option, the Select inventory location present in NetSuite setting will appear to select the inventory location in NetSuite.
  • Invoice: Sync orders as an invoice by using the settlement flows. You can choose this option if there is an open balance awaiting payment and that this amount will be paid by Walmart during the settlement process. The payments received during the settlement process are reconciled with the outstanding amount added to the invoice.
    If you select this option, the Select inventory location present in NetSuite setting will appear to select the inventory location in NetSuite.
  • Sales order: Sync orders as a sales order if it is already fulfilled. If you select this option, you must fulfill the order in NetSuite manually and run the auto-billing flow - NetSuite Order to NetSuite CashSale Add or NetSuite Order to NetSuite Invoice Add flow depending on the payment type for the order - to sync the order as invoice or cash sale.
    

    Important: The Sales order should not be qualified for fulfillment as the order will already have been fulfilled.

• Select inventory location present in NetSuite: Select the inventory or fulfillment location. You can see the selected location on the NetSuite order at body-level and line-level.
  This setting is enabled only if you choose the transaction type as Invoice or Cash Sale in the Sync Walmart Fulfillment Services orders as setting.

Shipping

The Shipping tab present under Settings > Order (WFS) lets you map the shipping methods between Walmart and NetSuite. You can also provide a default shipping method to be used in case no match is found.

1. Click the Map Ship Methods accordion to map the shipping methods between Walmart and NetSuite.
2. Select the shipping methods in Walmart in the Walmart Ship Method setting. Click Refresh () adjacent to the setting if no options are displayed when you click on the setting.
3. Select the shipping method in NetSuite in the NetSuite Ship Method setting. This selection will be mapped to the selection made in the Walmart Ship Method setting. Click Refresh () adjacent to the settings if no options are displayed when you click on the setting.
4. If no match is found for the shipping method values entered in the Walmart Ship Method and NetSuite Ship Method settings, you can use one of the options in the Action to take if unique match not found section to select and map the shipping method:
   • Fail record: Select this option if you want an error message to be displayed when a new value is selected in the Walmart Ship Method setting and a corresponding value is not selected in the NetSuite Ship Method setting.
   • Use Empty String as Default Value: Select this option when you want to use the empty string as default value. If this option is selected, records with empty values (no shipping method has been selected) will be synced without any error message being displayed. If the shipping method is required to be selected (which is usually the case in NetSuite), then this option should not be selected.
   • Use Null as default value: Select this option if you wish to use null as default value. If this option is selected, records with null values (for example, records where data is entered by pressing the spacebar key on the keyboard or junk data has been entered) will be synced without any error message being displayed. If the shipping method is required to be selected (which is usually the case in NetSuite), then this option should not be selected.
   • Use Custom Default Value: Select this option when a shipping method is not mapped in the Map Ship Methods accordion and you want NetSuite to assign the shipping method to the selected default value in this option. If this option is selected, the Default Lookup Value setting will appear. You need to select the default value from the options available in the setting. The options that appear in this setting need to be created in NetSuite.

Recommended Practice:

Since the shipping will already have been done for WFS orders, you can select the Use Custom Default Value option and add a generic shipping method (created in NetSuite) like Walmart Fulfillment Services Shipping in the Default Lookup Value setting, as shown in the image below and click Save to set it as the default shipping method.

Orders

The Orders tab present under Settings > Order (WFS) lets you control the orders that can be synced from Walmart to NetSuite.

• Walmart Fulfillment Services order IDs: This setting is used to control the orders that can be synced from Walmart to NetSuite. This setting is mostly used for selecting the orders that are synced using the Walmart (WFS) order to NetSuite order (add) (on-demand sync) flow. You can provide up to 10 Walmart Fulfillment Services order IDs in this setting, but each order ID must be separated by a comma.The order IDs in this setting will trigger the Walmart (WFS) order to NetSuite order (add) (on-demand sync) flow.
  
  Note:

  • The Walmart (WFS) order to NetSuite order (add) (on-demand sync) flow syncs orders with any order status (including orders that are not in delivered status) to NetSuite.
  • If you enter Walmart seller fulfilled order IDs or invalid order IDs in the Walmart Fulfillment Services order IDs setting, an error message will be displayed.
• Sync historical Walmart Fulfillment Services orders: Check this box to sync Walmart Fulfillment Services orders older than seven days. Select the historical date and time in the Sync Walmart Fulfillment Services orders date setting. If you uncheck this setting, by default, only the orders for the last seven days are synced to NetSuite.
  This setting is helpful when syncing bulk order data older than seven days.
• Sync Walmart Fulfillment Services orders date: Select the date and time from which the Walmart Fulfillment Services orders need to be synced to NetSuite in this setting. This setting will only be available if you have checked the Sync historical Walmart Fulfillment Services orders setting.

Customers

You can configure how the customers are synced to NetSuite using the Customers tab present under Settings > Order (WFS).

• Allocate Walmart Fulfillment Service orders to these NetSuite customers: Provide the internal ID(s) of NetSuite customers in a comma-separated format. Based on the number of customer IDs you provide, during order sync to NetSuite, the Walmart Fulfillment Service orders are equally allocated among the mentioned customers. This setting lets you skip the creation of new customer records in NetSuite for each new order from Walmart.
  If this setting is blank, the customer data of the Walmart Fulfillment Services order will be synced to NetSuite. A duplicate check will be done for all the customer data to check if there is an existing customer record in NetSuite. If a customer record exists in NetSuite, the Walmart Fulfillment Services order will be mapped to the existing customer record. If there is no match for existing customers, a new customer record will be created in NetSuite and the Walmart Fulfillment Services order will be mapped to it.

Related articles

• Sync Walmart Fulfillment Services orders