The Item Attributes Data Feed API provides Walmart item attribute information, including hierarchy, descriptions, and status. This data feed is the latest snapshot and contains only the attributes related to the items 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/itemattributes

Feed Details

The following table provides the Item Attributes details.

Specification	Details
Feed Type	Dimension
Data Grain	Walmart Item Number, Operational Company Code
Refresh Frequency	Daily
Incremental Data	Snapshot
File Format	orc, parquet
Target Refresh Time	Monday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST
History	NA

Feed Structure

The following table provides the Item Attributes structure.

Sequence	Business Name	Technical Name	Data Type	Primary Key	Sensitive Metrics	DSS Mapping
1	Walmart Item Number	wm_item_nbr	Long	Y	-	Walmart Item Number
4	Operational Company Code	op_cmpny_cd	String	Y	-	-
2	Store Item ID	mds_fam_id	Long	-	-	Item Nbr
3	Catalog Item ID/ eComm Prod ID	catlg_item_id	Long	-	-	Item ID
5	Vendor Number	vendor_nbr	Integer	-	-	Vendor Nbr
6	Accounting Department Number	acctg_dept_nbr	Integer	-	-	Acct Dept Nbr
7	Item Status Code	item_status_cd	String	-	-	Item Status
8	Item Name	item_name	String	-	-	Item Name
9	Fineline Description	fineline_desc	String	-	-	Fineline Description
10	Item Create Date	item_create_dt	Date	-	-	Item Start Date
11	Item End Date	obsolete_dt	Date	-	-	Item End Date
12	Item Type Code	item_type_cd	Integer	-	-	Item Type Code
13	Universal Product Code Number	wm_upc_nbr	Long	-	-	UPC
14	Walmart UPC Description	wm_upc_desc	String	-	-	UPC Desc
15	Item Type Description	item_type_desc	String	-	-	-
16	All Links Item Description	all_links_item_desc_1	String	-	-	Prime Item Desc
17	All Links Item Number	all_links_item_nbr	Integer	-	-	-
18	All Links Store Item Id	all_links_mds_fam_id	Integer	-	-	-
19	Base Unit Retail Amount	base_unit_rtl_amt	Decimal (11,2)	-	-	Unit Retail
20	Never Out Indicator	never_out_ind	Integer	-	-	Never Out Flag
21	Warehouse Min Order Quantity	whse_min_order_qty	Integer	-	-	Min Order Qty
22	Pallet HI Quantity	pallet_hi_qty	Integer	-	-	Pallet Hi Qty
23	Pallet UPC Number	pallet_upc_nbr	Long	-	-	Pallet UPC
24	Warehouse Pack Quantity	whpk_qty	Integer	-	-	Warehouse Pack Qty (Owned Only)
25	Warehouse Alignment Type Description	whse_algn_type_desc	String	-	-	-
26	Warehouse Pack Length Quantity	whpk_len_qty	Decimal (9,3)	-	-	WHPK Length
27	Warehouse Pack Width Quantity	whpk_wdth_qty	Decimal (9,3)	-	-	-
28	Warehouse Pack Cubic Quantity	whpk_cube_qty	Decimal (9,3)	-	-	WHPK Cubic Ft
29	Warehouse Pack Height Quantity	whpk_ht_qty	Decimal (9,3)	-	-	WHPK Height
30	Vendor Department Number	vendor_dept_nbr	Integer	-	-	Vendor Nbr Dept
31	Vendor Minimum Order Quantity	vndr_min_order_qty	Integer	-	-	Vndr Min Ord Qty
32	Vendor Pack Quantity	vnpk_qty	Integer	-	-	VNPK Qty
33	Vendor Pack Weight Quantity	vnpk_wt_qty	Decimal (18,4)	-	-	Vendor Pack Weight
34	Vendor Pack Length Quantity	vnpk_len_qty	Decimal (9,3)	-	-	VNPK Length
35	Vendor Pack Width Quantity	vnpk_wdth_qty	Decimal (9,3)	-	-	VNPK Width
36	Vendor Pack Height Quantity	vnpk_ht_qty	Decimal (9,3)	-	-	VNPK Height
37	Vendor Sequence Number	vendor_seq_nbr	Integer	-	-	Vendor Sequence Nbr
38	Omni Segment Number	omni_seg_nbr	Integer	-	-	-
39	Omni Segment Description	omni_seg_desc	String	-	-	MDSE Segment Description
40	Omni Department Number	omni_dept_nbr	Integer	-	-	Acct Dept Nbr
41	Omni Department Description	omni_dept_desc	String	-	-	Dept Desc
42	Omni Category Number	omni_catg_nbr	Integer	-	-	Category Nbr
43	Omni Category Description	omni_catg_desc	String	-	-	Dept Category Description
44	Omni Category Group Number	omni_catg_grp_nbr	Integer	-	-	-
45	Omni Category Group Description	omni_catg_grp_desc	String	-	-	Dept Category Group Description
46	Omni Subcategory Number	omni_subcatg_nbr	Integer	-	-	-
47	Omni Subcategory Description	omni_subcatg_desc	String	-	-	Dept Subcategory Description
48	Vendor Stock ID	vendor_stock_id	String	-	-	Vendor Stock ID
49	Vendor Name	vendor_nm	String	-	-	Vendor Name
50	Brand Owner Name	brand_ownr_nm	String	-	-	Brand Owner Name
51	Brand Name	brand_nm	String	-	-	Brand Name
52	Brand ID	brand_id	Integer	-	-	Brand ID
53	Brand Family Name	brand_fam_nm	String	-	-	Brand Family Name
54	Brand Family ID	brand_fam_id	Integer	-	-	Brand Family ID
55	Brand Owner ID	brand_ownr_id	Integer	-	-	Brand Owner ID
56	Vendor Pack Cost Amount	vnpk_cost_amt	Decimal (13,4)	-	Y	Reg VNPK Cost
57	Warehouse Pack Unit Cost	whpk_unit_cost	Decimal (13,4)	-	Y	WHPK Cost
58	Item Description 2	item_desc_2	String	-	-	Item Desc 2
59	Color Description	color_desc	String	-	-	Color Desc
60	Size Description	size_desc	String	-	-	Size Desc
61	Replenishment Subtype Code	repl_subtype_cd	Integer	-	-	Item Sub Type
62	Replenishment Subtype Description	repl_subtype_desc	String	-	-	-
63	Item Length Quantity	item_len_qty	Decimal (9,3)	-	-	Item Length
64	Item Height Quantity	item_ht_qty	Decimal (9,3)	-	-	Item Height
65	Item Width Quantity	item_wdth_qty	Decimal (9,3)	-	-	Item Width
66	Item Cube Quantity	item_cube_qty	Decimal (9,3)	-	-	-
67	Item Cube Unit of Measure Code	item_cube_uom_cd	String	-	-	-
68	Item Cube Unit of Measure Description	item_cube_uom_desc	String	-	-	-
69	Item Order Effective Date	item_order_eff_dt	Date	-	-	Effective Date
70	Sell Quantity	sell_qty	Decimal (9,4)	-	-	UOM Sell Qty
71	Sell Unit of Measure Code	sell_uom_cd	String	-	-	UOM Code
72	Sell Unit of Measure Description	sell_uom_desc	String	-	-	-
73	Pallet Ti Quantity	pallet_ti_qty	Integer	-	-	Pallet Ti Qty
74	Vendor Pack Cube Quantity	vnpk_cube_qty	Decimal (9,3)	-	-	VNPK Cubic Ft
75	Vendor Pack Cube Unit of Measure Code	vnpk_cube_uom_cd	String	-	-	-
76	Vendor Pack Cube Unit of Measure Description	vnpk_cube_uom_desc	String	-	-	-
77	Vendor Case Pack Code	vnpk_cspk_cd	String	-	-	-
78	Vendor Case Pack Description	vnpk_cspk_desc	String	-	-	-
79	Warehouse Pack UPC Number	whpk_upc_nbr	Long	-	-	WHPK UPC
80	Warehouse Pack Weight Quantity	whpk_wt_qty	Decimal (11,4)	-	-	Whse Pack Weight
81	Warehouse Pack Weight Unit of Measure Code	whpk_wt_uom_cd	String	-	-	UOM Code
82	Warehouse Pack Weight Unit of Measure Description	whpk_wt_uom_desc	String	-	-	-
83	Order Sizing Factory Quantity	order_sizng_fctr_qty	Decimal (9,3)	-	-	Cubic Order Sizing Factor
84	Replenishment Unit Indicator	repl_unit_in d	Integer	-	-	Replenish Unit Ind
85	Replenishment Group Number	repl_group_nbr	Long	-	-	Consumer ID
86	Fineline Number	fineline_nbr	Integer	-	-	Fineline Number
87	Geographic Region Code	geo_region_cd	String	-	-	-
88	Base Division Number	base_div_nbr	Integer	-	-	-
89	Buyer Reporting Position ID	buyr_rpt_postn_id	Integer	-	-	-
90	Warehouse Pack Calculation Method Description	whpk_calc_mthd_desc	String	-	-	-
91	Planner Reporting Position ID	plnr_rpt_postn_id	Integer	-	-	-
92	Accounting Department Description	acctg_dept_desc	String	-	-	Acct Dept Nbr
93	Country Name	cntry_nm	String	-	-	-
94	Item Status Description	item_status_desc	String	-	-	Item Status
95	Prime Item Number	prime_xref_item_nbr	Integer	-	-	-
96	Prime MDS Fam ID	prime_xref_mds_fam_id	Integer	-	-	-
97	Prime Lia Item Number	prime_lia_item_nbr	Integer	-	-	-
98	Prime Lia MDS Fam ID	prime_lia_mds_fam_id	Integer	-	-	-
99	Warehouse Alignment Type Code	whse_algn_type_cd	String	-	-	Whse Align
100	Warehouse Area Code	whse_area_cd	Integer	-	-	-
101	Warehouse Area Description	whse_area_desc	String	-	-	-
102	Warehouse Rotation Code	whse_rotation_cd	Integer	-	-	-
103	Warehouse Rotation Description	whse_rotation_desc	String	-	-	-
104	Warehouse Pack Calculation Method Code	whpk_calc_mthd_cd	String	-	-	-
105	Warehouse Pack Sell Amount	whpk_sell_amt	Decimal (13,4)	-	-	-
106	Price Look Up Number	plu_nbr	Integer	-	-	-
107	Consumer Item Number	cons_item_nbr	Integer	-	-	-
108	Consumer Item Description	cons_item_desc	String	-	-	-
109	Product Number	prod_nbr	Integer	-	-	-
110	Product Description	prod_desc	String	-	-	Product Description
111	Customer Base Unit Retail Amount	cust_base_rtl_amt	Decimal (11,2)	-	-	-
112	Base Retail UOM Code	base_rtl_uom_cd	String	-	-	-
113	Base Retail UOM Description	base_rtl_uom_desc	String	-	-	-
114	Cancel When Out Indicator	cncl_when_out_ind	Integer	-	-	Cancel When Out Flag
115	Item Import Indicator	item_import_ind	Integer	-	-	-
116	Item Replenishment Indicator	item_repl_ind	Integer	-	-	-
117	Guaranteed Sales Indicator	guar_sales_ind	Integer	-	-	-
118	Master Carton Indicator	master_carton_ind	Integer	-	-	-
119	Vendor Pack Weight UOM	vnpk_wt_uom_cd	String	-	-	-
120	Vendor Pack Weight Description	vnpk_wt_uom_desc	String	-	-	-
121	Vendor Pack Dimension UOM Code	vnpk_dim_uom_cd	String	-	-	-
122	Vendor Pack Dimension UOM Description	vnpk_dim_uom_desc	String	-	-	-
123	Warehouse Max Order Qty	whse_max_order_qty	Integer	-	-	Max Order Qty
124	Warehouse Pack Cube UOM Code	whpk_cube_uom_cd	String	-	-	-
125	Warehouse Pack Cube UOM Desc	whpk_cube_uom_desc	String	-	-	-
126	Warehouse Pack Dimension UOM Code	whpk_dim_uom_cd	String	-	-	-
127	Warehouse Pack Dimension UOM Description	whpk_dim_uom_desc	String	-	-	-
128	Buying Region Code	buyg_region_cd	Integer	-	-	Buying Region Code
129	Buying Region Description	buyg_region_desc	String	-	-	Buying Region Desc
130	Shop Description	shop_desc	String	-	-	-
131	Signing Description	signing_desc	String	-	-	Signing Desc
132	Assortment Type Code	asort_type_cd	Integer	-	-	-
133	Assortment Type Description	asort_type_desc	String	-	-	-
134	Season Code	seasn_cd	Integer	-	-	Season Code
135	Season Description	seasn_desc	String	-	-	-
136	Season Year	seasn_yr	Integer	-	-	Season Year
137	Item Dimension Unit of Measure Code	item_dim_uom_cd	String	-	-	UOM Code
138	Item Dimension Unit of Measure Description	item_dim_uom_desc	String	-	-	-
139	Item Weight Quantity	item_wt_qty	Decimal (11,4)	-	-	Item Weight
140	Item Weight Unit of Measure Code	item_wt_uom_cd	String	-	-	-
141	Item Weight Unit of Measure Description	item_wt_uom_desc	String	-	-	-
142	Item Expiry Date	item_expire_dt	Date	-	-	-
143	Estimated Out of Stock Date	est_out_of_stock_dt	Date	-	-	-
144	Pallet Size Code	pallet_size_cd	String	-	-	-
145	Pallet Rounding Percent	pallet_rnd_pct	Decimal (3,2)	-	-	-
146	Case UPC Number	case_upc_nbr	Long	-	-	-
147	Vendor Pack Weight Format Code	vnpk_wt_fmt_cd	String	-	-	Pack Weight Fmt
148	Vendor Pack Weight Format Description	vnpk_wt_fmt_desc	String	-	-	-
149	Vendor Pack Net Weight Quantity	vnpk_net_wt_qty	Decimal (11,4)	-	-	Vendor Pack Weight
150	Vendor Pack Net Weight UOM Code	vnpk_net_wt_uom_cd	String	-	-	-
151	Modular Based Merchandising Code	modlr_base_mdse_cd	String	-	-	-
152	Modular Based Merchandising Description	modlr_base_mdse_desc	String	-	-	-
153	Item Status Change Date	item_status_chng_dt	Date	-	-	-
154	Item Cost Amount	item_cost_amt	Decimal (13,4)	-	Y	-
155	Account Number	acct_nbr	Integer	-	-	-
156	Account Number Type Code	acct_nbr_type_cd	Integer	-	-	-
157	Account Number Type Description	acct_nbr_type_desc	String	-	-	-
158	Activity Code	actv_cd	String	-	-	-
159	Activity Description	actv_desc	String	-	-	-
160	Alcohol Percentage	alcohol_pct	Decimal (5,2)	-	-	-
161	Alternate Channel Source Indicator	alt_chnl_src_ind	Integer	-	-	-
162	Backroom Scale Indicator	backrm_scale_ind	Integer	-	-	-
163	Canned Order Indicator	canned_order_ind	Integer	-	-	-
164	Case UPC Format Code	case_upc_fmt_cd	Integer	-	-	-
165	Case UPC Format Description	case_upc_fmt_desc	String	-	-	-
166	Catch Weight Indicator	catch_wt_ind	Integer	-	-	-
167	Consumable Division Number	cnsumable_div_nbr	Integer	-	-	-
168	Controlled Substance Indicator	cntrl_substance_ind	Integer	-	-	-
169	Commodity ID	commodity_id	Integer	-	-	-
170	Conveyable Indicator	convey_ind	Integer	-	-	-
171	Crush Factor Code	crush_fctr_cd	Integer	-	-	-
172	Crush Factor Description	crush_fctr_desc	String	-	-	-
173	DC Drug Enforcement Agency Indicator	dc_dea_rpt_ind	Integer	-	-	-
174	Grocery Item Destination Code	dest_cd	Integer	-	-	-
175	Grocery Item Destination Description	dest_desc	String	-	-	-
176	Diet Type Code	diet_type_cd	Integer	-	-	-
177	Diet Type Description	diet_type_desc	String	-	-	-
178	Associate Discount Indicator	assoc_disc_ind	Integer	-	-	-
179	Fire Health and Safety Distribution Center Slot	fhs_dc_slot_cd	Integer	-	-	-
180	Fire Health and Safety Distribution Center Description	fhs_dc_slot_desc	String	-	-	-
181	FSA Indicator	fsa_ind	Integer	-	-	-
182	Gift Card Face Amount	gift_card_face_amt	Decimal (11,2)	-	-	-
183	Gift Card Fee Amount	gift_card_fee_amt	Decimal (9,2)	-	-	-
184	Gift Card Fee Percentage	gift_card_fee_pct	Decimal (5,3)	-	-	-
185	Gift Card Type Code	gift_card_type_cd	Integer	-	-	-
186	Gift Card Type Description	gift_card_type_desc	String	-	-	-
187	Ideal Temperature HI Qty	ideal_tempr_hi_qty	Integer	-	-	-
188	Ideal Temperature LOW Qty	ideal_tempr_low_qty	Integer	-	-	-
189	Inforem Reorder Type Code	infrm_reord_type_cd	String	-	-	-
190	Inforem Reorder Type Description	infrm_reord_type_desc	String	-	-	-
191	Item Scannable Indicator	item_scannable_ind	Integer	-	-	-
192	Item Synchronized Status Code	item_sync_status_cd	Integer	-	-	-
193	Item Synchronized Status Description	item_sync_status_desc	String	-	-	-
194	Item File Source Name	itemfile_src_nm	String	-	-	-
195	Last Order Date	last_order_dt	Date	-	-	-
196	License Code	lic_cd	Integer	-	-	License Code
197	License Description	lic_desc	String	-	-	-
198	Merchandise Program ID	mdse_pgm_id	Integer	-	-	Space ID
199	Manufacturer Pre-Price Amount	mfgr_pre_price_amt	Decimal (18,2)	-	-	-
200	Manufacturer Suggested Retail Amount	mfgr_sugd_rtl_amt	Decimal (18,2)	-	-	-
201	Minimum Price Indicator	min_price_ind	Integer	-	-	-
202	Minimum Receiving Days	min_rcvng_days_qty	Integer	-	-	-
203	Minimum Wholesale Life Quantity	min_whse_life_qty	Integer	-	-	-
204	NonMember Upcharge Indicator	non_mbr_upchrg_ind	Integer	-	-	-
205	OSA Supplier ID	osa_supplier_id	Integer	-	-	-
206	Pallet UPC Format Code	pallet_upc_fmt_cd	Integer	-	-	-
207	Pallet UPC Format Description	pallet_upc_fmt_desc	String	-	-	-
208	Performance Rating Code	perfm_ratg_cd	Integer	-	-	-
209	Performance Rating Description	perfm_ratg_desc	String	-	-	-
210	Price Comparison Qty	price_comp_qty	Decimal (9,4)	-	-	-
211	Price Comparison UOM Code	price_comp_uom_cd	String	-	-	-
212	Prime UPC Item Number	prime_upc_item_nbr	Integer	-	-	-
213	Prime UPC MDS Fam ID	prime_upc_mds_fam_id	Integer	-	-	-
214	Promotion Order Book Code	promo_order_book_cd	Integer	-	-	Order Book Flag
215	Promotion Order Book Description	promo_order_book_desc	String	-	-	-
216	Prompt Price Indicator	prmpt_pric e_ind	Integer	-	-	-
217	QC Code	qlty_cntrl_cd	Integer	-	-	-
218	QC Description	qlty_cntrl_desc	String	-	-	-
219	Reserve Merchandise Code	rsrv_mdse_cd	Integer	-	-	-
220	Reserve Merchandise Description	rsrv_mdse_desc	String	-	-	-
221	Reserve MDSE Indicator	rsrv_mdse_ind	Integer	-	-	-
222	Retail VAT Indicator	rtl_incl_vat_ind	Integer	-	-	-
223	Return Resale Indicator	rtn_resale_ind	Integer	-	-	-
224	RFID Indicator	rfid_ind	Integer	-	-	-
225	RPPC Indicator	rppc_ind	Integer	-	-	RPPC Indicator
226	Retail Notify Store Indicator	rtl_notif_store_ind	Integer	-	-	-
227	Electronic Security Tag Indicator	secur_tag_ind	Integer	-	-	-
228	Segregation Code	segregation_cd	Short	-	-	-
229	Segregation Description	segregation_desc	String	-	-	-
230	Send to Store Date	send_store_dt	Date	-	-	-
231	Shelf Label Requirement Indicator	shelf_lbl_reqmt_ind	Integer	-	-	Shelf Label Flag
232	Shelf Rotation Indicator	shelf_rotation_ind	Integer	-	-	-
233	Shelf-Life Days Qty	shelf_life_dys_qty	Integer	-	-	-
234	Supplier Display Indicator	supplier_disp_ind	Short	-	-	-
235	Temperature Sensitive Indicator	tempr_sensitive_ind	Integer	-	-	-
236	Temperature UOM Code	tempr_uom_cd	String	-	-	-
237	UPC Format Code	upc_fmt_cd	Short	-	-	-
238	UPC Format Description	upc_fmt_desc	String	-	-	-
239	Variable Comp Indicator	var_comp_ind	Integer	-	-	-
240	Variable Weight Indicator	var_wt_ind	Integer	-	-	-
241	Vendor First Order Date	vndr_first_order_dt	Date	-	-	-
242	Vendor First Ship Date	vndr_first_ship_dt	Date	-	-	-
243	Vendor First Available Date	vndr_first_avlbl_dt	Date	-	-	-
244	Vendor Incremental Order Qty	vndr_incrm_order_qty	Integer	-	-	-
245	Vendor Last Ship Date	vndr_last_ship_dt	Date	-	-	-
246	Vendor Lead Time	vndr_ld_tm_qty	Short	-	-	-
247	Vendor Minimum Order UOM	vndr_min_order_uom_cd	String	-	-	-
248	Warehouse Net Weight Quantity	whpk_net_wt_qty	Decimal (11,4)	-	-	-
249	Warehouse Pack UPC Format Code	whpk_upc_fmt_cd	Short	-	-	-
250	Warehouse Pack UPC Format Description	whpk_upc_fmt_desc	String	-	-	-
251	Private Label Indicator	pvt_lbl_ind	Integer	-	-	-
252	GTIN	gtin	String	-	-	-
253	Buyer User ID	buyer_userid	String	-	-	-
254	Buyer Full Name	buyer_full_nm	String	-	-	-
255	Item Share Indicator	item_share_ind	String	-	-	-
256	Item Share Cost Indicator	item_share_cost_ind	String	-	-	-
257	Future Vendor Pack Cost Amount	future_vnpk_cost_amt	Decimal (38,9)	-	Y	-
258	Manufacturer Company ID	mfg_cmpny_id	String	-	-	-
259	Future Effective Date	future_effective_date	Date	-	-	-