Supplier cost and price mapping

Shopify Supplier Price List CSV Update Mapper

Turn supplier SKU, barcode, new cost, and new selling price columns into a minimal Shopify cost and price update worksheet without building the update file by hand.

Local browser scanSafe fixes onlyShopify-focused checks

Browser-side scan

Drop a supplier list with SKU or Barcode and new cost and price

-

No CSV selected

No CSV selectedUpload a Shopify CSV or supplier list carrying SKU, Barcode, EAN, or UPC identity alongside a new supplier cost and a new selling price. The tool stays in your browser and never uploads your data.
Private by default. Your Shopify CSV with supplier cost and price columns data stays in this browser session. The export applies only safe deterministic changes and leaves manual-review items in the findings list.

This mapper is for merchants who receive a supplier price list that already carries Shopify identity (Variant SKU or barcode) alongside an updated cost and a new selling price. Everything runs locally in your browser with the File API, and no data is uploaded to a server. Upload a CSV with product identity (Variant SKU, Barcode, EAN, or UPC), a new supplier cost, and a new selling price column. The tool normalizes currency values, flags missing or invalid identifiers and amounts, detects duplicate identities, computes cost and price deltas against existing Cost per item and Variant Price columns when those are present, and exports a minimal Shopify-style update worksheet (identity plus Cost per item and Variant Price) with a review note. It does not call Shopify APIs and does not write, sync, or import anything to Shopify; any import stays a manual step you perform afterward.

Import blockers

Common causes this scan checks

  • Supplier cost and retail prices change regularly but are keyed to a supplier SKU or barcode rather than a Shopify product handle.
  • Updating thousands of variant costs and prices from a supplier list by hand in a spreadsheet is slow and error-prone.
  • Cost and price changes need a review pass to confirm they match sourcing and pricing strategy before any Shopify update import.
  • Merchants want a minimal update worksheet with only identity and price columns to avoid accidentally overwriting other product fields.

Workflow

How to use the cleaned CSV

  1. Prepare a CSV that carries product identity (Variant SKU, Barcode, EAN, or UPC), a new supplier cost, and a new selling price column.
  2. Upload the supplier price list and review the missing identity, invalid cost or price, and duplicate identity warnings.
  3. Check the cost and price delta notes to confirm the new values match your sourcing agreement and pricing strategy.
  4. Export the minimal cost and price update worksheet and import it into Shopify with a small test batch first.

Auto-fix policy

What the export can safely change

  • Detects product identity (Variant SKU, Barcode, EAN, or UPC), new supplier cost, and new selling price columns from common aliases.
  • Normalizes currency values deterministically (strips currency symbols, thousands separators, and surrounding whitespace).
  • Computes cost and price deltas against existing Cost per item and Variant Price columns when those reference columns are present.
  • Flags rows that cannot be safely mapped (missing or duplicate identity, invalid amounts, or cost at or above price) and marks the rest ready for the worksheet.

CSV example

CSV example: supplier cost and price update mapping

The mapper detects SKU and barcode identity, normalizes the supplier costs and prices, computes cost and price deltas against the existing Shopify reference columns, and exports a minimal Shopify update worksheet with a review note so the new sourcing values can be checked before a manual import.

Before
Handle,Title,Variant SKU,Variant Barcode,Supplier Cost,New Sell Price,Existing Cost Per Item,Current Price
SK001,Blue Widget,SK001-A,6291000123456,12.50,24.99,11.20,23.99
SK002,Red Widget,SK002-B,6291000123457,14.75,29.99,13.50,29.99
After
Handle,Variant SKU,Variant Barcode,Cost per item,Variant Price,Current Cost (reference),Current Price (reference),Cost Delta,Price Delta,Review note,Source row
SK001,SK001-A,6291000123456,12.50,24.99,11.20,23.99,1.30,1.00,Ready: cost up 1.30 price up 1.00,2
SK002,SK002-B,6291000123457,14.75,29.99,13.50,29.99,1.25,0.00,Ready: cost up 1.25 price unchanged,3

FAQ

Shopify CSV questions

Does this connect to my supplier system or my Shopify account?

No. The tool is browser-only and processes your CSV locally with the File API. It never calls Shopify APIs and never sends data to a supplier system; it only produces a worksheet you import yourself.

What if my supplier list uses a different identifier?

The tool reads Variant SKU, Barcode, EAN, and UPC columns. If your supplier uses a custom field, add a Variant SKU or Barcode column to the CSV so each row can be matched to a Shopify variant.

Can I update cost without changing price, or vice versa?

This single-file MVP expects both a new cost and a new price column in the input. If you only need one, use the bulk price update audit for price-only files, or include just the cost columns and ignore the price output.

What do the cost and price deltas mean?

A delta is the difference between the new supplier value and the current Shopify value when a reference column is present. Larger deltas (more than 10 percent or more than 5 in currency) are flagged so you can catch typos or strategy mismatches before importing.

Related tools

Shopify CSV Bulk Price Update Audit

Audit Shopify CSV sale-price updates, keep only price columns, catch compare-at price risks, and export a smaller update-only CSV.

Shopify Purchase Order and Transfer CSV Import Preflight

Validate Shopify purchase order and inventory transfer CSV files locally, normalizing supplier SKU, cost, tax percentage, quantity, and location into a review worksheet before a manual import attempt.

Shopify CSV Price Format Fixer

Find Shopify CSV price format issues before import, including currency symbols, comma decimals, blank prices, and non-numeric cells.

Shopify CSV Validator

Check a Shopify product CSV before import so you can catch structure, encoding, image, price, and variant problems early.

Feedback

How is this tool working for you?

Found a bug, a false alarm, or a missing check? Tell me — a human reads every note.