Market

Sync from Amazon is currently live for UK · DE and FR activate when their sync edge functions deploy

🔗 Live SP-API sync available — pull fresh stock levels directly from Amazon FBA

Total ASINs

—

OOS

—

Below 52 DOH

—

Overstock

—

Working units

—

COGS (working)

—

Storage cost/mo

—

All ASINs

At Risk

OOS

Overstock

Aged Stock

Pipeline

ASIN	SKU	Product	FBA	Working	Total DOH	Vel/wk	Aged	Alert	Transparency	Action	Flag / Note
📦 Select a market and upload an Inventory Health Report or sync from Amazon to populate

📊 Overview

🩺 Inventory Health

💰 Pricing Health

Total SKUs

—

OOS / Critical

—

Below 56 DOH

—

SKUs w/ Duplicates

—

Bridge POs needed

—

Overstock value

—

All SKUs

Hero SKUs

At Risk

With Duplicates

Bridge POs

Nelsons SKU	Product	ASINs	RC DOH	FBA	Vel/wk	L28 Sales	Alert	Action
🇺🇸 Upload your Recom Domo export + ASIN map to populate this view

Market

Month

3PL ships from own market · Nelsons owns SP-API flow

📦 Purchase Order

SKUs in this PO Click any row for detail

SKU	ASIN	Product	Units	Sell price	Compliance	Content	Fee/unit	Margin

Total 1P ASINs

—

Transitioned

—

Sellable Value

—

at Amazon 1P

Aged 90+ Value

—

fee risk

Unsellable Value

—

needs disposition

Open PO Units

—

ordering into 1P

Transition Progress

0% — All in 1P100% — Fully on 3P

All ASINs

🚨 Transition Risk

Open POs ⚠

Sell Through

Aged Stock

Unsellable

Complete

ASIN	Product	Brand	Sellable	DOI Left	Final Transition	3P Readiness	Aged 90+	Unsellable	Open PO	Status	Target 3P ASIN	Action	Notes
Upload your Vendor Central ASIN Sourcing Report to populate

Current ASINs

323

Target

160

To Remove

163

Units Stranded

17,259

Stranded Value

$353k

10-Week Cleanup ProgressWeek 1 of 10

839 (start)0% complete160 (target)

839323 today160

Critical ASIN Removal Tracker

Priority	ASIN	Product	FBA Units	Removal #	Status

All ASINs

Primary

Duplicates

P1 Critical

P2 Urgent

Hero ASINs

◐ Low Risk

✓ Done

🔍 PO Checker

Upload Full Duplicate Tracker CSV:

Primary ASINs

—

Active Recall

—

Low Risk

0

Cleaned

0

P1 Critical

—

P2 Urgent

—

Primary OOS

—

% Cleaned

0%

ASIN	Product	Brand	Pack Size	Role	Priority	DOH / Units	Maps to Primary
Loading…

Weekly Scorecard

Week 1

Metric	Entry	Target	Status

ASINs tracked

—

OOS at FBA

—

Pipeline dependent

—

Working units

—

Active shipments

—

Pipeline DOH by ASIN

Green = FBA · Amber = Working at CPG · Blue = In transit

ASIN	Product	FBA	Working	Shipped	Pipeline DOH	Alert	Action
Upload shipment CSVs + inventory health report to populate

Add a note

Type @Name to mention a team member (e.g. @Garrie, @Naomi, @Fella)

Up to 5 files · 25MB each · .xlsx .csv .pdf .docx .png .jpg .txt

Team Notes

admin

Manage welcome messages, user permissions, and AI usage.

Manage personalised welcome messages for each team member. Set birthdays, vacations, holidays and custom messages — they activate automatically on the right dates.

Current special messages Green = active right now

Add new message

Team member email

Display name

Occasion

Emoji

Message

Active from (optional)

Active until (optional)

Active (turn on immediately)

