Choose quick or prepared export
The Pirate Ship workflow has no API credential and does not purchase postage inside EZFormz. It creates a spreadsheet for Pirate Ship and later imports a shipment report.
Use the quick Pirate Ship CSV when you will choose package values during Pirate Ship import. It exports non-cancelled orders without existing tracking on a best-effort address basis.
Use Prepare Pirate Ship when orders need different saved packages, weights, or dimensions. Prepared export validates packages and addresses before download. For illustrated setup and mixed-package examples, use Pirate Ship setup and Pirate Ship mixed packages.
Export is read-only. It does not buy postage, create a shipment, change status, add tracking, or send email.
Build prepared package groups
- Open the form's Received orders page and choose Prepare Pirate Ship.
- Add a package group from a saved preset or enter its weight and dimensions manually.
- Assign every order you intend to export to exactly one group.
- Resolve all blocked addresses and package errors.
- Download each ready group.
You can prepare up to 20 groups and 1,000 orders in one workflow. Enter a positive weight and all three positive dimensions, or explicitly allow Pirate Ship's selected defaults for blank cells. Any supplied weight cannot exceed 2,400 ounces, or 150 pounds, and any supplied dimension cannot exceed 108 inches. When all dimensions are supplied, the longest side plus twice each of the other sides cannot exceed 165 inches.
EZFormz warns when a package is over 70 pounds because USPS services can disappear, and when length plus girth is over 130 inches because USPS availability can be reduced. A warning does not guarantee that Pirate Ship or a carrier will sell the package; verify the final service there.
A prepared recipient needs a name, street, and city. US addresses also need state and ZIP. Cancelled orders and orders that already have tracking are excluded and checked again immediately before download.
Changing a group's name, preset, weight, dimensions, Pirate Ship default setting, or assignments invalidates the affected prepared download state. Download the corrected groups again. Browsers can ask permission when several group files download.
Preserve prepared values during Pirate Ship import
Prepared CSVs add Ounces, Length, Width, and Height to the base address and order columns. The saved weight is already expressed in ounces; do not convert or round it again. A carrier preset name is not encoded as the Pirate Ship package type, so choose the equivalent package inside Pirate Ship when applicable.
Keep the EZFormz order ID in Order Number exactly as exported. A prepared order can appear only once, and its one row represents one package; duplicate order IDs are rejected. For a multi-box order, prepare one row and handle the additional packages manually.
The CSV does not contain Package Type, Extra Services, or Customs columns. Choose one shared setup for the group during Pirate Ship import. When EZFormz exports blank weight or dimension cells because Use Pirate Ship's selected default was enabled, confirm the values Pirate Ship will apply before buying postage.
- In Pirate Ship, choose Ship → Import a Spreadsheet and upload one exported group.
- Confirm Order Number and address mapping. For prepared groups, map ounces and all three dimensions.
- Choose the matching package type and review services, customs, addresses, and price.
- Buy labels only after Pirate Ship's final validation.
Export a usable shipment report
After buying labels, export Pirate Ship's shipment report as .xlsx or .csv. Include Order ID, plus Address 1, Address 2, City, State, ZIP, and Country when available, so EZFormz can compare identities and show useful mismatch warnings. Do not edit the exported EZFormz Order Number before the report is created.
The uploaded report can be up to 10 MB. EZFormz reads supported tracking and order/address aliases and ignores unrelated shipment status, information, date, and tracking-URL fields rather than treating them as tracking numbers.
Review how rows match
- Back in Received orders, choose Import tracking and upload the report.
- Review every ready row, every row marked Needs review, and the separate No match list.
- Compare the report values, current order, destination, and tracking number.
- Select only trustworthy rows and apply them.
Matching tries the exact EZFormz order ID first, then a unique email, a unique name plus ZIP, and finally a unique name. Only order-ID and email matches whose compared fields agree can become automatically ready. Name-based fallbacks go to Needs review. Ambiguous names and missing matches go to No match. Neither group is silently applied.
An applied row must still point to an eligible, non-cancelled order and a valid tracking number. Tracking accepts letters, numbers, underscores, and hyphens and must be at least four characters. If the order changed after preview, review or import it again.
Understand apply and repeat behavior
Applying a selected row saves the tracking number, changes an eligible order to Shipped, and sends the standard tracking email. Direct Vendor Shipped is preserved instead of being replaced. Completed or Cancelled orders and other newly ineligible statuses are not overwritten.
Importing the same unchanged tracking again is skipped as a no-op. Pirate Ship does not send later tracking events to EZFormz, so the order remains Shipped unless you update it manually. For multiple boxes, import one tracking number and add the others manually to the order; prepared export cannot represent the same order as several package rows.
The export and report contain buyer names, emails, phone numbers, delivery addresses, order IDs, items, and totals. Upload them only to the official Pirate Ship account, restrict access to the files, and delete copies when your fulfillment and record-retention needs allow.