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 upload screen. 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 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 cost columns are present.

Importing your file

1. Go to Cost of goods → Item costs and open the CSV import option.
2. Choose the CSV file from your computer.
3. Let DashVue match each row to an item by SKU, or by title where no SKU match is found.
4. Confirm the import so the cost values are written to the matched items.

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.

Rows that do not match

If a row’s SKU or title does not match any item in DashVue, that row simply will not update anything. 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.