CSV Import Guide

Notice

We have recently updated the CSV values for Services and Packages. Please refer to our CSV Guide page for the latest list.

CSV Import Guide: Steps for Bulk Shipment Processing

Streamline your bulk shipment management using CSV files and guarantee label accuracy on every attempt.

Understanding CSV

A CSV (Comma-Separated Values) file is a straightforward text file that retains tabular data, akin to a spreadsheet. Consider it the foundational framework of an Excel document – pure data without the added embellishments like fonts, colors, or calculations.

Core Aspects of CSV:

  • The file must have a .CSV extension.
  • Data fields are delineated by commas; hence, no data field should contain a comma.
  • Preferred size: Up to 50 labels and no more than 20,000 characters.

Breaking Down the CSV Fields

Utilizing our efficient template simplifies the entire procedure. Here's a detailed breakdown of the necessary data points:

Field Description Examples & Options
Carrier Designated shipping service Ex: USPS
Service Specific shipping service Ex: Priority; See the carrier service types section below.
Length Package measurements (in inches) -
Width Package measurements (in inches) -
Height Package measurements (in inches) -
Weight(Lbs) Weight of the package in pounds -
Weight(Oz) Weight of the package in ounces -
Package Type Specific package type used for shipment Ex: FlatRateEnvelope, Custom; See the carrier package types section below.

USPS Service Types (Domestic Only):

Service Type Delivery Duration
USPS_First (First Class Mail) 1-5 business days
USPS_Priority (Priority Mail) 1-3 business days
USPS_Express (Priority Mail Express) 1-2 days
USPS_GroundAdvantage (Ground Advantage) 2-5 days
USPS_LibraryMail (Library Mail) 2-8 business days
USPS_MediaMail (Media Mail) 2-8 business days

USPS Package Types:

  • Custom (Custom)
  • USPS_Card (Card)
  • USPS_Letter (Letter)
  • USPS_Flat (Flat)
  • USPS_Parcel (Parcel)
  • USPS_IrregularParcel (Irregular Parcel)
  • USPS_Softpack (Softpack)
  • USPS_FlatRateEnvelope (Flat Rate Envelope)
  • USPS_FlatRateLegalEnvelope (Flat Rate Legal Envelope)
  • USPS_FlatRatePaddedEnvelope (Flat Rate Padded Envelope)
  • USPS_FlatRateGiftCardEnvelope (Flat Rate Gift Card Envelope)
  • USPS_FlatRateWindowEnvelope (Flat Rate Window Envelope)
  • USPS_FlatRateCardboardEnvelope (Flat Rate Cardboard Envelope)
  • USPS_SmallFlatRateEnvelope (Small Flat Rate Envelope)
  • USPS_SmallFlatRateBox (Small Flat Rate Box)
  • USPS_MediumFlatRateBox (Medium Flat Rate Box)
  • USPS_LargeFlatRateBox (Large Flat Rate Box)
  • USPS_RegionalRateBoxA (Regional Rate Box A)
  • USPS_RegionalRateBoxB (Regional Rate Box B)
  • USPS_LargeFlatRateBoardGameBox (Large Flat Rate Board Game Box)

CSV FAQ

  • Can I resubmit an identical file? Certainly! However, this will initiate new individual shipments. It's beneficial for repeated shipping needs.
  • What happens if my CSV file exceeds the recommended size? Uploading an overly large file may lead to processing errors or delays. It's recommended to split larger files or contact us for assistance.
  • Can I use special characters in my CSV file? While special characters (e.g., &, #, $) might be acceptable, it's best to avoid them to prevent potential issues. Stick to alphanumeric characters and standard punctuation.
  • How often can I upload CSV files? You can upload as frequently as you need. However, ensure each file meets the recommended size and format requirements for optimal processing.

Common Challenges & Resolutions:

  • Inaccurately entered carrier names.
  • Mismatched service type with chosen carrier.
  • Selection of an inappropriate package type.
  • A carrier's inability to provide a cost estimate for the selected service.

We Value Your Feedback!

Ensuring your seamless shipping experience remains our primary concern. Should you have suggestions, questions, or wish to report issues, don't hesitate to connect with us. We're eager to assist!