History.csv
CSV file · Verified sales history in PostgreSQL
Used bySales Insights AgentLive
Not connected
Last sync Never
Files and databases
4 of 6 connectedAgents have read access only. Nothing here is written back to the source system.
price_list.csv
CSV file · Uploaded file · refreshed nightly · 2,480 rows · 6 columns
Used byPricing AgentDTC Pricing AgentPrice Target Analyzer
Connected
Last sync Today, 06:10
knowledge_base.csv
CSV file · Uploaded file · refreshed manually · 184 rows · 5 columns
Used bymain (default)
Connected
Last sync 8 Sep, 14:20
ad_performance.csv
CSV file · Uploaded file · refreshed nightly · 8,940 rows · 11 columns
Used byAdvertising Analyst AgentPromo & Content Agent
Connected
Last sync Today, 06:10
stock_on_hand.csv
CSV file · Uploaded file · refreshed nightly · 2,480 rows · 6 columns
Used byInventory Agent
Connected
Last sync Today, 06:10
reporting_warehouse
Database · PostgreSQL · reporting.internal:5432
Not yet assigned to an agent
Not connected
Last sync Never
Database & API connections
10 of 11 connectedSource systems feeding the warehouse. Each lands in its own schema and is queryable together at the Gold layer.
| Source | Category | Connects via | Status | |
|---|---|---|---|---|
| Amazon | Marketplace | Vendor Central / SP-API | Connected | |
| Amazon Ads | Advertising | Selling Partner API | Connected | |
| Shopify | E-commerce | REST API | Connected | |
| Wayfair | Marketplace | Vendor API | Connected | |
| Klaviyo | Marketing | Email / SMS API | Connected | |
| Zendesk | Support | Support API | Connected | |
| Bazaarvoice | Reviews | Reviews API | Connected | |
| Salsify | Product data | PIM API | Connected | |
| Legacy SQL Server | Historical data | Direct database | Connected | |
| My Samm | Financial | MySamm API | Connected | |
| Sage 300 | ERP / pricing | Direct database + API | Awaiting data |
Sage 300 is built and ready but awaiting access from the source system. History.csv is live from PostgreSQL. SOL is available as a supply chain tool.