Grocery Inventory and Sales Dataset

Dataset Overview:

This dataset provides detailed information on various grocery items, including product details, supplier information, stock levels, reorder data, pricing, and sales performance. The data covers 990 products across various categories such as Grains & Pulses, Beverages, Fruits & Vegetables, and more. The dataset is useful for inventory management, sales analysis, and supply chain optimization.

Columns:

• Product_ID: Unique identifier for each product.
• Product_Name: Name of the product.
• Category: The product category (e.g., Grains & Pulses, Beverages, Fruits & Vegetables).
• Supplier_ID: Unique identifier for the product supplier.
• Supplier_Name: Name of the supplier.
• Stock_Quantity: The current stock level of the product in the warehouse.
• Reorder_Level: The stock level at which new stock should be ordered.
• Reorder_Quantity: The quantity of product to order when the stock reaches the reorder level.
• Unit_Price: Price per unit of the product.
• Date_Received: The date the product was received into the warehouse.
• Last_Order_Date: The last date the product was ordered.
• Expiration_Date: The expiration date of the product, if applicable.
• Warehouse_Location: The warehouse address where the product is stored.
• Sales_Volume: The total number of units sold.
• Inventory_Turnover_Rate: The rate at which the product sells and is replenished.
• Status: Current status of the product (e.g., Active, Discontinued, Backordered).

Dataset Usage:

• Inventory Management: Analyze stock levels and reorder strategies to optimize product availability and reduce stockouts or overstock.
• Sales Performance: Track sales volume and inventory turnover rate to understand product demand and profitability.
• Supplier Analysis: Evaluate suppliers based on product availability, pricing, and delivery frequency.
• Product Lifecycle: Identify discontinued or backordered products and analyze expiration dates for perishable goods.

How to Use:

This dataset can be used for various tasks such as: - Predicting reorder quantities using machine learning. - Analyzing inventory turnover to optimize stock levels. - Conducting sales trend analysis to identify popular or slow-moving items. - Improving supply chain efficiency by analyzing supplier performance.

Notes:

• This dataset is fictional and used for educational or demonstration purposes only.
• The expiration dates and last order dates should be considered for time-sensitive or perishable items.
• Some products have been marked as discontinued or backordered, indicating their current status in the inventory system.

License:

This dataset is released under the Creative Commons Attribution 4.0 International License. You are free to share, adapt, and use the data, provided proper attribution is given.

Graph and download economic data for Retailers: Inventories to Sales Ratio (RETAILIRNSA) from Jan 1992 to Apr 2025 about ratio, inventories, sales, retail, and USA.

The dataset is about a retail sales dataset containing information about store sales for various products over time.

The specific variables include: Store: Unique identifier for the store location Date: Calendar date of the sales data Product: Name of the product being sold Weekly Sales: Total number of units sold for the product in a week Inventory Level: Number of units of the product currently in stock at the store Temperature: Average temperature for the week at the store location Past Promotion of Product (in lac): Total value (in lakhs) of any past promotions for the product during the week (1 lac = 100,000) Demand Forecast: Predicted number of units to be sold for the product in the next week (provided for baseline model comparison)

This dataset can be used for various analytical purposes related to retail sales and inventory management, including:

Demand forecasting: By analyzing historical sales data, temperature, past promotions, and other relevant factors, you can build models to predict future demand for products. This information can be used to optimize inventory levels and prevent stock outs or overstocking. Promotion analysis: You can compare sales data during promotional periods with non-promotional periods to assess the effectiveness of different promotions and identify products that respond well to promotions. Product analysis: By analyzing sales data across different stores and time periods, you can identify which products are most popular and in which locations. This information can be used to inform product placement, marketing strategies, and assortment planning. Store performance analysis: You can compare sales performance across different stores to identify top-performing stores and understand factors contributing to their success. This information can be used to identify areas for improvement in underperforming stores.

By utilizing this dataset for these analytical purposes, retail organizations can gain valuable insights into their sales patterns, customer behavior, and inventory management practices. This information can be used to make data-driven decisions that improve sales performance, profitability, and customer satisfaction.

Graph and download economic data for Existing Home Sales: Housing Inventory (HOSINVUSM495N) from May 2024 to May 2025 about inventories, sales, housing, and USA.

Graph and download economic data for Existing Single-Family Home Sales: Housing Inventory (HSFINVUSM495N) from May 2024 to May 2025 about 1-unit structures, inventories, family, sales, housing, and USA.

United States Existing Home Sales: Inventory data was reported at 1,850,000.000 Unit in Oct 2018. This records a decrease from the previous number of 1,880,000.000 Unit for Sep 2018. United States Existing Home Sales: Inventory data is updated monthly, averaging 2,280,000.000 Unit from Jan 1999 (Median) to Oct 2018, with 238 observations. The data reached an all-time high of 4,040,000.000 Unit in Jul 2007 and a record low of 1,460,000.000 Unit in Dec 2017. United States Existing Home Sales: Inventory data remains active status in CEIC and is reported by National Association of Realtors. The data is categorized under Global Database’s United States – Table US.EB005: Existing Home Sales.

