Skip to main content
OrderRules

Export shipments to carrier CSV (Yamato / Sagawa / Japan Post)

2 min read

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

In-Store Pickup SetupTracking Import & Auto-Fulfillment