A pick list (also called a picking list or picklist) is a document that tells whoever is picking orders which items to grab, how many of each, where each one is stored, and which order it belongs to. Paper pick lists are still the norm: 44% of distribution centers rely on paper-based picking (Peerless Research Group, 2024).
If retrieving products from the shelf is slowing your business down, or you’re having issues with incorrectly selected products, then using a picklist template could be an invaluable tool.
Picking is the process of removing sold products from your inventory, usually to prepare them for shipping. A lot of first-time businesses begin with a simple approach to picking: they’ll open a sales order, go to the back room to gather stock for that order, and then start all over again for the next order. This workflow is fine if you have just a few orders, but it also means a lot of unnecessary trips back and forth. And those trips add up fast. Order picking accounts for roughly 55% of warehouse operating costs, and about half of all picking time is spent walking between locations (Dukic and Oluic, 2007).
A faster way of working is to gather your orders and create a list of what needs to be retrieved, where it can be found, and which sales order the product belongs to. Sort that list by storage location, and you can pick everything in a single trip. It helps with accuracy, too, which matters more than most businesses realize: in inFlow’s 2026 survey of 400 inventory operators, the median business shipped 95–98% of orders correctly, which means as many as 1 in 20 goes out wrong.
A good place to start creating a picklist is to download our free Excel picklist template.
This is just one of the many Excel inventory templates we’ve made, so be sure to check them out!
What is a pick list?
A pick list is a document, printed or on a screen, that tells a picker exactly what to collect from storage to fill one or more orders. Every line on it answers four questions: what item, how many, where it lives, and which order it’s for.
You’ll also hear it called a picking list, a picklist, or a pick sheet. They all mean the same thing. (Fair warning: in software like Salesforce, a “picklist” is a dropdown menu. Same word, completely different job.)
Pick lists are usually created from sales orders, but manufacturers use them too when pulling raw materials for a production run. And the person working through the list? That’s the picker, whether it’s a dedicated warehouse associate or a business owner packing orders after closing time.
Here’s how it plays out. Say you run a small online kitchenware shop, and three orders come in overnight. Two of them include the same cast iron skillet. Without a pick list, you’d make three separate trips to the back room and visit the skillet shelf twice. With one, you make a single loop, grab both skillets at once, and sort them into the right orders afterward.
What should a pick list include?
At a minimum, a pick list needs an order number, an item name, a storage location, a quantity, and a way to mark each line as picked. Our template covers those, plus an aisle column for businesses with larger storage areas. As your operation grows, adding a few extra fields can save you from the most common mix-ups. We’ll flagged those in the chart below.
| Field | What goes in it | In our template? |
|---|---|---|
| Order No. | The sales order number, in case you are picking for several orders at once | Yes |
| Item name | The name of the product you need to pick | Yes |
| Location | The storage location of that product (if you have several) | Yes |
| Aisle | A sublocation, in case your storage room or warehouse has a lot of subdivisions to look through (you can hide this column if you don’t need it) | Yes |
| Quantity | The amount of that product you need to pick | Yes |
| Picked? | A checkbox to tick off when you print the list and start picking | Yes |
| SKU or barcode | A unique code that tells similar products apart (think size or color variants) | Add a column |
| Unit of measure | Each, box, or case, so nobody grabs one case when the order called for one unit | Add a column |
| Lot or serial number | Which specific lot or serial to pull, for tracked or expiring products | Add a column |
| Picker initials and date | Who picked the order and when, so you can trace mistakes back to the source | Add a column |

