Skip to main content
Technical

Hand Shipment Data to Yamato, Sagawa & Japan Post via CSV (Shopify)

Jahangir AlamJuly 24, 2026Updated October 12, 2026Facts checked October 12, 20263 min read
CSVShift-JISヤマト・佐川・日本郵便

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.

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 · Tracking import & auto-fulfillment.

See the Carrier CSV feature or start a free 14-day trial.

Frequently asked questions

Yamato B2クラウド (97 columns), Sagawa e飛伝III (74 columns), and Japan Post ゆうプリR (118 columns), all Shift-JIS encoded, one row per shipment.

No. Export profiles save your billing and freight codes and column mappings per shop — set them once.

Yes. Upload the carrier shipment CSV and OrderRules matches by order number, creates fulfillments with tracking URLs, and can notify customers.

Comparing apps?

See how OrderRules stacks up against every other Shopify app in this category.

Ready to take control of your orders?

Try OrderRules Free