Import your item costs from a CSV

If you have costs for a lot of items already sitting in a spreadsheet, you do not need to enter them one by one. This article covers how to bulk-set cost of goods in DashVue by uploading a CSV file from the item costs screen.

Where to find it

Go to Cost of Goods → Item costs. From there, open the CSV import option to bring up the “Import COGS from CSV” window. This is the fastest way to backfill cost data across many items in one go, rather than using Quick Fill or editing items individually.

What your CSV needs

Your file needs a column DashVue can use to identify each item, plus a column with the cost figure itself:

• A SKU column, a Title column, or both. DashVue matches by SKU first, and falls back to matching by title where no SKU match is found.
• A cost column (a COGS or Cost heading) containing the amount you paid for each item.

Any other columns in your file are ignored. There is no need to reformat an existing spreadsheet just to strip out extra data, as long as the SKU or title and the cost column are present.

Importing your file

The import runs in a single window with two steps: pick your file, then review the matches DashVue found before anything is written.

1. Go to Cost of Goods → Item costs and open the CSV import option.
2. In the “Import COGS from CSV” window, choose the CSV file from your computer.
3. DashVue matches each row to an item by SKU, or by title where no SKU match is found, and shows you the result row by row.
4. Check the matches, then confirm to write the cost values to the matched items.

Once your file is parsed, the same window switches to a preview. A summary line tells you how many rows were found and how many matched, and each row shows what it matched to and how. A green SKU badge means the row matched on SKU; a violet Title badge means it matched on the item title. Rows with no match are shown dimmed and are left untouched.

Select Import to apply the costs. Once the import finishes, the costs you uploaded feed straight into the margin and estimated net figures shown elsewhere in DashVue, the same as if you had entered them by hand. If you want to change your file first, Back returns you to the file picker.

Rows that do not match

If a row’s SKU or title does not match any item in DashVue, that row is shown as unmatched in the preview and simply will not update anything. Only the matched rows are written when you import, so the count on the import button is the number of items that will actually change. Double-check your SKUs and titles against what is showing on the item costs list if you find costs missing after an import, since a small mismatch in spelling or formatting is the most common reason a row is skipped.

See the related articles below for more on tracking costs and stock.