How do I upload a 3PL price sheet in bulk?
Here’s a guide for importing 3PL pricing for multiple SKUs or package types using a spreadsheet.
Note: This guide is for 3PL providers (as opposed to operators who use a 3PL solution).
📌 Why Use a Bulk Import?
Manually entering prices one by one in the 3PL Price Chart can be time-consuming. Instead, you can use a bulk upload template to update:
- 
Inbound/Outbound processing fees 
- 
Restocking and handling fees 
- 
Daily storage rates 
- 
Pricing by SKU or storage package 
- 
Aging-based fee tiers 
📥 Step-by-Step: Uploading a 3PL Price Sheet
- 
Go to the 3PL Price Bulk Update Tool 
 Navigate to:
 ERP → Billing → 3PL Price Bulk Update
- 
Download the Import Template 
 Click the Download Template button.
 This file includes required column headers for SKU, customer, and pricing fields.💡 Use this template—custom formats will not import correctly. 
- 
Fill Out the Template 
 Open the Excel file and enter:- 
Customer Number (3PL Client) 
- 
SKU or Package Name 
- 
Fees: Inbound, Outbound, Label, Restocking, Handling, etc. 
- 
Daily Storage Rate 
- 
Aging Range (Days From / Days To) if applicable 
 
- 
- 
Upload Your File 
 Back in 3PL Price Bulk Update, click Import- 
Choose your file 
- 
Click Upload, then Next 
- 
Confirm your mappings and click Submit 
 
- 
- 
Check the Results 
 You’ll be redirected to the Import Center- 
Refresh until status shows Complete 
- 
Any errors will be shown with a reason code 
 
- 
- 
Verify Prices 
 Return to ERP → Billing → 3PL Price Chart- 
Select the client 
- 
Click Search 
- 
Confirm that your pricing updates appear correctly 
 
- 
⚠️ Warnings & Tips
❗ Make sure the Customer Number and SKU/Package Name exactly match what’s in your system.
✅ Use aging ranges to set dynamic storage pricing (e.g., higher fees after 30 days).
🔁 You can re-upload as often as needed—new entries will overwrite existing ones for that customer and SKU.
![white-logo-db.png]](https://support.digitbridge.com/hs-fs/hubfs/white-logo-db.png?height=50&name=white-logo-db.png)