Why specs belong in the editing phase
Aspect ratio, duration, container, file size and cover frame all affect layout, caption placement and whether you need to re-export. Discovering a mismatch at upload time usually means re-exporting the whole batch, not fixing one clip.
Another common pattern: the same clip works on account A but not account B. The difference is usually permissions, campaign eligibility or platform state — the spec is just the first variable to rule out.
The pre-publish checklist
Turn these into columns and confirm them per clip before export. The notes describe frequent pitfalls, not fixed values; check the official notice for actual limits.
Run through these every time:
- Aspect ratio and resolution: mostly vertical; keep captions out of the UI button zone (cropped captions are a common rejection).
- Duration: confirm the content format's allowed range — over-limit clips are usually rejected, not truncated.
- Container and codec: actually play the exported file rather than trusting the extension.
- File size: oversized files break on unstable connections, and an interrupted upload is often misread as completed.
- Cover / first frame: avoid all-black, all-white or text-only frames; unreadable thumbnails cost clicks.
- Audio and subtitles: silent sections, low volume and desynced captions are usually noticed only after publishing.
- Filename: avoid special characters and very long names, and match the "video file" column exactly.
Make filenames and rows match
The most expensive batch error is not a format mismatch — it is attaching the wrong title to the wrong clip. You need one stable unique key between the row and the local file, usually the filename.
Your sheet needs at minimum: video file, title, keywords, tags and a note column. Rename a file and you must update the row, or the per-video log will record results against the wrong clip.
A diagnostic order for failed uploads
Do not immediately retry the entire batch. Narrow the scope in this order first:
Recommended sequence:
- 1. Read that clip's error message: format, duration, permission or network interruption usually points somewhere.
- 2. Test one known-good clip to separate "this file is bad" from "this account / time window is bad".
- 3. Check account eligibility and current campaign rules against the official notice.
- 4. Confirm the file is not locked by another process, disk space is sufficient and the connection is stable.
- 5. Retry only the failed items. Re-running successful ones can create duplicate content.
Per-video results beat a single "done" status
Publishing thirty clips and seeing "complete" does not mean thirty successes. You need a result and a failure reason per clip to retry selectively.
Keeping those results has a second benefit: when you prepare the next batch, you can skip videos that already published successfully.
When to move to bulk organisation
If you already manage titles and tags in a spreadsheet, the next step is joining check → schedule → log into one flow instead of matching things by hand each time.
ShopeePilot organizes titles, tags and keywords in bulk from CSV / Excel, publishes the queue on your own devices, and keeps per-video results and failure reasons so only failed items get retried. It runs on your own accounts and devices, does not operate accounts or handle credentials, and does not bypass platform limits.