💡 Birthday tip: Set date_from and date_to to the same date each year — the message will activate on that day automatically. For recurring birthdays, you'll need to re-add them each year (or just update the year). Vacation messages work best with a manual toggle so you can turn them off when someone returns early!

Manage who has access to which sections of the ERP. To add a new user, first create their account in the Supabase dashboard, then assign permissions here.

Users without permissions

User	Role	AI	Sections	Last sign-in

Claude API usage across the platform. Cost estimates are approximate, based on Sonnet pricing ($3/M input + $15/M output).

Period:

Daily trend

User	Calls	Input tokens	Output tokens	Total	Est. cost	Errors

Data hygiene tools. These operate on master_asin_registry, content_tracker, and related tables.

🔄 Sync Listing Titles from Amazon SP-API · Catalog Items

Pulls the current Seller Central item title from Amazon SP-API and writes it to master_asin_registry.description. Use "Fill gaps" to update rows tagged in notes as needing customer-facing copy, or "All listings" to force-refresh every title against Amazon's current truth.

Market Mode

Edit user

Email

Full name

Role

🤖 AI features enabled (allows calls to Claude API)

⚖️ NLT Decision Authority (can approve/deny Transparency enrolment)

Section access

AI usage (last 7 days)

Open Cases

—

Submitted / Investigating

—

Total Units Lost

—

Value Owed

—

open + submitted

Recovered

—

Recovery Rate

—

All

Open

Submitted

Reimbursed

Shipment

Lost Inbound

Lost Warehouse

Closed

📦 Case Builder

⚖ Reconciliation

Ch.	Type	Shipment ID	ASIN	Product	Expected	Received	Disc.	Value	Reimbursed	Case #	Status	Update
No discrepancies recorded yet.

Add discrepancy manually

Channel

Type

Shipment ID

ASIN

SKU / MSKU (auto-fills cost)

Amazon Case #

Product name

Units expected

Units received

Unit cost £ (auto)

Unit cost $ (auto)

Date submitted to Amazon

Notes

Reimbursements ReportSeller Central CSV

Seller Central → Reports → Fulfillment → Payments → Reimbursements → Download CSV

↑

Upload Reimbursements Report

Inventory Ledger ReportSeller Central CSV

Seller Central → Reports → Fulfillment → Inventory → Inventory Ledger → Download CSV
We auto-filter for lost/damaged events only.

↑

Upload Inventory Ledger

Found Inventory Tracker Inventory Ledger

Seller Central → Reports → Inventory → Inventory Ledger → Detailed View → Event Type: Adjustments → Download CSV. We filter for Reason F (Found) units automatically.

↑

Upload Inventory Ledger (Adjustments)

Import Shipment Discrepancies Amazon TSV

Seller Central → Manage FBA Shipments → open a Closed shipment → top right Print/Download → Download shipment. Upload one or multiple TSV files at once.

↑

Upload Shipment TSV (one or multiple)

After import the Case Builder opens automatically. Enter the units received for each ASIN from Seller Central, then click Generate Case Text.

💡 Unit costs auto-fill from your COGS file — just enter the SKU and the cost populates automatically. 326 of 329 US ASINs and most UK ASINs are covered. For any gaps, enter the cost manually.

Policy & Compliance

Violation tracker, appeals, and weekly policy monitoring across UK / US / DE / FR

All

Open

In Appeal

Awaiting Docs

Resolved

Closed

📋 Case Builder

📡 Policy Tracker

ASIN	Market	Brand	Violation	Severity	Days	Status	Next Action

Live Catalog

Active + OOS-suppressed ASINs on UK · pulled from SP-API

Total in Catalog

—

Active

—

OOS Suppressed

—

Loading catalog…

Content Standards

ASIN Registry · A+ / PDP / Regulatory / Images

Total ASINs

—

Fully Live

—

Content Gaps

—

In Review

—

Completion

—

BRAND

Loading content tracker…

Content Audit

SEO/GEO Optimisation · Policy Compliance · All Markets

Loading audit data…

