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.