Pick list vs pick slip vs packing slip
A pick list and a pick slip are both internal documents that tell staff what to retrieve, while a packing slip goes in the box and tells the customer what shipped. In practice, plenty of businesses use “pick list” and “pick slip” interchangeably. When there is a distinction, it usually comes down to how many orders the document covers.
| Document | Who reads it | Covers | Shows storage locations? | When it’s used |
|---|---|---|---|---|
| Pick list | Picker | One order or many orders at once | Yes | Before picking |
| Pick slip (or pick ticket) | Picker | Usually a single order | Yes | Before picking |
| Packing slip | Customer | One shipment | No | Packed in the box with the order |
The easiest way to keep them straight: if it lists shelf locations, it’s for your team. If it lists what’s in the box, it’s for your customer.
How to use our free Excel pick list template
Our template is built for small businesses that pick from a back room, stockroom, or small warehouse. Here’s how to go from download to a finished pick in six steps.
Step 1: Download and open the template
When you click the template link, the file will download to your computer. Open it in Excel, click Enable Editing if you see a yellow banner at the top, and you’re ready to go. It’s also important to note that you’ll need an up-to-date version of Microsoft Excel to successfully access and edit the template.
Don’t have Excel? You can upload the file to Google Drive and open it in Google Sheets instead.
Step 2: Clear the sample rows
When you load up the template for the first time, you will see six columns (covered in the table above). We have left a few example orders and items in the first six rows, so feel free to delete them when you start.
Step 3: Add items from your open sales orders
The basic workflow of this picklist is to examine your open sales orders (i.e., the ones you can actually fulfill) and add all of their products to the picklist. If you have too many products to fit on one page, don’t worry: the template comes with three pages. Just scroll down to the next page and add your extra products there.
Step 4: Sort by location to cut down on trips
If you have multiple sales orders that require the same product, it might be more efficient to organize your picklist by Location first, instead of by Order No. This way, you can visit each storage location just once but still process all of your orders.
To do it, select your data, go to Data > Sort, and sort by Location, then by Aisle. To learn more about sorting your Excel picklist by the Location column, have a look at this Microsoft support article.
This small change does a lot of heavy lifting. Since roughly half of all picking time goes to walking between locations (Dukic and Oluic, 2007), every repeat trip you cut is time straight back in your pocket.
Step 5: Print the list and pick
Once your list is sorted, print it. Then you can head to the back room or storage area to start retrieving products in a single trip, instead of multiple trips back and forth. Tick the ‘Picked?‘ box for each line as you go.
Having the printed picklist with you will provide you with all the information you need to find your products and properly assign them to your orders afterward.
Step 6: Record short picks and update your stock counts
Sometimes you may think you have enough product to fulfill your orders, but once you get to the back room, you find you’re a few pieces short. In cases like this, just write the amount you were able to pick beside the checkbox in the Picked? column.
Then close the loop: update the quantities in your inventory spreadsheet and let the customer know if part of their order will ship late. Short picks are more common than most people think. 44% of operators run into a stockout at least once a month, and a pick list is often where it first gets noticed.
How to build a pick list in Excel from scratch
You can build a basic pick list in Excel in about ten minutes using headers, a table, and a few print settings. If you’d rather skip the setup, our free template has this done already. Otherwise, here’s how:
- Add your headers. In row 1, type Order No., Item name, Location, Aisle, Quantity, and Picked? Add SKU or Unit of measure columns if you need them.
- Format it as a table. Click any header and press Ctrl + T. This makes sorting and filtering a one-click job.
- Add checkboxes. In Excel for Microsoft 365, select the Picked? column and choose Insert > Checkbox. On older versions, leave the column blank and tick it by hand on the printout.
- Freeze the header row. Go to View > Freeze Panes > Freeze Top Row so the column names stay visible as the list grows.
- Repeat headers on every printed page. Under Page Layout > Print Titles, set row 1 to repeat at the top. Multi-page pick lists stay readable this way.
- Save it as a template. Choose File > Save As and pick the Excel Template (.xltx) format, so you start with a clean copy every time.
Which picking method should your pick list support?
The right picking method depends on how many orders you process and how much your orders overlap. Small businesses picking a handful of orders a day are usually fine picking one order at a time. Once several orders share the same products, batching them onto a single pick list sorted by location starts paying off. Research on conventional warehouses found that the right combination of picking methods can cut travel distance by up to 80% (Dukic and Oluic, 2007).
| Method | How it works | Best for | What the pick list looks like |
|---|---|---|---|
| Discrete (single order) picking | One picker completes one order at a time | Low order volumes and large or complex items | One pick list per order |
| Batch picking | One picker collects items for several orders in one trip, then sorts them | Orders that share the same products | One combined list, sorted by location |
| Zone picking | Each picker stays in one area and picks only the items stored there | Larger warehouses with many SKUs | One list per zone |
| Wave picking | Orders are released in scheduled groups, often by shipping cutoff or carrier | Operations with set pickup times | A new list for each wave |
For a deeper comparison, check out our guide on how to choose the best warehouse order picking method. And if you’re ready to rethink how your shelves are labeled, street-style routing is a simple way to make any pick list follow a logical path.
Common pick list mistakes (and how to avoid them)
Inventory management often involves an element of guess and check in terms of what strategies and tools will be most effective. However, it’s best to anticipate and mitigate issues as much as possible before you start. And these aren’t rare issues: 49.8% of operators name order accuracy as one of their biggest warehouse challenges.
Here are the most common pick list mistakes and how to fix each one:
- Mistakes in inventory counts and tracking. If your spreadsheet says you have 12 and the shelf has 9, every pick list built from it is wrong. Run regular cycle counts and update quantities right after each pick.
- Picking the wrong items. Similar products (a 10 oz and a 12 oz version, say) are easy to confuse. Add a SKU column and, where possible, scan barcodes to confirm each pick.
- Picking the wrong unit of measure. One “box” and one “each” are very different quantities. Add a unit of measure column for anything sold in more than one unit.
- Poor delegation for item picking. When two people work from the same list, items get picked twice or not at all. Give each picker their own list (or zone), and have them initial it.
- Mixups in staging picked items. Batch picking saves trips but creates a sorting job at the end. Use a separate tote or bin for each order and label it with the order number.
You can solve many of these mistakes with high-quality inventory management software that reduces human error. Such software helps you better organize and manage inventory by prompting you to scan the unique barcodes of items, so that any movements or changes of status are immediately and precisely documented.
It’s worth knowing where the bar sits, too. Large distribution centers tracked by WERC’s DC Measures study reported a median order picking accuracy of 99.3%, with best-in-class operations at 99.9% or higher (WERC DC Measures 2018, via Honeywell). Compare that to the 95–98% median among the smaller operators we surveyed, and it’s clear there’s room to grow.
When should you switch from an Excel pick list to software?
It’s time to move beyond an Excel pick list when you’re retyping the same order details in multiple places, more than one person picks at a time, or short picks keep catching you by surprise. A spreadsheet is a genuinely good tool at a small scale. It just can’t update itself.
You’re far from alone if you’re still on spreadsheets. 84.8% of the operators we surveyed use them to track inventory, and 74.3% rely on them as their sole or primary tool. But when inFlow customers describe the moment spreadsheets stopped working, the story is remarkably consistent. As one put it: “Multiple spreadsheets and going through emails… if you forget to update one, all the formulas get messed up.”
A few signs you’ve hit that point:
- You build the same pick list from sales orders by hand every day.
- Two pickers have grabbed the same stock for different orders.
- You manage inventory across multiple locations or sublocations.
- Short picks show up on the shelf instead of on your screen.
- Your pick list and your inventory counts are kept in separate files.
How inFlow generates pick lists automatically
Our picklist template is easy to use, but you will still need to fill it out manually every time you process your orders.
If you like using picklists and would like to speed things up even more, inFlow can help by handling your complete order flow. inFlow keeps track of your stock levels and sales orders, and turns them into pick lists for you:
- Pick lists straight from your sales orders. Print a pick list from any sales order, with the location and sublocation already filled in. You can also select multiple sales orders and bulk print their pick lists at once.
- An efficient path by default. inFlow sorts pick lists to follow an efficient route through your sublocations, and you can adjust the order in your picking options.
- No more double picks. When picking starts, inFlow allocates the exact stock (sublocation, lot, or serial number) to that order, so two team members aren’t sent after the same units.
- Scan to pick on mobile. Pick orders from the inFlow mobile app by scanning barcodes, and record partial picks when the shelf comes up short.
- Know when to reorder. inFlow flags products that drop below their reorder point and can email you low stock alerts, so you can avoid losing sales due to stockouts.
Whether you’re picking five orders a week or fifty a day, a well-built pick list is one of the simplest ways to save steps and ship the right products every time. Start with our free template, and when filling it out by hand starts eating into your day, let inFlow take it from there.
FAQ
What is a picker in a warehouse?
A picker (or order picker) is the person, or sometimes machine, responsible for collecting products from storage to fill customer orders. Pickers work from a pick list that shows each item, quantity, and location. In a small business, the picker might also be the packer, the shipper, and the owner. In larger warehouses, it’s usually a dedicated role measured on speed and accuracy.
Is a picklist the same as a pick list?
In inventory management, yes. “Picklist,” “pick list,” and “picking list” all describe the document that tells staff which items to retrieve, how many, and from where. The one-word version also has a separate meaning in software platforms like Salesforce, where a picklist is a dropdown field with preset options. Context usually makes it clear which one someone means.
What is the main purpose of a pick list in inventory management?
The main purpose of a pick list is to get the right products, in the right quantities, from the right locations, with as little walking as possible. By grouping everything a picker needs onto one sorted list, it cuts repeat trips to the same shelves and reduces picking errors. That matters because order picking makes up roughly 55% of warehouse operating costs.
Which picking method is best for small vs large order volumes?
For small order volumes, discrete picking (one order at a time) is usually simplest and most accurate. As volume grows and orders start sharing products, batch picking saves time by collecting items for several orders in one trip. Large warehouses with many SKUs often move to zone or wave picking, where pickers stay in one area or work in scheduled groups.
How do you choose the best pick locations in a warehouse?
Put your fastest-moving products in the easiest-to-reach spots, closest to your packing area and at waist to shoulder height. Keep items that are often ordered together near each other, and separate look-alike products so they’re harder to confuse. Then label every location clearly, so your pick list can point to an exact aisle, shelf, or bin.
What software can generate pick lists automatically?
Inventory management software and warehouse management systems (WMS) can both generate pick lists from sales orders automatically. For small and midsize businesses, tools like inFlow create pick lists with locations filled in, sort them into an efficient picking path, and let staff confirm picks by scanning barcodes on a mobile device. That removes the manual data entry where most picking errors start.

I am purchasing a business that stocks 500-1000 different items. Items are sold by lengths in 1/4 yard increments. Other items are sold in individual pieces. I would like to scan items into inventory and remove them as they are sold.
Which program and pricing would be best for this application?
Hi Harry,
If you’re tracking ~1000 different types of items, inFlow Cloud Essentials plan could help you with that. Monthly and annual pricing is listed here: https://www.inflowinventory.com/cloud?#pricing
If you already have a spreadsheet listing all of the different items, we can help you to import it and get you going faster in Cloud.
You can track items by the piece, by the 1/4 yard, or whatever unit of measure you prefer.
Finally, all of our software is scanner-compatible. You’d just enter the barcodes into inFlow Cloud to associate them with products, and you can then scan them straight onto orders without having to type the names out.
I hope you’ll give inFlow Cloud a try, and if you have any questions, our support team would be happy to help: https://www.inflowinventory.com/software-contact-info