---
title: "Hand Shipment Data to Yamato, Sagawa & Japan Post via CSV (Shopify)"
description: "Export Shopify shipments into the official Yamato B2クラウド, Sagawa e飛伝III, and Japan Post ゆうプリR CSV layouts — Shift-JIS, one row per shipment, with tracking import."
contentType: "blog"
locale: "en"
localized: true
source: "https://orderrules.com/blog/shopify-carrier-csv-yamato-sagawa-japan-post"
slug: "shopify-carrier-csv-yamato-sagawa-japan-post"
date: "2026-07-24"
tags:
  - "shopify"
  - "carrier csv"
  - "yamato"
  - "sagawa"
  - "japan post"
  - "shift-jis"
  - "fulfillment"
---
For Japanese Shopify merchants, the slow part of fulfillment isn't packing — it's getting order data into the carrier's shipping tool. Re-typing addresses and delivery windows into **B2クラウド**, **e飛伝III**, or **ゆうプリR** by hand doesn't scale. OrderRules exports it for you, in each carrier's **official CSV layout**.

## Three official layouts, Shift-JIS encoded

OrderRules (Advanced plan) exports to the exact formats each carrier's tool expects:

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

Every file is **Shift-JIS encoded** — the encoding the carrier tools read — with **one row per shipment**, i.e. per distinct delivery date and time slot.

## Set up a profile once

1. In **Delivery**, under **Carrier CSV export**, open **Manage & customize export profiles** and customize the carrier preset you use.
2. Enter your carrier account details — for Yamato, the billing code (ご請求先顧客コード) and freight number (運賃管理番号) that B2クラウド requires. Saved per shop, so you enter them once.
3. Optionally **remap columns**. Time slots built from the carrier's preset map to its **native slot codes** automatically (e.g. 14:00–16:00 → Yamato's 14–16 code); a custom window outside the carrier's bands exports without one.
4. **Download a sample CSV** and test-import it into the carrier tool before your first live batch.

## Export by delivery date and slot

The export filters by delivery-date range, and if you turn on order tagging, orders also carry `delivery:YYYY-MM-DD` and `slot:HHMM-HHMM` tags for filtering Shopify order search by date or window. Pick the profile, export, and upload the Shift-JIS file into B2クラウド / e飛伝III / ゆうプリR. To turn a customer-chosen delivery date into a daily "ship today" list, see [Delivery date → ship date: a daily fulfillment workflow](/blog/shopify-delivery-date-to-ship-date).

## Close the loop: tracking import & auto-fulfillment

When the carrier returns tracking numbers, upload that shipment CSV under **Import tracking numbers** in **Delivery**. OrderRules matches rows to orders **by order number**, creates fulfillments with the correct **carrier tracking URL**, and can send Shopify's **shipping-confirmation email** if you tick that option.

## Why this matters

OrderRules covers all three carriers — and pairs the export with delivery scheduling and order limits in the same app. Full walkthrough: [Export shipments to carrier CSV](/docs/delivery/carrier-csv-export) · [Tracking import & auto-fulfillment](/docs/delivery/tracking-import-auto-fulfillment).

See the [Carrier CSV feature](/features/carrier-csv) or [start a free 14-day trial](/pricing).