this graph was created in R and Canva :

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2F1a47e2e6e4836b86b065441359d5c9f0%2Fgraph1.gif?generation=1742159161939732&alt=media" alt=""> https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2F87de025c5703cb69483764c4fc9c58ab%2Fgraph2.gif?generation=1742159169346925&alt=media" alt=""> https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F16731800%2Fddf5001438c97c8c030333261685849b%2Fgraph3.png?generation=1742159174793142&alt=media" alt="">

The dataset offers a comprehensive view of grocery inventory, covering 990 products across multiple categories such as Grains & Pulses, Beverages, Fruits & Vegetables, and more. It includes crucial details about each product, such as its unique identifier (Product_ID), name, category, and supplier information, including Supplier_ID and Supplier_Name. This dataset is particularly valuable for businesses aiming to optimize inventory management, sales tracking, and supply chain efficiency.

Key inventory-related fields include Stock_Quantity, which indicates the current stock level, and Reorder_Level, which determines when a product should be reordered. The Reorder_Quantity specifies how much stock to order when inventory falls below the reorder threshold. Additionally, Unit_Price provides insight into pricing, helping businesses analyze cost trends and profitability.

To manage product flow, the dataset includes dates such as Date_Received, which tracks when the product was added to the warehouse, and Last_Order_Date, marking the most recent procurement. For perishable goods, the Expiration_Date column is critical, allowing businesses to minimize waste by monitoring shelf life. The Warehouse_Location specifies where each product is stored, facilitating efficient inventory handling.

Sales and performance metrics are also included. The Sales_Volume column records the total number of units sold, providing insights into consumer demand. Inventory_Turnover_Rate helps businesses assess how quickly a product sells and is replenished, ensuring better stock management. The dataset also tracks the Status of each product, indicating whether it is Active, Discontinued, or Backordered.

The dataset serves multiple purposes in inventory management, sales performance evaluation, supplier analysis, and product lifecycle tracking. Businesses can leverage this data to refine reorder strategies, ensuring optimal stock levels and avoiding stockouts or excessive inventory. Sales analysis can help identify high-demand products and slow-moving items, enabling better decision-making in pricing and promotions. Evaluating suppliers based on their performance, pricing, and delivery efficiency helps streamline procurement and improve overall supply chain operations.

Furthermore, the dataset can support predictive analytics by employing machine learning techniques to estimate reorder quantities, forecast demand, and optimize stock replenishment. Inventory turnover insights can aid in maintaining a balanced supply, preventing unnecessary overstocking or shortages. By tracking trends in sales, businesses can refine their marketing and distribution strategies, ensuring sustained profitability.

This dataset is designed for educational and demonstration purposes, offering fictional data under the Creative Commons Attribution 4.0 International License. Users are free to analyze, modify, and apply the data while providing proper attribution. Additionally, certain products are marked as discontinued or backordered, reflecting real-world inventory dynamics. Businesses dealing with perishable goods should closely monitor expiration and last order dates to avoid losses due to spoilage.

Overall, this dataset provides a versatile resource for those interested in inventory management, sales analysis, and supply chain optimization. By leveraging the structured data, businesses can make data-driven decisions to enhance operational efficiency and maximize profitability.

Graph and download economic data for Ratios of private inventories to final sales of domestic business (A811RC2Q027SBEA) from Q1 1947 to Q1 2025 about final sales, ratio, inventories, domestic, business, private, GDP, and USA.

In terms of inventory management, the pandemic was a true disruption for U.S. retailers. This graph looks at the amount of inventory compared to the number of fulfilled sales from January 2020 to November 2021. In April 2020, the inventories-to-sales ratio jumped to its annual peak due to the imposed lockdown. Only two months later, it decreased abruptly as stores reopened and consumers could shop with the same frequency. The ratio stood at 1.09 percent as of November 2021.

United States - Auto Inventory/Sales was 1.28100 Ratio in April of 2025, according to the United States Federal Reserve. Historically, United States - Auto Inventory/Sales reached a record high of 4.64300 in January of 2009 and a record low of 0.42700 in January of 2022. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Auto Inventory/Sales - last updated from the United States Federal Reserve on June of 2025.

Total Housing Inventory in the United States increased to 1540 Thousands in May from 1450 Thousands in April of 2025. This dataset includes a chart with historical data for the United States Total Housing Inventory.

Monthly Canadian manufacturers' sales, new orders, unfilled orders, raw materials, goods or work in process, finished goods, total inventories, inventory to sales ratios and finished goods to sales ratios for durable and non-durable goods by North American Industry Classification System (NAICS), in dollars unless otherwise noted. Unadjusted and seasonally adjusted values available from January 1992 to the current reference month.

