On this page
Load data from a file when no connector covers the source; how the file is read becomes a reusable mapping template.
Who can do this: an owner or admin, or a role with the connector capability.
Before you start#
- The organization has a brand; in a multi-brand organization pick the receiving brand first.
- A self-prepared file in one of the built-in column templates (orders, creators, inventory, creator costs, targets, products) needs no mapping template.
Steps#
- Open the file in a plain text editor, not Excel, which re-encodes silently, and check the header, currency symbols, dates and encoding.
- Once per file format, create a mapping template at CSV / Excel mapping ("Ánh xạ cột CSV / Excel"): source and target, map columns, preview, save (field reference).
- At Upload data ("Tải lên dữ liệu") choose Marketplace export or Self-prepared file and the template.
- Drop the file (
.csv,.xlsx,.xls, up to 8 MiB) and check the preview and the receiving brand. - Select Upload & queue.
- In Recent uploads read the status, rows read and dropped and the first failure. Success with none dropped is the goal.
- Reconcile at Data validation ("Đối soát dữ liệu") against the original file for the same period.
If it fails#
| Symptom | Cause | Fix |
|---|---|---|
| Row dropped, not a number | A currency symbol is still in the column | Turn on currency-symbol stripping in the template. |
| Row dropped, not a date | A day-first date read as US-style | Set the date format explicitly in the template. |
| Vietnamese text is garbled | The file is in an older Windows encoding | Set that encoding in the template. |
| File rejected as too large | One long historical export above 8 MiB | Split it and upload each part. |
| Re-upload doubles the numbers | The template has no dedupe key | Add a dedupe key, then re-upload. |
| Status says missing columns | A raw marketplace file uploaded as self-prepared | Re-upload through the Marketplace export mode and its template. |
| Money column is zero on every row | The file no longer carries the mapped money column | Check the column name, then update the template. |