Atlas IMS · V3

Wireframes & Architecture

Single-file mockup of the 9 core screens, the system architecture, and the V3 data model. Notion-style dark theme. List → detail with slide-overs. Flat nav, no tab-in-tab.

28 May 2026 · Draft for Steve · Pairs with ims/v3/V3-SPEC.md

Contents

  1. System Architecture
  2. Data Model
  3. 01 · Overview
  4. 02 · Items master
  5. 03 · Item detail
  6. 04 · Stock
  7. 05 · Buy / POs
  8. 06 · Make / Production
  9. 07 · Plan production wizard
  10. 08 · Sell / per-order COGS
  11. 09 · Plan (demand + supply)
System Architecture
How the pieces fit
Shopify AU
orders · variants
Shopify US
orders · variants
Skio
subscription charges
ShipBob
AU FC 227 · US FCs
eStore
AU legacy · drains Jun
Katana
raw · WIP · mirror
Cloudflare Worker API
/api/v3/* · sync · reorder · COGS
Supabase Postgres
items · boms · stock_movements · POs · production · sales
Dashboard
app.atlasims.ai · vanilla JS
Slack briefing
#supply-chain · 7am AEST
Telegram alerts
critical only · Steve
Email digests
Emma · weekly + ad-hoc
Webhook mirror
→ Katana during transition
External feeds (read)
Core (Atlas-owned)
UI
Outbound (push)

Atlas is the source of truth for items, BOMs, stock movements, POs and production orders. Katana mirror runs during Phase A and B as a fallback, then turns off at Phase C. ShipBob is primary AU FG location from 1 June.

Data Model · 6 tables that matter
Postgres · Supabase
items PK id
  • skutext uq
  • nametext
  • typeenum
  • default_supplier_idfk
  • lead_time_daysint
  • safety_stock_daysint
  • target_cover_daysint
  • external_ids_jsonjsonb
boms + bom_lines PK id
  • item_idfk
  • versionint
  • statusenum
  • effective_fromdate
  • approved_byfk user
  • yield_qtynumeric
  • change_reasontext
  • + bom_lineschild
stock_movements PK id · event log
  • item_idfk
  • location_idfk
  • qtysigned num
  • movement_typeenum
  • source_doc_typetext
  • source_doc_iduuid
  • batch_numbertext
  • unit_costnumeric
purchase_orders PK id
  • supplier_idfk
  • statusenum
  • expected_atdate
  • received_atdate
  • total_costnumeric
  • currencytext
  • payment_termstext
  • + po_lineschild
production_orders PK id · NEW
  • bom_idfk (version)
  • qty_to_producenumeric
  • qty_producednumeric
  • statusenum
  • copacker_supplier_idfk
  • expected_completedate
  • actual_completedate
  • + po_lines snapshotchild
sales_orders PK id · COGS locked
  • channeltext
  • shopify_order_idtext
  • statusenum
  • fulfilled_atts
  • revenuenumeric
  • cogs_lockednumeric
  • gp1numeric
  • + sales_order_lineschild

Hard rule: every operational row carries legal_entity_id. Stock balance is always SUM(stock_movements.qty) per (item, location). Never write directly to a balance. COGS locks at fulfillment using the BOM version active on that date.

01 · Overview
app.atlasims.ai/overview

Overview

Thu 28 May · last sync 04:52 UTC · ShipBob, eStore, Katana, Shopify
Days cover (weighted)
38d
↓ 4d vs last week
Open exceptions
7
2 critical · 5 warn
Open POs
12
A$786K committed
Production this week
10,940
3 batches at Wellforth
Revenue today
A$24.8K
↑ 12% vs 7d avg

Needs attention

SeveritySKUItemStockDays coverBlockerOwner
CRITICALHYPHW15Watermelon Pouch 156664dSensient flavour lateEmma
CRITICALHYPHMXB15Variety Pack 15-240-2dOversoldEmma
URGENTMHWBCLRD750750ml Bottle41219dJinjiang PO slippedEmma
URGENTHYPHBC15Blackcurrant Pouch 151,81022dBOM update pendingSteve
WARNHYPHLL15Lemon Lime Pouch 1598028dNo PO yetEmma
WARNHYPHOM15Orange Mango Pouch 151,42032dAwaiting OPO releaseEmma
INFOKAT-FLAV-WMWM flavour concentrate8 kg7dSensient PO-113 in transitAtlas

Inbound this week

DocSupplierETAValue
PO-113SensientThu 29 MayA$27,420
PO-118O F PackagingMon 02 JunA$11,300
OPO-78Wellforth (WM 20s)Tue 03 JunA$48,900
PO-121Jinjiang JiaxingMon 09 JunA$130,800

Recent activity

WhenEventWho
14:32ShipBob sync · 37 SKUs · 17,541 on-handAtlas
12:08PO-119 status → AcknowledgedEmma
11:14BOM v4 HYPHW15 saved as draftEmma
09:45Stocktake adjustment · HYPHBC15 · -12Emma
08:02Briefing posted to #supply-chainAtlas
02 · Items master
app.atlasims.ai/items

Items

142 active · 18 archived
All Finished Raw Packaging Merch Archived
SKUNameTypeSupplierLeadStock (all loc)Days coverBOMStatus
HYPHW15Watermelon Pouch 15FGWellforth28d6664dv3 ✓Active
HYPHBC15Blackcurrant Pouch 15FGWellforth28d1,81022dv2 ✓Active
HYPHLL15Lemon Lime Pouch 15FGWellforth28d98028dv2 ✓Active
HYPHOM15Orange Mango Pouch 15FGWellforth28d1,42032dv2 ✓Active
HYPHT15Tropical Pouch 15FGWellforth28d2,14048dv2 ✓Active
HYPHMXB15Variety Pack 15FGWellforth28d-240-2dv3 ✓Active
HYPHW15X10Watermelon X10 CartonFGWellforth28d34062dv1 ✓Active
MHWBCLRD750750ml Bottle RedFGJinjiang Jiaxing85d41219dv1 ✓Active
KAT-FLAV-WMWM flavour concentrateRawSensient42d8 kg7dActive
KAT-PKG-POUCHPouch packaging (blank)PkgO F Packaging84d28,40096dActive
KAT-ELEC-MIXElectrolyte base mixRawRedox35d142 kg52dActive
MHHDBLKHyro Hoodie BlackMerchHebei Angtian90d220240dActive
03 · Item detail (slide-over from Items)
app.atlasims.ai/items?open=HYPHW15

← Items list (dimmed under slide-over)

SKUNameStockCover
HYPHW15Watermelon Pouch 156664d
HYPHBC15Blackcurrant Pouch 151,81022d
HYPHLL15Lemon Lime Pouch 1598028d
HYPHOM15Orange Mango Pouch 151,42032d
Watermelon Pouch 15
HYPHW15 · FG · Wellforth · BOM v3
OverviewStockBOMMovementsSalesPOs

At a glance

Stock (all loc)666 units Velocity (14d avg)156 units/day Days cover4 days · CRITICAL InboundOPO-78 · 2,340 · ETA blocked Last WACA$2.84 / unit Margin (last 30d)68.4%

Stock by location

LocationOn handCommittedAvailable
ShipBob Sydney 3 (FC 227)48822466
eStore Sydney (legacy)1780178
Wellforth WIP000

Active BOM (v3)

ComponentQty / pouchUOMUnit cost
KAT-FLAV-WM2.4gA$0.42
KAT-ELEC-MIX8.1gA$0.96
KAT-PKG-POUCH1eaA$0.31
KAT-LABEL-WM1eaA$0.08
04 · Stock
app.atlasims.ai/stock

Stock

Snapshot from stock_movements · refreshed 14:32
All locations ShipBob Sydney 3 eStore Sydney Wellforth WIP Katana raw
SKUItemLocationBatchOn handCommittedAvailableDays coverWAC
HYPHW15Watermelon Pouch 15ShipBob Sydney 3WB-2026-04488224663d$2.84
HYPHW15Watermelon Pouch 15eStore SydneyWB-2026-0317801781d$2.91
HYPHBC15Blackcurrant Pouch 15ShipBob Sydney 3WB-2026-041,420481,37219d$2.62
HYPHBC15Blackcurrant Pouch 15eStore SydneyWB-2026-0343804386d$2.71
HYPHMXB15Variety Pack 15ShipBob Sydney 3WB-2026-04-2400-240-$2.78
KAT-FLAV-WMWM flavour concentrateWellforth WIPSEN-2026-028 kg5 kg3 kg7d$176/kg
KAT-FLAV-BCBC flavour concentrateWellforth WIPSEN-2026-0122 kg4 kg18 kg52d$168/kg
KAT-PKG-POUCHPouch packaging blankWellforth WIPOFP-2026-Q228,40012,00016,40096d$0.31
KAT-ELEC-MIXElectrolyte base mixWellforth WIPRDX-2026-04142 kg38 kg104 kg52d$118/kg
MHWBCLRD750750ml Bottle RedShipBob Sydney 3JJ-2026-01412840419d$4.92

Negative balance on HYPHMXB15 is an oversold condition. Click row → "Reconcile" to convert to a stocktake_correction movement, post adjustment with reason.

05 · Buy / Purchase orders
app.atlasims.ai/buy

Buy

12 open POs · A$786K committed · 4 due this week

Reorder recs (today)

SKUItemSupplierQtyDays cover afterCostLead
HYPHW15Watermelon Pouch 15Wellforth8,00055dA$22,72028d
KAT-FLAV-WMWM flavour concentrateSensient40 kg42dA$7,04042d
MHWBCLRD750750ml Bottle RedJinjiang Jiaxing5,00082dA$24,60085d
KAT-PKG-POUCHPouch packagingO F Packaging120,000140dA$38,04084d

PO pipeline

Draft2
PO-122
Sensient · WM flavour 60kg
A$10,560Not sent
PO-123
O F Packaging · Pouches 200K
A$63,400Not sent
Sent / Ack5
PO-119
Wellforth · BC pouch 8K
A$22,720Acked Mon
PO-120
Redox · electrolyte 500kg
A$59,000Sent Tue
PO-121
Jinjiang · 750ml bottle 24K
A$130,800Sent 12 May
PO-117
Hebei · Hoodie 500
A$14,500Acked
PO-115
Olsson's · salts 800kg
A$28,600Acked
Partially received3
PO-113
Sensient · WM flavour 80kg
A$14,080 / A$27,42050% in
PO-118
O F Pack · cartons 30K
20K / 30KMon ETA rest
PO-112
Sensient · BC flavour 60kg
40kg / 60kgSlipped
Closed2
PO-108
Wellforth · OM pouch 6K
A$17,040Closed 22 May
PO-110
Redox · electrolyte 300kg
A$35,400Closed 20 May
06 · Make / Production
app.atlasims.ai/make

Make

3 in progress · 2 ready to release · 1 blocked on raw
Draft2
OPO-80
HYPHLL15 · 6,000 pouches
WellforthNot released
OPO-81
HYPHT15 · 4,000 pouches
WellforthNot released
Released2
OPO-79
HYPHW15 · 8,000 pouches
WellforthStart Mon 02 Jun
OPO-77
HYPHBC15 · 8,000 pouches
WellforthStart Mon 02 Jun
In progress3
OPO-78 ⚠
HYPHW15 · 2,340 pouches
BLOCKED · WM flavETA Tue 03 Jun
OPO-76
HYPHOM15 · 5,200 pouches
60% completeDone Fri 30
OPO-75
HYPHMXB15 · 3,400 packs
30% completeDone Mon 02
Completed2
OPO-74
HYPHBC15 · 6,000 done
Closed 24 MayWAC $2.62
OPO-73
HYPHT15 · 4,000 done
Closed 21 MayWAC $2.71
07 · Plan production wizard
app.atlasims.ai/make/new

Plan production · OPO-82 draft

Wellforth · BOM explosion · component check
Choose item
Set qty
3
Check components
4
Schedule
5
Review

Job spec

ItemHYPHW15 · Watermelon 15 Qty to produce8,000 pouches BOMv3 (active · approved 12 May) CopackerWellforth Expected completeTue 24 Jun Est WACA$2.84 / unit Total costA$22,720

BOM explosion · component availability

ComponentRequiredAvailableShortfallStatusFix
KAT-FLAV-WM19.2 kg3 kg16.2 kgShortPO-113 ETA Thu
KAT-ELEC-MIX64.8 kg104 kgOK
KAT-PKG-POUCH8,000 ea16,400 eaOK
KAT-LABEL-WM8,000 ea12,200 eaOK
KAT-CART-X10800 ea2,400 eaOK
08 · Sell · per-order COGS + GP
app.atlasims.ai/sell

Sell

Last 30 days · Shopify + Skio + Wholesale · COGS locked at fulfillment
Revenue (30d)
A$742K
↑ 8.2%
COGS (30d)
A$214K
28.8% of rev
GP1 (30d)
A$528K
71.2% margin
Orders
8,420
AOV A$88
All channels Shopify AU Skio AU Wholesale Last 7d Last 30d
OrderWhenChannelCustomerLinesRevenueCOGSGP1MarginStatus
#48295Today 13:24ShopifyL. Hayes2× HYPHW15, 1× HYPHBC15A$92.00A$8.86A$83.1490.4%Open
#48294Today 13:08ShopifyM. Tran1× HYPHMXB15A$54.00A$15.62A$38.3871.1%Fulfilled
#48293Today 12:55SkioR. Singh3× HYPHW15A$84.00A$8.52A$75.4889.9%Fulfilled
#48292Today 12:42ShopifyA. Brown1× HYPHW15X10A$220.00A$28.40A$191.6087.1%Fulfilled
#48291Today 12:18SkioK. O'Neill2× HYPHBC15, 1× HYPHT15A$94.00A$10.31A$83.6989.0%Fulfilled
#48290Today 11:54WholesaleChemist Warehouse PO-4421200× HYPHMXB15X10A$28,400.00A$5,560.00A$22,840.0080.4%Open
#48289Today 11:30ShopifyJ. Pereira1× HYPHT15, 1× MHWBCLRD750A$78.00A$7.76A$70.2490.1%Fulfilled
#48288Today 11:08ShopifyS. Wong2× HYPHOM15A$72.00A$5.68A$66.3292.1%Fulfilled
#48287Today 10:42SkioD. Aziz4× HYPHW15A$108.00A$11.36A$96.6489.5%Fulfilled
#48286Today 10:18ShopifyC. Mendez1× HYPHMXB15, 1× MHHDBLKA$118.00A$32.40A$85.6072.5%Fulfilled

Click any row → slide-over with line-by-line COGS breakdown using the BOM version active at fulfillment date. Wholesale row uses contract pricing flag, locked GP at PO acceptance.

09 · Plan · demand + supply
app.atlasims.ai/plan

Plan

12-month demand + supply grid · last saved by Steve 22 May
Pouches Cartons X10 Bottles Raw materials All SKUs

Demand · units / month

SKUJunJulAugSepOctNovDecJan 27Feb
HYPHW155,2005,8006,4007,2008,4009,80010,4008,6007,200
HYPHBC153,8004,2004,6005,2006,0006,8007,4006,2005,200
HYPHLL152,4002,6002,9003,2003,8004,4004,8004,0003,400
HYPHOM152,8003,1003,4003,8004,4005,2005,6004,6003,900
HYPHT152,2002,4002,7003,1003,6004,2004,5003,8003,200
HYPHMXB151,8002,0002,2002,5002,9003,4003,7003,1002,600
Total pouches18,20020,10022,20025,00029,10033,80036,40030,30025,500

Supply · what we need vs what's covered

ComponentJun needJul needAug needOn hand + POAug shortfallAction
KAT-FLAV-WM12.5 kg13.9 kg15.4 kg48 kg (PO-113 + PO-122)+6 kgOrder soon
KAT-FLAV-BC9.1 kg10.1 kg11.0 kg52 kgOK
KAT-ELEC-MIX147 kg163 kg180 kg642 kg (incl. PO-120)OK
KAT-PKG-POUCH18,20020,10022,200148,400 (incl. PO-118, PO-123)OK
KAT-LABEL-WM5,2005,8006,40012,200+5,200Order soon
KAT-CART-X101,8202,0102,2202,400+3,650Order now
Atlas IMS V3 wireframes · pairs with ims/v3/V3-SPEC.md · single static HTML file · no build, no framework · 28 May 2026