Articles in this section

Understand Walmart - NetSuite Product Flow (ItemSpec 5.X)

Walmart is deprecating the ItemSpec 4.x APIs by August 31, 2025. To align with this change and ensure continued product listing functionality, a new template titled "Walmart - NetSuite Product Flow (ItemSpec 5.x)" has been introduced and is now available in the CeligoMarketplace. This flow enables Walmart sellers to list and maintain product data on Walmart using the latest Item Spec 5.x API.

Key functionality:

  • Aligned with Walmart’s ItemSpec 5.x API, which replaces the deprecated ItemSpec 4.x APIs (effective August 31, 2025).
  • Delivered outside the integration app as a standalone template for faster updates and independent management.
  • This flow is intended to replace the existing product flow within the Walmart–NetSuite integration app going forward.
  • Unlike the category-based setup used in the integration app, this template flow replaces it with a more flexible and granular product-type-based structure.
  • Supports over 6,600 unique Walmart Product Types.

Install Product flow (Template) from Marketplace

For detailed instructions on installing the Walmart - NetSuite Product Flow (ItemSpec 5.x) template, refer to Install Walmart - NetSuite Product flow (ItemSpec 5.X).

Understand the flows

After installing the template, go to the Flows tab. You’ll see three categories:

  1. Product sync
  2. Migration (One-time)
  3. First-time Setup

    Und_Img1.png

First-time Setup

If you're installing and setting up the product template for the first time, start by configuring the Walmart – NetSuite integration app ID (for migration only) and Walmart – NetSuite Integration App Account ID or Name fields on the Settings page.

Understand_img_2.PNG

Once these fields are configured, run the Auto-configure Pre-requisites flow under First-time Setup to complete the initial configuration.

Und_img3.png

This flow automatically creates the required saved search in NetSuite, which is then linked to the NetSuite Item to Walmart Item Add/Update flow.

Und_img_4.png

Migration (One-time)

For detailed instructions on migrating from the integration app product flow to the Walmart - NetSuite Product Flow (ItemSpec 5.x), refer to Migrate to Walmart - NetSuite Product Flow (ItemSpec 5.X).

Und_img5.png

Product sync

In the Product sync, there are two flows: 

  1. Add attribute mappings for Product Types specified in Settings 
  2. NetSuite Item to Walmart Item Add/Update

    Und_img6.png

When you run the Add attribute mappings for Product Types specified in Settings flow, it fetches the product type spec and the latest attribute mappings from Walmart for all product types defined in the Settings > Product Types for listing field. The Get Product flow imports lookup then retrieves the import bubbles from the NetSuite Item to Walmart Item Add/Update flow. The Add/update mappings to Product flow import then adds or updates the mappings to the import bubbles based on validation results.

The NetSuite Item to Walmart Item Add/Update flow allows you to export an item from NetSuite into Walmart. Whenever an item is created or updated in NetSuite, the flow exports the details of that item as a product on Walmart. 

The Get Items from NetSuite export retrieves items from NetSuite. The Check item listing status on Walmart lookup then checks whether each item is already listed on Walmart. The Get product type spec for Walmart lookup fetches the product type specification for additional validation.

If an item is not listed on Walmart, the List a new item in Walmart import adds the item. If the item is already listed, the Update item details for existing Walmart listing import checks for changes and updates the item accordingly.

Und_img_15.png

The Get product type spec for Walmart lookup attempts to fetch the product type specification for items marked as both Listed: Yes and Listed: No. The product types and item details are derived from the NetSuite item record. You may have already selected the product type using the custom field in NetSuite called Walmart Product Type

Und_img7.png

Mappings

The following mappings are available by default in both the List a new item in Walmart and Update item details for existing Walmart listing imports. While the field mappings in List a new item in Walmart and Update item details for existing Walmart listing are the same, they are not linked to each other.

Default mappings:  

  • MPItemFeedHeader

    • BusinessUnit
    • Locale
    • Version
  • MPitem

    • Visible
    • Orderable
  • Schema
  • ProductType

Important

Avoid deleting or modifying the schema and product type mappings, as this may affect flow functionality.

Und_img8.png

Under Visible, the mappings for the Walmart product types specified in Settings > Product Types for listing will appear only after you run the Add attribute mappings for Product Types specified in Settings flow.

Und_img9.png

Important