United States - Total Business: Inventories to Sales was 1.38000 Ratio in April of 2025, according to the United States Federal Reserve. Historically, United States - Total Business: Inventories to Sales reached a record high of 1.74000 in April of 2020 and a record low of 1.24000 in March of 2011. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Total Business: Inventories to Sales - last updated from the United States Federal Reserve on June of 2025.

Dataset Overview: The Country Delight Dairy Sales & Inventory Dataset provides a detailed collection of data related to dairy farms, products, sales, and inventory tracking. It includes information on farm locations, land size, livestock count, product details, sales records, customer distribution, stock levels, and pricing. This dataset is valuable for researchers, analysts, and businesses in the dairy sector.

Dataset Features:

Location: The geographical region of the dairy farm. Total Land Area (acres): The size of the dairy farm. Number of Cows: Total number of cows at the farm. Farm Size: Categorization of farms as Small, Medium, or Large. Date: Date of data collection. Product Name: Type of dairy product. Brand: The brand associated with the dairy product. Quantity (liters/kg): The total quantity available. Price per Unit: The unit price of the product. Total Value: The total value based on available quantity. Shelf Life (days): The product's expiration period. Storage Condition: Storage requirements. Production Date: Manufacturing date of the product. Expiration Date: Date when the product expires. Quantity Sold (liters/kg): The amount of product sold. Price per Unit (sold): The selling price per unit. Approx. Total Revenue (INR): Estimated revenue from sales. Customer Location: The buyer's location. Sales Channel: Mode of sale (Retail, Wholesale, or Online). Quantity in Stock (liters/kg): Remaining stock levels. Minimum Stock Threshold (liters/kg): The minimum required stock before restocking. Reorder Quantity (liters/kg): Suggested reorder amount to maintain inventory.

Data Size & Format: Rows: 122,983 Columns: 23 Format: CSV (Comma-Separated Values) Time Range: 2019-2022 Geographic Coverage: India (multiple states and union territories)

Licensing & Attribution: This dataset is open-source under a Creative Commons license. Users are encouraged to cite the dataset when utilizing it for research, analysis, or publication.

Acknowledgments: The dataset incorporates publicly available information, dairy industry reports for analytical purposes.

United States - Manufacturers: Inventories to Sales was 1.58000 Ratio in April of 2025, according to the United States Federal Reserve. Historically, United States - Manufacturers: Inventories to Sales reached a record high of 1.88000 in April of 2020 and a record low of 1.14000 in December of 2005. Trading Economics provides the current actual value, an historical data chart and related indicators for United States - Manufacturers: Inventories to Sales - last updated from the United States Federal Reserve on June of 2025.

In September 2024, the U.S. automotive industry's inventory-to-sales ratio decreased compared to August 2024, reaching 1.27. This was however a slight uptick compared to the levels recorded in 2022, when the global chip shortage depleted automotive dealerships' car supply. Chip shortage impacts supply The inventory/sales ratio reported in February 2022 was a record low for the United States' automotive sector, lower than the ratio one month earlier, in January 2022. The ratio slumped when U.S. vehicle sales began to gain steam and supply remained low amid shortages of automotive parts, most notably microchips. In contrast, the inventory-to-sales level rose to its highest in January 2009 amid the 2008/09 financial crisis, reaching about 4.6. High demand but low consumer satisfaction The impact of the shortage is not just felt by dealerships but also impacts consumers' car buying experience. Around 48 percent of U.S. consumers intended to buy a car as of September 2024, a share which remained stable compared to survey results gathered from October 2021 to September 2022. Some of the most in demand brands in the United States maintained relatively low days of supply values, indicative of potential issues for consumers looking to acquire a popular model.

Graph and download economic data for Total Business: Inventories to Sales Ratio (ISRATIO) from Jan 1992 to Apr 2025 about ratio, inventories, business, sales, and USA.

United States Inventory: sa: Single Family: Lexington, KY data was reported at 664.070 Unit th in Jul 2020. This records a decrease from the previous number of 827.994 Unit th for Jun 2020. United States Inventory: sa: Single Family: Lexington, KY data is updated monthly, averaging 1,640.121 Unit th from Feb 2012 (Median) to Jul 2020, with 102 observations. The data reached an all-time high of 2,870.683 Unit th in Mar 2012 and a record low of 664.070 Unit th in Jul 2020. United States Inventory: sa: Single Family: Lexington, KY data remains active status in CEIC and is reported by Redfin. The data is categorized under Global Database’s United States – Table US.EB026: Inventory of Home for Sale: by Metropolitan Areas: Seasonally Adjusted.

This dataset provide a listing of inventory items, including store quantities and sale prices. Update Frequency : Daily

Graph and download economic data for Manufacturers: Inventories to Sales Ratio (MNFCTRIRNSA) from Jan 1992 to Apr 2025 about ratio, inventories, sales, manufacturing, and USA.