Click & Drop Pick List Template & Automation Guide

When e-commerce order volumes grow beyond 15 or 20 parcels a day, processing orders one by one becomes an operational bottleneck. UK online sellers using Royal Mail Click & Drop quickly run into a frustrating limitation: the platform has no native feature to generate a consolidated picking list for your warehouse or packing area.

Royal Mail Click & Drop excels at generating postage labels, but it lacks warehouse picking logistics. Sellers are left trying to pick items directly from individual screen rows, printing single packing slips, or manually copying order data into a spreadsheet.

This guide explains why Royal Mail does not offer a native pick list, how to build a manual Excel pick list template, and how modern browser automation bridges the gap without requiring expensive software.

What Is a Pick List (and Why Click & Drop Doesn't Have One)?

Before building a picking workflow, it is important to distinguish between two documents often confused in warehouse management:

• Packing Slip: A customer-facing document placed inside the parcel. It lists the items contained within that specific order alongside delivery instructions and branding.
• Pick List (Picking Sheet): An internal warehouse document created for the picker. It consolidates every item required across an entire batch of orders, grouping duplicate SKUs together so the picker can gather stock in a single walk through the warehouse.

+-------------------------------------------------------------------+
|                       CONSOLIDATED PICK LIST                      |
+---------------------+-------------------+-------------------------+
| SKU                 | Item Description  | Total Quantity to Pick  |
+---------------------+-------------------+-------------------------+
| WGT-BLK-S           | Widget Black (S)  | 14 units                |
| WGT-RED-M           | Widget Red (M)    | 8 units                 |
+---------------------+-------------------+-------------------------+

Why Royal Mail Omitted Pick Lists

Royal Mail Click & Drop was built primarily as a transactional carrier bridge—a portal to import order addresses, apply postage services, and generate compliant 4x6 inch shipping labels or delivery notes.

According to Royal Mail Click & Drop documentation, the orders grid is intended for order administration and despatch confirmation, not active warehouse picking. Because Click & Drop does not manage bin locations, inventory levels, or warehouse routes, it leaves order aggregation to external sales channels or dedicated middleware.

Attempting to pick directly from the Click & Drop dashboard forces pickers to walk back and forth across storage shelves for every individual order, drastically increasing picking errors and labor costs.

Method 1: The Manual Excel Pick List Template (The Hard Way)

For small operations processing low volumes, creating a manual spreadsheet template in Microsoft Excel or Google Sheets provides a zero-cost starting point.

[Sales Channels] ---> [Export CSV] ---> [Excel Clean-up] ---> [Print Pick List]
                                             |
                                    (15-30 mins per batch)

Step-by-Step Setup

1. Export Data: Log into your primary sales channel (Shopify, Etsy, eBay, or WooCommerce) or export the unmanifested order report from Click & Drop.
2. Format Columns: Open the CSV file in Excel and filter for three essential columns: SKU, Item Title, and Quantity.
3. Aggregate Quantities: Create a Pivot Table (Insert > PivotTable). Place SKU and Item Title in the Rows area, and set Quantity to Sum in the Values area.
4. Print Document: Print the aggregated pivot table for your picking team to use on the warehouse floor.

Limitations of Spreadsheet Templates

While functional, spreadsheet templates introduce operational risks as daily order volumes grow:

• Time Consumption: Exporting, cleaning, and formatting data takes 15 to 30 minutes per despatch batch.
• Data Integrity Errors: Copy-pasting errors can lead to missing line items or incorrect item counts.
• Static Data: Standard spreadsheets do not clean up messy product titles or strip redundant variation text automatically.
• No Sorting Link: A spreadsheet pick list does not re-sequence your Royal Mail PDF labels, meaning you still spend significant time searching for the matching shipping label after picking.

Method 2: Enterprise Order Management Systems (The Overkill Way)

At the enterprise level, multi-channel businesses often deploy full Order Management Systems (OMS) or Warehouse Management Systems (WMS) such as Shiptheory or Selro.

[Sales Channels] ---> [Enterprise OMS] ---> [Royal Mail API]
                            |
               (Includes Picking & Packing)

Advantages

• Direct API connection across multiple sales channels.
• Advanced barcode scanning and bin-location routing.
• Automated rules for carrier selection.

Drawbacks for Small to Medium Sellers

• High Monthly Cost: Subscription fees often start at £30–£150+ per month.
• Operational Friction: Requires migrating your entire fulfilment workflow out of the intuitive Royal Mail Click & Drop interface into a complex third-party dashboard.
• Setup Complexity: Configuring rules, mapping integrations, and training staff can take weeks.

Method 3: Browser Extension Automation with ShipKnot (The Smart Way)

For UK e-commerce merchants who prefer keeping Royal Mail Click & Drop at the core of their despatch routine, ShipKnot offers a lightweight browser extension that bridges the picking gap directly inside Chrome.

+--------------------------------------------------------------------+
|                    ROYAL MAIL CLICK & DROP                         |
| +--------------------------------+ +-----------------------------+ |
| | Active Orders Grid             | | [ShipKnot Chrome SidePanel] | |
| | - Order #1001 (2x Widget Black)| |                             | |
| | - Order #1002 (1x Widget Black)| | -> Auto-Consolidates Items  | |
| |                                | | -> Generates A4 Pick PDF    | |
| +--------------------------------+ +-----------------------------+ |
+--------------------------------------------------------------------+

Rather than forcing you into an external platform, ShipKnot runs natively inside Chrome's SidePanel while you view your Click & Drop dashboard. It acts as an automated item extractor, consolidator, and PDF pick list generator.

Key Features for Picking & Packing

• Instant A4 PDF Pick Lists: Extracts active orders directly from Click & Drop (/api/orders/v2) and compiles print-ready A4 picking sheets formatted specifically for warehouse clipboards.
• Smart Item Consolidation: Merges identical items across disparate orders using title matching, SKU matching, or custom rules. Item quantities are summed automatically with bold visual callouts.
• Title Overrides & Keyword Trimming: Strips unnecessary variation fluff (e.g., "Color: Red, Size: Medium") or cleans up long product titles to keep picking sheets concise.
• Integrated PDF Sorter: Re-orders standard 2-page Royal Mail PDF packs (Delivery Note + Label) to match your physical picking order or custom criteria (SKU, Quantity, Order ID).
• 100% Local Browser Processing: Operates entirely within your browser local session. Customer names, delivery addresses, and order details are processed client-side and never transmitted to external servers.

Merchants can review features and tier options on the ShipKnot home page and explore flexible options on the /pricing page.

Comparison: Manual Excel vs. Enterprise OMS vs. ShipKnot

Step-by-Step: Setting Up an Efficient Order Picking Workflow

To minimise errors and reduce warehouse handling time, structure your daily picking routine around these four stages:

[1. Sync & Merge] ---> [2. Generate Pick List] ---> [3. Physical Pick] ---> [4. Sorted Pack]

Phase 1: Batching & Deduplication

Clear pending edits in your sales channels (Shopify, Etsy, eBay) and sync all active orders into Royal Mail Click & Drop. If customers have placed multiple separate orders to the same recipient address, merge them prior to picking to avoid redundant shipping fees.

Phase 2: Consolidate the Pick Document

Extract active orders into an aggregated pick list document. Ensure product options display clear identifiers (SKU and primary Title). Clean up long strings so warehouse staff can scan item lines quickly without reading unnecessary marketing descriptions.

Phase 3: Route Optimisation

Organise your warehouse or stockroom logically. Store high-frequency SKUs (fast movers) near the packing table. Print your consolidated pick sheet and navigate storage shelves once to collect total unit counts for every item line required in the batch.

Phase 4: Matching Labels to Items

Once items arrive at the packing desk, use a sorted PDF label pack. Sorting delivery notes and postage labels by SKU count or item name allows packers to process single-item orders in bulk before moving on to complex multi-item shipments.

Best Practices to Eliminate Warehouse Packing Errors

1. Standardise SKUs Across Channels: Ensure identical items share the exact same SKU string across Shopify, Etsy, and eBay. Mismatched SKUs prevent picking engines from accurately aggregating total quantities.
2. Separate Single-Item from Multi-Item Orders: Single-item orders account for up to 70% of daily volume for many e-commerce brands. Batch-picking single-item orders allows for ultra-fast packing assembly lines.
3. Implement Visual Pick Checkboxes: Use pick sheets featuring clear checkbox targets next to bold quantity numbers. Require pickers to check off items physically as they enter the batch bin.
4. Audit First-Page/Last-Page Bounds: When printing large PDF label batches, double-check that label counts match delivery notes. Using built-in PDF verification tools prevents misaligned 2-page pair sets.

Summary

Relying on manual spreadsheet templates or printing unorganised orders directly from Royal Mail Click & Drop slows down despatch times and increases fulfillment errors. While full Enterprise OMS solutions exist, they often add unnecessary cost and administrative complexity for small and medium UK sellers.

By leveraging targeted browser tools like ShipKnot, sellers can generate consolidated A4 PDF pick lists, clean item titles, and re-sort shipping label packs directly within their existing Click & Drop window—saving hours of manual effort every day.

Frequently Asked Questions

Does Royal Mail Click & Drop have a built-in pick list feature? No. Royal Mail Click & Drop is designed for shipping label generation and payment. It does not provide a native feature to aggregate orders into a consolidated warehouse pick list.

What is the difference between a pick list and a packing slip? A pick list is an internal warehouse document that sums total quantities of all items across a batch of orders for efficient picking. A packing slip is an individual customer receipt placed inside a single parcel.

How can I make a pick list using Excel from Click & Drop? You can export your unmanifested orders CSV, open it in Microsoft Excel, and insert a Pivot Table using 'SKU' as the row label and 'Quantity' as the sum value to create a basic consolidated pick sheet.

Can ShipKnot create pick lists directly inside Royal Mail Click & Drop? Yes. ShipKnot is a Chrome extension that opens in Chrome's SidePanel on the Click & Drop dashboard. It extracts active orders, merges duplicate line items, and generates print-ready A4 PDF picking sheets instantly.