Content Workshop

Draft · Review · Approve · Export

Team Activity Log Every change made by the team — full transparency

No activity yet — changes made by the team will appear here.

🇬🇧 UK Inventory Health ReportSeller Central

↑

Drop or click to upload

Amazon Seller Central → Reports → Inventory Health

🛡️ Seller Central All Listings (GTINs)Seller Central

↑

Drop or click to upload

Seller Central → Inventory → Manage All Inventory → Download → All Listings (.txt / .csv)

Populates master_asin_registry.gtin from the product-id / product-id-type columns. Feeds the Transparency Tracker's Onboarding Template export. Amazon accepts 8/12/13/14-digit GTIN, EAN, or UPC.

🇺🇸 US Recom Domo ExportRecom/Domo

↑

Drop or click to upload

Recom Domo → Velocities, Inventory & DOH export

💰 Nelsons US MAP List (2025)Nelsons Internal

↑

Drop or click to upload

WORKING_MAP_2025.xlsx — sheet "All Products" with ASIN / SKU / MSRP / MAP 2025 / WS

ASIN-keyed. Feeds USA RRP · Nelsons Wholesale (FULL) · MAPP onto the US Recom Pricing Health tab. Re-upload whenever Nelsons issues a revised MAP schedule.

📅 Weekly Pricing History (Domo)Recom/Domo

↑

Drop or click to upload

Domo → Sales By ASIN broken out by week (PERIOD = weekly date) — feeds ASP sparklines & MAP violation detection

Adds 29-week ASP sparkline to every row on the Pricing Health tab (weekly ASP with a dashed MAP line and red dots on below-MAP weeks). Also drives the MAP Violation KPIs — direct evidence for the "we sold below MAP N weeks and lost the Buy Box" story.

📦 Recom PO History (NetSuite)Supply

↑

Drop or click to upload

