Single workflow: download the current inventory snapshot as Excel,
edit the Purchase Price column (other column edits are ignored), and reupload.
The portal verifies your file against current inventory and updates per-lot purchase
cost records. Result Excel includes Status + Note for every row.
1 Download current inventory
One row per (product, lot, cost record). Lots without cost records
appear once with a blank Purchase Price.
2 Edit the Purchase Price column
Edit Purchase Price only. Other column edits are silently ignored.
Add rows below a lot to record multiple (vendor, price) costs for the same lot.
Leave Purchase Price blank to skip a row.
Don't change Lot, MDS Number, or Qty columns — those are validation references.
3 Preview your changes
Upload the file. You'll see a per-row preview. Nothing is committed yet.