TDI Bridge (Client Demo) — Vendor Pricing ⇄ NetSuite Inventory

Demo tool to preview the “middle bridge” concept: match items, compute new cost and sale price, and flag exceptions before any import. This demo does not export files.
Mode: Demo (export disabled) Outputs: preview + exceptions

Simple Concept

Quick framing: We keep both source sheets intact, then build a middle bridge that matches records, computes the update values, and flags anything that needs a human check.

Matching rules (ranked)

  1. Exact: Vendor Style # matches NetSuite Item / Name
  2. Variant: Vendor Style # matches NetSuite suffix after “:” (example 330059:330059-R-080)
  3. Review-only: Loose text similarity (flag only)

Bridge output columns (preview)

  • Internal ID anchor
  • New Cost (5% off WHLS if needed)
  • New Sale Price (MAP else MSRP)
  • UPC Action keep/overwrite/mismatch
  • DiscontinuedCandidate safe flag
Client demo preview only. No file generation in this version.

Paste NetSuite Inventory Export

Paste CSV or TSV with headers. Useful columns: Internal ID, Name or Item, Display Name, UPC Code.
NetSuite rows: 0 Detected columns: —

Paste Vendor Pricing Sheet

Paste CSV or TSV with headers. Useful columns: Style #, WHLS, 5 % off wholesale, MSRP, MAP.
Vendor rows: 0 Detected columns: —

Field Matching (Drag + Drop Mapping)

Drag detected columns into the targets. Map once, then run.

Detected Columns

NetSuite columns
Vendor columns
Defaults
Cost uses 5% off wholesale if vendor off-5 is missing. Sale price uses MAP else MSRP. DiscontinuedCandidate flags NetSuite items missing in vendor list.

Targets

Bridge Results

Matches OK: 0 Warnings: 0 Critical errors: 0 Mode: Demo

Preview (first 25 rows)

Internal IDNew CostNew Sale PriceUPC ActionDiscontinuedCandidateNotes

Exceptions (grouped)

No Match
Multiple Matches
UPC Issues
Discontinued Candidates
Review-only Matches
Other Notes
Demo version: export is disabled. This view is for confirming mapping, previewing updates, and reviewing exceptions.