Shopee Taiwan orders (to ship, with short names)

คำอธิบายของเทมเพลตนี้ยังไม่ได้แปล จึงแสดงเป็นภาษาอังกฤษ

ไฟล์ที่เทมเพลตนี้อ่าน

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.