eComm Inventory
eComm Inventory refers to the data related to the stock of products available for sale through Walmart's eCommerce platform. This data encompasses various metrics that offer insights into inventory levels at different stages of the fulfillment process, including Fulfillment Centers (FCs).
Why Does eComm Inventory Matter?
Understanding eComm Inventory can play a key role in maintaining a responsive and efficient supply chain. The data supports important business goals across fulfillment, cost control, and customer satisfaction.
- Demand Fulfillment: May help ensure products are available to meet customer demand, reducing the risk of stockouts
- Operational Efficiency: Can support supply chain optimization, reducing delays and improving delivery times
- Cost Management: May help avoid overstocking, reducing tied-up capital and storage costs
- Customer Satisfaction: Visibility into product availability can improve customer experience and loyalty
Benefits of eComm Inventory Data to Suppliers
Access to this data provides suppliers with actionable insights that can enhance decision-making across multiple touchpoints.
Enhanced Forecasting
Historical sales data and trends can support more accurate demand forecasting, helping suppliers plan production and inventory.
Improved Visibility
By gaining visibility into omni-inventory, suppliers can:
- Achieve a holistic view of product availability across channels
- Balance inventory levels more effectively
- Anticipate shifts in consumer behavior
- Integrate online and offline inventory data
- Improve overall supply chain efficiency
Improved Collaboration
Sharing inventory data can improve communication and coordination between suppliers and Walmart, strengthening supply chain alignment.
Examples and Use Cases
Stock Allocation
Suppliers can use eComm Inventory data to optimize stock distribution across Fulfillment Centers. For example, locations with higher demand may be prioritized for restocking.
Relevant Fields
| Table Name | Technical Name | Business Name |
|---|---|---|
| eComm Inventory | catlg_item_id | Catalog Item ID / eComm Prod ID |
| eComm Inventory | trbl_qty | Trouble Quantity |
| eComm Inventory | on_hand_rtl_amt | On Hand Retail Amount |
| eComm Inventory | on_hand_unit_qty | On Hand Unit Quantity |
| eComm Inventory | hld_qty | Hold Quantity |
| eComm Inventory | rpt_dt | Report Date |
| Omni Sales | wm_item_nbr | Walmart Item Number |
| Omni Sales | auth_based_net_sales_amt | AUTH Based Net Sales Amount |
| Omni Sales | auth_based_qty | AUTH Based Item Quantity |
| Omni Sales | shpd_based_net_sales_amt | Shipped Based Net Sales Amount |
| Omni Sales | aur | Average Unit Retail Amount |
| Omni Sales | cost_sales | Cost Sales |
Product Performance Analysis
Inventory turnover and sales data can help assess product performance. For example, consistently underperforming products may require improvement or discontinuation.
Relevant Fields
| Table Name | Technical Name | Business Name |
|---|---|---|
| eComm Inventory | catlg_item_id | Catalog Item ID / eComm Prod ID |
| eComm Inventory | trbl_qty | Trouble Quantity |
| eComm Inventory | on_hand_rtl_amt | On Hand Retail Amount |
| eComm Inventory | on_hand_unit_qty | On Hand Unit Quantity |
| eComm Inventory | hld_qty | Hold Quantity |
| eComm Inventory | rpt_dt | Report Date |
| Omni Sales | wm_item_nbr | Walmart Item Number |
| Omni Sales | auth_based_net_sales_amt | AUTH Based Net Sales Amount |
| Omni Sales | auth_based_qty | AUTH Based Item Quantity |
| Omni Sales | shpd_based_net_sales_amt | Shipped Based Net Sales Amount |
| Omni Sales | aur | Average Unit Retail Amount |
| Omni Sales | cost_sales | Cost Sales |
| Omni Sales | prod_margin | Product Margin |
Supply Chain Adjustments
These insights allow suppliers to respond proactively to disruptions. For example, production delays can be managed through better communication and contingency planning.
Relevant Fields
| Table Name | Technical Name | Business Name |
|---|---|---|
| eComm Inventory | rip_qty | Receipts In Progress Quantity |
| eComm Inventory | wip_qty | Work In Progress Quantity |
| eComm Inventory | on_hand_rtl_amt | On Hand Retail Amount |
| eComm Inventory | on_hand_unit_qty | On Hand Unit Quantity |
| eComm Inventory | rpt_dt | Report Date |
| Omni Sales | wm_item_nbr | Walmart Item Number |
| Omni Sales | catlg_item_id | Catalog Item ID / eComm Prod ID |
| Omni Sales | geo_region_cd | Geographic Region Code |
| Omni Sales | op_cmpny_cd | Operational Company Code |
| Omni Sales | order_chnl_nm | Order Channel Name |
| Omni Sales | shpd_based_net_sales_amt | Shipped Based Net Sales Amount |
| Omni Sales | cntra_cost | Contract Cost |
| Omni Sales | bus_dt | Business Date |
Conclusion
eComm Inventory data is a valuable resource for suppliers, offering insights that enhance:
- Inventory management
- Forecasting accuracy
- Supply chain decision-making
By leveraging this data, suppliers can:
- Better meet customer demand
- Manage operational costs
- Strengthen collaboration with Walmart
Ultimately, eComm Inventory data helps create a more complete view of the inventory pipeline, enabling more informed and effective business decisions.
