This report provides insights into performance data of seller’s catalog. Sellers can fetch top 100K items sorted in descending order by GMV through this report.
To get the Item Performance Report, call GET /v3/getReport and specify
itemPerformance for the
type query parameter, (e.g. https://marketplace.walmartapis.com/v3/getReport?type=itemPerformance ).
What’s in the report CSV file?
The Item Performance report is returned in a .CSV file, with report name listed in content-disposition header, (e.g. filename=10000000354_2016-01-15T23:09:54.438+0000.zip). Your Partner ID is attached to report as a prefix, (e.g. 10000000354) followed by file generation timestamp.
The API response provides the .csv file with the following information about your item performance:
|Product Name||Title of the product||String|
|Item ID||An identifier number that seller uses to identify the product||String|
|SKU ID||Unique identifier for the item||String|
|Super Department||Super department that the product belongs to||String|
|Department||Department that the product belongs to||String|
|Category||Category of this product||String|
|Sub Category||Sub category of this product||String|
|Brand||Name, term, design, or other feature that distinguishes one seller’s product from those of others. This can be the name of the company associated with the product.||String|
|GMV||Gross Merchandise Value. This is Authorized Sales minus Cancelled Sales||Float|
|Commission||The commission paid to Walmart, taken from GMV||Float|
|GMV-Commission||GMV minus Commission||Float|
|AUR||Average Unit Retail. This is (Authorized Sales – Canceled Sales)/ (Authorized Units – Canceled Units)||Float|
|Total Units||Authorized Units minus Cancelled Units||Integer|
|Cancelled Units||Total number of units cancelled||Integer|
|Cancelled Sales||Total sales that were cancelled||Float|
|Item Conversion Rate||Percentage of number of items that are converted into sales. This is total units sold divided by product visits||Float|
|Base Item Id||Unique item identifier||String|
|Total Product Visits||Number of times customers visited product details page||Integer|
|GMV Comp %||GMV comparison to last year GMV. This is (GMV TY – GMV LY)/GMV LY||Float|
|Authorized Orders||Total Purchase Orders that were placed and authorized||Integer|
|Authorized Units||Number of authorized units that were sold||Integer|
|Authorized Sales||Total authorized item sales||Float|
|Total LY GMV||Last year GMV of the product||Float|