From Till

fromtill.com

Tools / Plainrow / join without uploading

Match two CSV files by SKU

Put warehouse stock on every catalog product. Blank stock stays, leftovers go, and both files stay on this computer.

A client trusted you with these files. You cannot put their CSV on someone else's computer.

Put warehouse stock on every catalog product — blank stock stays, leftovers that were never listed go — and keep both files on this computer.

  1. Open the catalog and the warehouse file.
  2. Put warehouse stock onto every catalog product.
  3. Download one sheet.

Example

catalog.csv
SKUProductPrice
TOWEL-01Linen tea towel18.00
MUG-02Stoneware mug14.00
warehouse.csv
SKUOn HandBin
TOWEL-0112A-1
CRATE-0811B-8
Result
SKUProductPriceOn HandBin
TOWEL-01Linen tea towel18.0012A-1
MUG-02Stoneware mug14.00

The stoneware mug stays on the sheet with a blank On Hand. The leftover that was only in the warehouse never appears.

A client is waiting on a sheet. You are the virtual assistant, the nonprofit ops person, the one-seat bookkeeper. The next screen wants an upload. You cannot put this client's CSV in the cloud.

Lite cannot do that. Lite is free: two files, stack, dedupe, export.

Kitchen does this job. $19 one-time. Polar emails a zip. You get the sheet back without uploading.

Buy Kitchen · $19 Try Lite

Kitchen is the $19 zip Polar emails. This job runs on this computer. Lite is stack and dedupe only. Support.