Fix Click Post CSV Errors: Address Fields, Encoding, and Postal Codes

(Updated: )13 min read
Fix Click Post CSV Errors: Address Fields, Encoding, and Postal Codes
Table of Contents

Fix Click Post CSV import errors: address fields, encoding, and postal codes

When a CSV import fails, check the screen message and affected rows, then compare the column order, encoding, and required fields with Japan Post's template. Japan Post does not publish error-frequency data, so this guide does not rank causes. The before-and-after examples below are fictional. For the full workflow, also see the Shopify × Click Post shipping guide.

Check the official CSV requirements

Click Post's Bulk Application uses the official CSV template. Keep its column names and order. The official CSV guide lists these main requirements:

FieldOfficial requirement
Postal code7 half-width digits without a hyphen, or 7 half-width digits plus one half-width hyphen (8 characters total)
Recipient nameRequired; up to 20 full-width or 40 half-width characters, excluding the honorific
Honorific“Sama” or “Onchū”
Address lines 1–4At least one is required; each allows 20 full-width or 40 half-width characters
ContentsRequired; up to 15 full-width or 30 half-width characters
CSVCSV text in Shift-JIS; up to 40 items per upload

The guide also says not to change the template's header row. If you start with data exported from Shopify or another system, match the field names, column order, and character limits before uploading.

Correct errors using examples

These before-and-after examples are fictional. They are not actual error messages or real addresses.

CheckFictional example before correctionFictional example after correction
Address fieldPut a fictional Japanese address with 21 full-width characters entirely in address 1Preserve all parts: put the first 11 characters (prefecture, city, and town) in address 1 and the 10-character building name in address 2. Joining them in order reproduces the original address; check each field’s limit
Postal codeFull-width digits and a full-width hyphen7 half-width digits without a hyphen, or 7 half-width digits plus one half-width hyphen (8 characters total)
EncodingSaved as UTF-8Saved as Shift-JIS as specified by the official guide
Column orderReordered columnsKeep the official template's header and column order

Do not delete street numbers, building names, or other address details to fit a field limit. Join the fields in order and check that they reproduce the original address and remain clear for delivery. For more address-field examples and checks, see How to prevent Click Post address errors.

Conceptual diagram of splitting a fictional address across fields without losing information; not an actual app screen.
Conceptual diagram of splitting a fictional address across fields without losing information; not an actual app screen.

Prepare the CSV and submit a Bulk Application

1. Identify the scope of the import error

In Click Post's Bulk Application screen, check whether the whole file failed or only particular rows. Use the message and affected rows to compare the file with the official template.

2. Check the CSV format, encoding, and header

Confirm that the file is CSV text in Shift-JIS. Check that columns were not added, removed, or reordered, and that the header names were not changed.

3. Check required fields and field lengths

Check the postal code, recipient name, at least one address field, and contents. Address lines 1–4, the name, and contents each have character limits in the official guide. Split long addresses across fields while keeping them readable.

4. Check postal-code digits and hyphens

Use 7 half-width digits without a hyphen, or 7 half-width digits plus one half-width hyphen (8 characters total). Replace any full-width digits or hyphens.

5. Split uploads above 40 items

One upload allows up to 40 items. For 41 or more, split the order rows so each file contains no more than 40, then upload the files separately. Compare order numbers and counts afterward to look for omissions or duplicates. For detailed CSV-splitting and bulk-application steps, see How to use Click Post’s Bulk Application.

Export CSV from Shopify and register tracking numbers

The Shopify listing for Instant Ship! for Click Post describes CSV export from selected Shopify orders and automatic address splitting. Check the exported order details and the official template requirements before uploading. The listing does not say that the app automatically splits CSVs into groups of 40, so split files yourself when needed.

After Click Post creates the shipping labels, upload the original label PDF issued by Click Post to the app. Review the candidate tracking numbers and their order matches shown by the app, then confirm registration to the corresponding Shopify orders. See the app guide for the listed features.

Frequently asked questions

What is the most common cause of a Click Post CSV import error?

Japan Post does not publish data showing error frequencies, so we cannot rank the causes. First, read the on-screen message, then check the official template's column order, Shift-JIS encoding, required fields, and address-field character limits.

Can I upload a Shopify CSV to Click Post without changes?

Not necessarily. Match the exported fields to the Click Post template's columns and requirements, then save it as CSV text in Shift-JIS. Up to 4 address fields are available, each with a limit of 20 full-width or 40 half-width characters.

Why does a CSV made on a Mac show garbled text?

If the CSV was saved in an encoding other than Shift-JIS, it may show garbled text or an import error. Check the file encoding and save it again in Shift-JIS as stated in the official guide.

How do I fix an address-length error?

Each of address lines 1 through 4 must be within 20 full-width or 40 half-width characters. Split a long address across fields in a readable way, then check the character count in each field.

What should I do if a CSV exceeds the 40-item limit?

The official guide allows up to 40 items per CSV upload. Split the order rows so each file has no more than 40 items, then upload the files separately.

Compare the CSV with the official template and the message on the Click Post screen before uploading. To learn about creating a CSV from Shopify orders and reviewing and registering tracking-number candidates from the original label PDF, see the app's Shopify App Store listing and app guide.

Related Articles