Request an assortment recommendations report

Use the assortment recommendations report to find items with strong demand where selection is limited. This report helps you identify high potential products to expand your catalog responsibly.

Endpoint

POST https://marketplace.walmartapis.com/v3/reports/reportRequests

Sample request

POST https://marketplace.walmartapis.com/v3/reports/reportRequests
Authorization: Bearer <access_token>
WM_QOS.CORRELATION_ID: <guid>
WM_SVC.NAME: Walmart Marketplace
Content-Type: application/json { "reportType": "ASSORTMENT_RECOMMENDATIONS", "format": "CSV", "rowFilters": { "multiValueFilter": { "parameter": "BRAND", "values": ["Acme", "Contoso"] }, "enumFilter": { "parameter": "ITEM_AVAILABILITY_STATUS", "values": ["EXISTING_IN_WALMART", "NEW_TO_WALMART"] }, "rangeFilter": { "parameter": "PRICE", "floorValue": 10.0, "ceilingValue": 50.0 } }
}

Track and download

  1. Track status with GET /v3/reports/reportRequests/{requestId}. Status values are RECEIVED, INPROGRESS, READY, and ERROR.
  2. When status is READY, download the file with GET /v3/reports/downloadReport?requestId={requestId}.

Filters

Use the same filter envelope used by other on request reports. Examples below show each filter type in isolation.

Multi value filter

{ "rowFilters": { "multiValueFilter": { "parameter": "CATEGORY", "values": ["Electronics", "Home"] } }
}

Parameters commonly supported include BRAND, CATEGORY, and PRODUCT_TYPE. Provide up to seven values. Values must not be empty. The service applies OR logic across values.

Enum filter

{ "rowFilters": { "enumFilter": { "parameter": "ITEM_AVAILABILITY_STATUS", "values": ["EXISTING_IN_WALMART", "NEW_TO_WALMART"] } }
}

Other enum filter parameters may include SHOPPING_TRENDS and DEMAND_SALES_TRENDS. Confirm the exact list on the report types page.

Range filter

{ "rowFilters": { "rangeFilter": { "parameter": "PRICE", "floorValue": 10.0, "ceilingValue": 50.0 } }
}

Limits

  • Rate limit is two calls per seller per hour for this report type.

Report fields

CSV header names are case sensitive. Use the Header (CSV) column when parsing.

Header (CSV)Description
ItemRecommendationUniqueIdUnique identifier for each recommendation.
ItemNameName of the recommended item.
BrandBrand of the recommended item.
CategoryCategory of the recommended item.
PriceCurrencyCurrency used for displayed prices.
ItemAvailabilityStatusWhether the item is new to Walmart or already exists on Walmart.
GTINGlobal Trade Item Number if available.
UPCUniversal Product Code if available.
ISBNInternational Standard Book Number if available.
EANEuropean Article Number if available.
WalmartItemIdWalmart item identifier for existing items.
WalmartUrlProduct URL on Walmart for existing items.
WalmartItemPriceCurrent item price on Walmart.
WalmartShippingPriceShipping price on Walmart.
WalmartTotalPriceItem price plus shipping price on Walmart.
WfsIndicatorWhether the item is eligible for WFS.
CompetitorItemIdCompetitor marketplace item identifier.
CompetitorUrlCompetitor marketplace product URL.
CompetitorItemPriceCurrent item price on the competitor.
CompetitorShippingPriceShipping price on the competitor.
CompetitorTotalPriceItem price plus shipping price on the competitor.
PotentialSalesEstimated annual revenue band across sellers.
ShoppingTrendsDemand types such as Most Searched For, Best Sellers, and Deal Items.
ProductTypeProduct type useful for setup and categorization.
PotentialSalesRankRank from one to ten indicating relative potential.
DemandSalesTrendsMonths ordered by demand such as JAN, FEB, MAR.
WeeklyDemandTrendsWeekly demand vector such as w1:0.16 to w52:0.21.
MonthlyDemandTrendsMonthly demand vector such as jan24:0.34 to dec24:0.29.
OffersCountTotal number of offers on Walmart.
SearchKeywordsPopular customer search terms related to the item.
WeeklyPriceTrendsWeekly price history up to fifty two weeks.
MonthlyPriceTrendsMonthly price history up to twelve months.

Next steps