Integration Bridge: Vendor Pricing + NetSuite Inventory

Simple on screen, strong underneath

This page is meant to help a quick Teams call: it explains the concept first, then shows the working “bridge” below. Paste in two exports, and it produces a clean import-ready CSV plus a short anomaly list.

The Integration Sheet Idea (the good concept)

One bridge in the middle that turns two messy sources into one clean import.
Clear mapping from vendor cost/MSRP to our item pricing fields.
Fast updates without hand edits, while still catching the “gotchas.”

What this HTML adds (why it helps)

Shows matches vs. non-matches in plain English (no formula hunting).
Flags UPC mismatches, missing UPCs, duplicate keys, and items that look discontinued.
Outputs import-ready CSV plus an exceptions list we can fix before import.

What we’re doing in one sentence

We match items, compute the new prices, verify UPCs, and generate an import that updates pricing and can tag discontinued items without accidentally changing the wrong records.

What “anomalies” usually look like

Item variants like 30530:305302-15W where the vendor uses a simpler style key.
Vendor sheet missing discontinued styles, so we have to infer discontinuation.
UPC exists on one side but not the other, or the UPC changed and needs a controlled overwrite.

Little hometown G-wiz note: this isn’t meant to replace the integration sheet — it’s a “flashlight and a tape measure.” It makes the match logic obvious, highlights oddballs, and then hands us clean rows to paste into the real workbook or CSV import.

NetSuite Export Paste

Paste rows from Excel/CSV. Tab-delimited paste works great.

Source A

Vendor Pricing Paste

Paste the vendor sheet. Include headers (Style #, WHLS, 5 % off wholesale, MSRP, etc.).

Source B

Primary match key Price rule Cost rule Discontinued logic Discontinued tag value

Bridge Results Preview

Waiting for data

Status	Match Key	NetSuite Internal ID	NetSuite Item	NetSuite Display Name	NetSuite UPC	Vendor Style	Vendor Name	Vendor WHLS	Vendor 5% Off	Vendor MSRP	Vendor MAP	New Cost	New Sale	UPC Action	Discontinued
Paste both sheets above, then click Build Bridge Table.

Import CSV Output Copy/paste into a workbook or save as .csv

Exceptions and Talking Notes The “why we trust this import” list