虾皮台湾 订单报表(待出货・含简称规则)
示范用:同一份订单报表,加上商品简称规则,把冗长的品名缩成第一个词。规则需要依你的卖场调整。
下载
这是“虾皮台湾 订单报表(待出货)”的另一个版本,读取同一份文件。 虾皮台湾 订单报表(待出货)
已用真实的导出文件验证。
这个平台的导出文件通常有打开密码。第一次导入时 SortingGo 会请你输入,并可以记在格式里。
示例文件是合成数据,可以用来试导入,确认模板在你的 App 上正常运作。
相关说明: 商品名称太长?用商品简称规则自动缩短
这个模板的说明尚未翻译,以下以英文显示。
这个模板读取的文件
Reads the same file as "Shopee Taiwan orders (to ship)": the order report (.xlsx) from Shopee Seller Centre, sheet "orders", headers in row 1. The only difference is an added short-name rule.
取得订单文件
- Export the order report from the orders page of Shopee Seller Centre and download the .xlsx file.
- Shopee Taiwan protects the report with a password. The first time you import with this template, SortingGo asks for the password and can remember it in the format, so it is not asked again.
- Import the sample file first to see what the short names look like, then switch to your own order file.
注意事项
- The short-name rule is one custom regex: it skips the 【】 and [ ] tags at the start of a title and takes the first word after them. The full product name is kept; the short name is what the screen shows and the voice reads out.
- The rule does not suit every shop. A title that starts with a promotional word outside brackets gets that word as its short name, and products whose first word is the same get the same short name. The sample holds both on purpose: the tote bag comes out as 加厚款 (a promotional word), and two different tumblers are both called 保溫杯.
- On one real Shopee Taiwan report (57 rows to ship, 30 products) the rule produced 24 different short names, so some products shared one. Always check the result after importing.
- How to adjust the rule, patterns you can use as they are, and a prompt for asking an AI assistant are in the guide to short-name rules.
- Everything else is the same as the main template: only 待出貨 (to ship) rows, the buyer account as customer, Shopee's product ID as product code, and the variation name as spec.
怎么使用
- 在 SortingGo 的“1.导入”点导入格式的菜单,选“从模板库挑选…”。
- 找到你的平台,按“加入并用来导入”。
- 选择平台导出的订单文件。直接选文件也可以:App 认得平台的报表时,会询问要不要使用对应的模板。
也可以用文件加入:下载模板的格式文件(.xlsx),在 SortingGo 的“自定义导入格式”点“导入格式”并选择它。
需要 SortingGo 1.9.6 或更新的版本。
所有方案都可以使用模板。免费版与 Lite 不会导入订单编号与商品代码,其余字段(包含规格)都会导入。
字段对应
| SortingGo 字段 | 文件中的字段 |
|---|---|
| 订单日期 | 訂單成立日期 |
| 客户名称 | 買家帳號 |
| 商品名称 | 商品名稱 |
| 数量 | 數量 |
| 订单编号 | 訂單編號 |
| 商品代码 | 商品ID |
| 规格 | 商品選項名稱 |
| 订单备注 | 買家備註 |
模板不能用了?
平台会更改导出文件的字段。如果导入时提示找不到字段,请把只保留表头行的导出文件寄给我们(先删除所有订单数据),我们会更新模板。
字段资料的来源
模板更新日期:2026-10-05
SortingGo 与本页提到的平台没有合作或隶属关系。各平台名称属于其所有者,在此仅用来说明模板适用的文件。