Always configure the source (NetSuite) field mappings in both the 'List a new itemin Walmart' and 'Update item details for existing Walmartlisting' imports.

Note

To delete a product type, you must delete it from both the mappings and Settings. Deleting a product type from Settings alone will not remove it from the existing mappings.

Configure settings in NetSuite

Prerequisites

  • Ensure that the Walmart Product Type field is populated on the NetSuite item record.
  • Ensure that your NetSuite bundle is up to date. If it is not, contact Celigo Support for assistance.

Populate Walmart Product Type field:

  1. Log in to your NetSuite account.
  2. Search and find the required item in the Global search, and click Edit.
  3. Navigate to the eTail > Walmart tab.
  4. In the Walmart Product Type field, enter the product type you want to add.
  5. Click Save

    Und_img10.png

Configure flow settings

Before you run the flow, navigate to Settings > General and configure settings:

  1. In the Walmart Item Spec Version field, enter the version used to list items on Walmart. To view version history or check for the latest available version, refer to Walmart ItemSpec Versions. By default, the latest supported version is pre-filled.
  2. In the Product Types for listing field, enter one or more product types, separated by commas. The mappings for the specified product types will be added or updated in the product flow only after you run the Add attribute mappings for Product Types specified in Settings flow. 
  3. Enable the Advanced attribute cleanup setting to allow the flow to remove irrelevant mapped fields by referencing the Walmart Item Spec schema before submitting data to Walmart.

    Und_img11.png
  4. In the Walmart - NetSuite integration app ID (for migration only) field, enter the integration ID of your existing Walmart - NetSuite integration app. This is required only during the integration app migration. You can find the app ID in the integration app URL.

    Note

    Once you fill the Walmart – NetSuite integration app ID (for migration only) field, the Walmart – NetSuite integration app Account ID or Name field will appear.

    Und_img_12.png
  5. In the Walmart – NetSuite integration app Account ID or Name field, enter the Account ID or Account Name associated with your Walmart – NetSuite integration app. You can find this information in the integration app under Settings > General > Walmart Account Name.

    Und_img13.png

Run the flow

  1. By default, the NetSuite Item to Walmart Item Add/Update flow is disabled. To enable it, click the On/Off toggle and select Enable.
  2. After you enable the flow, click Run.
  3. If you run the flow for the first time, a delta flow pop-up window is displayed. This helps you sync the historical records. 

    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.

      Und_img14.png
  4. Click Run.

You can find the flow status in the Run console. 

Common Item Spec 5.x errors and resolutions

Q1: What does the “Validation Error – Closed List” mean?

Error: "color","containerType","count","machine_and_tool_lubricant_type","features","manufacturerPartNumber","countPerPack","multipackQuantity","vehicleYear","flashPoint","size","vehicleModel","modelNumber","vehicleType" 'Size' is not a valid Unit for the 'variantAttributeNames' field. Select a valid value from the drop-down list: [color,containerType,count,machine_and_tool_lubricant_type,features,manufacturerPartNumber,countPerPack,multipackQuantity,vehicleYear,flashPoint,size,vehicleModel,modelNumber,vehicleType]. Size

Reason: Certain attributes are closed-list in nature, meaning their values must be selected from a predefined set of options. Sellers should ensure the value they provide matches one of the approved options in the closed list.

Resolution: Select a valid value from the dropdown list of approved options in Walmart Seller Center.

Q2: What does the “Validation Error – Min/Max Length” mean?

Error: ‘productName' is a required field with a minimum length of '10' characters. Enter a 'productName.'

Reason: This error occurs when the entered value does not meet the required character length for specific attributes.

Resolution: Ensure the value meets the attribute’s defined minimum or maximum character length (for example, productName must be at least 10 characters).

Q3: What does the “Invalid Product ID Error” mean?

Error: You cannot use this SKU because it was previously used with a different GTIN. You had created a SKU with this ID and later changed it to another ID. This SKU is being used as a reference ID for previously created SKU in your catalog. Please set up the item with a unique SKU ID. For more details, review this Help article: https://sellerhelp.walmart.com/s/guide?article=000007896

Reason: This error occurs when the GTIN provided by the seller is invalid or has already been used. Walmart verifies GTINs to confirm their validity and does not allow reuse of SKUs previously linked to different GTINs.

Resolution: Use a unique SKU and a valid GTIN. For more details, refer to Walmart's help article.