Product Dim Details & Structure

The Product Dimensions Data Feed API provides information about the attributes for a given Walmart.com-only product, including hierarchy, ratings, and status. This data feed is the latest snapshot and contains only the attributes related to the products supplied to Walmart as of the current date. If there are items that were historically supplied to Walmart that are no longer being supplied as of the current date, then the attributes related to those items are not sent in the feed.

Endpoints

GET
/v2/bulkfeeds/snapshot/productdimensions

Feed Details

The following table provides the Product Dimensions details.

SpecificationDetails
Feed TypeDimension
Refresh FrequencyDaily
Data GrainCatalog Item ID / eComm Prod ID
Incremental DataSnapshot
File Formatorc, parquet
Target Refresh TimeMonday - Friday: 3:00 PM CST
HistoryNA

Feed Structure

The following table provides the Product Dimensions structure.

SequenceBusiness NameTechnical NameData TypePrimary KeySensitive MetricsDSS Mapping
1Catalog Item ID / eComm Prod IDcatlg_item_idLongY--
2Product Nameprod_nmString--Item Name
3Universal Product Code Numberecomm_upc_nbrString---
4Part of Bundle (Y/N)kit_comp_indShort--Part of Bundle (Y/N)
5Street Datestreet_dtDate--Street Date
6Customer Average Rating Valuecust_ratg_avg_valDecimal (4,3)--Curr Avg Customer Reviews
7Customer Rating Countcust_ratg_cntLong--Curr Avg Customer Rating
8Put Eligibility Indicatorelig_put_indShort--PUT indicator
9S2H Eligibility Indicatorelig_s2h_indShort--S2H Eligibility Indicator
10Current Replenishment Flagown_repl_indShort--Curr Replenishable Flag
11CVI Have It Indicatorcvi_have_it_indShort---
12Current Display Statuslifecyc_status_nmString--Curr Display Status
13Offer Start Dateoffr_start_dtDate--Offer Start Date
14Offer End Dateoffr_end_dtDate--Offer End Date
15Current Lowest Ship Methodshpg_mthd_chrg_arraymap<string, string>--Curr Lowest Ship Method
16Current Price Display Codeprice_type_nmString--Curr Price Display Code
17Current S2H Ship Chargeshpg_chrg_amtDecimal (18,5)--Curr S2H Ship Charge
18Walmart Order Department Numberrpt_hrchy_lvl1_idInteger--Acct Dept Nbr
19Omni Segment Numberomni_seg_nbrInteger---
20Omni Segment Descriptionomni_seg_descString---
21Omni Department Numberomni_dept_nbrInteger---
22Omni Department Descriptionomni_dept_descString---
23Omni Category Numberomni_catg_nbrInteger---
24Omni Category Descriptionomni_catg_descString---
25Omni Category Group Numberomni_catg_grp_nbrInteger---
26Omni Category Group Descriptionomni_catg_grp_descString---
27Omni Subcategory Numberomni_subcatg_nbrInteger---
28Omni Subcategory Descriptionomni_subcatg_descString---
29Operational Company Codeop_cmpny_cdString---
30Brand Namebrand_nmString--Brand Name
31Product Cost Own Amountprod_cost_own_amtDecimal (18,5)-Y-
32Product Cost Direct Store Vendor Amountprod_cost_dsv_amtDecimal (18,5)-Y-
33Components Country of Origin Namecmpnt_cntry_of_orign_nmString--Country of Origin
34Primary Shelf Idprmry_shelf_idInteger--Shelf Number
35Aerosol Indicatoraerosol_indInteger--Aerosol Indicator
36Chemical Indicatorchem_indShort--Chemical indicator
37Controlled Substance Indicatorcntrl_substance_indShort--Controlled Substance Indicator
38CPSC Certificate Indicatorcpsc_cert_indShort--CPSC Indicator
39Mercury Indicatormercury_indShort--Mercury Indicator
40Paper Wood Indicatorpaper_wood_indShort--Paper/Wood Indicator
41Pesticide Indicatorpesticide_indShort--Pesticide Indicator
42Brand IDbrand_idInteger---
43Brand Class Descriptionbrand_class_descString---
44Battery Indicatorbattery_indInteger---
45Battery Type Codebattery_type_cdInteger---
46Battery Type Descriptionbattery_type_descString---

©️Walmart | All Rights Reserved | Confidential