Product catalog
Your internal master list
| Internal SKU | Supplier SKU | Product |
|---|---|---|
| P-410 | NX-4401 | Desk lamp |
| P-411 | NX-4407 | Floor lamp |
| P-412 | NX-4412 | Wall light |
Inventory update
Update product records from a supplier price file without manual copy and paste.
Keep your own catalog as the main file, connect it to the supplier’s latest list by SKU or supplier code, and bring across current cost, stock, or lead-time fields. Products that cannot be matched stay visible for review.
- Match bySupplier SKU
- AddUnit cost and lead time
- GetYour catalog with the supplier’s latest purchasing information
Ready-to-use example
Try this job with a small workbook first.
The workbook contains a Main file sheet, a Lookup file sheet, and the expected result. Upload it in both file slots and select the two source sheets when RowPair asks.
When this helps
A focused tool for a common spreadsheet job.
- Updating purchase costs from a new supplier file
- Adding availability or lead times to an inventory sheet
- Finding discontinued or unknown supplier SKUs
- Combining an internal catalog with differently ordered supplier data
Worked example
Two source files become one reviewable result.
The examples below show the fields that matter; your files can contain additional columns and use different column orders.
Supplier price list
The latest purchasing data
| Item code | Unit cost | Lead time |
|---|---|---|
| NX-4401 | €18.40 | 3 days |
| NX-4407 | €41.90 | 5 days |
| NX-4412 | €23.15 | 2 weeks |
Updated catalog
Internal fields remain first
| Internal SKU | Product | Unit cost | Lead time |
|---|---|---|---|
| P-410 | Desk lamp | €18.40 | 3 days |
| P-411 | Floor lamp | €41.90 | 5 days |
| P-412 | Wall light | €23.15 | 2 weeks |
Step by step
How to do it in RowPair.
- 01
Use your catalog as the main file
This preserves your internal SKU, product name, category, and preferred row order.
- 02
Add the supplier file
Excel and CSV are both supported, so the two files do not need to share a format.
- 03
Connect supplier identifiers
Match Supplier SKU in your catalog to Item code in the price list.
- 04
Review before updating
Resolve duplicated items and inspect missing SKUs before downloading the new cost and lead-time columns.
Before you export
Checks that prevent a misleading merge.
One SKU, several pack sizes
If a supplier repeats an item code for different packs, use the review action to select the right row rather than accepting an arbitrary price.
Currency and tax
RowPair transfers the supplier value as supplied; confirm currency, VAT, units, and price basis before importing the result into another system.
Changed supplier codes
A genuinely new or changed item code appears as no match. Keep it unresolved until you confirm the correct internal product.
Free · no account · local processing
Use the spreadsheets you already have.
Nothing is uploaded. Review the result in your browser, then download Excel or CSV.
Open the spreadsheet matcher