Upload CSV File
📥 How to Get CSV Data from USDA:
- Go to https://mymarketnews.ams.usda.gov/public_data
- Click "Search by Market Types"
- Select "Shipping Point" as Market Type
- Choose your Commodity (Strawberries, Blueberries, etc.)
- Set date range (10 days prior to today)
- Click "Get Data!" to download CSV
- Upload the downloaded CSV file here
Available Data Services
📊 USDA CSV Parser
usda_csv_parser.php
Parses CSV data from USDA My Market News exports. Handles all commodity types,
organic/conventional, import/domestic classifications.
🚚 Shipping Point Integration
shipping_point_integration.php
Manages shipping point data by commodity and state. Provides daily aggregates
and historical trending.
🐄 LMPRS Integration
lmprs_integration.php
Real-time livestock and dairy prices from USDA LMPRS API. Includes cattle,
pork, and dairy products.
🥬 Produce Market Integration
produce_market_integration.php
Terminal market produce prices from major US cities. Supports fruits and
vegetables price tracking.
🛒 Retail Market Prices
import_retail_prices.php
Consumer-facing retail prices by region. Import retail.csv to track grocery store
prices across 9 US regions with historical comparisons.
⚡ Service Usage
All services are automatically loaded when you upload CSV data. The system will:
- ✓ Parse the CSV structure
- ✓ Identify commodity types
- ✓ Extract price data
- ✓ Calculate aggregates
- ✓ Store in database (if selected)
- ✓ Generate reports