How to fill your cost list using Excel or Google Sheets

Step 1 — Export your list

Go to Discount Guardian Settings → Bulk Update via CSV → click "Export Missing Costs List". You'll download a file that looks like this: 

SKU,Cost
SHIRT-RED-L,
PANTS-BLACK-32,
SHOES-WHITE-42,

Step 2 — Open alongside your supplier sheet

Open both files in Excel or Google Sheets. Your supplier sheet likely looks like this: 

SKU          Price
SHIRT-RED-L  12.50
PANTS-BLACK  8.00
SHOES-WHITE  22.00

Step 3 — Use a lookup formula in the Cost column

In cell B2 of your missing costs file, use the formula for your tool:

Excel

=XLOOKUP(A2, SupplierSheet!A:A, SupplierSheet!B:B, "")
  • A2 → the SKU you want to find
  • SupplierSheet!A:A → look for it in column A of your supplier sheet
  • SupplierSheet!B:B → when found, return the price from column B
  • "" → if not found, leave it blank

Google Sheets

=VLOOKUP(A2, SupplierSheet!A:B, 2, FALSE)
  • A2 → the SKU you want to find
  • SupplierSheet!A:B → search in columns A and B of your supplier sheet
  • 2 → return the value from the 2nd column (price)
  • FALSE → match the SKU exactly

Then drag the formula down (or double-click the fill handle) to fill all rows.

Step 4 — Save and upload

Excel: File → Save As → choose CSV format

Google Sheets: File → Download → Comma-separated values (.csv)

Go back to Discount Guardian Settings → Bulk Update via CSV → upload the file

All your costs will be updated at once ✅