Smart Purchasing

Four Star Seafood

Contact admin for access credentials

Smart Purchasing Dashboard

AI-Powered Order Recommendations Based on Sales Patterns & Lead Times

📡 ERP Status: Not connected
📍 Location:
Total Items
0
🔴 Critical
0
🟠 High Priority
0
🟡 Medium
0
Est. Order Cost
$0
📅 Seasonal Prediction Active

Pars are automatically adjusted based on: monthly seasonality patterns, upcoming holidays, and year-over-year trends.

🌊 Offshore Marine Forecast

Click to load
▼
📅 Order Schedule
Vendors with scheduled order days — click to start a PO
Order Recommendations (Ranked by Urgency)
💡
Smart Par Levels: Calculated from sales history using category-specific time periods. Click any recommendation to create a purchase order instantly.

Sales Analytics & Dynamic Par Calculator

📊
Sales analytics are powered by ERP sync. Weekly par levels are calculated from recent sales data (last 4 weeks). Products with no recent sales will have a par level of ZERO and will not appear in recommendations. Use the 🔄 Sync from ERP button on the Dashboard to refresh data.
💡
Weekly Par Calculation (Based on RECENT Sales):

Formula: Weekly Par = Average of Last 4 Weeks + Safety Stock

Key Rules:
• Pars are calculated from the most recent 4 weeks of sales only
• Products with NO sales in recent weeks = Par of ZERO (e.g., Albacore with no recent sales → Par = 0)
• Each warehouse (SFO/LAX) has its own separate par levels
• Products must have recent activity to appear in recommendations

Example: If Black Cod sold 100, 120, 80, 100 lbs in the last 4 weeks at SFO:
→ Average = 100 lbs/week → SFO Weekly Par ≈ 100 + safety stock

Order Calculation Settings

📦
Smart Ordering Formula:
Order Qty = (Weekly Par × Buffer) - Stock at Arrival
Stock at Arrival = Current Stock - (Daily Usage × Lead Time)

Days from order to delivery (1-14). This affects how much stock you'll use before the order arrives. Can be overridden per vendor.

Extra buffer on top of order cycle (0-100%). Default: 25%. At 25%, if you order 2×/wk (3.5 day cycle), you'll target 4.4 days of stock.

Multiplier for standard deviation in par calculation (1.0 - 3.0). Default: 1.5. Higher = more buffer in weekly par.

Manual seasonal adjustment (+/- %). Use if automatic seasonal prediction is disabled.

💡
Example Calculation (Lobster Chix):
Weekly par: 116# • Order frequency: 2×/wk • Current stock: 56# • Buffer: 25%
→ Daily usage: 116 ÷ 7 = 16.6#/day
→ Order cycle: 7 ÷ 2 = 3.5 days between orders
→ Vendor lead time: 1 day (less than cycle, so cycle drives qty)
→ Coverage: 3.5 × 1.25 = 4.4 days
→ Target stock: 16.6 × 4.4 = 73#
→ Order: 73 - 56 = 17#

Lead Time Override (e.g. Mancini Pasta, 90-day lead):
If vendor lead time exceeds order cycle, lead time drives quantity.
→ Base coverage: max(14d cycle, 90d lead) = 90 days
→ Coverage: 90 × 1.25 = 112.5 days → orders enough for the wait. 🚚

🚫 Excluded Products (0)

Products excluded from ordering recommendations and Today's Needs. Use for items you don't purchase through this platform.

💡 Tip: You can also exclude products directly from the dashboard by clicking the ✕ button on any recommendation row.

🎯 Advanced Analytics & Intelligence

Data-driven insights from your actual sales history, inventory, and pricing data.

Inventory Management

Click column headers to sort • Click stock values to edit

💡
Inventory data is synced from the ERP. Use "Sync from ERP" below to refresh.

🔄 ERP Direct Sync

Connect directly to your Access database via API. Pulls inventory, sales history, vendors, pending POs, committed orders, and seasonal factors in real-time.

LIVE DATA
API Status: Not connected

📦 Order Pipeline Data

Pipeline data is synced automatically from the ERP. Shows pending POs, committed orders, UOM conversions, and default UOMs.

📥 Pending POs (Incoming)
No pending POs loaded
📋 Committed Orders (Outgoing)
No committed orders loaded
⚖️ UOM Conversions
No UOM data loaded
📐 Default UOMs
No default UOM data loaded
🌉 SFO Inventory
No data loaded
🌴 LAX Inventory
No data loaded
Showing Products
0
Total SFO Stock
0
Total LAX Stock
0
Low Stock Items
0
SKU ⇅ Product Name ⇅ Category ⇅ SFO Stock ⇅ SFO Par ⇅ LAX Stock ⇅ LAX Par ⇅ Status ⇅

Vendor Management

Manage supplier relationships and performance

⏱️ Vendor Lead Times & Order Schedule

⚠️
Lead times and order days affect reorder calculations! Set which days you place orders with each vendor, plus their lead time. The system calculates how much to order based on when the next delivery will arrive.
📍 Schedule for:
Vendor ID Vendor Name Location Lead Time Del Exp Order Min Order → Delivery Schedule Email

📊 Purchase History

Vendor-product relationships and lead times are synced from ERP

Total Vendors
0
With Email
0
Avg Lead Time
—
Active Orders
0

Purchase Orders

Create and manage purchase orders & inter-location transfers

Total POs
0
📱 Platform
0
🖥️ ERP Direct
0
Draft
0
Sent/Active
0
Total Value
$0
🔍

✈️ Cargo Tracking

Track air cargo shipments via AWB numbers from purchase orders

📋 Vendor Price Sheets

Upload and manage vendor price lists for cost comparison and PO reference

Total Sheets
0
Active
0
Expiring Soon
0
Total Products
0
Vendors Covered
0
🔍