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.
| Specification | Details |
|---|---|
| Feed Type | Dimension |
| Refresh Frequency | Daily |
| Data Grain | Catalog Item ID / eComm Prod ID |
| Incremental Data | Snapshot |
| File Format | orc, parquet |
| Target Refresh Time | Monday - Friday: 3:00 PM CST |
| History | NA |
Feed Structure
The following table provides the Product Dimensions structure.
| Sequence | Business Name | Technical Name | Data Type | Primary Key | Sensitive Metrics | DSS Mapping |
|---|---|---|---|---|---|---|
| 1 | Catalog Item ID / eComm Prod ID | catlg_item_id | Long | Y | - | - |
| 2 | Product Name | prod_nm | String | - | - | Item Name |
| 3 | Universal Product Code Number | ecomm_upc_nbr | String | - | - | - |
| 4 | Part of Bundle (Y/N) | kit_comp_ind | Short | - | - | Part of Bundle (Y/N) |
| 5 | Street Date | street_dt | Date | - | - | Street Date |
| 6 | Customer Average Rating Value | cust_ratg_avg_val | Decimal (4,3) | - | - | Curr Avg Customer Reviews |
| 7 | Customer Rating Count | cust_ratg_cnt | Long | - | - | Curr Avg Customer Rating |
| 8 | Put Eligibility Indicator | elig_put_ind | Short | - | - | PUT indicator |
| 9 | S2H Eligibility Indicator | elig_s2h_ind | Short | - | - | S2H Eligibility Indicator |
| 10 | Current Replenishment Flag | own_repl_ind | Short | - | - | Curr Replenishable Flag |
| 11 | CVI Have It Indicator | cvi_have_it_ind | Short | - | - | - |
| 12 | Current Display Status | lifecyc_status_nm | String | - | - | Curr Display Status |
| 13 | Offer Start Date | offr_start_dt | Date | - | - | Offer Start Date |
| 14 | Offer End Date | offr_end_dt | Date | - | - | Offer End Date |
| 15 | Current Lowest Ship Method | shpg_mthd_chrg_array | map<string, string> | - | - | Curr Lowest Ship Method |
| 16 | Current Price Display Code | price_type_nm | String | - | - | Curr Price Display Code |
| 17 | Current S2H Ship Charge | shpg_chrg_amt | Decimal (18,5) | - | - | Curr S2H Ship Charge |
| 18 | Walmart Order Department Number | rpt_hrchy_lvl1_id | Integer | - | - | Acct Dept Nbr |
| 19 | Omni Segment Number | omni_seg_nbr | Integer | - | - | - |
| 20 | Omni Segment Description | omni_seg_desc | String | - | - | - |
| 21 | Omni Department Number | omni_dept_nbr | Integer | - | - | - |
| 22 | Omni Department Description | omni_dept_desc | String | - | - | - |
| 23 | Omni Category Number | omni_catg_nbr | Integer | - | - | - |
| 24 | Omni Category Description | omni_catg_desc | String | - | - | - |
| 25 | Omni Category Group Number | omni_catg_grp_nbr | Integer | - | - | - |
| 26 | Omni Category Group Description | omni_catg_grp_desc | String | - | - | - |
| 27 | Omni Subcategory Number | omni_subcatg_nbr | Integer | - | - | - |
| 28 | Omni Subcategory Description | omni_subcatg_desc | String | - | - | - |
| 29 | Operational Company Code | op_cmpny_cd | String | - | - | - |
| 30 | Brand Name | brand_nm | String | - | - | Brand Name |
| 31 | Product Cost Own Amount | prod_cost_own_amt | Decimal (18,5) | - | Y | - |
| 32 | Product Cost Direct Store Vendor Amount | prod_cost_dsv_amt | Decimal (18,5) | - | Y | - |
| 33 | Components Country of Origin Name | cmpnt_cntry_of_orign_nm | String | - | - | Country of Origin |
| 34 | Primary Shelf Id | prmry_shelf_id | Integer | - | - | Shelf Number |
| 35 | Aerosol Indicator | aerosol_ind | Integer | - | - | Aerosol Indicator |
| 36 | Chemical Indicator | chem_ind | Short | - | - | Chemical indicator |
| 37 | Controlled Substance Indicator | cntrl_substance_ind | Short | - | - | Controlled Substance Indicator |
| 38 | CPSC Certificate Indicator | cpsc_cert_ind | Short | - | - | CPSC Indicator |
| 39 | Mercury Indicator | mercury_ind | Short | - | - | Mercury Indicator |
| 40 | Paper Wood Indicator | paper_wood_ind | Short | - | - | Paper/Wood Indicator |
| 41 | Pesticide Indicator | pesticide_ind | Short | - | - | Pesticide Indicator |
| 42 | Brand ID | brand_id | Integer | - | - | - |
| 43 | Brand Class Description | brand_class_desc | String | - | - | - |
| 44 | Battery Indicator | battery_ind | Integer | - | - | - |
| 45 | Battery Type Code | battery_type_cd | Integer | - | - | - |
| 46 | Battery Type Description | battery_type_desc | String | - | - | - |
©️Walmart | All Rights Reserved | Confidential