Update existing Square items from a supplier CSV
Put new supplier costs and prices on the items you already sell. Items match by SKU, GTIN or name, and anything missing from the supplier file is reported and left unchanged.
Supplier file
Drag and drop your supplier file hereChoose your supplier file
What changes on items you already sell
Price, Default Unit Cost and New Quantity, and only on the rows you approve. New Quantity changes only if you pick a stock setting other than Ignore.
If a supplier cost or price is empty or zero, it is skipped, so a gap in the supplier file can't wipe out a price you charge today. Every other cell keeps the value Square gave it. No column moves either, because Square rejects a file with reordered or deleted columns (opens in a new tab).
| Your Square export | SKU 30-114, Price 24.00, Default Unit Cost 11.10 |
|---|---|
| Supplier CSV | Part No 30-114, Net 11.85 |
| Written back | SKU 30-114, Price 24.00, Default Unit Cost 11.85 |
If your export has no Default Unit Cost column
Only prices can change in that case, because the tool never adds a cost column to your export. Square lists default unit cost as a Plus and Premium feature (opens in a new tab), so check the column is there before you start.
Square's cost of goods sold and margin reports are built on unit cost, so keep it current. The whole routine is in how to update Square unit costs from a supplier spreadsheet.
Do I need to export my whole item library?
No. Square exports only the items you are viewing (opens in a new tab), so you can filter the item library to one category and export those items. Only items in the export can be updated.
In a filtered export, a supplier row with no match is marked as new. Check those rows before you approve them, or an item you left out of the export gets created a second time.