Prepare two SKU exports
Export the old and new inventories as UTF-8 CSV. Keep the original file rows so you can trace the result. If the spreadsheet has already converted 00123 to 123, restore the SKU from the source system before exporting.
Trace matches to the source
Choose CSV and column 2 on both sides, skip the header, then open Advanced settings and select Include source lines in CSV. Download the relevant panel. A-only identifies records missing from the new snapshot; B-only identifies new SKUs.
Read a repeat correctly
For the samples below, the shared SKU 00123 is on lines 2 and 3 in A and line 2 in B. Its row in the In both CSV therefore contains 00123, 2 3, and 2. For multiline records, the exported number is the record’s starting line.
name,sku Cable,00123 Spare,00123 Adapter,410
name,sku Cable,00123 Dock,550