You can now include Unit Price in spreadsheet exports. Unit prices have been editable in the app for a while, but there was no way to get the current values out. The field is in the Variant Fields group on the export page, and it works in the CSV and Excel formats.
Each cell holds the full unit price measurement as a small JSON value, like this:
{"quantityValue": 100.0, "quantityUnit": "G", "referenceValue": 1, "referenceUnit": "KG"}
That’s the quantity in the package and the reference amount the price is shown per. Variants without a unit price export as a blank cell.
The same column works in the other direction too. Upload the spreadsheet as an edit and the Unit Price column maps automatically, so you can export your unit prices, change the values in the spreadsheet, and upload it back. Blank cells are skipped, and if a value isn’t valid JSON or is missing one of the four fields you’ll see a clear error before anything is changed.
