TikTok Shop 订单（日／月／年）导入模板

下载

依公开的字段资料制作，尚未用真实的导出文件验证。字段名称不同时，导入会提示找不到字段。

示例文件是合成数据，可以用来试导入，确认模板在你的 App 上正常运作。

这个模板的说明尚未翻译，以下以英文显示。

The order export (.xlsx) from TikTok Shop Seller Center with English column headers, one row per item.

Export orders from the orders page of Seller Center and download the .xlsx file.
The template reads the first sheet of the workbook. Headers are in row 1, row 2 holds column descriptions and is skipped, and data starts in row 3.

Built from public sources and not yet checked against a real export. If a column name differs in your file, the import reports the missing column.
Dates are read as day/month/year, which is what sellers in Vietnam report. If your export writes month/day/year (seen in Japan), change the date order in the format, or every date with a day of 12 or less is read wrongly.
This template needs English headers. If your Seller Center is set to another language, the headers are in that language and will not match.
The customer is the buyer username. Items without a variation have "Default" as the spec.
Order status is not filtered: every row in the file is imported. Select the orders to ship when you export.

也可以用文件加入：下载模板的格式文件（.xlsx），在 SortingGo 的“自定义导入格式”点“导入格式”并选择它。

需要 SortingGo 1.9.6 或更新的版本。

所有方案都可以使用模板。免费版与 Lite 不会导入订单编号与商品代码，其余字段（包含规格）都会导入。

平台会更改导出文件的字段。如果导入时提示找不到字段，请把只保留表头行的导出文件寄给我们（先删除所有订单数据），我们会更新模板。

模板更新日期：2026-10-05

SortingGo 与本页提到的平台没有合作或隶属关系。各平台名称属于其所有者，在此仅用来说明模板适用的文件。