DOCS

Uploading orders in bulk

Uploading orders in bulk

Quickly sync orders from sales channels into the Zonos Dashboard by uploading a CSV file. Once orders are uploaded, you can select them in the shipment list and create Japan Post labels.

Before you can create labels

Complete your account setup and add a fulfillment center first. Labels cannot be created until both are done.

U.S. destinations only

Verified Account shipments are U.S.-bound only. Every row's Country Code must be US — non-U.S. destinations are rejected during upload.

  1. Go to DashboardOrders.
  2. Click Upload orders in the page header.
  3. Drag and drop your CSV file, or click to browse.
  4. Review the parsed rows.
  5. Click Create orders to create the orders.

After upload, your orders appear in the shipment list. Check the orders you want to label, then click Create labels. See Creating shipping labels for the label flow.

Download the CSV template from the Upload orders dialog in the Zonos Dashboard to see the expected column headers and order.

Save the template, fill in one row per item (multiple items per order share the same Order ID), and upload the completed file.

Each row represents one item. Multiple items belonging to the same shipment share the same Order ID, and order-level values (recipient, carton, and customs fields) are merged across those rows — the first non-empty value per field wins.

The columns below are listed in the same order as the downloadable template.

ColumnRequiredDescription
Order IDYesUnique identifier for the order. Repeated rows with the same Order ID are grouped into one shipment.
Item NameYesName of the item being shipped. Latin characters only.
HS CodeYesHS tariff code for the item.
Country of OriginYesTwo-letter ISO country code for where the item was manufactured (e.g. JP).
Item PriceYesUnit price of the item. Must be greater than 0.
CurrencyNoThree-letter currency code for the prices in the row. Defaults to your organization's currency when blank.
QuantityNoNumber of units. Whole number greater than 0; defaults to 1.
Item WeightYesWeight per unit. Must be greater than 0.
Weight UnitNoUnit for Item Weight (kg, lb, g, or oz). Defaults to grams when blank. See Weight and dimension units.
Carton LengthNoLength of the carton. See Cartons.
Carton WidthNoWidth of the carton.
Carton HeightNoHeight of the carton.
Carton Dimensional UnitNoUnit for the carton dimensions (cm, in, mm, or m). Defaults to centimeters.
Carton WeightNoWeight of the carton.
Carton Weight UnitNoUnit for Carton Weight (kg, lb, g, or oz). Defaults to grams.
Company NameNoRecipient's company name. Latin characters only.
First NameYesRecipient's first name. Latin characters only.
Last NameYesRecipient's last name. Latin characters only.
EmailNoRecipient's email.
PhoneYesRecipient's phone number.
Address Line 1YesRecipient's street address. Latin characters only.
Address Line 2NoRecipient's apartment, suite, or unit. Latin characters only.
CityYesRecipient's city. Latin characters only.
Postal CodeYesRecipient's ZIP code.
State/ProvinceYesU.S. state name or two-letter code (e.g. CA).
Country CodeYesDestination country. Must be US.
End UseNoFOR_RESALE or NOT_FOR_RESALE. Defaults to NOT_FOR_RESALE.
Shipping AmountYesShipping cost charged to the customer. Can be 0, but the column cannot be blank.
Contents TypeNoCustoms contents type (e.g. Sale of goods). See Customs and declaration fields.
Licence NumberNoExport license number, when one applies.
Certificate NumberNoCertificate number, when one applies.
InvoiceNoCommercial invoice number.
Tax Code/VAT NumberNoTax or VAT identifier for the shipment.
Pay ConditionNoPayment conditions for the shipment.
RemarksNoFree-text customs remarks.
Sender's Reference NumberNoYour internal reference or purchase-order number.
Non-commercialNotrue for a non-commercial shipment; false or blank for commercial.

The six Carton columns describe the box each shipment ships in. The dimensions and weight print on the Japan Post label, so Zonos does not auto-cartonize — supply real values.

Carton columns are optional, but if you provide a carton you must fill Carton Length, Carton Width, Carton Height, and Carton Weight together. A partial carton is ignored. When the units are blank, dimensions default to centimeters and weight defaults to grams (the CP72 customs units).

Cartons are order-level: on a multi-item order, set the carton columns on any one row for that Order ID.

These optional columns carry through to the Japan Post customs declaration on the label:

  • Contents Type — the customs reason for the contents (e.g. Sale of goods).
  • Licence Number, Certificate Number — regulatory identifiers when an item requires them.
  • Invoice — commercial invoice number.
  • Tax Code/VAT Number — tax or VAT identifier for the shipment.
  • Pay Condition — payment conditions for the shipment.
  • Remarks — free-text notes for the declaration.
  • Sender's Reference Number — your internal reference or purchase-order number.
  • Non-commercial — set to true to flag the shipment as non-commercial.

Like the carton, these are order-level — set them once per Order ID.

Weight units (Weight Unit and Carton Weight Unit) accept kg, lb, g, or oz. Dimension units (Carton Dimensional Unit) accept cm, in, mm, or m.

For Japan Post the unit columns are optional and default to the CP72 metric units — grams for weight and centimeters for dimensions. Because the unit is read from your file, you can keep your data in the units your sales channel exports; Zonos converts the net weight to grams for the customs declaration.

You do not choose a service level in the CSV. Pick the Japan Post service level for each shipment when you create labels in the Dashboard — see Creating shipping labels.

Book a demo

Was this page helpful?