Sagawa

Caution

For Sagawa slips to work as expected:

• Product type needs to include the word “Beer” or “Merch”

Set up

• Settings > settings.cod_payment_method_names_a
• Variant Types > requires_cold_shipping
• Ehiden Defaults > use_billing_address_as_sender? per shop
• Carrier Settings
  • Shipping codes
  • Shipping delivery times
• Bundling Recipes

Sagawa Settings

These 10 settings set the defaults for slips printed by eHiden.

Warehouse > Settings > Shipping Settings > Sagawa slip defaults

Customer Code

Input 12 digit customer code that appears on your monthly invoice from Sagawa

Shipping Person’s number

Input phone number

Sagawa Logistics Centre

Select one: Unspecified, SRC

Stops At Delivery Centre

Select one: Standard Delivery, Pick up from branch

Goods product types

Select multiple from BrewKeeper Product Types e.g. Merch

Insured Amount

Select one: > 35,000, > 51,000, > 100,000, > 1,000,000

Display Insured Amount

Select one: Do not display, Display if you have the insured amount

Delivery Speed

Select one: Courier Service, Supermarket, Immediate Flight, Air Mail (next day delivery), Air Mail (next morning delivery), 'Just Time' flight

Payment Style

Select one: Prepaid, Payment

Package Code

Select one: Boxed Goods, Bagged Goods, Suitcase, Envelope, Golf Bag, Skiis, Snowboard, Kegs (other)

CSV Columns

(A) 住所録コード (Address Code)

(B -> H) Shipping / Recipient Address columns

Phone number and Postal Code are kept separate from the Address1, 2 and 3 columns

• お届け先電話番号 (Column B Shipping Phone Number)
• お届け先郵便番号 (Column C Shipping Postal Code)

Address columns are concatenated from Province, City, Address1, Address2 of the Shipping Address

• お届け先住所1 (Column D Address1)
• お届け先住所2 (Column E Address2)
• お届け先住所3 (Column F Address3)

Sample Order shipping address:

• City = “012345”
• Address1 = “abcdefghijklmnopqrstuvwxy”
• Address2 = “ABCDEFGHIJKLMNOPQRSTUVWXYZ”

Using the numbers and alphabet in this example will help distinguish how they are joined together below.

Changing shipping address -> Ehiden addresses

1. Join them together - “012345abcdefghijklmnopqrstuvwxyABCDEFGHIJKLMNOPQRSTUVWXYZ”
2. お届け先住所1 = “012345abcdefghij” (first 16 characters)
3. お届け先住所2 = “klmnopqrstuvwxyA” (next 16 characters)
4. お届け先住所3 = “BCDEFGHIJKLMNOPQ” (next 16 characters)

notice RSTUVWXYZ has been cut off

Name1 and Name2 columns

• お届け先名称1 (Column G Name1)
• お届け先名称2 (Column H Name2)

Same Name:

• First name = “Shaun William”

• Last name = “Cechner”

• Company = “BrewKeeper”

• お届け先名称1 = Cechner Shaun Wi

• お届け先名称2 = BrewKeeper

Changing the name -> Ehiden name fields

お届け先名称1

1. Join together Last name and First name with a space

• “Cechner Shaun William”

2. Keep the first 16 characters

• “Cechner Shaun Wi”

お届け先名称2

1. Strip the first 16 characters of the company field

• “BrewKeeper”

(I) お客様管理ナンバー (Shipping Customer Admin Number)

13 characters order name + ’-’ + 2 digits shipping number

e.g., Order name: #2025-1234

Admin number: #2025-1234-01

(J) お客様コード (Customer Code)

12 digit customer code that appears on your monthly invoice from Sagawa.
Taken from Sagawa Settings

(K) 部署・担当者 (Person And Division In Charge)

Not set

(L) 荷送人電話番号 (Shipping Persons Number)

Taken from Sagawa Settings

(M -> R) Shipping Requestors fields

Taken from Sagawa Settings

• ご依頼主電話番号 (Column M Shipping Requestors Phone Number)
• ご依頼主郵便番号 (Column N Shipping Requestors Postal Code)
• ご依頼主住所1 (Column O Shipping Requestors Address Line 1)
• ご依頼主住所2 (Column P Shipping Requestors Address Line 2)
• ご依頼主名称1 (Column Q Shipping Requestors Name Line 1)
• ご依頼主名称2 (Column R Shipping Requestors Name Line 2)

(S) 荷姿コード (Package Code)

Taken from Sagawa Settings

• 001 = Boxed Goods
• 002 = Bagged Goods
• 003 = Suitcase
• 004 = Envelope
• 005 = Golf Bag
• 006 = Skis
• 007 = Snowboard
• 008 = Other

(T -> X) Item columns

• 品名1 (Column T Item 1)
• 品名2 (Column U Item 2)
• 品名3 (Column V Item 3)
• 品名4 (Column W Item 4)
• 品名5 (Column X Item 5)

e.g., 毬那２４本缶パックｘ２０

(Y) 出荷個数 (Item Count)

We get “Packing items” from the document items

• get the linked order line item from each document item that has an SKU
• the line item is built from the sku fragment and the quantity from the document item

