TikTok Shop Japan orders
CSV with Japanese headers and month/day/year dates. From a single public source; not yet checked against a real export.
Downloads
Built from public column lists and not yet checked against a real export. If a column name differs, the import reports the missing column.
The sample holds made-up data. Import it to see the template working in your app before using your own file.
The file this template reads
The order export (.csv) from TikTok Shop's Seller Center in Japan, with Japanese headers and one row per item.
Getting the order file
- Export the orders from the Seller Center and download the .csv file.
- The headers are in row 1 and the orders start in row 2.
Good to know
- This template was built from a single public source and has not been checked against a real export. If your file's column names differ, the import says which column it could not find.
- Dates are read as month/day/year (for example 01/27/2026 6:03:56 PM).
- The customer name comes from “カスタマーのユーザー名” (the buyer's account), the product code from “セラーSKU” and the spec from “バリエーション”. A product without variations shows “デフォルト” as its spec.
- English-header exports from other countries have a description row under the headers; this template expects none. If your file has one, set “rows to skip after the header” to 1 in the format.
- Order status is not filtered: every row in the file is imported. Choose the orders to ship when you export.
How to use a template
- In SortingGo, open "1. Import", tap the import format menu and choose "Choose from the template library...".
- Find your marketplace and tap "Add and use for this import".
- Choose the order file your marketplace exported. You can also just choose the file: when the app recognises a marketplace report, it asks whether to use the matching template.
You can also add a template from a file: download its format file (.xlsx), then in SortingGo open "Custom Import Formats", tap "Import format" and choose it.
Requires SortingGo 1.9.6 or later.
Templates work on every plan. Free and Lite do not import the order number and product code; every other field, including the spec, is imported.
Column mapping
| SortingGo field | Column in the file |
|---|---|
| Order date | 注文作成時刻 |
| Customer | カスタマーのユーザー名 |
| Product name | 商品名 |
| Quantity | 数量 |
| Order number | 注文ID |
| Product code | セラーSKU |
| Spec | バリエーション |
| Order remark | カスタマーからのメッセージ |
Template not working?
Platforms change their export columns. If the import reports a missing column, send us the export with only its header row (delete every order row first) and we will update the template.
Where the column names come from
Template updated 2026-10-09
SortingGo is not affiliated with or endorsed by the platforms named on this page. Their names belong to their owners and are used only to say which file a template reads.