NetSuite → Purchase Orders By UPC export. Uses fullyBilled orders and compares Org. Qty (Recom's original ask) vs quantity fulfilled.

Adds the Supply Shortfall root cause to Pricing Health — Recom couldn't sell inventory that never shipped (expirations, FDA holds, production). Joined to ASINs via UPC from the MAP list.

💰 Nelsons US COGSWholesale

↑

Drop or click to upload

Nelsons COGS xlsx (Material | Description | £ | $). Only US-tagged SKUs are imported.

Powers the "Can we fund it?" flag on every below-floor ASIN. Uses Nelsons' 20% margin-over-COGS floor to compute the maximum additional wholesale discount available per SKU — Lara's decision queue for supporting Recom back to 16% margin.

📊 Recom Margin Ask ReportRecom

↑

Drop or click to upload

Recom's own pricing analysis xlsx (Bach_Pricing_Analysis_MM_DD_YYYY.xlsx). Headers on row 5.

Powers Recom vs Nelsons comparison — flags MAP mismatches, wholesale-cost mismatches, and SRP mismatches. Also shows Recom's annualized wholesale-cost ask across the catalog. Update whenever Recom sends a new version.

📈 Recom Sales By ASIN (Domo)Recom/Domo

↑

Drop or click to upload

Domo → Sales By ASIN, All In Table — CSV with PERIOD, Sales, Units, AVG BB Rev, Sessions

Feeds 2025 baseline units/revenue, Buy Box retention (critical suppression signal), sessions, and days out of stock onto the Pricing Health tab.

📉 Recom YTD Variance (Domo)Recom/Domo

↑

Drop or click to upload

Domo → YTD Variance Summary By — CSV with YTD Sales/Units per ASIN

Feeds 2026 YTD units/revenue onto the Pricing Health tab. Combined with 2025 baseline it computes the projected annualized YoY delta and drives the "Est. 2026 loss" KPI.

🔍 SmartScout ExportSmartScout

↑

Drop or click to upload

SmartScout Products OR recommerce Offers CSV — type auto-detected

Accepts either the Products export (market/category data — one file per full pull) or the recommerce Offers export (Recom's Buy Box % + monthly rev per ASIN; Cassandra pulls these per brand, so upload each brand file in turn — they'll all accumulate). Feeds the SmartScout KPIs and the "current" side of the BB Ret column.

🧩 ASIN → Nelsons SKU MapInternal

↑

Drop or click to upload

Internal team's XLSX — sheet named "ASIN MAPPING"

Feeds the Components only filter on the Overview and Inventory Health tabs — hides Recom's own bundle ASINs so Nelsons measures inventory on components it actually ships. Re-upload whenever the internal map changes.

📅 US Supply & Demand ScheduleFella / Weekly

↑

Drop or click to upload

Fella's weekly XLSX — sheet with US supply/demand data

Cross-referenced by the Overview action logic — SKUs Nelsons can't fulfill (oversold, QA hold, shortfall, air-freight-required) get a ⛔ Supply constrained action instead of a misleading "Raise reorder now". Re-upload each week when Fella sends the refresh.

📊 Recom — Account Health (Monthly)Recom/NetSuite

Month for this upload

↑

Drop or click to upload (multi-file)

Velocities, POs, Ad Overview, NTB, Attribution, etc. — auto-detected by header

Drop all your Recom monthly CSVs together. The system identifies each file by its header signature and loads them into the right tables. Re-uploading the same month overwrites previous data.

📈 Recom 3+9 ForecastFinance

Submission date Submission notes (email to finance — paste your email body here)

↑

Drop or click to upload XLSX

Recom_3-9_Updated_*.xlsx — must contain 3 tabs: Risk & Opps, Forecast (Baseline), Forecast + Consolidation

Each submission is versioned by submission date. Re-uploading the same date replaces; uploading a new date adds a new version (history preserved for trending).

📤 Recomiq Weekly Sales (Paid Media)Recom/Recomiq

↑

Drop or click to upload

Recomiq → Sales By ASIN – All In Table — weekly granularity, all ASINs

Feeds the Paid Media Initiatives dashboard for US Amazon campaigns. Recom is the US authorized reseller, so US ASIN sell-out lives in their Recomiq dashboard rather than our SP-API. Upserts on (ASIN × week) so re-uploads are safe.

📦 FBA Shipment Plans (Working Units)CPG Logistics

↑

Drop or click to upload (multiple)

Seller Central → Shipments → Download shipment CSV

🔄 UK 1P Transition ReportVendor Central

↑

Drop or click to upload

Vendor Central → Analytics → Inventory → ASIN Sourcing Report

📈 UK 1P Sales VelocityVendor Central

↑

Drop or click to upload

Vendor Central → Analytics → Sales → ASIN Sourcing (Retail view). Any time window — we read it from the report header.

Replaces the 3P proxy used for Days of Inventory with actual 1P sell-through. Without this, the dashboard estimates velocity from your 3P FBA listing — which is misleading whenever 1P is winning the Buy Box.

💷 Cost of Goods (COGS)Finance

↑

Drop or click to upload

Excel with UK COGS and/or US COGS sheets

UK sheet: columns ASIN · SKU · Description · STD Cost/u (£).
US sheet: columns Material (SKU) · Description · £ · $. US costs are joined to ASINs via the US Recom sync.

📊 Amazon Fee PreviewSeller Central

↑

Drop or click to upload

Seller Central → Reports → Fulfillment → Fee Preview → Download CSV

Amazon's own per-ASIN fees (referral, FBA, closing) — more accurate than fallback estimates. Re-upload monthly or whenever Amazon adjusts fees.

🏭 SAP B1 ExportOptional

↑

Drop or click to upload

Run the SAP SQL script each morning → export CSV

SAP B1 SQL script: See supabase/sap_query.sql in your deployment for the morning query your team can run.

Nelsons ERP

admin

Users without permissions

Daily trend

Policy & Compliance

Profile

Appearance

Dashboard

Notifications