We then use those packing items and bundle them according to the configured recipes

If the item count is 0, we set it to 1 (following default eHiden behaviour)

(Z) スピード指定 (Delivery Speed)

Taken from Sagawa Settings

• 000 = Courier Service (飛脚宅配便)
• 003 = Air Mail (next day delivery) (飛脚航空便（翌日中配達)
• 004 = Air Mail (next morning delivery) (飛脚航空便（翌日午前中配達）)
• 005 = “Just Time” Flight - a special service (飛脚ジャストタイム便)

The following are deprecated

• 001 = Supermarket
• 002 = Immediate Flight

(AA) 便種(商品) (Delivery Type)

This is based on whether cold shipping is required (based on the Variant Type). If it is, we set it to 002 (beer), otherwise its 001 (merch)

• 001 = Regular (Merch)
• 002 = Cool Shipping (Beer)

Not used:

• 003 = Frozen Shipping

(AB) 配達日 (Delivery Date)

If there is a Requested Delivery Date (RDD), we reformat it 2025/01/14 -> "20250114"

(AC) 配達指定時間帯 (Delivery Time 1)

• 01 = 09:00-12:00
• 12 = 12:00-14:00
• 14 = 14:00-16:00
• 16 = 16:00-18:00
• 18 = 18:00-20:00
• 04 = 18:00-21:00
• 19 = 19:00-21:00

(AD) 配達指定時間(時分) (Delivery Time 2)

Not used

(AE) 代引金額 (COD Amount)

eHiden calculates the COD amount itself from the document total.

(AF) 消費税 (Included Tax Amount)

Not supported

(AG) 決済種別 (COD Payment Method)

Taken from Sagawa Settings

(AH) 保険金額 (Insured Amount)

Taken from Sagawa Settings

(AI) 保険金額印字 (Display Insured Amount)

Taken from Sagawa Settings

(AJ -> AL) Seal Columns

• 指定シール1 (Seal 1)
• 指定シール2 (Seal 2)
• 指定シール3 (Seal 3)

There are 3 seal columns.

• If it’s cold shipping, the 001 seal is first.
• If there is a delivery time (see column AC), the delivery time code is converted from the time codes to the seal code, if there is no delivery time, but there is a delivery date, 005 is applied, which means theres a date but no time
• If there’s a COD payment required, 008 is applied

Time code conversion

delivery time -> time seal (timeframe)

01 -> 020 (morning)
12 -> 022 (12 to 14)
14 -> 023 (14 to 16)
16 -> 024 (16 to 18)
18 -> 025 (18 to 20)
04 -> 021 (18 to 21)
19 -> 026 (19 to 21)

• 001 = Cool Shipping
• 002 = Frozen Shipping
• 005 = Specific Day Delivery
• 008 = Cash-On-delivery

Deprecated:

• 007 = Specific Time Delivery
• 016 = Specific Time Delivery (AM)

🟩 Supported⬜ Not Supported

• 001: 飛脚クール便（冷蔵） (Hikyaku Cool Delivery - Refrigerated)
• 002: 飛脚クール便（冷凍） (Hikyaku Cool Delivery - Frozen)
• 004: 営業所受取サービス (Branch Pickup Service)
• 005: 指定日配達サービス (Specific Day Delivery Service) only if specific date
• 007: Specific Time Delivery (if time or time+date) [only if specific time OR time+date]
• 008: ｅコレクト（現金） (e-Collect - Cash) Only if COD
• 009: ｅコレクト（デビット／クレジット） (e-Collect - Debit/Credit)
• 010: ｅコレクト（全て可能） (e-Collect - All Payment Methods) Cash and / or wire delivery
• 011: 取扱注意 (Handle with Care)
• 012: 貴重品 (Valuables)
• 013: 天地無用 (This Side Up / Do Not Invert)
• 016: Specific Time Delivery (AM) -----> if time (AM only) or time(AM only)+ date? [we will need to test this as not sure why it would be different than flag 007]
  • return '016' if timeslot_code == '01' 01 = AM only else return '007
• 017: 飛脚航空便 (Hikyaku Air Service)
• 018: 飛脚ジャストタイム便 (Hikyaku Just-in-Time Service)
• 020: 時間帯指定サービス（午前中） (Time-Specified Delivery - Morning)
• 021: 時間帯指定サービス（18時～21時） (Time-Specified Delivery - 6 PM to 9 PM)
• 022: 時間帯指定サービス（12時～14時） (Time-Specified Delivery - 12 PM to 2 PM)
• 023: 時間帯指定サービス（14時～16時） (Time-Specified Delivery - 2 PM to 4 PM)
• 024: 時間帯指定サービス（16時～18時） (Time-Specified Delivery - 4 PM to 6 PM)
• 025: 時間帯指定サービス（18時～20時） (Time-Specified Delivery - 6 PM to 8 PM)
• 026: 時間帯指定サービス（19時～21時） (Time-Specified Delivery - 7 PM to 9 PM)

(AM) 営業店止め (Stops At Delivery Centre)

(AN) SRC区分 (Sagawa Logistics Centre)

(AO) 営業店コード (Sagawa Centre Code)

(AP) 元着区分 (Payment Style)