Skip to content
English
  • There are no suggestions because the search field is empty.

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

  1. Go to the 3PL Price Bulk Update Tool
    Navigate to:
    ERP → Billing → 3PL Price Bulk Update

  2. 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.

  3. 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

  4. Upload Your File
    Back in 3PL Price Bulk Update, click Import

    • Choose your file

    • Click Upload, then Next

    • Confirm your mappings and click Submit

  5. 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

  6. 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.


📎 Related Guides