Use a CSV with unique SKU identifiers.
Preserve blank fields and original units.
Quantity multiplied by unit price gives each row total.
Do not invent a value for a blank note.
Save a reviewed CSV and keep the source filename.