---
title: "Export shipments to carrier CSV (Yamato / Sagawa / Japan Post)"
description: "Export Shopify shipments to Yamato B2クラウド, Sagawa e飛伝III, or Japan Post ゆうプリR. Set up an editable profile, download a Shift-JIS CSV, and import tracking."
contentType: "docs"
locale: "en"
localized: true
source: "https://orderrules.com/docs/delivery/carrier-csv-export"
slug: "delivery/carrier-csv-export"
---
OrderRules exports your delivery orders into the **official CSV layouts** for Japan's three major carriers, ready to upload into each carrier's shipping tool. You set up a profile once, then export in a couple of clicks per batch.

## Supported layouts

- **Yamato — B2クラウド** (97 columns)
- **Sagawa — e飛伝III** (74 columns)
- **Japan Post — ゆうプリR** (118 columns)

All exports are **Shift-JIS encoded** (what the carrier tools expect) with **one row per shipment** — i.e. per distinct (delivery date, time slot).

## 1. Create an export profile

1. **Delivery → Carrier CSV → Add profile.**
2. Choose the **carrier / layout** (Yamato B2クラウド, Sagawa e飛伝III, or Japan Post ゆうプリR).
3. Enter your **carrier account details** — billing code, freight/charge codes, and any shipper defaults the layout requires. These are saved per shop, so you only enter them once.
4. (Optional) **Remap columns** if your carrier account uses non-default fields, and map OrderRules **slot windows** to the carrier's **native slot codes** (e.g. 14:00–16:00 → the carrier's afternoon code).
5. **Download a sample CSV** and do a test import in your carrier tool before your first live batch. Fix any field mapping, then save.

## 2. Export a batch

1. **Delivery → Carrier CSV → Export.**
2. Filter the orders to export — typically by **delivery date** (and slot). Auto-tagging (`delivery:YYYY-MM-DD`, `slot:HHMM-HHMM`) makes these filters exact.
3. Pick your **profile** and **Export**. You get a Shift-JIS CSV with one row per shipment.
4. Upload the file into the carrier's tool (B2クラウド / e飛伝III / ゆうプリR).

## 3. Import tracking numbers & auto-fulfill

After the carrier assigns tracking numbers:

1. **Delivery → Tracking import.**
2. Upload the carrier's **shipment CSV** (the file that includes tracking numbers).
3. OrderRules matches rows to orders **by order number**, creates fulfillments with the correct **carrier tracking URL**, and (optionally) **notifies customers**.

## Tips

- Keep one profile per carrier account; duplicate and tweak for seasonal freight codes.
- Always re-download a sample after changing column mappings.
- Slot codes differ by carrier — set them in the profile once so every export is correct.

## Related

- [Order auto-tagging](/docs/delivery/order-auto-tagging) · [Time slots](/docs/delivery/time-slots) · [Tracking import & auto-fulfillment](/docs/delivery/tracking-import-auto-fulfillment)
- See the [Carrier CSV feature overview](/features/carrier-csv).