Skip to content
Business Tools

SKU Pick List Generator

Aggregate order quantities by SKU, sort by bin, and print one pick list.

Combine the same SKU across orders, organize by bin, and make one printable list for picking.

Up to 5,000 rows or 5 MB · Your CSV stays in your browser

Data handling

Storage and export controls

Retention
The tool's working state is kept only while this page is open. Inputs and results are not saved to persistent storage by Got A Tool.
Export
The tool may prepare a result after you run it. It downloads or copies it only when you choose that action.

Advertising and analytics are separate site services. We do not send selected tool input to them. Read the Privacy Policy for details.

How it works

Turn order rows into one warehouse pick list

01

Add your order CSV

Choose the CSV containing each order line. It stays in your browser while you work.

02

Map and review

Map order, SKU, item, quantity, and optional location columns. Review exact source rows for incomplete or conflicting data.

03

Pick by location

Download one printable PDF with combined SKU quantities, sorted by location, and the orders that contributed to each SKU.

Example

Two orders, one SKU to pick

If order A-100 contains 2 MUG-BLUE items and B-200 contains 3, the list shows one MUG-BLUE line with a quantity of 5 and both order numbers. Located SKUs are sorted first; blank locations appear as Unassigned at the end.

Questions

Pick list details

What makes a row invalid?

An order number, SKU, item, and positive whole-number quantity are required. Each issue names its original CSV row.

What if the same SKU has different locations?

The SKU is excluded from the finished list and the conflicting source row is reported, so a picker is not sent to an ambiguous location.

Are orders combined automatically?

No order records are changed. The PDF only summarizes what to pick and preserves contributing order numbers.

Keep working