Bulk Shipping and CSV Import

Bulk shipping with CSV import is the next scaling step after manual Online Postage in the DHL Business Customer Portal. Instead of creating each shipment individually in the browser, you import an address list as a CSV file, apply postage to all shipments in one pass, and print labels as a batch job. For online retailers with 20 to 200 shipments per day, this is often the sweet spot: significantly faster than individual shipping, but without an API project or shipping software.

Mastering CSV import reduces click work at the packing station and lays the data foundation for later automation. This guide explains format, workflow, typical error sources, and the sensible transition to full shop integration.

What is bulk shipping with DHL?

Bulk shipping in the DHL Business Customer Portal means creating multiple shipping labels in batch from a shared data source. The most common approach is CSV import: you export open orders from your shop, ERP, or WMS, prepare the file according to DHL specifications, and upload it to the portal. DHL validates the records, generates tracking numbers, and provides labels for printing.

In the fulfillment context, bulk shipping differs from bulk shipments as an umbrella term: bulk shipments describe the logistical concept of large shipment volumes; CSV import is the concrete tool in the portal to apply postage to these volumes efficiently.

When is CSV import worth it?

Not every shipper needs bulk shipping. As a rule of thumb:

1. Under 15 shipments per day: Individual shipping in the portal is usually sufficient.
2. 15 to 250 shipments per day: CSV import is almost always worth it.
3. Over 250 shipments per day: Consider Integration and Interfaces or shipping software with DHL API.

Typical triggers for switching to CSV import:

• Peak seasons like Black Friday temporarily increase daily volume
• Multiple sales channels deliver orders in different formats
• The team at the packing station spends too much time on portal clicks instead of packing
• Address errors accumulate due to manual transfer

CSV format and required columns

DHL provides a CSV template for download in the Business Customer Portal. Exact column names may change slightly with portal updates – always download the current template directly from the portal before building productive exports.

Generally, a DHL CSV file contains recipient data, shipment details, and optional additional services. The file must be encoded as UTF-8 and typically use semicolon as the delimiter (German Excel default setting).

Exporting data from shop or WMS

Most shop systems offer CSV or Excel exports for open orders. The critical step is mapping: shop columns must be mapped to DHL columns. Common mapping tasks:

1. Merge first name and last name into one recipient line
2. Correctly separate or combine street and house number
3. Convert country code from ISO Alpha-2 (DE) to Alpha-3 (DEU)
4. Convert weight from grams to kilograms
5. Assign shipping product based on shipping method or package size

Step-by-step: CSV import in the portal

The bulk shipping workflow follows a fixed pattern. Standardize each step so that even temporary staff can work safely during peak periods.

001. Export and filter orders

Export only orders with status "ready to ship". Cancellations, unpaid orders, and addresses with open inquiries do not belong in the CSV. Filter by shipping date or cut-off time if you run multiple shipping waves per day.

002. Prepare and validate CSV

Before upload, secure the file with the following checks:

• No empty required fields (name, street, postal code, city, weight)
• Postal code format correct (5 digits domestic, country code for international)
• Weight greater than 0 and below product limit
• Product code included in contract
• No special characters that disrupt CSV parsing (escape quotation marks)
• Reference number unique per row
• File encoding UTF-8 with semicolon delimiter

003. Import in the Business Customer Portal

After login, navigate to "Bulk Shipping" or "Import Shipments". Upload the CSV file. The portal performs a pre-validation and marks faulty rows. Correct errors directly in the portal or in the source file and import again – depending on the error type.

004. Print labels and export shipment list

After successful validation, apply postage to all shipments with one click. Labels can be sent as PDF batch print or individually to the thermal printer. Export the shipment list with tracking numbers for write-back to shop or WMS. Details on label output can be found under Label Creation.

Typical errors and solutions

Even experienced shippers stumble over recurring CSV problems. The following overview helps with quick troubleshooting.

Quality control at the packing station

Bulk shipping increases speed – and with it the risk that label and package contents do not match. Implement a scan or reference check at the packing station:

1. Pick list with order numbers from the WMS
2. Scan label reference with pick or match visually
3. Re-weigh package and compare with CSV value
4. Seal package and place on cart for DHL pickup

Optimizing bulk shipping: best practices

Experienced shippers go beyond pure CSV import and build repeatable processes:

Establish fixed shipping waves

Instead of importing throughout the day, define fixed cut-off times – for example 10:00 AM and 2:00 PM. All orders received by then flow into one CSV. This simplifies staff planning and DHL pickup.

Automate product logic

Attach rules in the export script: shipments under 500 g and mailbox-compatible receive Warenpost, everything else DHL Paket. The decision Warenpost vs. Kleinpaket can largely be automated this way and reduces shipping costs.

Write tracking numbers back to the system

After import, export the shipment list from the portal and import tracking numbers via CSV import or manually into the shop backend. Customers then automatically receive shipping confirmations. Without this step, the customer remains in the dark – a common mistake for bulk shipping beginners.

From CSV import to API integration

CSV import is a bridge solution. With permanently high volume or complex multi-channel orders, automated label creation via API or shipping software pays off – see Integration and Interfaces.

Signs for the switch: more than 250 labels per day, more than two hours of CSV preparation daily, error-prone tracking write-back, or parallel multi-carrier processes.

Checklist: bulk shipping production-ready

10 points for a productive start:

• Current CSV template downloaded from DHL portal
• Shop export mapped to DHL columns and documented
• Test import with 5 shipments completed successfully
• Thermal printer configured for batch printing (100 x 200 mm)
• Packing station workflow with reference check defined
• Shipment list export for tracking write-back set up
• Staff trained for peak periods
• Error log for rejected CSV rows created
• Shipping waves and cut-off times established
• Escalation path for portal outages documented

Related topics

• DHL Business Customer Portal and Tools
• Online Postage
• Bulk Shipments
• Integration and Interfaces
• DHL Business Customer Portal – Glossary

Last updated: July 6, 2026